Export to excel, show values as strings

[jalal_logitude]

Hello,

When export a report using stimulsoft-silverlight to Excel, I can't do math operations on the values like sum,...
How i enable such feature ?

Best regards,
Jalal

[HighAley]

Hello.

Sorry, maybe we don't understand your question.
Could you describe it more detailed?

Thank you.

[jalal_logitude]

Hello,

I am trying to export a sales report using Silverlight, but when i open the excel file and try to sum the column, it doesn't work.

for example, a column with amounts : 100,200,300. When export from Stimulsoft to excel, i need in excel to sum the column so it will be 100+200+300 = 600
But, when i try that, it doesn't work because the cell format seems to be in 'string' not 'double'

Thanks
Jalal

[HighAley]

Hello, Jalal.

What version of our product do you use?
Do you set the Text Format in the report template?
If you set the right text format the numbers should be exported right.

Thank you.