https://bugs.freedesktop.org/show_bug.cgi?id=57229
Priority: medium Bug ID: 57229 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Function-Value not recalculated after deleting previous cell Severity: normal Classification: Unclassified OS: Mac OS X (All) Reporter: kloss.mail...@gmail.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs