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
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