Gets the value indicating whether print options are saved with the custom view. Syntax Property Value The value indicating whether print options are saved with the custom view. Remarks If the value is False, the return value of GetPrintOptions will always be null, regardless of the worksheet specified.
Gets the window options for the workbook associated with the custom view. Syntax Property Value The window options for the workbook associated with the custom view.. Remarks Setting properties on the returned WindowOptions instance will not change the actual window options of the associated workbook. After setting...
Determines what types of cell values are allowed and how the cell value is validated against the constraint(s). Syntax Members Member Description Date Dates with or without time portions are allowed as well as numbers equivalent to valid dates. When comparing against constraints, the cell value is used. Decimal On...
Represents the various styles in which invalid values are handled by Microsoft Excel. When error messages are not shown for invalid values, the error style is ignored and all invalid values are allowed to be set on cells. Syntax Members Member Description Information Invalid values are allowed. The error dialog sh...
Base class for all data validations rules which can be applied to a cell. Syntax
A collection of DataValidationRule instances in a worksheet. Syntax
Public Properties Public Methods
Public Methods
Public Properties
Applies an AnyValueDataValidationRule to a WorksheetCell. Syntax Parameters rule The data validation rule to apply to the cell.cell The cell to which the data validation rule should be applied. Exceptions Exception Description System.ArgumentNullException Occurs when rule is null. System.ArgumentNullException Occu...