Bug 57229 - Function-Value not recalculated after deleting previous cell
Summary: Function-Value not recalculated after deleting previous cell
Status: RESOLVED DUPLICATE of bug 56278
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.3.2 release
Hardware: x86-64 (AMD64) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-11-17 17:15 UTC by Bernd Kloss
Modified: 2013-11-16 18:17 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
First lines show descripted error (31.50 KB, application/vnd.ms-excel)
2012-11-17 17:34 UTC, Bernd Kloss 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Bernd Kloss 2012-11-17 17:15:07 UTC 
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.
Comment 1 Bernd Kloss 2012-11-17 17:34:50 UTC 
Created attachment 70195 [details]
First lines show descripted error
Comment 2 Bernd Kloss 2012-11-17 17:36:37 UTC 
Bug also occurs when spreadsheet is saved as *.ods
Comment 3 Markus Mohrhard 2012-11-17 17:59:27 UTC 

*** This bug has been marked as a duplicate of bug 56278 ***