SpreadsheetOptions Properties
Free Trial Web API version Licensing Request A Quote
HAVE QUESTIONS OR NEED HELP?SUBMIT THE SUPPORT REQUEST FORM or write email toSUPPORT@BYTESCOUT.COM
The SpreadsheetOptions type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | AutoFitRowsBeforeSave | Gets or sets a value indicating whether make auto-fit of rows before saving |
| CSVDetectDataTypes | Gets or set a value indicating whether to detect data types when loading delimiter-separated formats (CSV, TXT). |
| MaxColumnCountAllowed | Gets the max column count allowed for the current format limitations set (see methods .SetExcel2003Limits, .SetExcel2007Limits, .SetOpenOffice3Limits to set current limitations) |
| MaxRowCountAllowed | Gets the max row count allowed for the current format limitations set (see methods .SetExcel2003Limits, .SetExcel2007Limits, .SetOpenOffice3Limits to set current limitations) |
| MaxStringLengthAllowedPerCell | Gets the max string length per cell allowed for the current format limitations set (see methods .SetExcel2003Limits, .SetExcel2007Limits, .SetOpenOffice3Limits to set current limitations) |
| ThrowExceptionOnCalculateError | Gets or sets a value indicating whether [throw exception on calculate error]. |
| ThrowExceptionOnUnsupportedFormula | Gets or sets a value indicating whether [throw exception on unsupported formula]. |
| ThrowExceptionsOnFormatIncompatibilities | Throw the exception if data can be corrupted while saving to the file or stream (usually this applies, for example, if you save into XLS format while spreadsheet contains formatting not supported by XLS format but supported by XLSX format only) False by default |
| ThrowExceptionsOnFormatLimits | Gets or sets a value indicating whether [throw exceptions on spreadsheet format limits]. |
See Also