Using Offset Cells in Script formulas

[CVW]

this is a simple example of the question that I have. How do I use an offset cell in a formula

function main(workbook: ExcelScript.Workbook) {
// Get the currently active cell in the workbook.
let activeCell = workbook.getActiveCell();

// Get the cell to the left of the active cell use it in the formula.
let leftCell = activeCell.getOffsetRange(0, -1);

// Simple formula
activeCell.setValue("=len(leftCell)");

}

 

[ExcelToDAX]

How about:

function main(workbook: ExcelScript.Workbook) {
    let activeCell = workbook.getActiveCell();
    
    let leftCellAddress = activeCell.getOffsetRange(0, -1).getAddress();

    activeCell.setFormula(`=LEN(${leftCellAddress})`);

}

 

[CVW]

How about:

function main(workbook: ExcelScript.Workbook) {
    let activeCell = workbook.getActiveCell();
   
    let leftCellAddress = activeCell.getOffsetRange(0, -1).getAddress();

    activeCell.setFormula(`=LEN(${leftCellAddress})`);

}

Thank you