Page 1 of 1
Export Excel formula not calculating
Posted: Thu Oct 15, 2015 6:27 am
by 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.
Re: Export Excel formula not calculating
Posted: Thu Oct 15, 2015 10:16 am
by Alex K.
Hello,
Can you please send us your report with test data for analysis.
Thank you.
Re: Export Excel formula not calculating
Posted: Thu Oct 15, 2015 4:24 pm
by 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.
Re: Export Excel formula not calculating
Posted: Fri Oct 16, 2015 9:14 am
by 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.
Re: Export Excel formula not calculating
Posted: Fri Oct 16, 2015 4:33 pm
by fkmfkm
Hi,
What do you mean by the formulas work in XLSX files ?
Do I export it differently ? How should I export it ?
Re: Export Excel formula not calculating
Posted: Mon Oct 19, 2015 7:19 am
by HighAley
Hello.
Please, try to export to Excel format instead of Excel97-2003.
From code you should use StiExportFormat.Excel2007 format.
Thank you.
Re: Export Excel formula not calculating
Posted: Sat Oct 31, 2015 12:37 am
by fkmfkm
Great, Its working.
Thank you.
Re: Export Excel formula not calculating
Posted: Sat Oct 31, 2015 6:56 pm
by Jan
Hello,
Glad to help you!
Thank you.