Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

Export to excel issue with illegal XML characters

Pramod Bohra asked on October 27, 2017

 We have some report data with & in it and whenever we do the export to excel from Flexmonster grid, we get an error message. Below is sample data and screenshot of error message. Sample data to reproduce issue is below. We tried escaping the data but that didn’t work either.
 
^0,^0,^0,^0,^0,^0,^0,^0,^0,SCH L: BEG LOANS TO STKHDRS,-700000,^0
^0,^0,^0,^0,^0,^0,^0,^0,^0,SCH L: BEG MORT PAYABLE>1 YR,-618456,^0
^0,^0,^0,^0,^0,^0,^0,^0,^0,SCH L: BEG MORTG & LOANS,9564000,^0
^0,^0,^0,^0,^0,^0,^0,^0,^0,SCH L: BEG MRTG PAYABLE<1 YR,285000,^0

Attachments:
fm-excel-issue.png

1 answer

Public
Tanya Gryshko Flexmonster October 27, 2017

Hello, Pramod,
Thank you for writing.
We have tested your data and everything works as expected on our side. Please try updating to the latest version. This may resolve your issue.
Waiting for your feedback.
Regards,
Tanya

Please login or Register to Submit Answer