AutoFitterOptions

AutoFitterOptions class

Represents all auto fitter options.

Constructors

NameDescription
AutoFitterOptions

Properties

NameTypeDescription
DefaultEditLanguageintGets or sets default edit language. The value of the property is DefaultEditLanguage integer constant. It may display/re
AutoFitMergedCellsbooleanIndicates whether auto fit row height when the cells is merged in a row. The default value is false. NOTE: This member i
AutoFitMergedCellsTypeintGets and set the type of auto fitting row height of merged cells. The value of the property is AutoFitMergedCellsType in
OnlyAutobooleanIndicates whether only fit the rows which height are not customed.
IgnoreHiddenbooleanIgnores the hidden rows/columns.
MaxRowHeightfloatGets and sets the max row height(in unit of Point) when autofitting rows.
AutoFitWrappedTextTypeintGets and sets the type of auto fitting wrapped text. The value of the property is AutoFitWrappedTextType integer constan
FormatStrategyintGets and sets the formatted strategy. The value of the property is CellValueFormatStrategy integer constant. The default
ForRenderingbooleanIndicates whether fit for rendering purpose.

AutoFitterOptions()

AutoFitterOptions.DefaultEditLanguage property

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 DefaultEditLanguage.AUTO .

Type: int

AutoFitterOptions.AutoFitMergedCells property

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.

Type: boolean

AutoFitterOptions.AutoFitMergedCellsType property

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.

Type: int

AutoFitterOptions.OnlyAuto property

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

Type: boolean

AutoFitterOptions.IgnoreHidden property

Ignores the hidden rows/columns.

Type: boolean

AutoFitterOptions.MaxRowHeight property

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

Type: float

AutoFitterOptions.AutoFitWrappedTextType property

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

Type: int

AutoFitterOptions.FormatStrategy property

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

Type: int

AutoFitterOptions.ForRendering property

Indicates whether fit for rendering purpose.

Type: boolean