[libreoffice-users] Calc - SUMIF - between two date condition

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 ther

[libreoffice-users] Calc - SUMIF - between two date condition

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 ther

[libreoffice-users] Re: Highlighting nouns in LibreOffice Writer?

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 context:

[libreoffice-users] Highlighting nouns in LibreOffice Writer?

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: http://nabb

[libreoffice-users] Re: Creating Form in Base and connect it to database

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: h

[libreoffice-users] Creating Form in Base and connect it to database

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 text

[libreoffice-users] Re: Making hyperlink within Writer document? - SOLVED

Hi Bo Siltberg, Ctrl-F2 solve my problem. I can there set up my new - or I can say - changed cross-references out there. Thank you very much! - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Making-hyperlink-within-Writer-document-tp4197191p4

[libreoffice-users] Making hyperlink within Writer document?

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 h

[libreoffice-users] Re: COUNTIF() with more than one conditions

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: http://nabble.documentfoundation.org/COUNTIF-with-mo

[libreoffice-users] COUNTIF() with more than one conditions

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? =COUNTIF(C152:C22

[libreoffice-users] Re: =COUNTIF(F16:X21;"8a")+1 - Error:509 ?

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 >

[libreoffice-users] =COUNTIF(F16:X21;"8a")+1 - Error:509 ?

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

[libreoffice-users] Re: Suddenly get black menu and some areas

Well, I solve this problem by deleting the ~/.config/libreoffice/ directory. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Suddenly-get-black-menu-and-some-areas-tp4139272p4139274.html Sent from the Users mailing list archive at Nabble.com.

[libreoffice-users] Suddenly get black menu and some areas

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 and

[libreoffice-users] Re: Setting up Hyperlink Color in Impress

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: http://nabble.documentfoundation.org/Setting-up-

[libreoffice-users] Setting up Hyperlink in Impress

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

[libreoffice-users] Re: To open a second Sheet with one mouse click from the first Sheet in same document?

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 na

[libreoffice-users] To open a second Sheet with one mouse click from the first Sheet in same document?

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 that

[libreoffice-users] Calc - combobox in a cell?

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: http://nabble.documentfoundation.org/Calc-combo

[libreoffice-users] GUI Tool to plan scatch an Impress presentation?

Hi! I think, it is advisable to someone that, that first plane her/his presentation on a paper, right? Is there such a GUI Tool for this purpose? I'm trying to use MindMap tool ( freemind, vym ) but I'm not satisfied with it. Any advices? - Best Regards from Pál -- View this message in c

[libreoffice-users] Re: License for a LO Calc document?

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: ht

[libreoffice-users] License for a LO Calc document?

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 -- Vie

[libreoffice-users] Re: Searching numbers between two values

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: users+un

[libreoffice-users] Re: Searching numbers between two values

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 t

[libreoffice-users] Re: Searching numbers between two values

I found a solution! On can see it in the following uploaded file. 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('Nu

[libreoffice-users] Re: Searching numbers between two values

Now I'm searching the way how to SUM those numbers ( between 20 and 60 ) finded on sheets Num1, Num2, Num 3? BetweenTwoNumbers.ods I uploaded the file again, because I changed it a little. I changed it because I search f

[libreoffice-users] Re: Searching numbers between two values

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

[libreoffice-users] Re: Searching numbers between two values

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: users+unsubscr...@glo

[libreoffice-users] Searching numbers between two values

Hi, I'm using LibreOffice 4.0.3.3 (Build az.: 400m0(Build:3)). 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 t

[libreoffice-users] Re: A function doesn't work on cell whihc is a link to another cell

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: http://nabble.documentfoundation.org/A-function-doesn-t-work-on-cell-whihc-is-a-link-

[libreoffice-users] A function doesn't work on cell whihc is a link to another cell

Hi, 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 ( cal

[libreoffice-users] Re: Can't enter a number in a cell

OKI find what causes this behavior. 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

[libreoffice-users] Can't enter a number in a cell

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:

[libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file

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"

[libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file

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

[libreoffice-users] CELL() doesn't show the cell content of another CALC file

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

[libreoffice-users] Automatically increasing next value by 2 in cells

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 I

[libreoffice-users] Re: LibreOffice 3.4.4 - Error: wrong data type.

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=9&t=41870 >>> You can translate functi

[libreoffice-users] Re: LibreOffice 3.4.4 - Error: wrong data type.

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 column

[libreoffice-users] Re: LibreOffice 3.4.4 - Error: wrong data type.

Gérard Fargeot wrote > > I've made a "formula translator" : > http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=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

[libreoffice-users] Re: AVERAGE calculation differs when alone or in a complex formula?

Jay Lozier wrote > > On 12/29/2011 12:38 PM, csanyipal wrote: >> Johnny Rosenberg wrote >>> 2011/12/29 csanyipal<csanyipal@>: >>> >>>> Jay Lozier wrote >>>>> On 12/29/2011 09:09 AM, csanyipal wrote: >>>> Indeed, I was

[libreoffice-users] Re: AVERAGE calculation differs when alone or in a complex formula?

Johnny Rosenberg wrote > > 2011/12/29 csanyipal <csanyipal@>: > >> Jay Lozier wrote >>> >>> On 12/29/2011 09:09 AM, csanyipal wrote: > >> Indeed, I was inattentive here. Thanks! >> >> http://nabble.documentfoundation.org/file/n3619

[libreoffice-users] Re: AVERAGE calculation differs when alone or in a complex formula?

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

[libreoffice-users] AVERAGE calculation differs when alone or in a complex formula?

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 calcul

[libreoffice-users] Re: To sum only those values in a range that are between two number

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:Y26>

[libreoffice-users] Re: To sum only those values in a range that are between two number

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:Y26>25;'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

[libreoffice-users] Re: LibreOffice 3.4.4 - Error: wrong data type.

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: http://nabble.documentfoundation.org/LibreOffice-3-4-4