Created attachment 76213 [details] My document for the bugreport with negative numbers and a sum, all with correct formatting. Problem description: Negative numbers in sums aren't displayed in red font-color after loading the spreadsheet. Cells are formatted as numbers (or currency) and selected "negative in red" (I'm on the german UI). While first editing, the formatting is displayed correctly. After saving and loading the document, the negative numbers in sums (only!) are still display in black font-color, instead of red. Steps to reproduce: 1. Create a new spreadsheet. 2. Enter some negative numbers in cells of a column. 3. Make a sum of these negative numbers. 4. Format column als "numbers" (or "currency") and "negative in red". 5. Everything should be displayed correctly. 6. Save and close the document. 7. Load the document. 8. "Static" numbers should be displayed in correct formatting: red font-color. 9. Sum should be displayed in wrong formatting: black font-color. Current behavior: negative sums are displayed with black font-color, instead of red (with correct formatting). Expected behavior: negative sums are displayed with red font-color, instead of red (with correct formatting). Operating System: Mac OS X Version: 4.0.1.2 release
... after loading: if you change a value of a cell, which is involved in the sum calculation, the negative number will be displayed in red font-color again.
Hi Michael, thanks for reporting. In think this is a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=60215 *** This bug has been marked as a duplicate of bug 60215 ***