https://bugs.freedesktop.org/show_bug.cgi?id=67581
Cor Nouws <c...@nouenoff.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- OS|Windows (All) |All Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #6 from Cor Nouws <c...@nouenoff.nl> --- (In reply to comment #0) > UNWANTED RESULTS: > 1. The original formulas in "file 1", pointing to pre-existing named ranges > in "file 1" are corrupted - their named range references have been replaced > with one of the range names pasted in from "file 2" Can confrim this. > 2. If I edit the formulas to replace the unwanted range names with the > original range names, they WILL NOT CHANGE. When I press enter to confirm > my formula edit, the range name I just typed in reverts immediately to the > new, incorrect range name What I found: in the window Manage names, there are single quotes around the sheet name MASTER SUMMARY. Removing those, makes that the original range names are again used in the formulas, but then the formulas pasted from file2 are corrupted :) (In 4.1.0.4 I had a different result - there is some problem with c&paste formulas from another file IIRC). -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs