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

Namespace: C1.Silverlight.Excel
Assembly: C1.Silverlight.Excel.5 (in C1.Silverlight.Excel.5.dll)

Syntax

C#
public enum CompatibilityMode

Visual Basic
Public Enumeration CompatibilityMode

Members

Member name	Value	Description
Excel2003	0	Sheets may have up to 65,536 rows and 256 columns. Workbooks may have up to 4050 unique cell styles.
Excel2007	1	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	2	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 name

Value

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