I get an error 'Format error' when exporting to excel. So, I tried changing the format of each expression and I got rid of the error, but I am unable to maintain the number format.
1) I included Num(<Expression>, '#,##0') in all the expression. Eventhough the front end of the application looks good and I didn't have any error while exporting, but the number format is changed to '########' (without any comma) in the excel sheet.
Is there any other format (with Commas) which will work both in the front-end and while exporting too.
If so then in the chart property , on NUMBER tab use either integer or number and on separaters use .(perioed) and ,(comma), that should work when you export.
Yes. I use the chart, but the problem started only when I entered on Number tab. I get error when exporting to excel sheet, when I give integer or decimal format and hence I changed to 'expression default' and that is why I am changing the number format in the expression itself.
