https://bugs.freedesktop.org/show_bug.cgi?id=64930
Priority: medium
Bug ID: 64930
Assignee: [email protected]
Summary: : Reference to label invalid after FILESAVE/FILEOPEN
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.6.6.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 79720
--> https://bugs.freedesktop.org/attachment.cgi?id=79720&action=edit
Example of failure as explained in the description.
Column label "Alabel" is a function of another cell. When the file is saved and
then opened, the label is invalid in the formula that references the label. In
attached file testCase.ods, cell C1 is a function of cell A1. C1 is defined as
a label (in this case a label for cell C2). This label 'Alabel' is referenced
in the formula in cell B1. After saving and again opening the file, the
reference to 'Alabel' in cell B1 is invalid. To demonstrate the problem, open
file testCase.ods, set contents of cell B1 to "='Alabel'" (no double quotes)
and cell B1 will display the contents of cell C2, i.e. "stuff". After saving
and opening the file again, cell B1 will be "#NAME?", whereas it should be the
value before the file was saved, i.e. "stuff".
--
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
