Created attachment 78260[details]
sample
MS displays the two Format code with the same result, but AOO doesn't, please see cell A1 and A2
[>0][BLUE]#.0;[<0][RED]#.0;[GREEN]#.000
[<0][RED]#.0;[=0][GREEN]#.000;[BLUE]#.0

Created attachment 78315[details]
Add patch
Root Cause:
AOO will ignore the <0 condition if appear in first scetion
Resolution:
To check the condition of first section, if meet condition, remove the minus sign

This is Apache OpenOffice (AOO) Bugzilla: the Apache OpenOffice (AOO) bug system. In case
of problems with the functioning of Apache OpenOffice (AOO) Bugzilla, please contact
aoo-bugzilla-admin@apache.org.
Please Note: this e-mail address is only for reporting problems
with Apache OpenOffice (AOO) Bugzilla. Mail about any other subject will be silently
ignored.