Question

Number Format in exported Excel differs from report number format

Hi,
When exporting content to Excel, the number format in the exported Excel is different from the Report Definition number format.
I've tried to user controls pxCurrency or pxNumber, but the results is the same, Excel see the cells as text. the requirement ask to see them as number.

Any idea? is related to different locale on users? We have users with IT_it and EN_us locale.

We're on Pega Platform 7.1.9

Thank you,
Andrea

Comments

Keep up to date on this post and subscribe to comments

October 17, 2019 - 9:59am
Response to rakss

Hi rakss,
Thank you for your suggestion, but i've already found these links, and i need to correctly export number format, not date.
when i open report on excel, number are displayed like these: 

-2,76203E+13

losing decimal separators, so users are unable to see the correct values.
i've opened html generated when export and the cell format is:

<TD class='excel-number'>-27620.284243202<div style='width:1px'/></TD>

i'd also like to truncate to 2 decimal places.

Andrea

October 18, 2019 - 5:53am
Response to AndreaG86

UPDATE:
right now the only solution that i've found is to force decimal separator "." on Excel client.