Page 1 of 1

Formatted field - conditions

PostPosted: Tue Jan 09, 2018 9:09 pm
by 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";

Re: formatted field - conditions

PostPosted: Wed Jan 10, 2018 1:14 am
by 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?

Re: Formatted field - conditions

PostPosted: Wed Jan 10, 2018 3:31 pm
by 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 ...

Re: Formatted field - conditions

PostPosted: Wed Jan 10, 2018 4:44 pm
by 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...

Re: Formatted field - conditions

PostPosted: Wed Jan 10, 2018 4:52 pm
by mihmih
So in Base, there is a restriction to 3 conditions?

Re: Formatted field - conditions

PostPosted: Fri Jan 12, 2018 11:19 am
by 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).