Version

Search Results

MaxExcelWorkbookFonts Field

Maximum number fonts in a workbook allowed by Excel. Syntax

MaxRecursionIterations Property

Gets or sets the maximum number of times formulas should be iteratively calculated. Syntax Property Value The maximum number of times formulas should be iteratively calculated. Exceptions Exception Description System.ArgumentOutOfRangeException The assigned value is outside the valid range of 1 and 32767. Remarks ...

MaxRowCount Property

Gets the maximum number of rows allowed in each worksheet based on the CurrentFormat. Syntax

NamedReferences Property

Gets the collection of named references in the workbook. Syntax Property Value The collection of named references in the workbook. Remarks Named references are typically used to refer to cells or ranges of cells by name. The named reference names are used by formulas instead of explicitly naming the cells or cell ...

Palette Property

Gets the color palette used when the saved file is opened in Microsoft Excel 2003 and earlier versions. Syntax Remarks When the file is opened in Microsoft Excel 2003 and earlier versions, the actual colors used in cells and shapes may not be displayed. Instead, the closest color in the palette will be displayed i...

PixelsToCharacterWidth256ths Method

Converts pixels to units of 1/256s of the average character width. Syntax Parameters pixels The number of pixels. Return Value The number of units of 1/256s of the average character width equivalent to the pixels value. Remarks The units of 1/256s of the average character width are based on the font height of the ...

Precision Property

Gets or sets the precision to use when obtaining a cells value. Syntax Property Value The precision to use when obtaining a cells value. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The assigned value is not defined in the Precision enumeration. Remarks The precision determin...

PropertyChanged Event (Workbook)

Occurs after a property value has changed Syntax Event Data The event handler receives an argument of type PropertyChangedEventArgs containing data related to this event. The following PropertyChangedEventArgs properties provide information specific to this event.Property Description PropertyName

Protect(Boolean,Boolean) Method

Protects the Workbook without a password. Syntax Parameters allowEditStructure Optional boolean indicating the new value for the WorkbookProtection.AllowEditStructure.allowEditWindows Optional boolean indicating the new value for the WorkbookProtection.AllowEditWindows. Remarks When a Workbook is protected without...

Protect(SecureString,Boolean,Boolean) Method

Protects the worksheet with the specified password. Syntax Parameters password The password used to protect the Worksheet.allowEditStructure Optional boolean indicating the new value for the WorkbookProtection.AllowEditStructure.allowEditWindows Optional boolean indicating the new value for the WorkbookProtection....