Excel for WPF | ComponentOne
C1.WPF.Excel Namespace / CompatibilityMode Enumeration

In This Topic
    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
    MemberDescription
    Excel2003Sheets 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

    See Also