FlxConsts Class
Utility methods and constants usable anywhere.
Syntax
Namespace: FlexCel.Core
public static class FlxConsts
Fields
Name | Description |
---|---|
DefColWidthAdapt | OBSOLETE: Use ExcelMetrics.DefColWidthAdapt instead. Multiply by this number to convert the DEFAULT column width to pixels. This is different from ColMult, that goes in a column by column basis. |
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. |
ColMult | OBSOLETE: Use ExcelMetrics.ColMult instead. Multiply by this number to convert the width of a column from pixels to excel internal units. Note that the default column width is different, you need to multiply by DefColWidthAdapt |
RowMult | Multiply by this number to convert pixels to excel row height units. |
DispMul | Number of points in an inch. |
ColMultDisplay | OBSOLETE: Use ExcelMetrics.ColMultDisplay instead. Multiply by this number to convert the width of a column from GraphicsUnit.Display units (1/100 inch) to Excel internal units. Note that the default column width is different, you need to multiply by DefColWidthAdapt |
RowMultDisplay | OBSOLETE: Use ExcelMetrics.RowMultDisplay instead. Multiply by this number to convert the height of a row from GraphicsUnit.Display units (1/100 inch) to Excel internal units. |
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 ExcelFile.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. |
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 |
---|---|
EncodeColumn | OBSOLETE: Use TCellAddress.EncodeColumn instead. Returns "A" for column 1, "B" for 2 and so on. |
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 ExcelFile.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 ExcelFile.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 ExcelFile.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 ExcelFile.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. |