Page 1 of 1
Formatted field - conditions
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: Wed Jan 10, 2018 4:52 pm
by mihmih
So in Base, there is a restriction to 3 conditions?
Re: Formatted field - conditions
Posted: 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).