Need a special offer?Find out if your project fits.
+

Excel Export Formatting

Answered
Subramanian asked on September 21, 2022

Hey Team, 
        Facing an issue while exporting a table in classic grid type.
        Created a custom column with formula containing 'percent'.The resulting data is not formatted with % symbol in table but When it is exported as excel, the % symbol is added to the cell text. Is there any way to remove the % symbol in excel export as well. Tried the customizeCell option, but no luck. Thanks in Advance!

6 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 23, 2022

Hello, Subramanian!

Thank you for contacting us.

We have managed to reproduce the described behavior on our side. Our dev team will have a closer look at it and return back to you with the fix on the ETA October 18th.
We will notify you about any updates on the matter.

Feel free to contact us in case of any other questions.

Kind regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster October 18, 2022

Hello, Subramanian!
 
Hope you are doing well.

We are glad to inform you that the issue with exporting calculated values containing percent formula to Excel was fixed.

This fix is provided in the 2.9.36 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-36/.

You are welcome to update the component. Here is our updating guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.

Please let us know if the fix works well for you.
 
Kind regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster October 25, 2022

Hello, Subramanian!

Hope you are having a great week.

Our team is wondering if you had some time to test the fix for exporting calculated values with the percent formula. Could you please let us know if the fix works for your case?

Looking forward to hearing your feedback.

Regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 1, 2022

Hello, Subramanian!

Hope everything is well.

Just checking in to ask if the fix for exporting calculated values with the percent formula works well for you.

Looking forward to your response.

Regards,
Solomiia

Public
Subramanian November 1, 2022

Hi Solomiia,

Yup! it was working perfectly. Thanks for the support

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 1, 2022

Hi, Subramanian!

Thank you for your swift response.

We are glad to hear that the fix works well for you.

Feel free to contact us in case of any other questions.

Regards,
Solomiia

Please login or Register to Submit Answer