https://bugs.freedesktop.org/show_bug.cgi?id=81435
Priority: medium
Bug ID: 81435
Assignee: [email protected]
Summary: Names lose reference information when copying cell
ranges
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
How to reproduce:
Open the attachted example file. Press CTRL+F3 to verify that the names
“NamedField_1”, “NamedField_2” and “NamedField_3” are properly defined,
referring to $Sheet2_1.$C$3, $Sheet2_1.$C$5 and $Sheet2_1.$C$6 respectively.
In Sheet2_2 select cells A4 … C4 and copy them (Using CTRL+C and CTRL+V) into
the corresponding blank cells in Sheet2_1.
Current behaviour:
Pressing CTRL+F3 shows that “NamedField_1”, “NamedField_2” and “NamedField_3”
now display an #REF!-Error. Despite this error, the value in Sheet2_1.C8 is
unchanged. Note that this cell refers to the names that contain the ref error.
Save and reload the spreadsheet changes the value in cell Sheet2_1.C8: It now
displays an error.
Expected behaviour:
The names should not be affected by the insertion.
I observed that copying cell ranges produces other effects too. Cells referred
to different ranges after copying some unrelated cells. Unfortunately I was not
yet able construct a situation that reliably demonstrates this behaviour.
As the correct reference information is lost, this error involves loss of data
and that's why I classified it as major error. What makes the situation worse
is that this loss of information may go unnoticed: Cell Sheet2_1.C8 remains
unchanged despite the fact the the reference information became invalid.
There are a couple of bugs that seem somehow related to this one:
Bug 81330, bug 67581, bug 81295 and 81294.
--
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
