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_​Formula​Arguments2003	Maximum number of arguments for a formula in xls file format.
Max_​Formula​Arguments2007	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.​Default​FormatId
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.
KeepMaxRowsAnd​Columns​When​Updating	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.
MaxNestedCamera​Objects	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
XlsxCompression​Level​ZLib	The compression level in zlib values.
PdfPngCompression​Level​ZLib	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.​Excel​Version 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.​Excel​Version 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.​Excel​Version 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.​Excel​Version is TExcelVersion.​v97_​2003 or 1048575 otherwise.
Max_​Letters​InColumn​Name	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_​Formula​String​Constant	Maximum length of a direct string inside a formula, as in ' = "my long string..."
Max_​Formula​Len97_​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.