Oops... this seems not to be a bug, but a feature :-( Searching the OOo Calc forum topic, i saw the next solution:
http://www.oooforum.org/forum/viewtopic.phtml?t=59440 (answer on question) <begin solution> JohnV Administrator Joined: 07 Mar 2003 Posts: 4810 Location: Kentucky, USA Posted: Sun Jul 08, 2007 12:25 pm Post subject: Try Tools > Options > Calc > General >From Help: Quote: Expand references when new columns/rows are inserted Specifies whether to expand references when inserting columns or rows adjacent to the reference range. This is only possible if the reference range, where the column or row is inserted, originally spanned at least two cells in the desired direction. Example: If the range A1:B1 is referenced in a formula and you insert a new column after column B, the reference is expanded to A1:C1. If the range A1:B1 is referenced and a new row is inserted under row 1, the reference is not expanded, since there is only a single cell in the vertical direction. If you insert rows or columns in the middle of a reference area, the reference is always expanded. </solution> I've tried this option and now my inserts are behaving as espected :-) Hope this helps other people. P.S.: I think this should be set by default -- Natural named range not updated https://bugs.launchpad.net/bugs/46055 You received this bug notification because you are a member of Ubuntu Bugs, which is a direct subscriber. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
