Hi,
inserting rows with insert metod seems having ungrateful effects on
formula positioned in under part cells.
A simple example...
in calc table write:
at cell B11: 1
at cell B12: 2
at cell B13: 3
and in cell B10: =SUM(B11:B13)
and execute this code:
Sub Main
osheet=ThisComponent.sheets.getByName(_
ThisComponent.currentController.activesheet.name)
oSheet.Rows.InsertByIndex(8.3)
end sub
Changing the values of "position row" and "inserting rows nunber" return
unexpected result in B10 formula... (you can easily to try...)
Is it normal?
Any idea for workaround?
thanks
Bart
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
