Search Results for

    Show / Hide Table of Contents

    TFlxNumberFormat Record

    Static class to convert cells to formatted strings. It uses format strings from Excel, that are different to those on .net, so we have to try to reconcile the diffs.

    Syntax

    Unit: FlexCel.Core

    TFlxNumberFormat = record;

    Methods

    Name Description
    FormatValue Overloaded
    FormatValue(TCellValue, string, TCoreExcelFile)
    FormatValue(TCellValue, string, TUIColor, TCoreExcelFile)
    FormatValue(TCellValue, string, TUIColor, TCoreExcelFile, Boolean)
    FormatValue(TCellValue, string, TUIColor, TCoreExcelFile, Boolean, Boolean)
    FormatValue(TCellValue, string, TUIColor, TCoreExcelFile, Boolean, Boolean, TAdaptativeFormats)
    FormatValue(TCellValue, string, TUIColor, TCoreExcelFile, Boolean, Boolean, Integer, TAdaptativeFormats)
    HasDateOrTime Returns true if the format string has a date or a time.
    HasDate Returns true if the format string has a date.
    HasTime Returns true if the format string has a time.
    PercentCount Returns the number of %% sign in a cell. Each %% in the format string multiplies the value by 100, so 0.1 formatted as "0%%" will display as 10%% and formatted as 0%%%% will display as 1000%%%%.

    Properties

    Name Description
    RegionalDateString Returns the string used on a standard date on the current locale
    RegionalDate​Time​String Returns the string used on a standard date and time on the current locale

    Events

    Name Description
    CultureCreating Fires before a culture is created. Read Localized Month Names for more information on how to use it.
    Note that this event is static and it applies to the whole app.
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com