C1.Excel.CompatibilityMode

CompatibilityMode Enum

Specifies limits to sheet size that correspond to specific versions of Microsoft Excel.

public enum CompatibilityMode

Name	Description
Excel2003	Sheets may have up to 65,536 rows and 256 columns. Workbooks may have up to 4050 unique cell styles.
Excel2007	Sheets may have up to 1,048,576 rows and 18,278 columns. Workbooks may have up to 65,536 unique cell styles. Workbooks that exceed the Excel2003 limits must be saved in OpenXml format instead of XLS. It may not be possible to open these workbooks with versions earlier than Excel 2007 (C1Excel will still open them correctly).
NoLimits	No size limits are enforced. It may not be possible to open these workbooks with any version of Excel (C1Excel will still open them correctly).

Name

Description

Excel2003

Sheets may have up to 65,536 rows and 256 columns. Workbooks may have up to 4050 unique cell styles.

Excel2007

Sheets may have up to 1,048,576 rows and 18,278 columns. Workbooks may have up to 65,536 unique cell styles.

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

It may not be possible to open these workbooks with versions earlier than Excel 2007 (C1Excel will still open them correctly).

NoLimits

No size limits are enforced.

It may not be possible to open these workbooks with any version of Excel (C1Excel will still open them correctly).