AutoFitterOptions – Properties & Usage Guide | Aspose.Cells Cloud API
Contents
[
Hide
]
AutoFitterOptions Properties
The AutoFitterOptions object lets you fine‑tune the automatic row‑height adjustment performed by Aspose.Cells Cloud. It is useful when you need precise control over merged‑cell handling, hidden rows/columns, language‑specific formatting, or rendering‑specific behavior.
| Name | Type | Description | Notes |
|---|---|---|---|
| AutoFitMergedCellsType | string | Determines how merged cells are auto‑fitted. | Allowed values: All, First, None. Default: All. Sample JSON: "AutoFitMergedCellsType":"All" |
| IgnoreHidden | boolean | When true, hidden rows and columns are ignored during the auto‑fit process. | Default: false. Sample JSON: "IgnoreHidden":false |
| OnlyAuto | boolean | Indicates whether only rows whose heights are not manually customized should be auto‑fitted. | Default: false. Sample JSON: "OnlyAuto":false |
| DefaultEditLanguage | string | Sets the default editing language for the workbook. | Default: system language (e.g., "en-US"). Sample JSON: "DefaultEditLanguage":"en-US" |
| MaxRowHeight | double | Maximum row height (in points) applied when auto‑fitting rows. A value of 0 means no limit. | Default: 0. Sample JSON: "MaxRowHeight":0 |
| AutoFitWrappedTextType | string | Controls how wrapped text within cells is auto‑fitted. | Allowed values: All, OnlyWrapped, None. Default: All. Sample JSON: "AutoFitWrappedTextType":"All" |
| FormatStrategy | string | Specifies the formatting strategy used during the auto‑fit operation. | Common values: AutoFit, PreserveExisting. Default: AutoFit. Sample JSON: "FormatStrategy":"AutoFit" |
| ForRendering | string | Indicates whether the auto‑fit should be performed for rendering purposes (e.g., PDF, image). | Allowed values: True, False. Default: False. Sample JSON: "ForRendering":"False" |