asked on July 3, 2025
I have a column with percentage symbols and the isPercent value is set to true. In the pivot table the values are showing the % symbol but when I export the report to to excel it does not have the % symbol anymore.
⋅ 7 days ago
Hello, Amogh!
Thank you for reaching out to us.
We cannot reproduce the described behavior of exporting to Excel with isPercent: true on our side.
As a first step, please update the component to the latest version: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
If the described behavior persists in the latest version of Flexmonster, please modify the following JSFiddle to recreate the issue: https://jsfiddle.net/flexmonster/uhdp5qw7/. With this information, we'll be able to investigate the case further.
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ 2 days ago
Hello,
Apologies the issue I was facing with the columns having isPercent set to true was a formatting issue on my end in exceljs which I fixed.
I was also trying to get this working at a row level since there are cases where my rows have a percent datatype. I got it working in the pivot table using the customizeCellFunction by appending the % symbol to cell.text and it is working as expected. But the same doesn't reflect in the exported excel. Is there a way I can get it to work?
⋅ 2 days ago
Hello, Amogh!
Thank you for getting back to us.
We are happy to hear that the isPercent feature works as expected when exporting to Excel.
Kindly note that customizeCell have some limitations when exporting styled text in Excel, however, the additional cell text should be present in the exported Excel file.
We have prepared an example with adding a percent symbol to certain rows using customizeCell function: https://jsfiddle.net/flexmonster/81g94fam/. You are welcome to check that the percent symbol is present in the exported Excel file.
Hope you will find our answer helpful.
Kind regards,
Solomiia
