TFlxConsts Record
Utility methods and constants usable anywhere.
Syntax
Unit: FlexCel.Core
TFlxConsts = record;
Constants
Name | Description |
---|---|
Max_Columns97_2003 | Maximum column on an xls (Excel 97 - 2003) spreadsheet. (0 based, that is 255) |
Max_Columns2007 | Maximum column on an xlsx (Excel 2007 and up) spreadsheet. (0 based, that is 16383) |
Max_Rows97_2003 | Maximum row on an xls (Excel 97 - 2003) spreadsheet. (0 based, that is 65535) |
Max_Rows95 | Maximum row on an xls (Excel 2 - 95) spreadsheet. (0 based) |
Max_Rows2007 | Maximum row on an xlsx (Excel 2007 and up) spreadsheet. (0 based, that is 1048575) |
Max_Sheets | Maximum sheet on a spreadsheet. (0 based, that is 65530) |
Max_PxlColumns | Maximum column on Pocket Excel a spreadsheet. (0 based, that is 255) |
Max_PxlRows | Maximum row on a Pocket Excel spreadsheet. (0 based, that is 16383) |
Max_PxlSheets | Maximum sheet on a Pocket Excel spreadsheet. (0 based, that is 255) |
Max_FormulaArguments2003 | Maximum number of arguments for a formula in xls file format. |
Max_FormulaArguments2007 | Maximum number of arguments for a formula in xlsx file format. |
Max_StringLenInCell | Maximum length of a string in a cell. |
RowMult | Multiply by this number to convert pixels to excel row height units. |
DispMul | Number of points in an inch. |
DefaultBrightness | Brightness to keep the image unchanged. |
DefaultContrast | Contrast to keep the image unchanged. |
DefaultGamma | Gamma to keep the image unchanged. |
DefaultRotation | Zero rotation. |
NoTransparentColor | Constant meaning there is no transparent color defined on the image. |
DefaultFormatId | The default XF for a file. You can also access this value with TExcelFile.DefaultFormatId |
ObjectPathSeparator | String used to separate 2 objects on an object path. |
ObjectPathAbsolute | When an objpath starts with this character, it is an absolute path that includes the object index. If it doesn't start with it, then the ObjPath doesn't include the original object. |
ObjectPathObjName | When an objpath starts with this character, it is a path that goes directly to the name of an object. Note that when more than an object have the same name in the same sheet, this path won't work and you will have to use absolute or relative ones. |
ObjectPathSpId | When an objpath starts with this character, what follows is a single shape id that identifies the object. |
Fields
Name | Description |
---|---|
ExcelVersion | Defines the Excel mode used in this thread. Note that while on v2007 (the default) you still can make xls 97 spreadsheets, so the only reason to change this setting is if you have any compatibility issues (for example your code depends on a sheet having 65536 rows). IMPORTANT: Do NOT change this value after reading a workbook. Also, remember that the value is changed for all the reports in all threads. |
KeepMaxRowsAndColumnsWhenUpdating | Defines what FlexCel will do when it finds a reference to the last row or column in an Excel 97-2003 spreadsheet, and it is upgrading to Excel 2007. If false (the default) row 65536 will be updated to row 1048576, and column 256 to column 16384. If true, references will stay the same. Note: This is a global property, so it affects all threads running. |
MaxNestedCameraObjects | When a camera object references an cell range that includes the camera object, there would be infinite recursion. This variable determines what is the maximum times that FlexCel will recurse when rendering the camera objects. |
Methods
Name | Description |
---|---|
XlsxCompressionLevelZLib | The compression level in zlib values. |
PdfPngCompressionLevelZLib | The compression level in zlib values. |
Properties
Name | Description |
---|---|
Max_Columns | Maximum column in the spreadsheet. (0 based). Note that this number is 1 less than the maximum column count, because this value is 0-based. You can use MaxColCount to get the number of columns instead. This number might be 255 if TExcelFile.ExcelVersion is TExcelVersion.v97_2003 or 16383 otherwise. |
MaxRowCount | Returns the maximum number of rows that you can have in a spreadsheet. This is the same as Max_Rows + 1. This number might be 65536 if TExcelFile.ExcelVersion is TExcelVersion.v97_2003 or 1048576 otherwise. |
MaxColCount | Returns the maximum number of columns that you can have in a spreadsheet. This is the same as Max_Columns + 1. This number might be 256 if TExcelFile.ExcelVersion is TExcelVersion.v97_2003 or 16384 otherwise. |
Max_Rows | Maximum row in the spreadsheet. (0 based). Note that this number is 1 less than the maximum row count, because this value is 0-based. You can use MaxRowCount to get the number of columns instead. This number might be 65535 if TExcelFile.ExcelVersion is TExcelVersion.v97_2003 or 1048575 otherwise. |
Max_LettersInColumnName | Number of letters in a column name. This is 2 in xls97 (columns go up to IV) and 3 in xls2007 (columns go up to XFD) |
Max_FormulaLen | Maximum number of characters in a Formula |
Max_FormulaStringConstant | Maximum length of a direct string inside a formula, as in ' = "my long string..." |
Max_FormulaLen97_2003 | Maximum number of characters in a Formula for an Excel 97 to 2003 spreadsheet. |
Max_FormulaLen2007 | Maximum number of characters in a Formula for an Excel 2007 or newer spreadsheet. |
Max_DvErrorTitleLen | Maximum number of characters in an Error title for a Data Validation. |
Max_DvErrorTextLen | Maximum number of characters in an Error text for a Data Validation. |
Max_DvInputTitleLen | Maximum number of characters in an Input title for a Data Validation. |
Max_DvInputTextLen | Maximum number of characters in an Input text for a Data Validation. |
Max_CommentAuthor | Maximum number of characters allowed in the author of a comment. |
Max_ChartSeries | Maximum number of series in a chart. |
MaxRowHeight | The maximum height you can set in a row, multiplied by 20. This is (409 * 20 + 10) and means a maximum row height of 409.5. Excel says the maximum is 409, but you can enter up to 409.5 |
Min_FontSize | Minimum font size allowed in a file. |
Max_FontSize | Maximum font size allowed in a file. |