https://bugs.freedesktop.org/show_bug.cgi?id=81295
Priority: medium
Bug ID: 81295
Assignee: [email protected]
Summary: Name Scope Handling is Incorrect
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 102704
--> https://bugs.freedesktop.org/attachment.cgi?id=102704&action=edit
Example file to show the effect.
How to reproduce:
The attached spreadsheet contains a tab “Aggregation”. Cells C3 … C5 refer to
the global name “Criterion”. These cells should display the values 16, 19 and
5. Press CTRL+F3 to show the “manage names” dialog. Change the scope of the
name “Criterion” from “Document (Global)” to “Description of the Problem”. Note
that the values change to 7, 5 and 3. Now changing the scope of “Criterion”
back to “Document (Global)” or to “Aggregation” does not change these values.
The wrong values persist saving and reloading the document. The reason for this
behaviour seems to be that Calc silently changes the formulas referring to the
range “Criterion”: This name is set between quotes. I have got the impression
that “Criterion” is an undocumented reserved name as the behaviour is different
if you use a name different from “Criterion”.
Expected behaviour: The cells should display an error as the name “Criterion”
is not defined for the “Aggregation” sheet. Changing the scope to “Document
(Global)” or “Aggregation” should restore the original values. Changing the
scope should not trigger changes in the formulas. If the special behaviour is
intended then a warning should appear explaining the special meaning of the
name “Criterion”.
Note: Changing the scope of the name “Values” seems to work as expected.
--
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
