new AutoFitterOptions()

Methods

getAutoFitMergedCells()

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()

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.

getAutoFitWrappedTextType()

Gets and sets the type of auto fitting wrapped text. The value of the property is AutoFitWrappedTextType integer constant.

getDefaultEditLanguage()

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.

getFormatStrategy()

Gets and sets the formatted strategy. The value of the property is CellValueFormatStrategy integer constant. The default value is CellStyle for performance.

getIgnoreHidden()

Ignores the hidden rows/columns.

getMaxRowHeight()

Gets and sets the max row height(in unit of Point) when autofitting rows.

getOnlyAuto()

Indicates whether only fit the rows which height are not customed.

setAutoFitMergedCells()

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.

setAutoFitMergedCellsType()

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.

setAutoFitWrappedTextType()

Gets and sets the type of auto fitting wrapped text. The value of the property is AutoFitWrappedTextType integer constant.

setDefaultEditLanguage()

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.

setFormatStrategy()

Gets and sets the formatted strategy. The value of the property is CellValueFormatStrategy integer constant. The default value is CellStyle for performance.

setIgnoreHidden()

Ignores the hidden rows/columns.

setMaxRowHeight()

Gets and sets the max row height(in unit of Point) when autofitting rows.

setOnlyAuto()

Indicates whether only fit the rows which height are not customed.