[libreoffice-users] Can one export from Calc a spreadsheet raw into a MySql database table raw?
Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? -- Regards from Pal -- 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 Joe, Joe Conner joeconner2...@gmail.com writes: On 12/30/2011 9:57 PM, csanyipal wrote: 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. SNIP I think the problem may be the settings. Look at TOOLS - PROTECT DOCUMENT - (Both SHEET and DOCUMENT) uncheck each. Did this do it for you? Thanks! Yes it did and the password was 'Calc' without quotes. -- Regards, Pal -- 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: Happy New Year all!
Hi :) Happy New Year all! -- Regards from Pál -- 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] To sum only those values in a range that are between two number
Hi, I'm trying to sum only those values in a range that are in the same time greater than 25 and lower or equal than 384. How can I do that? -- Regards, Pal -- 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
Csanyi Pal csanyi...@gmail.com writes: I'm trying to sum only those values in a range that are in the same time greater than 25 and lower or equal than 384. I'm trying with this formula: =SUMIF('O.tanácsi f.év'.Y7:Y26;AND('O.tanácsi f.év'.Y7:Y2625;'O.tanácsi f.év'.Y7:Y26=384)) but that doesn't give to me the right result. -- Regards, Pal -- 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] LibreOffice 3.4.4 - Error: wrong data type.
Hi, I have in the range of O23:O27 on one sheet formulas: 1. cell: =DARABTELI(K5:K24;ÉS(K5:K24=5;K5:K24=7)) 2. cell: =DARABTELI(K5:K24;ÉS(K5:K24=8;K5:K24=15)) 3. cell: =DARABTELI(K5:K24;ÉS(K5:K24=16;K5:K24=25)) 4. cell: =DARABTELI(K5:K24;ÉS(K5:K24=26;K5:K24=34)) 5. cell: =DARABTELI(K5:K24;=35) The cell K5 has the formula: =HA(CELLA(contents;'1.'.T$28)0;CELLA(contents;'1.'.T$28);.) In the cells: O23, O24, O27 everything is well. But in cells O25 and O26 I get ### instead of some result and in the status line there is an error: 'Error: wrong data type.' when those cells are active (one by one of course). What could be the problem here? -- Regards, Pal -- 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 gerard.farg...@orange.fr writes: I have in the range of O23:O27 on one sheet formulas: 1. cell: =DARABTELI(K5:K24;ÉS(K5:K24=5;K5:K24=7)) 2. cell: =DARABTELI(K5:K24;ÉS(K5:K24=8;K5:K24=15)) 3. cell: =DARABTELI(K5:K24;ÉS(K5:K24=16;K5:K24=25)) 4. cell: =DARABTELI(K5:K24;ÉS(K5:K24=26;K5:K24=34)) 5. cell: =DARABTELI(K5:K24;=35) The cell K5 has the formula: =HA(CELLA(contents;'1.'.T$28)0;CELLA(contents;'1.'.T$28);.) In the cells: O23, O24, O27 everything is well. But in cells O25 and O26 I get ### instead of some result and in the status line there is an error: 'Error: wrong data type.' when those cells are active (one by one of course). What could be the problem here? You will have more answer if you post formula in English instead of Hungarian. :) Can I do that from LibreOffice? How can I translate formula names? Must I change the Language environment for this? dot (.) is a special character. In the menu Tools Options LO Calc Calculate, turned off Enable regular expressions in formulas. Your formula =DARABTELI(K5:K24;ÉS(K5:K24=5;K5:K24=7)) (COUNTIF in english) seems to be false. ÉS(K5:K24=5;K5:K24=7) if validate as normal formula only checked if 1st row (K5) is between 5 and 7. If validate as an array formula, checked if *all* the cells of the range are between 5 and 7 and return an array of 1 if True, 0 if false. Ah I see now! Thanks! If you want to count how many cells of the range are =5 =7 , use SUMPRODUCT : =SZORZATÖSSZEG(K5:K24=5;K5:K24=7) Exactly that is what I want to do. Thanks for the information about the formula SUMPRODUCT! It is also a very bad idea to use dot in sheetname. Always use alphanumeric characters. I edited the formula and replaced dot '.' with zero 0. -- Regards, Pal -- 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.
csanyipal csanyi...@gmail.com writes: I attached the file: http://nabble.documentfoundation.org/file/n3614513/6oszt_NaploBizonyitvany_KitoltesetSegitoTablazat.ods 6oszt_NaploBizonyitvany_KitoltesetSegitoTablazat.ods The formulas that causes error are on the Sheet called: 'O.tanácsi f.év' -- Regards, Pal -- 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.
Csanyi Pal csanyi...@gmail.com writes: Sorry I was unclear again! I have in the range of O23:O27 on one sheet formulas: cell O23: =DARABTELI(K5:K24;ÉS(K5:K24=5;K5:K24=7)) cell O24: =DARABTELI(K5:K24;ÉS(K5:K24=8;K5:K24=15)) cell O25: =DARABTELI(K5:K24;ÉS(K5:K24=16;K5:K24=25)) cell O26: =DARABTELI(K5:K24;ÉS(K5:K24=26;K5:K24=34)) cell O27: =DARABTELI(K5:K24;=35) The cell K5 has the formula: =HA(CELLA(contents;'1.'.T$28)0;CELLA(contents;'1.'.T$28);.) The cells bellow of K5 (K6:K24) has same formulas except addresses is different, eg.: instead of '1.'.T$28 there is '2.'.T$28 and so on, like: =HA(CELLA(contents;'2.'.T$28)0;CELLA(contents;'2.'.T$28);.) In the cells: O23, O24, O27 everything is well. But in cells O25 and O26 I get ### (or #VALUE! if I set the column wider) instead of some result and in the status line there is an error: 'Error: wrong data type.' when those cells are active (one by one of course). These formulas are the same, uses the same range so I don't understand what could be the problem here? -- Regards, Pal -- 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: How to paste a function so Calc doesn't change addresses in it?
Alan Boba abo...@gmail.com writes: On Mon, Dec 26, 2011 at 11:21 AM, Csanyi Pal csanyi...@gmail.com wrote: Alan Boba abo...@gmail.com writes: On Mon, Dec 26, 2011 at 10:46 AM, Alan Boba abo...@gmail.com wrote: 2011/12/26 Csányi Pál csanyi...@gmail.com It works for the next raw, but how can I use this behavior when I want to copy to a different column? When I'm trying to copy to the next column: =HA(DARABÜRES('5.'.$AD6);0;HA('5.'.$AD6=1;-;HA(1'5.'.$AD66;+;hamis))) It remains like this: =HA(DARABÜRES('5.'.$AD6);0;HA('5.'.$AD6=1;-;HA(1'5.'.$AD66;+;hamis))) and the address $AD6 doesn't changed to $AD7, why? I'm a bit lost by your question. Copying the first formula to another cell _on_the_same_row_ should have exactly the result you've shown. My question abowe is about that that if one want to copy a formula into a cell say one raw lower, then addresses in formula would change without '$' prefix but wouldn't change (again, without '$' prefix) if the same formula want to copy into a cell that is in the same raw. I hope I'm clear now. (Sorry for my English.) If the cell reference in the formula should change from $AD6 to $AD7 then after copying the formula it must be pasted one row below the row it is copied from. If the formula is in cell A1 and copied from there to cell B2 the cell reference in the formula will be updated from $AD6 to $AD7. Note the destination I've given is on a different row and in a different column. However only the row number would change because the column value is preceded by $. If the formula is pasted into a cell two rows lower then the cell reference would change from $AD6 to $AD8 and so on. All right, I understand You perfectly. Thanks for the explanation! -- Regards, Pal -- 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: How to paste a function so ... - THANKS!!
Hi Gérard, thank you very much for your help! -- Regards, Pal http://cspl.me -- 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: How to paste a function so ... THANKS!!
Hi Alan, thank you very much for your help! -- Regards, Pal http://cspl.me -- 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