https://bugs.documentfoundation.org/show_bug.cgi?id=150312
Bug ID: 150312
Summary: Named ranges disappear in Calc
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
1. Create a new Calc document with two sheets Sheet1 and Sheet2. Activate
Sheet1 and add Named range:
Name: n_1
Range or Formula expression: $Sheet2.$A$1
Scope: Document (Global)
Save document as Book1.ods and close it.
2. Open Book1.ods. Delete sheet Sheet1. Save document as Book2.ods and close
it.
3. Open Book2.ods.
It doesn't have Named Range n_1!
Save document as Book3.ods and close it.
In my opinion, the reason is in the tag attribute table:base-cell-address.
Book1.ods:
<table:named-range table:name="n_1" table:base-cell-address="$Sheet1.$A$1"
table:cell-range-address="$Sheet2.$A$1"/>
Book2.ods:
<table:named-range table:name="n_1" table:base-cell-address=""
table:cell-range-address="$Sheet2.$A$1"/>
Book3.ods does not contain these tags.
--
You are receiving this mail because:
You are the assignee for the bug.
