AutoFitterOptions

AutoFitterOptions class

Represents all auto fitter options.

class AutoFitterOptions;

Constructors

Name	Description
constructor()	Default Constructor.

Methods

Method	Description
getDefaultEditLanguage()	Gets or sets default edit language.
setDefaultEditLanguage(DefaultEditLanguage)	Gets or sets default edit language.
getAutoFitMergedCellsType()	Gets and set the type of auto fitting row height of merged cells.
setAutoFitMergedCellsType(AutoFitMergedCellsType)	Gets and set the type of auto fitting row height of merged cells.
getOnlyAuto()	Indicates whether only fit the rows which height are not customed.
setOnlyAuto(boolean)	Indicates whether only fit the rows which height are not customed.
getIgnoreHidden()	Ignores the hidden rows/columns.
setIgnoreHidden(boolean)	Ignores the hidden rows/columns.
getMaxRowHeight()	Gets and sets the max row height(in unit of Point) when autofitting rows.
setMaxRowHeight(number)	Gets and sets the max row height(in unit of Point) when autofitting rows.
getAutoFitWrappedTextType()	Gets and sets the type of auto fitting wrapped text.
setAutoFitWrappedTextType(AutoFitWrappedTextType)	Gets and sets the type of auto fitting wrapped text.
getFormatStrategy()	Gets and sets the formatted strategy.
setFormatStrategy(CellValueFormatStrategy)	Gets and sets the formatted strategy.
getForRendering()	Indicates whether fit for rendering purpose.
setForRendering(boolean)	Indicates whether fit for rendering purpose.

constructor()

Default Constructor.

constructor();

getDefaultEditLanguage()

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)

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

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)

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

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

getOnlyAuto() : boolean;

setOnlyAuto(boolean)

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

Ignores the hidden rows/columns.

getIgnoreHidden() : boolean;

setIgnoreHidden(boolean)

Ignores the hidden rows/columns.

setIgnoreHidden(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getMaxRowHeight()

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

getMaxRowHeight() : number;

setMaxRowHeight(number)

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

Gets and sets the type of auto fitting wrapped text.

getAutoFitWrappedTextType() : AutoFitWrappedTextType;

Returns

AutoFitWrappedTextType

setAutoFitWrappedTextType(AutoFitWrappedTextType)

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

Gets and sets the formatted strategy.

getFormatStrategy() : CellValueFormatStrategy;

Returns

CellValueFormatStrategy

Remarks

The default value is CellStyle for performance.

setFormatStrategy(CellValueFormatStrategy)

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

Indicates whether fit for rendering purpose.

getForRendering() : boolean;

setForRendering(boolean)

Indicates whether fit for rendering purpose.

setForRendering(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.