Search Results for

    Show / Hide Table of Contents

    TCellAddress.TrySetCellRef Method

    Overloads

    • TCellAddress.TrySetCellRef(string)
    • TCellAddress.TrySetCellRef(string, TReferenceStyle, Integer, Integer)

    TCellAddress.TrySetCellRef(string)

    Tries to set a cell reference, and returns true if the cell is a correct A1 reference. This is similar to setting CellRef to a string, but it will not raise an exception.

    Syntax

    Unit: FlexCel.Core

    function TCellAddress.TrySetCellRef(const value: string): Boolean; overload;

    Parameters

    <-> Parameter Type Description
    const value string String with the cell reference, in A1 format. To use R1C1 notation, see TrySetCellRef(string, TReferenceStyle, Integer, Integer)

    Returns

    True if value was a correct cell reference, false otherwise.

    See also

    • TCellAddress

    TCellAddress.TrySetCellRef(string, TReferenceStyle, Integer, Integer)

    Tries to set a cell reference, and returns true if the cell is a correct A1 or R1C1 reference.

    Syntax

    Unit: FlexCel.Core

    function TCellAddress.TrySetCellRef(const value: string; const referenceStyle: TReferenceStyle; const cellRow: Integer; const cellCol: Integer): Boolean; overload;

    Parameters

    <-> Parameter Type Description
    const value string String with the cell reference, in A1 or R1C1 format.
    const referenceStyle TReferenceStyle Style the reference is in (A1 or R1C1).
    const cellRow Integer Row where the cell is. This is only used for R1C1 relative references, to know where the cell is. For example, the reference R[1]C[1] when cellRow is 5 will reference row 6. A1 references or absolute R1C1 references ignore this parameter.
    const cellCol Integer Column where the cell is. This is only used for R1C1 relative references, to know where the cell is. For example, the reference R[1]C[1] when cellCol is 5 will reference column 6. A1 references or absolute R1C1 references ignore this parameter.

    Returns

    True if value was a correct cell reference, false otherwise.

    See also

    • TCellAddress
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com