I have attached two spreadsheets, Source and Target. They differ in only one respect: Target has a named range called NamedRange local to Sheet1 Source has a named range called NamedRange both local to Sheet1 *and* global. All of these ranges have the same definition. Open both spreadsheets. In Source, select and copy all of Sheet1 using Ctrl-A/Ctrl-C. In Target, copy that selection onto cell R1C1 of Sheet1. You will see that Target, previously having no global named ranges, now has a global named range called NamedRange. Since named range definitions are not one of the things that (so far as I know) are supposed to be copied when cells are copied, this behavior is unexpected. in some cases that I cannot reliably reproduce, the target spreadsheet will suffer data corruption upon paste when the source spreadsheet contains a global named range that has the same name as a local named range (on any sheet) on the target. Primarily, this results in named range references being turned into other named ranges. For example, after pasting a formula that referenced range X now references range Y, with predictably bizarre results (usually either a bogus value or #VALUE errors). Turning a references to range X into a #NAME error is also common, even though the source and target both share the same definition of X.
Created attachment 49895 [details] Source spreadsheet to copy/paste from
Created attachment 49896 [details] Target spreadsheet to paste to
[Reproducible] with reporters test kit and "LibreOffice 3.4.2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:203)]" . So OS -> All I see the same with LibO 3.4.1RC daily build, so I modify Version Problem appears only if target document has a local range name with same spelling as global range in source document. The problem also appears with 'Paste Special' and only "Text" checked (but not using Toolbar icon 'Paste - Unformatted Text). @Kohei: Please feel free to reassign if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Where is the bug? If you select "all", the right it's copy all range names in the source, global or not.
Reproduced on LibreOffice 3.4 340m1(Build:103) for OpenSuse Linux.
let me have a look at it
removing target 3.4.3: this won't be an easy change so no chance to include this in the stable branch, I will think about a solution for the 3.5 release Problem is in our named range handling in formulas.
might have a solution that is acceptable for 3-4, have send the patch to the ML for review
will be fixed in 3-5 but not in the stable 3-4 branch