Search Results for

    Show / Hide Table of Contents

    TExcelFile.SemiAbsoluteReferences Property

    When this property is false, inserting and copying ranges will behave the same as it does in Excel. When this property is true, absolute references to cells inside the block being copied will be treated as relative. For example, if you have:

    A1: 2
    B1: =$A$1 + $A$57
    

    and you copy the row 1 to row 2, in Excel or FlexCel when this property is false you will get:

    A2: 2
    B2: =$A$1 + $A$57
    

    When this property is true, you will get:

    A2: 2
    B2: =$A$2 + $A$57
    

    In the second case, the first reference was updated because it was inside the range being copied, but the second was not. This property might be useful when you want to duplicate blocks of cells, but want the absolute references inside it to point to the newer block.

    Syntax

    Unit: FlexCel.Core

    property TExcelFile.SemiAbsoluteReferences: Boolean

    See also

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