DeleteBlankOptions
DeleteBlankOptions class
Represents the setting of deleting blank cells/rows/columns.
Constructors
| Name | Description |
|---|---|
| DeleteBlankOptions |
Properties
| Name | Type | Description |
|---|---|---|
| EmptyStringAsBlank | boolean | Whether one cell will be taken as blank when its value is empty string. Default value is true. |
| EmptyFormulaValueAsBlank | boolean | Whether one cell will be taken as blank when it is formula and the calculated result is null or empty string. Default va |
| DrawingsAsBlank | boolean | |
| MergedCellsShrinkType | Number | The value of the property is MergedCellsShrinkType integer constant. |
| StartIndex | Number | |
| EndIndex | Number | |
| UpdateReference | boolean | Indicates if update references in other worksheets. |
| FormulaChangeMonitor | AbstractFormulaChangeMonitor |
DeleteBlankOptions()
DeleteBlankOptions.EmptyStringAsBlank property
Whether one cell will be taken as blank when its value is empty string. Default value is true.
Type: boolean
DeleteBlankOptions.EmptyFormulaValueAsBlank property
Whether one cell will be taken as blank when it is formula and the calculated result is null or empty string. Default value is false. Generally user should make sure the formulas have been calculated before deleting operation with this property as true. Otherwise all newly cretaed formulas by normal apis such as Cell.Formula will be taken as blank and may be deleted because before calculation their calculated results are all null.
Type: boolean
DeleteBlankOptions.DrawingsAsBlank property
Type: boolean
DeleteBlankOptions.MergedCellsShrinkType property
The value of the property is MergedCellsShrinkType integer constant.
Type: Number
DeleteBlankOptions.StartIndex property
Type: Number
DeleteBlankOptions.EndIndex property
Type: Number
DeleteBlankOptions.UpdateReference property
Indicates if update references in other worksheets.
Type: boolean
DeleteBlankOptions.FormulaChangeMonitor property
Type: AbstractFormulaChangeMonitor