We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XlsIO: importing an .xls file saved by OpenOffice

Thread ID:





52854 Dec 5,2006 12:22 PM UTC Mar 2,2007 12:41 PM UTC WinForms 3
Tags: GridControl
Administrator [Syncfusion]
Asked On December 5, 2006 12:22 PM UTC

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,


Resolver Systems


Chella Pandian B [Syncfusion]
Replied On December 5, 2006 06:53 PM UTC

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.



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

With regards,

Jonathan Hartley
Replied On December 7, 2006 03:21 PM UTC

That's great, thanks very much.

Sivasankari J [Syncfusion]
Replied On March 2, 2007 12:41 PM UTC

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,


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon