https://bugs.freedesktop.org/show_bug.cgi?id=85538
Kevin Suo <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|4.3.2.1 rc |Inherited From OOo OS|Windows (All) |All --- Comment #2 from Kevin Suo <[email protected]> --- Treating sheet name reference as reletive is a critical design flaw in LibreOffice (and also in the old OpenOffice.org / Apache OpenOffice. Assume the follow: [file1] sheet1 - A1: "1" sheet2 - A2: "=sheet1.A1" In Calc: Copy sheet2 to the end of [file1] (named sheet2_2) --> Current behaviour: sheet2_2 A2 becomes "=Sheet2.A1" Copy sheet2 to a new file [file2] --> Current behaviour: in [file2], sheet2: "=#REF!.A1" But, 99% of the spreadsheet users are expecting it shows exact the same content in sheet2_2 as in sheet2, because we are doing COPY, we are not dragging and filing cells. A "copy" means we duplicate sth and it should remain the same as the original. Treating "=Sheet2.A1" as reletive reference and changing it to reference to another sheet when doing sheet coping/moving is really bug behavior. In MS Excel: Copy sheet2 to the end of [file1] (named sheet2_2) --> Current behaviour: sheet2_2 A2 remains the same formular "=Sheet1.A1" Copy sheet2 to a new file [file2] --> Current behaviour: in [file2], sheet2: "=[file1]Sheet1!A1". Further, we can break the link to [file1] so the cell will show only the value "1". The way MS Excel behavious is excactly what the users want. -- 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
