After 1 hour of trying to figure out why I get a mistake on this Excel file, I give up.
lFileFormat := lFileFormat.Version2013;
pTempblob.Blob.CREATEINSTREAM(lInStream);
lWorkBook.CalculateAllValue; <<<< this gives me error
lWorkBook.SaveToStream(lInStream,lFileFormat); <<<< this gives me same error if above is uncommented
The error I get is
"A call to Spire.Xls.Workbook.CalculateAllValue failed with this message: "Specified argument was out of the range of valid values. "Parameter name : iStartpos"
What is weird,is that the following works.
lFileFormat := lFileFormat.PDF;
pTempblob.Blob.CREATEINSTREAM(lInStream);
lWorkBook.SaveToStream(lInStream,lFileFormat);
Can you please help find out why?
I tried on two editions of Spire (7.11.13, 7.11.23) - and we have a 1000 of templates running on Spire, so i have quite a lot of expertise in finding stuff in Excel that could confuse Spire. But notice that the attached file is close to empty!