2007/2/4, Bart Aimar <[EMAIL PROTECTED]>:
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]
My workaround is to not insert rows but rather move everything below a row one step down, but now I am talking about doing it manually, without a macro. And I just read that someone here might have delivered a better answer for you. Johnny Andersson
