https://bugs.freedesktop.org/show_bug.cgi?id=45385
--- Comment #9 from Rainer Bielefeld <[email protected]> 2012-03-16 05:44:06 PDT --- @Michael: I explained on "[de-users] Workaround für "Bug 45385 - EDITING: Copy Paste formula to different document adds souce document filename to references"" what my problem is Short summarize: I use spreadsheets following my internal standard with data in sheet1 and various calculations based on that data in other sheets of the document. When I had a new idea for a calculation in a newdocument.ods I was able to copy paste the cells with that new idea to an other spreadsheet olddocument.ods follwing the same standard, and I immediately was able to use the new calculation for the old data because the references in the calculation now lead to the project related values in olddocument.ods#seet1. Starting with 3.5 the pasted cells' references will be from olddocument.ods to source data in different newdocument.ods#seet1, what is useless for me. I additionally sometimes use combinations of the standard data from sheet1 with additional data on calculation sheet, and often I have to do an alternative calculation on a different sheet with same source data from sheet1 and different data on calculation sheet, and so I need the absolute reference even within the document to sheet1, and additionally when I copy parts of a sheet (with data on that sheet) do an other document. I believe I do that 1000 times or more a year, and so the find and replace workaround is really annoying. Until now I did not find the time to test whether the proposed workaround with named ranges would work. -- 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
