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