CompatibilityMode Enumeration

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

Syntax

Visual Basic
C#

'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.WPF.Excel.CompatibilityMode

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

C1.WPF.Excel Namespace