ThrowOverflowOrFormatException while LoadFromFile

Thu Apr 27, 2023 9:59 am

Hello Team,
I have an excel file contains around 10 sheets. About 30K data for each sheet with different formulas + 2 sheets with PivotTables.
When I used FreeSpire.XLS (12.7.0) and loaded file through LoadFromFile, it gave me following error:

Value was either too large or too small for an Int32.
2023-04-27 17:46:09.523 +08:00 [ERR] at System.Number.ThrowOverflowOrFormatException(ParsingStatus status, ReadOnlySpan`1 value, TypeCode type)
at System.Int32.Parse(String s, IFormatProvider provider)
at spr(String A_0)
at spr(XmlTextReader A_0, Int32 A_1)
at spr(XmlTextReader A_0)
at spr()
at spr()
at spr()
at spr(spr‐ A_0)
at spr‐.(Stream A_0, sprᾮ A_1, Boolean A_2)
at spr‐.(String A_0, sprᾮ A_1)
at spr‐..ctor(String A_0, sprᾮ A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(Object A_0, String A_1, ExcelVersion A_2)
at Spire.Xls.Workbook.LoadFromFile(String fileName, ExcelVersion version)

After several hours' investigation, I found it caused by 1 PivotTable, after refreshing it, the file became readable again.
I attached a mini file which can reproduce this issue.
Even if right now it's not a blocker issue, I don't want to spent hours next time to see other files with the similar issue.

Could you please support?

Thanks in advance

Thu Apr 27, 2023 10:05 am

BTW, Spire.xls 13.4.0 has the same issue. I tried it in case the commercial version is fine.

Fri Apr 28, 2023 6:08 am

Hi,

Thanks for your feedback.
I did not see the document you attached, could you kindly provide us with your document again? You can send it to us via email (support@e-iceblue.com) or attach it here. Thanks for your assistance.
This will greatly assist our development team to identify and fix the issue as soon as possible. Thank you again for your valuable feedback and we look forward to resolving this matter for you.

Best regards,
Triste
E-iceblue support team

Tue May 02, 2023 2:00 pm

Hi,

Thanks for your follow-up.
I sent it through mail, and within this post, I tried again to upload the file. Hope it works.

Thanks.

Wed May 03, 2023 1:37 am

Hi,

Thanks for your assistance.
After testing, I reproduced the issue you mentioned, this error occurred while loading the document, I will log this issue into our issue tracking system and tell you the ticket number when we return to our office. Sorry for any inconvenience caused, our developers will investigate and fix this issue. Once the issue is resolved, I will inform you asap. Thanks for your patience and understanding.

Best regards,
Triste
E-iceblue support team

Wed May 03, 2023 10:44 am

Hi,

Thanks for your feedback with confirmation, I look forward to the further update.
At this moment, I work around it by refreshing the pivot table.

Regards,
Jun

Thu May 04, 2023 2:08 am

Hi,

Thanks for our reply.
I have logged this issue into our issue tracking system with the ticket number SPIREXLS-4644, once the issue is fixed, I will inform you asap. Sorry for the inconvenience caused. Thanks for your patience and understanding.

Best regards,
Triste
E-iceblue support team

Thu Jun 01, 2023 9:52 am

Hi,

Thanks for your patience.
Glad to inform you that we just released spire.Xls_13.5.6 hotfix, which has fixed your issue SPIREXLS-4644, please download from the following links and have a test.
Website: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget: https://www.nuget.org/packages/Spire.XLS/13.5.6

Best regards,
Triste
E-iceblue support team