https://bugs.freedesktop.org/show_bug.cgi?id=57229
Priority: medium
Bug ID: 57229
Assignee: [email protected]
Summary: Function-Value not recalculated after deleting
previous cell
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.6.3.2 release
Component: Spreadsheet
Product: LibreOffice
Only on Mac-Book OS X not Windows
In O2:
=SUMME(D2:N2)
In P2:
=WENN(O2<=D$39;6;WENN(UND(O2>C$40;O2<=D$40);5;WENN(UND(O2>C$41;O2<=D$41);4;WENN(UND(O2>C$42;O2<=D$42);3;WENN(UND(O2>C$43;O2<=D$43);2;WENN(UND(O2>C$44;O2<=D$44);1;99))))))
In Q2:
=WENN(P2=6;1;0)
Start:
In O2 = 0
Then P2 = 6
Then Q2 =1
If formula in P2 is being deleted, Q2 should fall back to "0" (zero) but still
shows 1
In previous versions of Calc this has been working properly.
--
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
