https://bugs.freedesktop.org/show_bug.cgi?id=86305
Bug ID: 86305
Summary: EDITING: Entering data into a cell changes array
formula that references that cell
Product: LibreOffice
Version: 4.3.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 109500
--> https://bugs.freedesktop.org/attachment.cgi?id=109500&action=edit
File with an array formula that changes when one of its dependent cells
changes.
In the attached spreadsheet, cell B7 contains the array formula:
{=IF(SUM(B2:B4) > 0, SUM(B2:B4*D2:D4/C2:C4), 0)}
Enter the number 50 into cell B3; cell B7 correctly updates to 17.5%. Now look
at the formula in cell B7. It has changed to:
{=IF(SUM(B2:B4) > 0, SUM(B2:B4*D2:D4/C2:C4), 0.175)}
If you go to cell B3 and press the delete key, the result in cell B7 remains
unchanged instead of going back to zero.
A similar file imported from XLSX format works correctly.
--
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
