AutoFitterOptions

AutoFitterOptions class

Represents all auto fitter options.

class AutoFitterOptions;

Constructors

NameDescription
constructor()Default Constructor.

Properties

PropertyTypeDescription
defaultEditLanguageDefaultEditLanguageGets or sets default edit language.
autoFitMergedCellsTypeAutoFitMergedCellsTypeGets and set the type of auto fitting row height of merged cells.
onlyAutobooleanIndicates whether only fit the rows which height are not customed.
ignoreHiddenbooleanIgnores the hidden rows/columns.
maxRowHeightnumberGets and sets the max row height(in unit of Point) when autofitting rows.
autoFitWrappedTextTypeAutoFitWrappedTextTypeGets and sets the type of auto fitting wrapped text.
formatStrategyCellValueFormatStrategyGets and sets the formatted strategy.
forRenderingbooleanIndicates whether fit for rendering purpose.

constructor()

Default Constructor.

constructor();

defaultEditLanguage

Gets or sets default edit language.

defaultEditLanguage : DefaultEditLanguage;

Remarks

It may display/render different layouts for text paragraph when different edit languages is set. Default is Aspose.Cells.DefaultEditLanguage.Auto.

autoFitMergedCellsType

Gets and set the type of auto fitting row height of merged cells.

autoFitMergedCellsType : AutoFitMergedCellsType;

Remarks

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.

onlyAuto

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

onlyAuto : boolean;

ignoreHidden

Ignores the hidden rows/columns.

ignoreHidden : boolean;

maxRowHeight

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

maxRowHeight : number;

autoFitWrappedTextType

Gets and sets the type of auto fitting wrapped text.

autoFitWrappedTextType : AutoFitWrappedTextType;

formatStrategy

Gets and sets the formatted strategy.

formatStrategy : CellValueFormatStrategy;

Remarks

The default value is CellStyle for performance.

forRendering

Indicates whether fit for rendering purpose.

forRendering : boolean;