Hi,
I am trying to do a calculation in my LO Calc spredsheet.
The function that I want to run is the following:
SUMIFS($Expenses.I2:I323;$Expenses.K2:K323;"food";$Expenses.B2:B323;">="
$Incomes.A3)
but get the Error:509 in the Result cell.
In the I2:I323 range there are prices of goods out
Hi,
I am trying to do a calculation in my LO Calc spredsheet.
The function that I want to run is the following:
SUMIFS($Expenses.I2:I323;$Expenses.K2:K323;"food";$Expenses.B2:B323;">="
$Incomes.A3)
but get the Error:509 in the Result cell.
In the I2:I323 range there are prices of goods out
Hi Brian,
I understand your arguments.
I think this is at the moment impossible, even with the use of the
thesaurus, as Regina mentioned.
But one day in the near(?) future there will be an AI agent, "who" can help
me in this. Right?
-
Best Regards from
Pál
--
View this message in
Hi,
is there a way to highlight in a text in Writer just nouns in an English
text besides manually select nouns?
I mean is there such a tool to highlight just nouns with one click?
Or can I create a macro for this job?
-
Best Regards from
Pál
--
View this message in context:
I am using Gentoo linux system.
I have installed Libreoffice without java support, so I am going now to
correct this.
After that I shall return to the Base Form and shall see what can I do out
there by following you advices. Thanks!
-
Best Regards from
Pál
--
View this message in context:
Hi,
I have running PostgreSQL server on my laptop.
I have installed LibreOffice version 5.1.4.2 out there.
I created new Base file with connection to one of mine database.
Within Base I created a Form ( not with Form Wizard, because it is not
working ( Why? )).
On the Form I have labels and
Hi,
I have created last year a LibreOffice Writer document that has about 60
pages.
In this document I created hyperlinks within this document.
Hyperlinks links pages.. say, I click on such hyperlink, and I get moved to
another page in the same document.
The problem is, I forgot how did I these
Hi Miguel,
I have active regular expression (Menu/Tools/Options/LibreOffice
calc/Calculation)
so I can use
=COUNTIF(C152:C228;"=H|K|Sze|Cs|P")
function successfully.
Thanks!!
-
Best Regards from
Pál
--
View this message in context:
Hi,
in a range I have characters: "H", "K", "Sze", "Cs", "P" so so in each cell
there is just one of these characters.
I want to count howmany cells are in a range that contains either of these
characters.
Can I do this in a more elegant way than by using this function bellow?
Kolbjørn Stuestøl wrote
> I tried it using 5.0.1.2 on windows 7. Local set to Norwegian nynorsk
> (nn).
>
> Set A1= 1a, A2=2a ... A8=8a and B1=1b, B2=2b ... B8=8b.
>
> =COUNTIF(A1:B8;"8a")+1 returned 2 as espected.
>
> Perhaps an error in version 5.0.0.5. In that case it does not matter as it
>
Hello,
I have installed LO 5.0.0.5, Gentoo official package.
I have setup LINGUAS to hu: hu-HU (hu_HU.utf8).
In one of my old Calc sheet, I have function
=COUNTIF(F16:X21;"8a")+1
In previous LO version this was without error, but now it shows me this
error. Why?
Now, If I remove the '+1' from
Hello,
I just installed LibreOffice fresh on my Arch linux system.
I tried to setup to get automatically the A4 papersize.
Finally, I have succes in that.
Then I setup the View of LO and choose small icons in the menubar.
Then I close LO and after that I start it again.
I get black menubar
It must be a Style issue but I can't figure out what to do to get all slides
behave same, eg. to have the same color for hyperlinks on every slides.
What can I do to achieve this goal?
-
Best Regards from
Pál
--
View this message in context:
Hi,
I'm using LibreOffice version 4.2.7.2, Build: 4.2.7.2 Arch Linux build-2
I'm trying to set up the color of the visited and unvisited hyperlinks on
slides with:
Tools Options Appearance Unvisited Links, Visited Links
On some slides this works but on some slides dont. Why?
-
Best
Hello,
I'm using LibreOffice 4.2.6.3
Build: 4.2.6.3 Arch Linux build-4
Is it possible to create a hyperlink in a cell ( text or button ) in one
Calc Document on one Sheet so if one click on that hyperlink then get
focused another Sheet in the same Document?
The purpose of this would be that
Mark Bourne wrote
I assume you are using Insert Hyperlink Document, then leaving the
document path blank and either entering the sheet name in the Target
field or using the button next to that field to select a sheet?
Indeed.
Mark Bourne wrote
It doesn't seem to work with sheet names
Hello,
is it possible in Libreoffice Calc 4.2.6.3
Build az.: 4.2.6.3 Arch Linux build-4
to get in a cell a drop-down list or listbox - combobox with a few values
that one can select?
-
Best Regards from
Pál
--
View this message in context:
Hi Joel,
I have plan to sharing it say on the Internet, or say on a flesh drive that
I bring in to the school where I'm working.
I want to use Creative Commons License ( CC ).
In this case I will put the License for myLO Calc Spreadsheet file on my
homepage
( one can see how to do that here:
Hi,
how can ( if can ) one protect her/his LO Calc document ( spreadsheet ) with
a copyright license?
What is the preferred way to eg.: share a Calc document, but protecting it
from expropriate?
Or is it sufficient to protect a Calc document with a password?
-
Best Regards from
Pál
--
No, I know this function before, and I didn't found your message some twelve
hours before. Was it in this threed posted by You?
Yes, I want to exclude 20 and 60 in this example, and I know for '=' or
'=' options.
Thank you for the advice about third parameter of SUMIF() so now I deleted
those
Hi Miguel Ángel,
thank you for advices.
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061602.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
Hi,
I'm using LibreOffice 4.0.3.3 (Build az.: 400m0(Build:3)).
BetweenTwoNumbers.ods
http://nabble.documentfoundation.org/file/n4061491/BetweenTwoNumbers.ods
In the uploaded file BetweenTwoNumbers.ods there are four sheets:
between 20-60, Num 1, Num 2, Num 3.
On the 'between 20-60' sheet
Yes, this helps. Thank you!
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061513.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
Brian Barker wrote
Try:
=COUNTIF('Num 1'.A1:Z99;20)-COUNTIF('Num 1'.A1:Z99;=60)
=COUNTIF('Num 2'.A1:Z99;20)-COUNTIF('Num 2'.A1:Z99;=60)
=COUNTIF('Num 3'.A1:Z99;20)-COUNTIF('Num 3'.A1:Z99;=60)
moreover, I don't know how to create fourth function.
Easy:
=J1+J3+J5
(!)
I trust this
Now I'm searching the way how to SUM those numbers ( between 20 and 60 )
finded on sheets Num1, Num2, Num 3?
BetweenTwoNumbers.ods
http://nabble.documentfoundation.org/file/n4061519/BetweenTwoNumbers.ods
I uploaded the file again, because I changed it a little.
I changed it because I search
I found a solution! On can see it in the following uploaded file.
BetweenTwoNumbers.ods
http://nabble.documentfoundation.org/file/n4061578/BetweenTwoNumbers.ods
The function is:
=SUMIF('Num 1'.A1;20;'Num 1'.A1)-SUMIF('Num 1'.A1;60;'Num
1'.A1)+SUMIF('Num 2'.A1;20;'Num 2'.A1)-SUMIF('Num
Hi Michael,
I don't know why happen that, that it didn't work once, or twice some few
days back, but now it works.
Thank you for help and support!
-
Best Regards from
Pál
--
View this message in context:
OKI find what causes this behavior. Grade_CellBehavior.ods
http://nabble.documentfoundation.org/file/n4061008/Grade_CellBehavior.ods
In the uploaded file when one want to change the value of the AF6 cell,
because of the the auto-input of Calc I get the option '16-25' that is
actually a value of
Hi,
Grade_CellBehavior.ods
http://nabble.documentfoundation.org/file/n4061013/Grade_CellBehavior.ods
In the uploaded Calc file 'Grade_CellBehavior.ods' the column AE and BH are
just simple cells with number values.
The Sheet '1.' in this file is a sheet from another, bigger Calc file (
Hi,in LibreOffice 4.0.3.3 (Build at.: 400m0(Build:3)) Calc I want to enter a
number: '1' but Calc gives me the previous cell to enter the number,
moreover it does a subtraction of some numbers there.You can see this
behavior on the following images:
Hi,
I have two CALC files and in the second I created in one cell the CELL()
function:
=CELL(contents;'file:///win-adatok-1/Iskola/OsztalyFonok_vagyok/6.c_osztalyom/NaploBizonyitvanyKitoltesetSegitoTablazatok/6oszt_NaploBizonyitvany_KitoltesetSegitoTablazat.ods'#$'1.'.B6)
that should shows the
Andreas Säger wrote
The CELL function is there for some historic reasons. Very old documents
from other applications may use it. Except for the filename option
there is no use for it in Calc.
So which function can be used instead of CELL function?
-
Best Regards from
Pál
--
View this
Andreas Säger wrote
Am 10.03.2012 19:59, csanyipal wrote:
Andreas Säger wrote
The CELL function is there for some historic reasons. Very old documents
from other applications may use it. Except for the filename option
there is no use for it in Calc.
So which function can be used instead
Hi,
I have a Spreadsheet in which I must fill many cells with numbers so so
every next cell contain a number that is bigger then the previous number by
two.
However, these cells aren't neither side by side nor one underneath another
and are in pair (see the uploaded example file).
Moreover
Jay Lozier wrote
On 12/29/2011 12:38 PM, csanyipal wrote:
Johnny Rosenberg wrote
2011/12/29 csanyipallt;csanyipal@gt;:
Jay Lozier wrote
On 12/29/2011 09:09 AM, csanyipal wrote:
Indeed, I was inattentive here. Thanks!
However, as one can see in the file abowe (that I upload again
Gérard Fargeot wrote
I've made a formula translator :
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=41870
You can translate functions or whole formula to a language to an other.
Gérard
Grait!
I downloaded it and translate the UI to Hungarian. However I have some
Tom wrote
Hi :)
On the version you uploaded i was able to change the width of those
columns quite easily. Perhaps it is only the original that protects those
columns?
Regards from
Tom :)
Strange. I download that file that I uploaded and I can't change the width
of those columns.
Hladůvka Jiří wrote
Dne 30.12.2011 23:34, csanyipal napsal(a):
Gérard Fargeot wrote
I've made a formula translator :
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=41870
You can translate functions or whole formula to a language to an other.
Gérard
... and how does
Jay,
Jay Lozier wrote
On 12/29/2011 09:09 AM, csanyipal wrote:
I'm trying to figure out why differs AVERAGE calculations when using it
alone in a cell or when using it in a complex formula?
http://nabble.documentfoundation.org/file/n3618892/Average_Problem.ods
Average_Problem.ods
Johnny Rosenberg wrote
2011/12/29 csanyipal lt;csanyipal@gt;:
Jay Lozier wrote
On 12/29/2011 09:09 AM, csanyipal wrote:
Indeed, I was inattentive here. Thanks!
http://nabble.documentfoundation.org/file/n3619267/Average_Problem.ods
Average_Problem.ods
However, as one can see
Hi,
I'm trying to figure out why differs AVERAGE calculations when using it
alone in a cell or when using it in a complex formula?
http://nabble.documentfoundation.org/file/n3618892/Average_Problem.ods
Average_Problem.ods
In the .ods abowe on the sheet '17.' one can see that that AVERAGE
Hi Gérard,
Gérard Fargeot wrote
Hi Pal,
I'm trying with this formula:
{=SUMIF('O.tanácsi f.év'.Y7:Y26;AND('O.tanácsi
f.év'.Y7:Y2625;'O.tanácsif.év'.Y7:Y26=384))}
Did you forget the magic function SUMPRODUCT ?
=SUMPRODUCT('O.tanácsi f.év'.Y7:Y26;'O.tanácsi
csanyipal wrote
Hi Gérard,
Gérard Fargeot wrote
Hi Pal,
Did you forget the magic function SUMPRODUCT ?
=SUMPRODUCT('O.tanácsi f.év'.Y7:Y26;'O.tanácsi
f.év'.Y7:Y2625;'O.tanácsif.év'.Y7:Y26=384)
Gérard (again)
No, I didn't forget it, but it seems that that I didn't
Hi Carlo,
I attached the file:
http://nabble.documentfoundation.org/file/n3614513/6oszt_NaploBizonyitvany_KitoltesetSegitoTablazat.ods
6oszt_NaploBizonyitvany_KitoltesetSegitoTablazat.ods
Best Regards, Pál
--
View this message in context:
44 matches
Mail list logo
