Search Results for

    Show / Hide Table of Contents

    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.
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com