Formatted field - conditions

Creating and using forms

Formatted field - conditions

Postby mihmih » Tue Jan 09, 2018 9:09 pm

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

Re: formatted field - conditions

Postby Zizi64 » Wed Jan 10, 2018 1:14 am

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; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
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.
User avatar
Zizi64
Volunteer
 
Posts: 7986
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Formatted field - conditions

Postby mihmih » Wed Jan 10, 2018 3:31 pm

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 54 times
LibreOffice 4.2 on Windows7
mihmih
 
Posts: 103
Joined: Wed Feb 18, 2015 9:21 pm

Re: Formatted field - conditions

Postby Zizi64 » Wed Jan 10, 2018 4:44 pm

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; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
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.
User avatar
Zizi64
Volunteer
 
Posts: 7986
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Formatted field - conditions

Postby mihmih » Wed Jan 10, 2018 4:52 pm

So in Base, there is a restriction to 3 conditions?
LibreOffice 4.2 on Windows7
mihmih
 
Posts: 103
Joined: Wed Feb 18, 2015 9:21 pm

Re: Formatted field - conditions

Postby Zizi64 » Fri Jan 12, 2018 11:19 am

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; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
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.
User avatar
Zizi64
Volunteer
 
Posts: 7986
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Forms

Who is online

Users browsing this forum: No registered users and 4 guests