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.

Tue Nov 21, 2017 11:10 am

Hello,

We have two problems :

[*]We have an Exception in LoadFromFile from a specific Workbook :
Code: Select all
Exception levée : 'System.ApplicationException' dans Spire.XLS.dll
System.ApplicationException: Extended Format record FontIndex field has wrong value
   à spr3673.0(spr3378 A_0, Boolean A_1)
   à spr3673..ctor(spr2941 A_0, Object A_1, spr3378 A_2)
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.InsertDefaultExtFormats()
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(Boolean A_0, List`1 A_1, Dictionary`2 A_2)
   à spr5144.0(XmlReader A_0, Stream& A_1)
   à spr319.0(List`1& A_0)
   à spr319.1(List`1& A_0)
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(Stream A_0, String A_1)
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(Stream A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(String A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(spr2941 A_0, Object A_1, String A_2, ExcelParseOptions A_3, Boolean A_4, String A_5, ExcelVersion A_6)
   à spr1014.0(Object A_0, String A_1, ExcelParseOptions A_2, Boolean A_3, String A_4, ExcelVersion A_5)
   à spr1190.0(String A_0, ExcelParseOptions A_1, Boolean A_2, String A_3, ExcelVersion A_4)
   à Spire.Xls.Workbook.LoadFromFile(String fileName, ExcelVersion version)
   à Spire.Xls.Workbook.LoadFromFile(String fileName)


[*]In our application, we launch a GarbageCollector. This Garbage Generate this Unhandled error (Crash of application) :
Code: Select all
System.NullReferenceException: La référence d'objet n'est pas définie à une instance d'un objet.
   à spr627.1(XlsWorksheet A_0, Dictionary`2 A_1)
   à Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
   à Spire.Xls.Core.Spreadsheet.XlsWorksheetBase.ParseData()
   à Spire.Xls.Core.Spreadsheet.XlsWorksheet.10()
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.ClearAll()
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.DisposeAll()
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean SaveChanges, String Filename)
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean saveChanges)
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close()
   à Spire.Xls.Core.Spreadsheet.XlsWorkbook.Finalize()


Code to reproduce :

Code: Select all
try
{
    Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;

    var workbook = new Workbook();
    workbook.LoadFromFile("2016-2017.xlsx");
}
catch (Exception exception)
{
    Console.WriteLine(exception);
}

GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();


Could you reproduce ?

Regards,

Vincent
Attachments
2016-2017.zip
(68.23 KiB) Downloaded 256 times

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Wed Nov 22, 2017 2:14 am

Hello Vincent,

Thanks for your feedback. I have reproduced the issue on my side and logged it into our bug tracking system. Once there is any update, we will inform you.

Best reagrds,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Fri Dec 01, 2017 7:10 am

Hello Vincent,

Glad to inform you that the issue has been fixed. Welcome to download Spire.XLS Pack Hotfix Version:7.12.125.

Best regards,
Simon
E-iceblue support team
Last edited by Simon.yang on Wed Dec 06, 2017 1:34 am, edited 1 time in total.
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Tue Dec 05, 2017 10:16 am

Hello,

Problem solved

Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Wed Dec 06, 2017 1:33 am

Hello Vincent,

Thanks for your reply. If there is any other question, please feel free to contact us.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Return to Spire.XLS