Export formulas to Excel
Posted: Tue Mar 03, 2015 10:23 am
Hi Aleksey
Sorry for all the questions at the moment, we are doing lots of implementation involving Stimulsoft Silverlight version.
I downloaded your sample that shows how the Excel Value works in the Export options of a text control. I can't get it to work.
I even tried a very simple example of putting a text control on my report, setting the format to Numeric, and then in the Excel Value I entered:
= 2+3
My understanding is that in the exported Excel file, the cell should contain a formula of = 2 + 3 and the cell should display the result of 5.
Every time I try to use this feature, the exported Excel file doesn't contain a formula in the cell and the cell is empty.
Can you help me to understand how this should work?
Sorry for all the questions at the moment, we are doing lots of implementation involving Stimulsoft Silverlight version.
I downloaded your sample that shows how the Excel Value works in the Export options of a text control. I can't get it to work.
I even tried a very simple example of putting a text control on my report, setting the format to Numeric, and then in the Excel Value I entered:
= 2+3
My understanding is that in the exported Excel file, the cell should contain a formula of = 2 + 3 and the cell should display the result of 5.
Every time I try to use this feature, the exported Excel file doesn't contain a formula in the cell and the cell is empty.
Can you help me to understand how this should work?