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. |
isNull() | Checks whether the implementation object is null. |
constructor()
Default Constructor.
constructor();
getDefaultEditLanguage()
Gets or sets default edit language.
getDefaultEditLanguage() : DefaultEditLanguage;
Returns
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
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
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
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. |
isNull()
Checks whether the implementation object is null.
isNull() : boolean;