Numbers exported to Excel as text

Jennypi · Post by **Jennypi** » Wed Jan 05, 2011 10:50 am

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.

Post by **Ivan** » Thu Jan 06, 2011 2:02 am

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.

Jennypi · Post by **Jennypi** » Thu Jan 06, 2011 2:54 am

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.

Post by **Ivan** » Thu Jan 06, 2011 6:13 am

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.

Mike Simpkins · Post by **Mike Simpkins** » Thu Jan 06, 2011 4:08 pm

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

Jennypi · Post by **Jennypi** » Fri Jan 07, 2011 6:55 am

Hi Mike,

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

Thank you.

Post by **Jan** » Fri Jan 07, 2011 9:45 am

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.