https://bugs.freedesktop.org/show_bug.cgi?id=45385
--- Comment #8 from Markus Mohrhard <[email protected]> 2012-03-16 04:36:51 PDT --- So let me explain the reasons for this solution once in all detail. Copying sheet references between different sheets is a bit of a pain. Internally we use an index to indentify sheets but these don't need to be the same in different documents for the same sheet. So the simple index based copy/paste can't work. Using the sheet name is only a little bit better because you will only get useful results if you copy between similar documents. That means documents that more or less are in a direct relation, have the same structure and use the same names for the same data areas. If you copy between documents that are unrelated but still have the same sheet names you get just crap. Since we have two different sheet addressing modes we( Eike, Kohei and I ) decided that the sanest solution is to keep relative sheet ranges as they are and transform absolute sheet references to external ones pointing to the old data. The ideas behind this solution is that marking a sheet reference as absolute is a decision by the user where he says that he always wants to refer to this sheet. We further decided that references to the copied area will be preserved because they still point to the same data. So copying a whole sheet will not transform the absolute sheet refs pointing to this sheet, only the absolute sheet refs pointing to other sheets. Then ther are relative sheet refs and these are not transformed during a copy/paste between different documents. They still behave like our old absolute sheet ref behavior. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
