Created attachment 74926 [details] document as descibed above Problem description: FORMATTING: calculated negative numbers are not shown in red colour when reopening a file Steps to reproduce: 1. New document 2. fill cell a1 with -2, b1 with -1 and c1 with formula =a1+b1 (result: -3) 3. format all three cells as format of number with "negative in red"; all thre cells are shown in red 4. save the file and close libre office 5. open the file again: only cell a1 and b1 are shown in red, c1 is shown black Current behavior: see above Expected behavior: after reopening the file all three cells should be shown in red Operating System: Windows 7 Version: 4.0.0.3 release Last worked in: 3.6.5.2 release
altered the summary a bit 'format' -> 'conditional format'
Sorry, you are right. This isn't conditional formatting. My bad I can confirm this behavior using LibreOffice Version 4.1.0.0.alpha0+ (Build ID: c16e9f4ed97f65357e9986f46ad88ee9f223799) (build today) Linux Mint 14 x64. When you do ctrl+shift+F9 (=recalculation) this'll solve the problem.
Thanks to Markus (=developer) I mark this bug as duplicate of Bug 60215 *** This bug has been marked as a duplicate of bug 60215 ***