https://bugs.freedesktop.org/show_bug.cgi?id=59391
Priority: medium
Bug ID: 59391
Assignee: [email protected]
Summary: Naming a cell causes certain references using labeled
ranges to go undefined; recalculate/autocalculate
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 73046
--> https://bugs.freedesktop.org/attachment.cgi?id=73046&action=edit
Simple example of spreadsheet that fails when cell is named as documented in
the problem description.
Naming any cell by selecting the cell and typing the name in the name box
causes references to go undefined. In the example attached, the references that
go undefined are in formulas in the second column that reference the column
label of the third column. The failure seems to be dependent on the following
conditions.
1. The "name box" is used to define the name for the cell (rather than the menu
dialog "Insert > Name > Define").
2. The equations in the second column reference the label heading of the third
column.
3. In the third column, the cell immediately below the column label cell
contains a formula that references the label heading of the first column.
The steps for demonstrating the failure using the attached ods file are the
following.
1. Open the file.
2. Select cell D5 and then enter in the name box a legal name such as
'legalName' (no quotes), thus any formula that includes 'legalName' no quotes
will reference cell D5.
After naming cell D5, then cells B3 and B4 go undefined with the '#REF' error
indication. Editing the formula for either cell B3 or B4 will then cause the
formula to be evaluated correctly again. Recalculate doesn't fix the '#REF'
errors.
I'm using 3.5.7.2, but before isolating the problem I tried 4.0.0.x and it had
the same problem (though I didn't specifically try the attached simplified
example with that version.)
--
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
