AutoFitterOptions

AutoFitterOptions class

Represents all auto fitter options.

class AutoFitterOptions;

Constructors

Constructor	Description
constructor()	Default Constructor.

Properties

Property	Type	Description
defaultEditLanguage	DefaultEditLanguage	Gets or sets default edit language.
autoFitMergedCellsType	AutoFitMergedCellsType	Gets and set the type of auto fitting row height of merged cells.
onlyAuto	boolean	Indicates whether only fit the rows which height are not customed.
ignoreHidden	boolean	Ignores the hidden rows/columns.
maxRowHeight	number	Gets and sets the max row height(in unit of Point) when autofitting rows.
autoFitWrappedTextType	AutoFitWrappedTextType	Gets and sets the type of auto fitting wrapped text.
formatStrategy	CellValueFormatStrategy	Gets and sets the formatted strategy.
forRendering	boolean	Indicates whether fit for rendering purpose.

Methods

Method	Description
getDefaultEditLanguage()	@deprecated. Please use the ‘defaultEditLanguage’ property instead. Gets or sets default edit language.
setDefaultEditLanguage(DefaultEditLanguage)	@deprecated. Please use the ‘defaultEditLanguage’ property instead. Gets or sets default edit language.
getAutoFitMergedCellsType()	@deprecated. Please use the ‘autoFitMergedCellsType’ property instead. Gets and set the type of auto fitting row height of merged cells.
setAutoFitMergedCellsType(AutoFitMergedCellsType)	@deprecated. Please use the ‘autoFitMergedCellsType’ property instead. Gets and set the type of auto fitting row height of merged cells.
getOnlyAuto()	@deprecated. Please use the ‘onlyAuto’ property instead. Indicates whether only fit the rows which height are not customed.
setOnlyAuto(boolean)	@deprecated. Please use the ‘onlyAuto’ property instead. Indicates whether only fit the rows which height are not customed.
getIgnoreHidden()	@deprecated. Please use the ‘ignoreHidden’ property instead. Ignores the hidden rows/columns.
setIgnoreHidden(boolean)	@deprecated. Please use the ‘ignoreHidden’ property instead. Ignores the hidden rows/columns.
getMaxRowHeight()	@deprecated. Please use the ‘maxRowHeight’ property instead. Gets and sets the max row height(in unit of Point) when autofitting rows.
setMaxRowHeight(number)	@deprecated. Please use the ‘maxRowHeight’ property instead. Gets and sets the max row height(in unit of Point) when autofitting rows.
getAutoFitWrappedTextType()	@deprecated. Please use the ‘autoFitWrappedTextType’ property instead. Gets and sets the type of auto fitting wrapped text.
setAutoFitWrappedTextType(AutoFitWrappedTextType)	@deprecated. Please use the ‘autoFitWrappedTextType’ property instead. Gets and sets the type of auto fitting wrapped text.
getFormatStrategy()	@deprecated. Please use the ‘formatStrategy’ property instead. Gets and sets the formatted strategy.
setFormatStrategy(CellValueFormatStrategy)	@deprecated. Please use the ‘formatStrategy’ property instead. Gets and sets the formatted strategy.
getForRendering()	@deprecated. Please use the ‘forRendering’ property instead. Indicates whether fit for rendering purpose.
setForRendering(boolean)	@deprecated. Please use the ‘forRendering’ property instead. Indicates whether fit for rendering purpose.
isNull()	Checks whether the implementation object is null.

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;

getDefaultEditLanguage()

@deprecated. Please use the ‘defaultEditLanguage’ property instead. Gets or sets default edit language.

getDefaultEditLanguage() : DefaultEditLanguage;

Returns

DefaultEditLanguage

Remarks

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

setDefaultEditLanguage(DefaultEditLanguage)

@deprecated. Please use the ‘defaultEditLanguage’ property instead. Gets or sets default edit language.

setDefaultEditLanguage(value: DefaultEditLanguage) : void;

Parameters:

Parameter	Type	Description
value	DefaultEditLanguage	The value to set.

Remarks

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

getAutoFitMergedCellsType()

@deprecated. Please use the ‘autoFitMergedCellsType’ property instead. Gets and set the type of auto fitting row height of merged cells.

getAutoFitMergedCellsType() : AutoFitMergedCellsType;

Returns

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.

setAutoFitMergedCellsType(AutoFitMergedCellsType)

@deprecated. Please use the ‘autoFitMergedCellsType’ property instead. Gets and set the type of auto fitting row height of merged cells.

setAutoFitMergedCellsType(value: AutoFitMergedCellsType) : void;

Parameters:

Parameter	Type	Description
value	AutoFitMergedCellsType	The value to set.

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.

getOnlyAuto()

@deprecated. Please use the ‘onlyAuto’ property instead. Indicates whether only fit the rows which height are not customed.

getOnlyAuto() : boolean;

setOnlyAuto(boolean)

@deprecated. Please use the ‘onlyAuto’ property instead. Indicates whether only fit the rows which height are not customed.

setOnlyAuto(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getIgnoreHidden()

@deprecated. Please use the ‘ignoreHidden’ property instead. Ignores the hidden rows/columns.

getIgnoreHidden() : boolean;

setIgnoreHidden(boolean)

@deprecated. Please use the ‘ignoreHidden’ property instead. Ignores the hidden rows/columns.

setIgnoreHidden(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getMaxRowHeight()

@deprecated. Please use the ‘maxRowHeight’ property instead. Gets and sets the max row height(in unit of Point) when autofitting rows.

getMaxRowHeight() : number;

setMaxRowHeight(number)

@deprecated. Please use the ‘maxRowHeight’ property instead. Gets and sets the max row height(in unit of Point) when autofitting rows.

setMaxRowHeight(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getAutoFitWrappedTextType()

@deprecated. Please use the ‘autoFitWrappedTextType’ property instead. Gets and sets the type of auto fitting wrapped text.

getAutoFitWrappedTextType() : AutoFitWrappedTextType;

Returns

AutoFitWrappedTextType

setAutoFitWrappedTextType(AutoFitWrappedTextType)

@deprecated. Please use the ‘autoFitWrappedTextType’ property instead. Gets and sets the type of auto fitting wrapped text.

setAutoFitWrappedTextType(value: AutoFitWrappedTextType) : void;

Parameters:

Parameter	Type	Description
value	AutoFitWrappedTextType	The value to set.

getFormatStrategy()

@deprecated. Please use the ‘formatStrategy’ property instead. Gets and sets the formatted strategy.

getFormatStrategy() : CellValueFormatStrategy;

Returns

CellValueFormatStrategy

Remarks

The default value is CellStyle for performance.

setFormatStrategy(CellValueFormatStrategy)

@deprecated. Please use the ‘formatStrategy’ property instead. Gets and sets the formatted strategy.

setFormatStrategy(value: CellValueFormatStrategy) : void;

Parameters:

Parameter	Type	Description
value	CellValueFormatStrategy	The value to set.

Remarks

The default value is CellStyle for performance.

getForRendering()

@deprecated. Please use the ‘forRendering’ property instead. Indicates whether fit for rendering purpose.

getForRendering() : boolean;

setForRendering(boolean)

@deprecated. Please use the ‘forRendering’ property instead. Indicates whether fit for rendering purpose.

setForRendering(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;