https://bugs.documentfoundation.org/show_bug.cgi?id=166806
Bug ID: 166806
Summary: When copying a group of selected sheets, references
between them change
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Calc users often select a group of related sheets and copy these sheets to
another document.
In this case, in each copied sheet, the reference to the cell range of another
sheet in the formulas is replaced with a reference to the cell range of the
sheet of the source workbook.
Excel behaves differently.
If a formula on the copied sheet (A) contains a reference to a cell range of
another sheet (B), then it is replaced with a reference to the cell range of
the sheet of the source workbook only if the other sheet (B) is not subject to
copying (not selected).
The same logic in Calc and Excel is applied in the case when the copied sheet
contains a hyperlink to other sheets.
In my opinion, Excel's behavior meets user expectations, but Calc's behavior
does not.
Suggestion: in the "Move/Copy Sheet" dialog, provide a parameter that will
regulate the preservation of mutual references (hyperlinks) between the copied
sheets.
The same for the corresponding ".uno:move" command.
In tdf#130180 it is suggested to replace absolute references to sheets with
relative ones. But we should not change the Calc document from which the sheets
are copied. In addition, for example, if the formula on the first sheet
contains a relative reference to the third sheet (the name of the third sheet
is specified without the "$" prefix) and we copy only the first and third
sheets, then the reference after copying will contain an error value.
--
You are receiving this mail because:
You are the assignee for the bug.
