Creating reports and dashboards | Stimulsoft community forum

Hi,

One of my report allows users to export numbers to Excel files.
The problem that they have is that those numbers are considered as "text" by Excel (the cells have a small green triangle in the corner).
Meaning they can not use those numbers for formulas, and also they are not sortable as numbers (excel sorts them like this: 1-10-2-20 instead of 1-2-10-20).

How can I avoid this problem?
The only solution that we found so far is to export as csv instead of xls, but that is not optimal.

Thank you.

Hello,

If the TextFormat property of textbox is set to General, then a value is exported as "text".
Please set the TextFormat property of textboxes to Numeric.

Thank you.

Hi,

Thank you for your reply.
I set the TextFormat property to "Number" with 0 decimal digit and no group separator. But those textboxes are still exported as text... don't understand why...

Thanks.

Hello,

Can you please send us a sample report with data, which reproduces the issue?
Also please send to us the resulting excel file.

Thank you.

Are you sure you are in the right location? In addition to setting the Text Format property to Number, have you also set the property for "Excel Value?" This controls what format the program will send to Excel when it exports. I had trouble with this until I stumbled across the Excel Value property.

Good Luck

Hi Mike,

What am I supposed to write in this "Excel value" property? Could you please give an example?

Thank you.

Hello,

You can find ExcelValue property at text component. If you want export to Excel other value (not from Text property) you can use ExcelValue property.

Thank you.