asked on March 2, 2024
im using flexmonster react component i want to export a csv file in one of the column i have values starting with =HYPERLINK but everytime i download im getting '=HYPERLINK which is wrong how to fix this in code. I want the full =HYPERLINK("LINK", "View PDF") like this supported
⋅ March 5, 2024
Hello, Rathan!
Thank you for reaching out to us.
Kindly note that adding the ' symbol while exporting the strings that start with = is our security measure to avoid any formula injections. As a possible workaround, we suggest using Flexmonster export with destinationType = "plain" and then preprocessing the data exported to a callbackHandler function.
Here is the JSFiddle sample to illustrate the idea: https://jsfiddle.net/flexmonster/gfzqjuko/.
You can find more information about customizing the export in our docs: https://www.flexmonster.com/doc/export-report/#programmatically.
Hope you will find our answer helpful.
Kind regards,
Solomiia
⋅ March 6, 2024
Thanks Solomiia, the solution helped fix my issue.
⋅ March 7, 2024
Hello, Rathan!
Thank you for your feedback.
We are glad to hear the suggested approach works well for you.
Feel free to reach out to us in case of any other questions.
Kind regards,
Solomiia
