Formatted field - conditions

[mihmih]

Hi,

in one of the columns of the table I would like to have different colors of numerical values, but as soon as I enter the fourth condition, all the code disappears. Is there any restriction to max 3 conditions?

I would like to get something like that:

[=1][BLACK]"a";[=2][RED]"b";[=3][GREEN]"c";[>3][BLUE]"d";

[Zizi64]

in one of the columns of the table I would like to have different colors of numerical values, but as soon as I enter the fourth condition, all the code disappears. Is there any restriction to max 3 conditions?

I would like to get something like that:

[=1][BLACK]"a";[=2][RED]"b";[=3][GREEN]"c";[>3][BLUE]"d";
LibreOffice 4.2 on Windows7

The LibreOffice can handle more than 3 conditions in the CF function.

Can you upload your ODF type sample file here?

[mihmih]

when I paste the following text into the control code and click OK, then when I open the formatting again, in the code is only "Standard".


[RED][=1]"one";[BLUE][=2]"two";[BLACK][=3]"three";[RED][=4]"four";


Maybe something with this code is wrong? I can only attach a form in which it does not work ...

[Zizi64]

The LibreOffice can handle more than 3 conditions in the CF function.

Oh sorry, I see now: it is a Base related question, but not a Calc related one...

[mihmih]

So in Base, there is a restriction to 3 conditions?

[Zizi64]

So in Base, there is a restriction to 3 conditions?

Sorry, I do not know that. I never used the Base. The AOO Calc application has such restriction (but the LibreOffice Calc has not).