aspose.cells

aspose.cells

Class DeleteBlankOptions

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

Constructor Summary
DeleteBlankOptions()
 
Property Getters/Setters Summary
functiongetDrawingsAsBlank()
function
setDrawingsAsBlank(value)
          
functiongetEmptyFormulaValueAsBlank()
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.
functiongetEmptyStringAsBlank()
function
setEmptyStringAsBlank(value)
           Whether one cell will be taken as blank when its value is empty string. Default value is true.
functiongetEndIndex()
function
setEndIndex(value)
          
functiongetFormulaChangeMonitor()
function
setFormulaChangeMonitor(value)
          
functiongetMergedCellsShrinkType()
function
setMergedCellsShrinkType(value)
          The value of the property is MergedCellsShrinkType integer constant.
functiongetStartIndex()
function
setStartIndex(value)
          
functiongetUpdateReference()
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.

      • getDrawingsAsBlank/setDrawingsAsBlank : boolean 

        function getDrawingsAsBlank() / function setDrawingsAsBlank(value)

      • getMergedCellsShrinkType/setMergedCellsShrinkType : Number 

        function getMergedCellsShrinkType() / function setMergedCellsShrinkType(value)
        The value of the property is MergedCellsShrinkType integer constant.

      • getStartIndex/setStartIndex : Number 

        function getStartIndex() / function setStartIndex(value)

      • getEndIndex/setEndIndex : Number 

        function getEndIndex() / function setEndIndex(value)

      • getUpdateReference/setUpdateReference : boolean 

        function getUpdateReference() / function setUpdateReference(value)
        Indicates if update references in other worksheets.

      • getFormulaChangeMonitor/setFormulaChangeMonitor : AbstractFormulaChangeMonitor 

        function getFormulaChangeMonitor() / function setFormulaChangeMonitor(value)