Export Excel - Int to decimal (##,##) in Excel

KCRomain · Post by **KCRomain** » Wed Aug 17, 2011 7:32 am

Hi,

When exporting from Report FX for Flex to Excel, the int values are exported into 'number' type values. But Excel understand 'Number as decimal values'.
There a way to bypas this : put the cell type to Custom with a mask 'n'. But its a long job for big reports.
Is there an other way to do this? Can you fix it ?

Thanks a lot for your quick answer,

Romain - KeepCore (France)

Post by **Ivan** » Thu Aug 18, 2011 1:59 am

Hello,

Please select your textbox, open the TextFormat menu, uncheck the "Use Local Settings" property and set the DecimalDigits property to 0.

Thank you.

KCRomain · Post by **KCRomain** » Thu Aug 18, 2011 3:48 am

Hi,

It's work ! Thx for your quick answer.

Is there an internal difference with my approach (custom and n for the mask) ?

Romain - KeepCore (France)

Post by **HighAley** » Thu Aug 18, 2011 6:54 am

Hello.

KCRomain wrote:Is there an internal difference with my approach (custom and n for the mask) ?

In both cases the number exports to Excel identically. The difference is only in cell format.

Thank you.

KCRomain · Post by **KCRomain** » Fri Oct 07, 2011 8:09 am

Hello,

I (re)open this topic because, with 2011.2.11000, the export excel numbers have ##,## format with your previously method !!??

Post by **Ivan** » Tue Oct 11, 2011 3:33 pm

Hello,

KCRomain wrote:I (re)open this topic because, with 2011.2.11000, the export excel numbers have ##,## format with your previously method !!??

We couldn't reproduce this issue.
Can you please send us a sample report template with data, which reproduce the issue, and resulting excel file?

Thank you.