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
Pegasystems Inc.
IN
Please check out this links: https://community.pega.com/support/support-articles/date-format-changes-when-performing-export-excel
https://community.pega.com/support/support-articles/date-format-exported-excel-differs-report-date-format
Accenture SPA
IT
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