aspose.cells

Class AutoFitterOptions

Represents all auto fitter options.

Constructor Summary
 
Property Getters/Setters Summary
functiongetAutoFitMergedCells()
function
           Indicates whether auto fit row height when the cells is merged in a row. The default value is false.
functiongetAutoFitMergedCellsType()
function
           Gets and set the type of auto fitting row height. The value of the property is AutoFitMergedCellsType integer constant.
functiongetIgnoreHidden()
function
           Ingores the hidden rows/columns.
functiongetMaxRowHeight()
function
           Gets and sets the max row height(in unit of Point) when autofitting rows.
functiongetOnlyAuto()
function
           Indicates whether only fit the rows which height are not customed.
 

    • Constructor Detail

      • AutoFitterOptions

        function AutoFitterOptions()
    • Property Getters/Setters Detail

      • getAutoFitMergedCells/setAutoFitMergedCells : boolean 

        function getAutoFitMergedCells() / function setAutoFitMergedCells(value)
        
        Indicates whether auto fit row height when the cells is merged in a row. The default value is false. NOTE: This member is now obsolete. Instead, please use AutoFitterOptions.AutoFitMergedCellsType property, instead. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.
      • getAutoFitMergedCellsType/setAutoFitMergedCellsType : Number 

        function getAutoFitMergedCellsType() / function setAutoFitMergedCellsType(value)
        
        Gets and set the type of auto fitting row height. The value of the property is AutoFitMergedCellsType integer constant. If the cells in merged in a row and auto fit the rows in MS Excel, MS Excel do not expand the row height. If this option is true, Aspose.Cells will expand the row height to fit the cells' data.
      • getOnlyAuto/setOnlyAuto : boolean 

        function getOnlyAuto() / function setOnlyAuto(value)
        
        Indicates whether only fit the rows which height are not customed.
      • getIgnoreHidden/setIgnoreHidden : boolean 

        function getIgnoreHidden() / function setIgnoreHidden(value)
        
        Ingores the hidden rows/columns.
      • getMaxRowHeight/setMaxRowHeight : Number 

        function getMaxRowHeight() / function setMaxRowHeight(value)
        
        Gets and sets the max row height(in unit of Point) when autofitting rows.