XlsIO: importing an .xls file saved by OpenOffice

[Administrator]

Hello,
We've recently started using XlsIO to import Excel files into our Essential Grid application.

We noticed that .xls files which were saved by OpenOffice Calc (v2.0.4, the latest version) will fail on the call to ExcelEngine.Workbooks.Open(), with:

Index was out of range. Must be non-negative
and less than the size of the collection.
Parameter name: index

This seems to happen regardless of the content of the file, even on an empty, newly created document. (testcase attached)

We wondered whether you guys would like to know about this, whether you are interested in attempting to tweak your code for compatability with Open Office derived .xls files, whether you had any interest in helping us discover the difference between Excel and Open-Office derived files which causes the problem and chase Open Office to modify their output, or any other solutions to the problem.

Your thoughts appreciated,

Regards,

Jonathan
Resolver Systems



testcase-empty-doc-saved-from-openoffice.zip

[Chella Pandian B]

HI Jonathan

I was able to reproduce the issue in opening the excel file created using Openoffice.org Calc.
I have created a bug report regarding this please check the following link for further updates.

Link:

http://www.syncfusion.com/support/issues/xlsio/Default.aspx?ToDo=view&questId=3132


We are extremely sorry for the inconvenience.
Thanks for your interest in XlsIO.

With regards,
Chella.

[Jonathan Hartley]

That's great, thanks very much.

[Sivasankari J]

Hi Jonathan,

We have fixed this issue and could you please open an incident, so that it will help us to provide the patch that resolves the issue.

Thank you for your patience.

Thank you for using Syncfusion products.

Best Regards,
Sivasankari