Search Results for

    Show / Hide Table of Contents

    TValueType Enumeration

    All the things we can find on a cell.

    Syntax

    Unit: FlexCel.Report

    Members

    Name Value Description
    Const 0 A constant value, like 2 or "a".
    DataSet 1 A value from a Dataset. This tag is written as "<#DataTable.Column>
    Property 2 A report variable, like <#Variable>
    FullDataSet 3 A dataset with "*"
    FullDataSetCaptions 4 Captions for a full dataset.
    IF 5 An #IF construct
    IFS 6 An #IFS construct
    SWITCH 7 A #SWITCH construct
    Include 8 An include Tag.
    Equal 9 A #= tag
    DeleteSheet 10 A #Delete sheet
    SheetVisible 11 A #Sheet visible tag.
    ConfigSheet 12 #Config
    DeleteRange 13 #Delete Range
    DeleteRow 14 #Delete row
    DeleteCol 15 Delete Column
    FormatCell 16 Format cell
    FormatRow 17 Format row
    FormatCol 18 Format column
    FormatRange 19 Format range
    HPageBreak 20 Horizontal page break
    VPageBreak 21 Vertical page break
    Comment 22 This one will not really be stored.
    Evaluate 23 An expression that will be evaluated
    ImgSize 24 Only used inside images, to specify its zoom in %% and its aspect ratio.
    ImgPos 25 Only used inside images, to specify its position inside the cell.
    ImgFit 26 Only used inside images, to specify how to modify the containing cells to hold the image.
    ImgDelete 27 Only used inside images, to delete an image.
    Lookup 28 A lookup field. Parameters are: DataBase, KeyFields, KeyValues, ResultField.
    Array 29 An array of values. Useful for example as the KeyValues argument of the Lookup field.
    Regex 30 A regular expression replace.
    MergeRange 31 A cell that will be merged.
    Formula 32 The contents of this cell should be entered as formula.
    ColumnWidth 33 Adjusts the column width to a specified value.
    RowHeight 34 Adjusts the row height to a specified value.
    Html 35 Defines if the cell has HTML formatted data or not.
    Ref 36 The parameter is considered a reference and will be changed when copying the ranges.
    AutofitSettings 37 Sets autofit settings for the whole sheet.
    Defined 38 Returns true if the expression is defined.
    DefinedFormat 39 Returns true if the format is defined.
    Preprocess 40 An expression that will be pre evaluated and used to modify the template.
    AutoPageBreaks 41 FlexCel should automatically calculate the page breaks in this sheet.
    Aggregate 42 Does an operation like sum or average over a dataset.
    List 43 Concatenates all values in a dataset as a list.
    DbValue 44 Gets the value of a dataset given a row or a column.
    Hyperlink 45 Creates a link for the cell.
    SwapChartSeries 46 Swaps rows and columns in the chart data definition.
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com