Summary: | Sheet copy from doc1 to doc2 breaks "Defined Range" linkage | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | devMgr |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | devMgr, ilmari.lauhakangas |
Priority: | medium | ||
Version: | 7.2.1.2 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | small ods with sample Defined Range use and route to failure |
Description
devMgr
2021-11-03 19:53:12 UTC
CORRECTION: The phrase in the Description "logically senseless references to Doc1 definitions" should read "logically senseless references to Doc2 definitions" (In reply to devMgr from comment #0) > 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 Please attach minimal example spreadsheets at this step, so we can quickly reproduce the problem. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the documents. Created attachment 183684 [details]
small ods with sample Defined Range use and route to failure
Attached is a sample ods file, as requested.
The file contains comments to identify 'path to failure' to recreate the fault.
In essence, any change to the sheet population (copy, move, delete but not rename) results in the (inter-sheet) Defined Range(s) relationships becoming corrupt.
Probably stems from the internal sheet identity being inadequately robust/independent.
|