Pergunte aqui

Perfil de paparucino - atividade

2019-08-09 14:38:47 +0200 Marcada como a melhor resposta Change font size in input line 6.03RC3

Hi, Im actually using 6.2.5.2 - debian and the font size in calc input line is about 9px. In version 6.3.0.RC3 fonts are an annoying 12-13px. Question: is this related to gtk 3.18 or there are some switches to set? Thank you

2019-08-09 14:37:56 +0200 Medalha recebida  Pergunta notável (fonte)
2019-08-07 12:39:08 +0200 Medalha recebida  Pergunta popular (fonte)
2019-08-05 16:32:27 +0200 Perguntou Change font size in input line 6.03RC3

Change font size in input line 6.03RC3 Hi, Im actually using 6.2.5.2 - debian and the font size in calc input line is ab

2019-08-03 16:42:59 +0200 Respondeu uma pergunta how to increase font size in input line?

Hi, Im using 6.2.5.2 - debian and the font size in the input line is about 9px. In version 6.3.0.RC3 fonts are an anno

2019-04-09 20:21:51 +0200 Medalha recebida  Pergunta popular (fonte)
2019-04-08 20:53:05 +0200 Marcada como a melhor resposta Removing STYLE() breaks the formula

Hi all, some times ago I received a precious help from this community regarding the use of STYLE(). Well, now Im facing some problems when sheets is read on dropbox or with other suites so I decided to remove the STYLE() option. This works for me like a violin :)

=IF(C30="","",IF(COUNTIF(C6:C26,"MW|SA|PA|MA|PB|MB")=C30,"0"&T(STYLE("Good")),COUNTIF(C6:C26,"MW|SA|PA|MA|PB|MB")-C30&T(STYLE("Bad"))))

Then I modified it this way

=IF(C30="","",IF(COUNTIF(C6:C24,"MW|SA|PA|MA|PB|MB")=C30,"",COUNTIF(C6:C24,"MW|SA|PA|MA|PB|MB")-C30))

Now the cell shows the value in C30, (the one marked italic). I mean, if I change the reference (eg C29) in the first COUNTIF still see the value of C30 in the second COUNTIF. Which brings to my problem: I always see the value of the second C30.

Any suggestion? Thank you in advance

2019-04-08 17:02:43 +0200 Resposta comentada Removing STYLE() breaks the formula

Oh my..!!! My brain stopped to work. You are right. Sorry The "problem" is the cause of this (no comment) thread. Should

2019-04-08 16:52:06 +0200 Pergunta comentada Removing STYLE() breaks the formula

If the result is zero I see a correct blank cell, otherwise I always see the value of C30. It seems the formula doesnt t

2019-04-08 16:29:45 +0200 Pergunta editada Removing STYLE() breaks the formula

Removing STYLE() breaks the formula Hi all, some times ago I received a precious help from this community regarding the

2019-04-08 16:18:04 +0200 Perguntou Removing STYLE() breaks the formula

Removing STYLE() breaks the formula Hi all, some times ago I received a precious help from this community regarding the

2019-03-21 16:44:39 +0200 Marcada como a melhor resposta if cell = value color BG

Hi all, Im a noob user of libreoffice so pls be patient. Situation Cell A1 = value1, Cell B1 = value2, Cell C1 = IF((value2-value1=0),"0","X") What I would like: if result = 0 "color the baground with green, otherwisw red I tried with Conditional formatting (I really know it very little) and the max I got was a 0 or a X without any color

Any idea, suggestion?

Thank you in advance papa

2019-03-21 16:44:39 +0200 Medalha recebida  Acadêmico (fonte)
2018-09-12 14:48:54 +0200 Medalha recebida  Pergunta notável (fonte)
2018-02-22 21:12:41 +0200 Pergunta comentada Cant install 5.4.5 nor 6.0.1

Ok. Will try on Stackexchange

2018-02-22 19:03:09 +0200 Medalha recebida  Pergunta popular (fonte)
2018-02-22 12:05:47 +0200 Perguntou Cant install 5.4.5 nor 6.0.1

Cant install 5.4.5 nor 6.0.1 Hi all, Im trying to install the above versions on my deb machine. Both fails because LO ca

2018-01-18 04:37:16 +0200 Medalha recebida  Pergunta popular (fonte)
2017-11-12 15:19:40 +0200 Resposta comentada if cell = value color BG

It works. Thank you so much!!! papa

2017-11-12 14:45:58 +0200 Perguntou if cell = value color BG

if cell = value color BG Hi all, Im a noob user of libreoffice so pls be patient. Situation Cell A1 = value1, Cell B1 =

2016-09-09 07:03:09 +0200 Medalha recebida  Pergunta notável (fonte)
2016-03-15 11:53:33 +0200 Medalha recebida  Entusiasta
2016-03-14 14:47:39 +0200 Pergunta comentada Calc Tools Options not saved

Sorry. I clicked the wrong tag. This is not a duplicate queastion

2016-03-14 14:43:52 +0200 Medalha recebida  Pergunta notável (fonte)
2016-03-14 14:42:06 +0200 Resposta comentada Calc Tools Options not saved

Thank you. I will evaluate your suggestion since .xls file are on Dropbox and Im not sure the other members can read .ods files.

2016-03-13 18:31:52 +0200 Medalha recebida  Pergunta popular (fonte)
2016-03-11 20:56:02 +0200 Perguntou Calc Tools Options not saved

Hi all, a member of the forum suggested me to enable Tools-Options-Calc-Calculate.Enable.regular.expressions.in.formulas to solve a problem. I did then pressed OK to save it and everything worked fine but when I re-opened the file the above option wasnt setted. Further investigation in LibreOffice-Advanced-Expert Configuration showed that .../Calculate/Other_RegularExpressions is set to true and is always set to true while the check box returns blank after every launch of Calc.

Is it possible to have the flag permanently setted?

Thank you in advance paparucino

P.S. I use LO Version: 5.0.5.2

2016-03-11 18:23:20 +0200 Medalha recebida  Pergunta popular (fonte)
2016-03-11 18:22:51 +0200 Resposta comentada Count chars in a column

Im really sorry, I was hasty and didnt read correctly the first karolus answer (=COUNTIF( J6:J314 , "M|P" )). I made the modifications he suggested in Tools.... and everything is OK.

Thank you guys for you answers

2016-03-11 18:14:19 +0200 Respondeu uma pergunta Count chars in a column

I beg your pardon for the delay. The first solution ( =COUNTIF( J6:J314 , "M|P" ) always shows 0. @ Ratslinger: how could I perform your solution? I tried with COUNTIF(OR(J6:J314 ='M',J6:J314 ='P')) but it doesnt work @ karolus: the problem is that in the colums there are could be other characters which cant be taken into account

2016-03-08 18:42:56 +0200 Perguntou Count chars in a column

Hi all, Im new to libreoffice calc so, pls, be patient. I have a column which may contain only "M"s if the event is in the morning or only "P"s if its in the noon. I need to count the occurences of "M" or "P". What Im able to to is =COUNTIF(J6:J314,"=M") but Im not able to do the OR . Something like: Count the occurences of "M" or "P" in the range J6:J314

Thank youin advance paparucino