AutoFitterOptions

AutoFitterOptions class

Represents all auto fitter options.

class AutoFitterOptions;

Constructors

NameDescription
constructor()Default Constructor.

Methods

MethodDescription
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.
isNull()Checks whether the implementation object is null.

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:

ParameterTypeDescription
valueDefaultEditLanguageThe 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:

ParameterTypeDescription
valueAutoFitMergedCellsTypeThe 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:

ParameterTypeDescription
valuebooleanThe value to set.

getIgnoreHidden()

Ignores the hidden rows/columns.

getIgnoreHidden() : boolean;

setIgnoreHidden(boolean)

Ignores the hidden rows/columns.

setIgnoreHidden(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe 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:

ParameterTypeDescription
valuenumberThe 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:

ParameterTypeDescription
valueAutoFitWrappedTextTypeThe 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:

ParameterTypeDescription
valueCellValueFormatStrategyThe 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:

ParameterTypeDescription
valuebooleanThe value to set.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;