MacOS Mojave version 10.14.3
LibreOffice Community Version: 126.96.36.199
So, I have the following bit of code, which I will explain:
Sub sum_changing_variable_test Dim i As Long, b As Long i = 0 b = 1 Formsomme = "=Sum(D" & b &":D9)" Do Until i = 7 And b = 8 ThisComponent.Sheets.getByIndex(0).getCellByPosition(2,i).Formula = Formsomme i = i + 1 b = b + 1 Loop end sub
So basically, I am writing a macro that will put formula SUM(D1:D9) in cell C1, SUM(D2:D9) in C2, etc., all the way to SUM(D8:D9) in C8, thanks to the variables i and b that go up by one in the Do While…Loop. The variable i is for the rows, and b for the first cell in the D column.
However, for some reason, I just get SUM(D1:D9) from C1 to C9.
Therefore, I don’t know why D1 is not going up to D2, D3, etc., and why the formula is inserted into an additional row, when getCellByPosition(2,i), with i going from 0 to 7, means that the results should only appear in rows 1 to 8.
Would anybody know why this is happening ?
Thanks in advance for any potential attempts at explaining why.