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";
Formatted field - conditions
Formatted field - conditions
LibreOffice 4.2 on Windows7
Re: formatted field - conditions
The LibreOffice can handle more than 3 conditions in the CF function.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
Can you upload your ODF type sample file here?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Formatted field - conditions
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 ...
[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 ...
- Attachments
-
- Nowa Baza Danych.odb
- (11.01 KiB) Downloaded 236 times
LibreOffice 4.2 on Windows7
Re: Formatted field - conditions
Oh sorry, I see now: it is a Base related question, but not a Calc related one...The LibreOffice can handle more than 3 conditions in the CF function.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Formatted field - conditions
So in Base, there is a restriction to 3 conditions?
LibreOffice 4.2 on Windows7
Re: Formatted field - 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).So in Base, there is a restriction to 3 conditions?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.