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 of merged cells. The value of the property is AutoFitMergedCellsType integer constant.
functiongetAutoFitWrappedTextType()
function
           Gets and sets the type of auto fitting wrapped text. The value of the property is AutoFitWrappedTextType integer constant.
functiongetDefaultEditLanguage()
function
           Gets or sets default edit language. The value of the property is DefaultEditLanguage integer constant.
functiongetFormatStrategy()
function
           Gets and sets the formatted strategy. The value of the property is CellValueFormatStrategy integer constant.
functiongetIgnoreHidden()
function
           Ignores 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

      • getDefaultEditLanguage/setDefaultEditLanguage : Number 

        function getDefaultEditLanguage() / function setDefaultEditLanguage(value)
        
        Gets or sets default edit language. The value of the property is DefaultEditLanguage integer constant. It may display/render different layouts for text paragraph when different edit languages is set. Default is #Error Cref: !:DefaultEditLanguage.Auto.
      • 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 of merged cells. The value of the property is AutoFitMergedCellsType integer constant. Excel defaults to ignore merged cells when fitting the row height, so Aspose.Cells works as MS Excel default. Please set this type to change the way of auto fitting row height of merged cells.
      • 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)
        
        Ignores 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.
      • getAutoFitWrappedTextType/setAutoFitWrappedTextType : Number 

        function getAutoFitWrappedTextType() / function setAutoFitWrappedTextType(value)
        
        Gets and sets the type of auto fitting wrapped text. The value of the property is AutoFitWrappedTextType integer constant.
      • getFormatStrategy/setFormatStrategy : Number 

        function getFormatStrategy() / function setFormatStrategy(value)
        
        Gets and sets the formatted strategy. The value of the property is CellValueFormatStrategy integer constant. The default value is CellStyle for performance.