Having an odd problem with an Excel 2007 report generated by Aspose. The file is over 20MB so don’t want to attach it but will explain what is happening.
The report process completes successfully but when opening the file, I get the following error:
"Excel found unreadable content in ‘Filename.xlsm’. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."
After clicking Yes, I get a box which says:
"Removed Records: Formula from /xl/worksheets/sheet1.xml part.
There is a link to a log file. The contents are:
<?xml version=“1.0” encoding=“UTF-8”
Excel then goes into "Open and Repair mode" and the file opens, but not all of the formulas survived. There are 8 columns with formulas. They repeat properly for the first 65,537 rows of the data. Then the remaining 20,000 plus rows display "#N/A" (formula bar entry =#N/A).
I thought it odd that it would degrade at the point where previous versions of Excel would end (65,536). It doesn't seem to be a coincidence.
I removed all the formulas but one and the same error occurred and the same number of rows were correct vs. #N/A.
Seems like there is something between the report writer and Excel where it's not convinced that it's generating for Excel 2007. Has anyone run into this issue?
Thanks in advance,