CompatibilityMode Enumeration

In This Topic

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

Syntax

'Declaration
 
Public Enum CompatibilityMode 
   Inherits System.Enum

public enum CompatibilityMode : System.Enum

Members

Member	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).

Member

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).

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         C1.Excel.CompatibilityMode