Formatted field - conditions

Creating and using forms
Post Reply
mihmih
Posts: 111
Joined: Wed Feb 18, 2015 9:21 pm

Formatted field - conditions

Post 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";
LibreOffice 4.2 on Windows7
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: formatted field - conditions

Post 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?
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.
mihmih
Posts: 111
Joined: Wed Feb 18, 2015 9:21 pm

Re: Formatted field - conditions

Post 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 ...
Attachments
Nowa Baza Danych.odb
(11.01 KiB) Downloaded 236 times
LibreOffice 4.2 on Windows7
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Formatted field - conditions

Post 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...
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.
mihmih
Posts: 111
Joined: Wed Feb 18, 2015 9:21 pm

Re: Formatted field - conditions

Post by mihmih »

So in Base, there is a restriction to 3 conditions?
LibreOffice 4.2 on Windows7
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Formatted field - conditions

Post 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).
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.
Post Reply