SpreadsheetML2003SaveOptions
SpreadsheetML2003SaveOptions class
Represents the options for saving Excel 2003 spreadml file.
Constructors
| Name | Description |
|---|---|
| SpreadsheetML2003SaveOptions | Creates the options for saving Excel 2003 spreadml file. |
| SpreadsheetML2003SaveOptions | Creates the options for saving Excel 2003 spreadml file. NOTE: This constructor is now obsolete. Instead, please use Spr |
Properties
| Name | Type | Description |
|---|---|---|
| IsIndentedFormatting | boolean | Causes child elements to be indented. The default value is true. If the value is false, it will reduce the size of the x |
| LimitAsXls | boolean | Limit as xls, the max row index is 65535 and the max column index is 255. |
| ExportColumnIndexOfCell | boolean | The default value is false, it means that column index will be ignored if the cell is contiguous to the previous cell. |
| SaveFormat | int | Gets the save file format. The value of the property is SaveFormat integer constant. |
| ClearData | boolean | Make the workbook empty after saving the file. |
| CachedFileFolder | String | The cached file folder is used to store some large data. |
| ValidateMergedAreas | boolean | Indicates whether validate merged cells before saving the file. The default value is false. |
| MergeAreas | boolean | Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is |
| CreateDirectory | boolean | If true and the directory does not exist, the directory will be automatically created before saving the file. The defaul |
| SortNames | boolean | Indicates whether sorting defined names before saving file. |
| SortExternalNames | boolean | Indicates whether sorting external defined names before saving file. |
| RefreshChartCache | boolean | Indicates whether refreshing chart cache data |
| CheckExcelRestriction | boolean | |
| UpdateSmartArt | boolean | Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSm |
| EncryptDocumentProperties | boolean |
SpreadsheetML2003SaveOptions() (1 of 2)
Creates the options for saving Excel 2003 spreadml file.
SpreadsheetML2003SaveOptions(saveFormat) (2 of 2)
Creates the options for saving Excel 2003 spreadml file. NOTE: This constructor is now obsolete. Instead, please use SpreadsheetML2003SaveOptions() constructor. This property will be removed 12 months later since January 2021. Aspose apologizes for any inconvenience you may have experienced.
| Parameter | Type | Description |
|---|---|---|
| saveFormat | int | A SaveFormat value. The save format. |
SpreadsheetML2003SaveOptions.IsIndentedFormatting property
Causes child elements to be indented. The default value is true. If the value is false, it will reduce the size of the xml file
Type: boolean
SpreadsheetML2003SaveOptions.LimitAsXls property
Limit as xls, the max row index is 65535 and the max column index is 255.
Type: boolean
SpreadsheetML2003SaveOptions.ExportColumnIndexOfCell property
The default value is false, it means that column index will be ignored if the cell is contiguous to the previous cell.
Type: boolean
SpreadsheetML2003SaveOptions.SaveFormat property
Gets the save file format. The value of the property is SaveFormat integer constant.
Type: int
SpreadsheetML2003SaveOptions.ClearData property
Make the workbook empty after saving the file.
Type: boolean
SpreadsheetML2003SaveOptions.CachedFileFolder property
The cached file folder is used to store some large data.
Type: String
SpreadsheetML2003SaveOptions.ValidateMergedAreas property
Indicates whether validate merged cells before saving the file. The default value is false.
Type: boolean
SpreadsheetML2003SaveOptions.MergeAreas property
Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is false.
Type: boolean
SpreadsheetML2003SaveOptions.CreateDirectory property
If true and the directory does not exist, the directory will be automatically created before saving the file. The default value is false.
Type: boolean
SpreadsheetML2003SaveOptions.SortNames property
Indicates whether sorting defined names before saving file.
Type: boolean
SpreadsheetML2003SaveOptions.SortExternalNames property
Indicates whether sorting external defined names before saving file.
Type: boolean
SpreadsheetML2003SaveOptions.RefreshChartCache property
Indicates whether refreshing chart cache data
Type: boolean
SpreadsheetML2003SaveOptions.CheckExcelRestriction property
Type: boolean
SpreadsheetML2003SaveOptions.UpdateSmartArt property
Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.
Type: boolean
SpreadsheetML2003SaveOptions.EncryptDocumentProperties property
Type: boolean