VintaSoft Imaging .NET SDK 14.0: Documentation for .NET developer
Vintasoft.Imaging.Office.Spreadsheet.Formulas Namespace / FormulaExpression Class / Translate(Int32,Int32) Method
Syntax Remarks Requirements SeeAlso
In This Topic
    Translate(Int32,Int32) Method (FormulaExpression)
    In This Topic
    Shifts the position of all non-fixed cell references in the formula.
    Syntax
    'Declaration
    
    Public Sub Translate( _
    ByVal dx
    Horizontal reference offset.
    As System.Int32, _
    ByVal dy
    Vertical reference offset.
    As System.Int32 _
    )
    public void Translate(
    System.Int32 dx,
    System.Int32 dy
    )
    public: void Translate(
    System.Int32 dx,
    System.Int32 dy
    )
    public:
    void Translate(
    System.Int32 dx,
    System.Int32 dy
    )

    Parameters

    dx
    Horizontal reference offset.
    dy
    Vertical reference offset.
    Remarks

    If link has fixed row or column, row or column will not be changed. Method changes only explicitly specified links in A1 format.

    Requirements

    Target Platforms: .NET9; .NET 8; .NET 7; .NET 6; .NET Framework 4.8, 4.7, 4.6, 4.5, 4.0, 3.5

    See Also