[Solved] Write a loop to keep the formula

[luofeiyu]

From column B to F, i want to keep the expression.

Code: Select all

b5=b2*b3
c5=c2*c3
d5=d2*d3
e5=e2*e3
f5=f2*f3

When i is from 1 to 5,the "getCellByPosition(i, 4)" can express b5,c5,d5,e5,f5,how to express the right part such as "b2*b3"?

Code: Select all

sub strtest()
    oDoc = ThisComponent
    Sheets = oDoc.getSheets()
    Sheet = Sheets.getByName("Sheet1")
    for  i=1 to 5
       Sheet.getCellByPosition(i, 4).formula = "=some_string_expression"
    next 
end sub

[robleyd]

Nested loops

[karolus]

python:

Code: Select all

doc = XSCRIPTCONTEXT.getDocument()
columns = "BCDEF"
out =[[f"={c}2*{c}3" for c in columns ]]
cellrange = doc.Sheets["Sheet1"]["B5:F5"]
cellrange.FormulaArray = out