aspose.cells

Classes

Constants

Class DeleteBlankOptions

Represents the setting of deleting blank cells/rows/columns.

Constructor Summary
`DeleteBlankOptions()`

Property Getters/Setters Summary
`function`	`getEmptyFormulaValueAsBlank()`
`function`	`setEmptyFormulaValueAsBlank(value)`
	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.
`function`	`getEmptyStringAsBlank()`
`function`	`setEmptyStringAsBlank(value)`
	Whether one cell will be taken as blank when its value is empty string. Default value is true.
`function`	`getUpdateReference()`
`function`	`setUpdateReference(value)`
	Indicates if update references in other worksheets.

- Constructor Detail
  - DeleteBlankOptions
```
function DeleteBlankOptions()
```
- Property Getters/Setters Detail
  - getEmptyStringAsBlank/setEmptyStringAsBlank : boolean
```
function getEmptyStringAsBlank() / function setEmptyStringAsBlank(value)
```
    Whether one cell will be taken as blank when its value is empty string. Default value is true.
  - getEmptyFormulaValueAsBlank/setEmptyFormulaValueAsBlank : boolean
```
function getEmptyFormulaValueAsBlank() / function setEmptyFormulaValueAsBlank(value)
```
    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.
  - getUpdateReference/setUpdateReference : boolean
```
function getUpdateReference() / function setUpdateReference(value)
```
    Indicates if update references in other worksheets.