Excel export formatting issue

[rameez]

Describe the bug
When exporting a widget to excel, the tm1 formatting is not kept. The export applies custom formatting causing the cells to show blank values until we change format in Excel

To Reproduce
Steps to reproduce the behavior:

1. Create a widget with percentage values with TM1 formatting with two decimal places applied
2. export the widget to excel
3. the cells show custom format applied. Not taking into account the widget formatting

Expected behavior
Widget formatting should be applied upon export.

Screenshots
see attached

[Ada Trajer]

Hi Rameez, can you please tell me if Export to Excel Number Format is set in the table advanced options and in the default.constant.js file ( "exportToExcelNumberFormat")?

Thanks, Ada

[rameez]

Hi Ada,

Yes that setting is populated with this value #,###;(#,###);0;-

[Ada Trajer]

Can you please remove the format and try the export again?

[rameez]

No change after removing the format from the setting. Still seeing the same issue