[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 there. In the K2:K323 range there are names (types) of those goods out there. In the B2:B323 range there are dates of days when expenses occures out there. In the $Incomes.A3 there is the date of the day when an income occures out there. So what I want is the following. I want to sum those prices which are occured when the good was "food" but only then when that day occured at date stored in the $Incomes.A3 cell or after that date. What am I doing rong? - Best Regards from Pál -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[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 there. In the K2:K323 range there are names (types) of those goods out there. In the B2:B323 range there are dates of days when expenses occures out there. In the $Incomes.A3 there is the date of the day when an income occures out there. So what I want is the following. I want to sum those prices which are occured when the good was "food" but only then when that day occured at date stored in the $Incomes.A3 cell or after that date. What am I doing rong? - Best Regards from Pál -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[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: http://nabble.documentfoundation.org/Highlighting-nouns-in-LibreOffice-Writer-tp4219305p4219342.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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://nabble.documentfoundation.org/Highlighting-nouns-in-LibreOffice-Writer-tp4219305.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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: http://nabble.documentfoundation.org/Creating-Form-in-Base-and-connect-it-to-database-tp4199320p4199325.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 boxes and a button. The button should make changes in database when clicked. Mybe it is not necessary this button at all? I do not know what to do when editing this Form to get connected an approppriate text box with approppriate field in database record? Because right now there is nothing happen if I run this Form and fill out text boxes. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Creating-Form-in-Base-and-connect-it-to-database-tp4199320.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 hyperlinks.. Now I want to modify some of these hyperlinks but do not know ho to do it? I can see only that that when I click on such a hyperlink, I get moved to a beginning of a title on another page. Please help me remember how can I modify these hyperlinks! - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Making-hyperlink-within-Writer-document-tp4197191.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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-more-than-one-conditions-tp4173143p4173177.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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:C228;"=H")+COUNTIF(C153:C229;"=K")+COUNTIF(C154:C230;"=Sze")+COUNTIF(C155:C231;"=Cs")+COUNTIF(C156:C232;"=P") - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/COUNTIF-with-more-than-one-conditions-tp4173143.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 > works fine in 5.1. > So perhaps the solution is to upgrade to 5.1? > Kolbjørn Indeed, I tried the function in the same document on my Arch linux, where I have installed LO version: 5.0.1.2.0+ and the function works out there too. So this is a Gentoo issue. Thanks! - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/COUNTIF-F16-X21-8a-1-Error-509-tp4158926p4159009.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 the end of function, it is OK, but then I get not the value which I want. Now, how can I increase with '1' the value of the function: =COUNTIF(F16:X21;"8a") - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/COUNTIF-F16-X21-8a-1-Error-509-tp4158926.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 when want to change back my settings ( I found it difficult to in the black ) I can't get back the gray menubar. What happened? How can I solve this problem? - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Suddenly-get-black-menu-and-some-areas-tp4139272.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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-Hyperlink-Color-in-Impress-tp4129983p4130188.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Setting-up-Hyperlink-in-Impress-tp4129983.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 one should not searching a specific Sheet in the same Calc document but only to click in the first Sheet on a hyperlink so to get quickly the desired Sheet focused for a data entry. I tried this with 'Control+K' in a cell and setup there the desired Sheet in the same document. I then get a #1 text in the cell but it doesn't work; when I click on it with 'Control + mouse click' I get not focused the desired Sheet. Why can't I achieve this goal this way? - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/To-open-a-second-Sheet-with-one-mouse-click-from-the-first-Sheet-in-same-document-tp4123751.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 names resembling row or cell references (e.g. 3 or AB5) - clicking the link just takes you to that row or cell on the current sheet. Indeed. Mark Bourne wrote Possibly a bug, so may be worth reporting at http://bugs.libreoffice.org/. ... As a workaround, try entering the hyperlink target as 1.A1. That takes you to cell A1 on the sheet named 1. Of course, you can use a cell other than A1 if it would help to go directly to some other cell. That 1.A1 works. Thank you! - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/To-open-a-second-Sheet-with-one-mouse-click-from-the-first-Sheet-in-same-document-tp4123751p4123770.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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-combobox-in-a-cell-tp4123224.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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: http://creativecommons.org/choose/ http://creativecommons.org/choose/ ) , but I think I should to give some information for the future users of the spreadsheet about CC License for this work. Can I give this information in the Calc spreadsheet itself? - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/License-for-a-LO-Calc-document-tp4068086p4068401.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 -- View this message in context: http://nabble.documentfoundation.org/License-for-a-LO-Calc-document-tp4068086.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 third parameters in this file, and it works. Thank you for your help. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061594.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Searching numbers between two values
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 there are three functions to determine how many
numbers can find on sheets Num 1, Num 2 and Num 3 respectivly ( one by one )
and there is a fourth function that sholud count that at once on all Num 1-3
sheets.
As one can see, none of these three functions works:
=COUNTIF('Num 1'.A1;AND('Num 1'.A120;'Num 1'.A160))
=COUNTIF('Num 2'.A3;AND('Num 2'.A320;'Num 2'.A360))
=COUNTIF('Num 3'.A5;AND('Num 3'.A520;'Num 3'.A560))
moreover, I don't know how to create fourth function.
Can one advice me how to go further?
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[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...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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
(!)
I trust this helps.
Yes, this helps.
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061514.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[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 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 for a function which I can put in to just one cell of the 'between 20-60' sheet. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061519.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Searching numbers between two values
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 2'.A1;60;'Num
2'.A1)+SUMIF('Num 3'.A1;20;'Num 3'.A1)-SUMIF('Num 3'.A1;60;'Num 3'.A1)
Is there a simpler way to do it?
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061578.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[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-to-another-cell-tp4061013p4061324.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Can't enter a number in a cell
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 the AF46 cell in the Sheet itself.I find the solution: one must to switch the Tools - Cell Contents - AutoInput option.Sorry for the noise. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Can-t-enter-a-number-in-a-cell-tp4060840p4061008.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] A function doesn't work on cell whihc is a link to another cell
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 ( called here 'file1' ) in which I have such sheets for every pupil. I have also a Calc file 'file2' in which I have too such columns, as AE and BH, but cells in these columns are not just cells with number values, but links for 'file1'. So, in the school I fill out the cells in the 'file1' file, come home, copy the 'file1' into approppriate directory, open the 'file2' Calc file and get the values into it from 'file1' automatically. I hope this is cleare so far. As one can see in 'Grade_CellBehavior.ods' when one change the value '3' in AE6 to value '2' then the value in AD6 changes automatically to value !?. This shows me that that a teacher closed the grade for that Subject badly. But this doesn't work in the 'file2', because eg. the value in AE6 is not just a number, but a value that we get is a link from 'file1'. I hope this is clear. How can I solve this to works in the 'file2' too? - 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-to-another-cell-tp4061013.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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: http://nabble.documentfoundation.org/file/n4060840/EnteringIntoCell-1.png http://nabble.documentfoundation.org/file/n4060840/EnteringIntoCell-2.png What can I do to prevent such a behavior? - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Can-t-enter-a-number-in-a-cell-tp4060840.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 cell contents of the first CALC file. When I use instead of CELL() function the function: ='file:///win-adatok-1/Iskola/OsztalyFonok_vagyok/6.c_osztalyom/NaploBizonyitvanyKitoltesetSegitoTablazatok/6oszt_NaploBizonyitvany_KitoltesetSegitoTablazat.ods'#$'1.'.B6 then I can see the cell contetns of another CALC file. Why doesn't work the CELL() function in this case? - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/CELL-doesn-t-show-the-cell-content-of-another-CALC-file-tp3815399p3815399.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 this message in context: http://nabble.documentfoundation.org/CELL-doesn-t-show-the-cell-content-of-another-CALC-file-tp3815399p3815550.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 option there is no use for it in Calc. So which function can be used instead of CELL function? =CELL(content;A1) returns the exact same value as =A1 does. Thank you very much for help! - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/CELL-doesn-t-show-the-cell-content-of-another-CALC-file-tp3815399p3815581.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 have divers for these cells, so every kind of these cells must increasing it's number by two separately from other kind of cells. In the example ods file uploaded here one can see for example that that the cell by '5c' cell in the first instance has value '1' and to the right of this cell there is another '5c' cell that has value '2'. In the raws bellow somewhere are another pair of '5c' cells by which these values are increased by 2: the first is '3' and the second is '4'. And there are other kind of cells, like '5a', '5b', '6a', '6b', '6c', etc. too that must be increased in the next instance by 2. How can I achieve that that the value of these cells get increased automatically by 2? http://nabble.documentfoundation.org/file/n3660431/AutomaticallyIncreasingCellsValues.ods AutomaticallyIncreasingCellsValues.ods - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Automatically-increasing-next-value-by-2-in-cells-tp3660431p3660431.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 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, modified of course) that AVERAGE still calculate slightly different when are used in complex formula as if it used alone. Take a look again. They are still not the same (AD20 ≠ AD21). Indeed, it seems that that I work to much and my attention abates. It's time to rest a little. Thanks for the support! I know these errors are often hard to properly track down. When I have done something similar I knew I had entered the formula correctly but had make a minor change with big results. One way to avoid this is to use named ranges. Say C2:C34 is named scores then use the name in the formula. Thank you very much for help! (I want to thank you in private e-mail but this features doesn't work rigth now.) - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/AVERAGE-calculation-differs-when-alone-or-in-a-complex-formula-tp3618892p3620510.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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=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 reflections about it. In the 'fonction' sheet columns B and C are protected so one can't make none of these columns wider so eg. my translation can't be seen on the whole. That's the case in the 'formule' sheet too. My translated UI is here: http://nabble.documentfoundation.org/file/n3622035/traducteur_formule_RC1.ods traducteur_formule_RC1.ods Thanks! - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-4-4-Error-wrong-data-type-tp3614423p3622035.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 columns. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-4-4-Error-wrong-data-type-tp3614423p3622651.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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=9t=41870 You can translate functions or whole formula to a language to an other. Gérard ... and how does this correspond to the original context of http://nabble.documentfoundation.org/LibreOffice-3-4-4-Error-wrong-data-type-tt3614423.html ??? You are right, so I rename the Thread. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-4-4-Error-wrong-data-type-tp3614423p3622735.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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.org/file/n3618892/Average_Problem.ods Average_Problem.ods In the .ods abowe on the sheet '17.' one can see that that AVERAGE calculations in the 'AD30' =IF(OR(COUNTIF(AD6:AD17;=1);COUNTIF(AD19:AD20;=1);COUNTIF(AD29;=1));0;AVERAGE(AC6:AC17;AC19:AC20;AD29)) and in the 'AD46' =AVERAGE(AD6:AD17;AD19:AD20;AD29) One is (mostly) averaging the data in column AC and the other is using column AD. Since the data in each column is not the same the answers will be different. -- Jay Lozier jslozier@ Indeed, I was inattentive here. Thanks! http://nabble.documentfoundation.org/file/n3619267/Average_Problem.ods Average_Problem.ods However, as one can see in the file abowe (that I upload again, modified of course) that AVERAGE still calculate slightly different when are used in complex formula as if it used alone. Eg. in the abowe file one can see on the '19.' sheet that cell 'AD30' with the same AVERAGE formula, that is in a complex formula calculate the value '4,07' but the cell 'AD46' calculate with the same AVERAGE formula when is alone the value '4,13'. How could that be? - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/AVERAGE-calculation-differs-when-alone-or-in-a-complex-formula-tp3618892p3619267.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: AVERAGE calculation differs when alone or in a complex formula?
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 in the file abowe (that I upload again, modified of course) that AVERAGE still calculate slightly different when are used in complex formula as if it used alone. Take a look again. They are still not the same (AD20 ≠ AD21). Indeed, it seems that that I work to much and my attention abates. It's time to rest a little. Thanks for the support! - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/AVERAGE-calculation-differs-when-alone-or-in-a-complex-formula-tp3618892p3619319.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 calculations in the 'AD30' =IF(OR(COUNTIF(AD6:AD17;=1);COUNTIF(AD19:AD20;=1);COUNTIF(AD29;=1));0;AVERAGE(AC6:AC17;AC19:AC20;AD29)) and in the 'AD46' =AVERAGE(AD6:AD17;AD19:AD20;AD29) cells are different. How could it be? - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/AVERAGE-calculation-differs-when-alone-or-in-a-complex-formula-tp3618892p3618892.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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: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
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 understand it well.
Sorry.
Thanks again, Gérard!
--
View this message in context:
http://nabble.documentfoundation.org/To-sum-only-those-values-in-a-range-that-are-between-two-number-tp3616470p3616606.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[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: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 understand it
well. Sorry.
So if I understand well, SUMPRODUCT in this case will summarize values of
cells in an array if we gives the formula:
=SUMPRODUCT('O.tanácsi f.év'.Z7:Z26;'O.tanácsi f.év'.Z7:Z26=8;'O.tanácsi
f.év'.Z7:Z26=17)
*=SUMPRODUCT(array;condition1;condition2)*
but will only count cells with the given conditions if we gives the formula:
=SUMPRODUCT('O.tanácsi f.év'.Z7:Z26=8;'O.tanácsi f.év'.Z7:Z26=17)
* =SUMPRODUCT(condition1;condition2)*
condition1 and condition2 are arrays too.
As one can see in the LO Help, SUMPRODUCT multiplies corresponding elements
in the given arrays, and returns the sum of those products.
I'm trying to understand SUMPRODUCT considering this case abowe. Is there
something more to be added to this explanation?
Thanks!
Pál
--
View this message in context:
http://nabble.documentfoundation.org/To-sum-only-those-values-in-a-range-that-are-between-two-number-tp3616470p3616853.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[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-Error-wrong-data-type-tp3614423p3614513.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
