DeleteBlankOptions Class
Contents
[
Hide
]DeleteBlankOptions class
Represents the setting of deleting blank cells/rows/columns.
type DeleteBlankOptions struct {
ptr unsafe.Pointer
}
Constructors
| Method | Description |
|---|---|
| NewDeleteBlankOptions | Default constructor. |
| NewDeleteBlankOptions_DeleteOptions | Constructs from a parent object. |
Methods
| Method | Description |
|---|---|
| IsNull | Checks whether the implementation object is nullptr. |
| GetEmptyStringAsBlank | Whether one cell will be taken as blank when its value is empty string.Default value is true. |
| SetEmptyStringAsBlank | Whether one cell will be taken as blank when its value is empty string.Default value is true. |
| GetEmptyFormulaValueAsBlank | 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. |
| SetEmptyFormulaValueAsBlank | 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. |
| GetDrawingsAsBlank | Whether drawing related objects such as picture, shape, chart… will be taken as blank.Default value is true. |
| SetDrawingsAsBlank | Whether drawing related objects such as picture, shape, chart… will be taken as blank.Default value is true. |
| GetMergedCellsShrinkType | Indicates how to process merged cells when deleting blank rows/columns. |
| SetMergedCellsShrinkType | Indicates how to process merged cells when deleting blank rows/columns. |
| GetStartIndex | Specifies the start row/column index of the range to check and delete blank rows/columns. |
| SetStartIndex | Specifies the start row/column index of the range to check and delete blank rows/columns. |
| GetEndIndex | Specifies the end row/column index(inclusive) of the range to check and delete blank rows/columns.Default value is -1 and -1 means the maximum range of all objects(cells, drawings, …) that need to be checked. |
| SetEndIndex | Specifies the end row/column index(inclusive) of the range to check and delete blank rows/columns.Default value is -1 and -1 means the maximum range of all objects(cells, drawings, …) that need to be checked. |
| GetUpdateReference | Indicates if update references in other worksheets. |
| SetUpdateReference | Indicates if update references in other worksheets. |
| GetFormulaChangeMonitor | Gets/sets the monitor for tracking changes caused by the deletion. |
| SetFormulaChangeMonitor | Gets/sets the monitor for tracking changes caused by the deletion. |