I have been working on this for a day now and can’t figure out the problem. In the attached project I get an error that reads “Excel found unreadable content in ”. I have narrowed down the cause to the DSum functions on Sheet1, cells B2 & C2. If you delete those functions from the template workbook the error does not occur. Any ideas why?
Hi,
I was able to reproduce the problem with the latest version:
Aspose.Cells
for .NET v6.0.1.8
We have logged this issue in our database. We will fix it and update you asap.
This issue has been logged as CELLSNET-30084.
Hi,
As this defined name is referred by formula and pivot table, please not remove the defined name “Raw_Data” now.
// xlsWorkbook.Worksheets.Names.Remove(“Raw_Data”);
Anyways, we will look into it later.
After I remove that line everything now looks like it’s working properly. Something in the documentation gave me the impression that a named range needed to be removed and recreated if the size changes. That is why the line was in there, but it seems this is not the case. Problem solved, thanks.
Hi,
It’s good to know your problem is now sorted out.