Created attachment 77422 [details]
A simple spreadsheet with the first cell as a -1 and then every other cell below it multiplying the one two cells above by a -1

The spreadsheet I keep to handle my finances has some columns with 

 [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00

So that negative values always show in red.  

I last saved this spreadsheet in 4.0.2.1 and upon reopening, the formatting has been ignored.  The cells which should show red for a negative value do NOT. They are the normal color, black.   

However, if I changed the first cell in a chain of cells that each rely on the previous one, by placing a negative symbol in front of the formula or number and save it, nothing happens.  Upon removing that negative symbol (the minus sign right after the equal sign) the cell turns red and every cell in the chain that is negative also turns red. 


Steps to reproduce:
1.Create a cell with a -1 and format as stated above (sample attached)
2.Create a chain of cells each referencing the one before
3.Save the file
4.Reopen the file.  All cells will have default formatting, not red on negative formatting.
5.Change the top cell that all the others indirectly rely on by removing the negative sign or putting a positive number in.
6.All following cells in the chain will now respect the RED directive.
7.Change the top cell again, putting the negative sign back in, or changing the number to a negative number
8.All following cells still respect the RED directive.
9.Save the file.
10.Reopen the file, the RED directive is not respected until the top of the chain is changed again.

Current behavior:

Expected behavior:

              
Operating System: Ubuntu
Version: 4.0.2.1 rc