Page 1 of 1
Export Excel - Int to decimal (##,##) in Excel
Posted: Wed Aug 17, 2011 7:32 am
by KCRomain
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)
Export Excel - Int to decimal (##,##) in Excel
Posted: Thu Aug 18, 2011 1:59 am
by Ivan
Hello,
Please select your textbox, open the TextFormat menu, uncheck the "Use Local Settings" property and set the DecimalDigits property to 0.
Thank you.
Export Excel - Int to decimal (##,##) in Excel
Posted: Thu Aug 18, 2011 3:48 am
by KCRomain
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)
Export Excel - Int to decimal (##,##) in Excel
Posted: Thu Aug 18, 2011 6:54 am
by HighAley
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.
Export Excel - Int to decimal (##,##) in Excel
Posted: Fri Oct 07, 2011 8:09 am
by KCRomain
Hello,
I (re)open this topic because, with 2011.2.11000, the export excel numbers have ##,## format with your previously method !!??
Export Excel - Int to decimal (##,##) in Excel
Posted: Tue Oct 11, 2011 3:33 pm
by Ivan
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.