https://bugs.documentfoundation.org/show_bug.cgi?id=145532
Bug ID: 145532
Summary: Sheet copy from doc1 to doc2 breaks "Defined Range"
linkage
Product: LibreOffice
Version: 7.2.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Doc2 is a multi-sheet ods with several Defined Range specifications.
Doc1 is an unrelated ods with separate Defined Range specifications.
If a sheet from Doc1 is copied to Doc2, the distinct Defined Ranges in the two
docs clash.
I'm guessing that the internal tokens for the Defined Ranges used in Doc1 get
confused with the already existing Defined Range tokens in Doc2.
Suffice to say that the defined range names used in the cell formulae of the
moved sheet are replaced by syntactically correct but logically senseless
references to Doc1 definitions.
Any formula affected in this way is of course invalid and the moved sheet
becomes unworkable and not even easily correctable.
There is no obvious route / prep work to avoid this problem.
Possible work-around (v. labour-intensive): prior to copy, delete all defined
ranges in Doc1 (rendering all affected calcs syntactically illegal), move the
sheet to Doc2 and recreate the absent Defined Ranges in Doc2 after the copy.
Seems to meet with success, but is a heck of a lot of work.
(BTW, confirms the idea of 'low-level token' mismatch as the root cause of the
bug.)
Far preferable that a bugfix can be arranged.
Steps to Reproduce:
1.Create Doc1 with Defined Range specs and valid formulae that use the D.R.s
2.Create Doc2 with distinct Defined Range specs and valid formulae that use the
D.R.s
3.Copy a sheet that uses the D.R.s from Doc1 to Doc2
Actual Results:
The DR names used in the Doc1 sheet after the copy have been confused with the
DR names that pre-existed in Doc2. It is as though the low-level representation
of the formula uses an index reference into the DR list, and this is used to
mistakenly refer to a Doc2 DR.
Examination of the post-move formulae shows that the DR placeholder names have
been changed to align with Doc2 DR names.
Expected Results:
1. The DR specifications should copy over without confusion
2. The DR name references in the formulae should remain unchanged
3. The sheet should continue to be useable.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 6; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
