Hello !
The user of a Calc worksheet has the freedom of adjusting row heights manually. No big deal.
Now, in a macro, I want to know the value of some row heights the user has set.
I thought it will be easily solved but I ran into a problem.
The code below gives me the same row height, no matter which row I ask.
Sub TestRowHeight
dim oRow As Object, nHeight As Long
With ThisComponent.sheets("LabelTemplate")
oRow = ThisComponent.sheets("LabelTemplate").getRows.getByIndex(0)
nHeight = oRow.Height
MsgBox "The Height of the first Row is " + nHeight
oRow = ThisComponent.sheets("LabelTemplate").getRows.getByIndex(1)
nHeight = oRow.Height
MsgBox "The Height of the second Row is " + nHeight
End With
End Sub
I know for a fact that de height of the first row is different from the height of the second row, nevertheless, the message box always displays the height of the first row.
Am I missing something here?
Grtz,