C1 Community

I am using version 2.1.20073.74 of C1Excel and am trying to open a new Excel 2007 file (.XLSX).  I can open it with a couple of records however as soon as I go over the Office 2003 row limit, I get the following error message: "Maximum number of rows exceeded (65536)."  Is there something I'm doing wrong or is this just a limitation of the component?  It seems odd that the new format is supported however we cannot use the new row limit. 

 Thanks in advance,

Charles

After submitting an incident to Component 1 I received an email with the latest version of the C1Excel Component (C1Excel.2_2.1.20081.842) as well as the following email:

In the latest version of the control, a new property “CompatibilityMode” has been added.

Following are the settings for this property:

Valid settings are:

CompatibilityMode.Excel2003:

Up to 256 columns, 65,536 rows, and 4,050 cell styles.

CompatibilityMode.Excel2007:

Up to 18,278 columns, 1,048,576 rows, and 65,536 cell styles.

Workbooks that exceed the Excel2003 limits must be saved in OpenXml format instead of XLS.

CompatibilityMode.NoLimits:

No fixed limits (you may not be able to read these files with Microsoft Excel).

Here is a way you can this use this property:

C1XLBook1.CompatibilityMode = C1.C1Excel.CompatibilityMode.Excel2007

Please find attached the latest build along with this mail in which the said property has been added.

<Serglar> wrote in message news:202717@10.0.1.98...

Today I received a request from our customer whether we can support new Excel 2007 format for documents having more then 65536 rows. I tried to load a file with more then 65536 rows and I’ve got same error. I have latest C1Excel component on my machine. Any response from Component One?

 

Best regards

Sergey

---

http://helpcentral.componentone.com/cs/forums/p/74563/202717.aspx#202717