”Standard” is filled in by default, so I believe that ”Standard” is the correct term. All I did was to surrond the term with conditionsm kind of…
I also tried to replace ”Standard” with stuff like ”##0,00” and things like that. The result was the same, however. I run the English (US) version currently, but my operating system is set to Swedish, that's why I use commas as decimal separator, just in case anyone wonder. Johnny Rosenberg OpenOffice.org Calc 3.1.0 Ubuntu 8.10 (Yes, I got rid of the Ubuntu version of OpenOffice.org and replaced it with the version mentioned above) 2009/6/13 Brian Barker <[email protected]>: > At 08:56 13/06/2009 +0200, Johnny Rosenberg wrote: >> >> Conditional number formatting can be done in several ways, but this >> question is about the †right click → format cells†way, manually >> entering the number format. >> >> This is an example that didn't work like I expected: >> [BLUE][<-5]Standard;[RED][>30]Standard;[GREEN]Standard > > You had me confused a little here, since "Standard" doesn't do anything > significant in my (English) version of OpenOffice Calc (3.1 for Windows XP); > perhaps you translated from the Swedish? It needs to be "General" in > English, in fact. (But - perversely - the button in the Formatting toolbar > has the help tip "Number Format: Standard".) > >> For values <-5 it looks right, for example -6 is displayed as -6 in blue. >> However values≥-5 and <0 display a POSITIVE value in green. Where is the >> minus sign? > > Er, quite! With "General", I see the same effect as you. And it's not a > characteristic of the General format either: I see the same results if I use > "0" in place of "General". > >> Is this a bug or am I doing something wrong? > > Yes and no (in that order), I suspect. > > I'm sorry that this will not help much. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
