https://bugs.freedesktop.org/show_bug.cgi?id=67581
Priority: medium
Bug ID: 67581
Assignee: [email protected]
Summary: COPYING CELLS WITH NAMED RANGES FROM ONE SPREADSHEET
TO ANOTHER CORRUPTS FORMULA REFERENCES TO PREEXISTING
NAMED RANGES IN TARGET SPREADSHEET
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.6.5.2 release
Component: Libreoffice
Product: LibreOffice
I have a spreadsheet file "file 1" with several named ranges. VLOOKUP formulas
in this spreadsheet refer to the named ranges.
I have a second spreadsheet file "file 2" with formulas and named ranges which
I want to copy into the "file 1". There is no duplication of range names in or
between the 2 spreadsheets
Both files were created in LibreOffice, in .ods format. Neither file has ever
been saved in a different format, or opened with an application other then
LibreOffice
So, here is the problem:
1. Copy cells containing formulas and named ranges from "file 2" to the Windows
clipboard
2. Paste from the clipboard to a blank sheet in "file 1"
Result: formulas are pasted successfully, and named ranges are created
successfully in "file 1". All the original named ranges in "file 1" are still
visible and accesible i.e. click on a range name in the NAME BOX dropdown, and
the correct range is highlighted
Now the bad part...
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"
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
I can't find an existing bug report for this behaviour. I have encountered
this problem three times now, with three different pairs of calc spreadsheet
files
--
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
