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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XlsIO: importing an .xls file saved by OpenOffice

Thread ID:

Created:

Updated:

Platform:

Replies:

52854 Dec 5,2006 07:22 AM Mar 2,2007 07:41 AM Windows Forms 3
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On December 5, 2006 07:22 AM

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 [Syncfusion]
Replied On December 5, 2006 01:53 PM

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
Replied On December 7, 2006 10:21 AM

That's great, thanks very much.

Sivasankari J [Syncfusion]
Replied On March 2, 2007 07:41 AM

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

CONFIRMATION

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.

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

;