Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Feb 21, 2018 8:30 am

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!
Attachments
CA_1.rar
Pretty empty xlsx file
(9.8 KiB) Downloaded 246 times

pedgaard
 
Posts: 24
Joined: Fri May 20, 2016 3:12 pm

Wed Feb 21, 2018 9:24 am

Hello,

I tested your attached xlsx file with Spire.XLS Pack Version:8.0, there is no issues occur. Please have a try with this version.
Looking forward to your feedback.

Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Feb 26, 2018 7:01 am

Hello,

Has your issue got resolved?
Your feedback would be greatly appreciated.

Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS