https://bugs.freedesktop.org/show_bug.cgi?id=45385
famo <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from famo <[email protected]> 2012-03-15 10:38:56 UTC --- hey Markus, any thoughts on my comment #4 ? I tested your example from comment #3: > Create a document with: Sheet1, Sheet2, Sheet3 and another one with: Sheet3, > Sheet1, Sheet2 and now copy the formula =$Sheet1.$A$2 from Sheet2 of the first > document to the second document. My guess of the problem: In the formulas names are used for referencing to the sheets. However internally the sheets are referenced by ID: Name | ID Sheet1 | 0 Sheet2 | 1 Sheet3 | 2 This means the formula =$Sheet.A1 does not reference to the sheet with the name "Sheet1" (what would one actually expect), but to the first sheet of the document (the one with ID 0). If this formula is copied now to another document, for example such as this one: Name | ID Sheet3 | 0 Sheet1 | 1 Sheet2 | 2 The formula =$Sheet1.A1 converts to =$Sheet3.A1, that is unexpected. A sane solution would be here to keep the name and accordingly the name reference on copying. Is this technical feasible? What do you think? I would plead for REOPEN of this bug. -- 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
