Export Excel formula not calculating

[fkmfkm]

Hi,

I am using this to export my report

rep.ExportDocument(Stimulsoft.Report.StiExportFormat.Excel, xlsFilename)


In my report I have this.

Text Format: Number
Excel Value: =SUM(H30:I30)

The problem is after exported; the excel formula wont calculate.


Please Help.

[Alex K.]

Hello,

Can you please send us your report with test data for analysis.

Thank you.

[fkmfkm]

I have saved it using

rep.Render()
rep.SaveDocument("report.mrt")

The cell with the Excel formula is Text69.


I have also included the exported excel.


Thank you very much.

[HighAley]

Hello.

The formulas work is XLSX files.
The XLS file are is binary format and we will not make any improvement there.
To get the value you should go to the Edit mode of the cell with formula and press Enter.

Thank you.

[fkmfkm]

Hi,

What do you mean by the formulas work in XLSX files ?

Do I export it differently ? How should I export it ?

[HighAley]

Hello.

Please, try to export to Excel format instead of Excel97-2003.
From code you should use StiExportFormat.Excel2007 format.

Thank you.

[fkmfkm]

Great, Its working.


Thank you.

[Jan]

Hello,

Glad to help you!

Thank you.