[libreoffice-users] Help regarding LibOfficeBase/Firebird
Good evening, and a successful new year 2019 to all of you! And thanks for the gone interesting years with LibreOffice! (even if not always quite satisfying) My LibreOffice version on Windows10 now is 6.1.4.2 and I hope that LO-Base (finally) can meet my needs and intentions. I have some old database-projects that I (very nicely) have built on MSAccess2003 and want now to rebuild them onto LO-Base. One of them has three tables (a main form and two subforms with about a hundred records by 15-25 cols each) that I now have successfully ‘transformed’ via MSExcel to LO-Calc files. My goal now is to get these 400 records to three LOBase tables with a maximum of ease (the new registered database has been created – but no tables yet!). Now some questions to a LO-Base expert out there somewhere (I think the answers can be of interest to other LOBase-dummies like me!) 1 >>I have noticed that the embedded engine HSQLDB has been replaced with Firebird >>can I still work with LOBase as a frontend the same way as before? If not, why not? >>which are the main differences to be considered (e.g. regarding form- and report properties like with list-/comboboxes, reports etc) with Firebird vs HSQLDB >>where can I find fresh instructions (or tutorial) for LOBase (and if available for LOBase/Firebird) 2 >>as said the MSAccess table’s data are now saved as LOCalc-files. I have learned how to export a LOBase table to a LOCalc file (registered) – but I can not find how to do the reverse: >>how do I import a LOCalc file’s data to a (registered) LOBase table, or in other words, get the data (with or not it’s structures) from a LOCalc file into a LOBase table? 3 >> (Brian please, once more) what is the formula to calculate (now in a LOBase/Firebird form or query) a person's age out of her birth date? All advice is very much appreciated! Pertti Rönnberg /Finland, 79yrs -- 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
Re: [libreoffice-users] Help with LOCalc formula (SOLVED)
Hi, Bruce, Remy, Brian and Jim Thank you for your kindness and answers. Tonight while following the election on TV I'll have a lot to do when giving the VLOOKUP() a new try according to your advice. I must have done bad thinking -- perhaps getting old. Anyway I again learn a lot. Best regards Pertti On 8.11.2016 11.58, James E Lang wrote: Correction: replace 25 with 0. -- Jim -Original Message- From: "James E. Lang" <jim+...@lang.hm> To: "users@global.libreoffice.org" <users@global.libreoffice.org>, "Pertti Rönnberg" <p...@elisanet.fi> Cc: "Pertti Rönnberg" <p...@elisanet.fi> Sent: Tue, 08 Nov 2016 1:52 Subject: Re: [libreoffice-users] Help with LOCalc formula Try this. =IF(B1="","",OFFSET($Z$20,MATCH(B1,$B$20:$B$35,0)-1,25)) -- Jim -Original Message- From: "Pertti Rönnberg" <p...@elisanet.fi <mailto:p...@elisanet.fi>> To: "users@global.libreoffice.org <mailto:users@global.libreoffice.org>" <users@global.libreoffice.org <mailto:users@global.libreoffice.org>> Cc: "Pertti Rönnberg" <p...@elisanet.fi <mailto:p...@elisanet.fi>> Sent: Mon, 07 Nov 2016 8:00 Subject: [libreoffice-users] Help with LOCalc formula Best Spreadsheet Experts, May I ask for help having a more elegant formula in LOCalc (v.5.0.3; win10) Description I try to get a little extra to my pension savings by experimenting on the share market and follow up the results using Calc (not a database). I have a spreadsheet with two ranges – range(1) directly above range(2). r(1) specifies per row every specific purchase/sell event (date, company name, amount, etc). To calculate the actual "to-day"-result for this specific event (row) we need the "to-day"-value for this company's share (in e.g. column X), which value is taken from respective company's row in col.Z in r(2). r(1) has yearly 100-130 rows (events) Range(2) lists each company named in the above Range(1) and has in col.Z the corresponding share's "to-day"-value. These inserted share values varies from one day to the next. There are now 10-15 companies (rows) listed in r(2) – not in alphabetic order. r(2) sums the up-to-date result per company and the total result. Problem The belowe example simplified to 5 events concerning 3 companies may clearify the problem with the formula in X1 copied down col.X: =if(B1=$B$20;$Z$20;if(B1=$B$21;$Z$21;(ifB1=$B$22;$Z$22;0))) As you can see: with 15 (or more) companies (and >100 events) the formula will grow and become very long and sensitive for mistakes. VLOOKUP does not seem to be an option, at least it requires a completely new setup of the page. Range(1) - events A B C…. X 1. nokia 5,o 2. kone 41,o 3. nokia 5,o 4. fiskars 12,o 5. kone41,o Range(2) - companies A B C... Z 20 nokia 5,o 21 fiskars 12,o 22 kone 41,o Any suggestion will be very interesting. Thank you in advance Pertti Rönnberg/Finland -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org <mailto: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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org <mailto: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 -- 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] Help with LOCalc formula
Best Spreadsheet Experts, May I ask for help having a more elegant formula in LOCalc (v.5.0.3; win10) Description I try to get a little extra to my pension savings by experimenting on the share market and follow up the results using Calc (not a database). I have a spreadsheet with two ranges – range(1) directly above range(2). r(1) specifies per row every specific purchase/sell event (date, company name, amount, etc). To calculate the actual "to-day"-result for this specific event (row) we need the "to-day"-value for this company's share (in e.g. column X), which value is taken from respective company's row in col.Z in r(2). r(1) has yearly 100-130 rows (events) Range(2) lists each company named in the above Range(1) and has in col.Z the corresponding share's "to-day"-value. These inserted share values varies from one day to the next. There are now 10-15 companies (rows) listed in r(2) – not in alphabetic order. r(2) sums the up-to-date result per company and the total result. Problem The belowe example simplified to 5 events concerning 3 companies may clearify the problem with the formula in X1 copied down col.X: =if(B1=$B$20;$Z$20;if(B1=$B$21;$Z$21;(ifB1=$B$22;$Z$22;0))) As you can see: with 15 (or more) companies (and >100 events) the formula will grow and become very long and sensitive for mistakes. VLOOKUP does not seem to be an option, at least it requires a completely new setup of the page. Range(1) - events A B C…. X 1. nokia 5,o 2. kone 41,o 3. nokia 5,o 4. fiskars 12,o 5. kone41,o Range(2) - companies A B C... Z 20 nokia 5,o 21 fiskars 12,o 22 kone 41,o Any suggestion will be very interesting. Thank you in advance Pertti Rönnberg/Finland -- 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
Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!
Please, mr Philip Rhoades, Obviously you are not capable to realise what you are up to. All australians I have had the pleasure to meet, have been sympatic, intelligent, polite, well educated and in every way kind persons. From your writings the only conclusion is that you represent the outmostopposite end of these qualities. No wonder there are wars in the world. Stop behaving like a lowminded complete idiot. At least you could from your signature delete your address – that you are from Australia! Best regards Pertti Rönnberg, 76 yrs/ Finland On 28.1.2016 15:33, Philip Rhoades wrote: Gary, On 2016-01-28 22:44, Gary Collins wrote: Phil,you wrote: Just observation - you believe in sky fairies - Albert Einstein, Erwin Schrodinger, Paul Dirac, Antony Flew, all believed in a God; as do Richard Swinburne, Francis Collins, William Lane Craig, to name just a few. you also wrote. Well if you weren't clueless (which is not consistent with you believing in fairy stories) you would have realised by now that I don't have any and that I don't approve of others proselytising on this list . . I hope you would not refer to any of those I've listed above as 'clueless.' Being very smart or even a genius does not mean you have any "common" (more like "uncommon") sense. However, WRT your first example, people like you always claim Albert Einstein as a "believer" but in fact he did not believe in one or other of the common sky fairies that you seem to think he did - you probably know that and are just being dishonest about your claims . . Posts like yours could easily be seen as being offensive. The OP's post was offensive to me and shouldn't have included the sermon that it did. P. -- 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
Re: [libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS
Joel, Jean-Baptiste & others. Thank you for replying. A short explanation of my thinking. Many on this list have expressed the advice not to install the latest fresh version but install the latest bugfix of a 1-3 steps earlier version, just to minimize the risk of bugs and enjoy new features. OK? According to LibreO’s homepage the LO5.o2 and LO5.o3 are two different versions – probably not only regarding bugfixes but also with some new features; the most recent fresh now is LO5.03.2. So I decided for LO5.02.3 both on my Windows-machines (all 64bit) and on Ubuntu. Installing on Windows went OK but seems problematicto get it on Ubuntu (!!??) askUbuntu says not to use PPA because of safety reasons Joel says LO5.02.3 cannot (as a specific version) be installed directly in Ubuntu – not without even more confusing extra hockus-pockus with debian.tar.gz, etc (but not recommended?) May I put my main question this way: what is the general procedure (definite, correct) for upgrading an old LibreO version to a newer one in Ubuntu (e.g. Ubuntu 14.04.2 LTS) And the “subquestions”: (a)must the old version (& its help-pack) be removed before installing the new one in this Ubuntu? (b)when upgrading LibreO in Ubuntu does the help-pack upgrade automatically together with the main program or must it be installed separately? Please forgive me, I am trying to learn Ubuntu. Pertti Rönnberg On 11.11.2015 0:03, Joel Madero wrote: It is possible. If you want 5.0.2 specifically (not sure why...having identical versions on all machines really isn't required) but here are steps (assuming you're using 64 bit machine): 1. Download the debian package located: https://downloadarchive.documentfoundation.org/libreoffice/old/5.0.2.2/deb/x86_64/LibreOffice_5.0.2.2_Linux_x86-64_deb.tar.gz ; 2. Untar the file (navigate to folder using your file browser, right click on .tar.gz, uncompress it); 3. open terminal 4. use "cd" command to navigate to the DEBS folder inside of the uncompressed folder you just uncompressed, for example if I uncompressed the tar.gz to ~/Downloads then I would be something like this "cd ~/Downloads/[FOLDER NAME]/DEBS 5. sudo dpkg -i *.deb for the help files: https://downloadarchive.documentfoundation.org/libreoffice/old/5.0.2.2/deb/x86_64/ Download the relevant one and install the debian file the same way as described above. Best, Joel On Tue, Nov 10, 2015 at 1:55 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: Joel, I have installed the version LO5.02.2 on both my PC (Win 7, 64bit) and on another laptop and that is why I want to install it on Ubuntu too. But obviously it is not possible -- how come? By the way. Will the LO5.0x.x helppack install on Ubuntu together (automatically) with the LO-upgrade or shall it be installed separately? Pertti On 10.11.2015 23:39, Joel Madero wrote: Sorry that is incorrect - you'll actually get 5.0.3 which is the latest version in the repository. You can also install from the debian packages but this is not recommended for Ubuntu users - it is highly recommended to install from the ppa. Best, Joel On Tue, Nov 10, 2015 at 1:35 PM, Joel Madero <jmadero@gmail.com> wrote: It will install the latest version in the 5.0 repository. You'll get updates until 5.0 is end of life. You'll have to do the same procedure once 5.1 is released (add the 5.1 repository, update, then upgrade). Currently 5.0.2 is the latest version in 5.0 so that's the version that will be installed. On Tue, Nov 10, 2015 at 1:32 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: Joel Madero, Thank you for your reply. But this is one of the confusing details: does your answer not lead to install not the version 5.02.3 but a later/the latest one? Pertti On 10.11.2015 23:17, Joel Madero wrote: Terminal - sudo add-apt-repository ppa:libreoffice/libreoffice-5-0; sudo apt-get update; sudo apt-get install libreoffice Best, Joel On Tue, Nov 10, 2015 at 12:57 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: Hello Linux experts, May I ask for help -- the instructions on the web are too confusing for me. On my laptop (Win7, 64bit) I have recently installed the Oracle VirtualBox and there Ubuntu 14.04.2 LTS. The LibreO version in Ubuntu is 4.2.8 has only Writer, Calc and Impress. I want to replace that old LO4.2.8 version -- upgrade it to LO5.02.3 with all its components (at least Writer, Calc, Base, Draw and Math) but I do not want the lastest fresh versions. Can somebody tell me the step-by-step process/commands how this is performed? And must the old version be removed before installing the new one?. Thanks in advance. Pertti Rönnberg -- 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.o
Re: [libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS (SOLVED)
Joel, Jean-Baptiste and especially Andreas, thank you so very much for your help and kindness! Pertti Rönnberg On 11.11.2015 17:49, Joel Madero wrote: I think you really need to figure out what it is that you want. For additional help I suggest going to the #libreoffice IRC channel. What you asked for has been provided (how to upgrade to 5.0.2 as well as 5.0.3). If you want "still" version (I would argue it's not really all that more stable and you'll miss out on a lot of features that are in 5.x series) you need to install 4.4 not 5.0. On 11/11/2015 04:20 AM, Pertti Rönnberg wrote: Joel, Jean-Baptiste & others. Thank you for replying. A short explanation of my thinking. Many on this list have expressed the advice not to install the latest fresh version but install the latest bugfix of a 1-3 steps earlier version, just to minimize the risk of bugs and enjoy new features. OK? According to LibreO’s homepage the LO5.o2 and LO5.o3 are two different versions – probably not only regarding bugfixes but also with some new features; the most recent fresh now is LO5.03.2. So I decided for LO5.02.3 both on my Windows-machines (all 64bit) and on Ubuntu. Installing on Windows went OK but seems problematicto get it on Ubuntu (!!??) askUbuntu says not to use PPA because of safety reasons Joel says LO5.02.3 cannot (as a specific version) be installed directly in Ubuntu – not without even more confusing extra hockus-pockus with debian.tar.gz, etc (but not recommended?) May I put my main question this way: what is the general procedure (definite, correct) for upgrading an old LibreO version to a newer one in Ubuntu (e.g. Ubuntu 14.04.2 LTS) And the “subquestions”: (a)must the old version (& its help-pack) be removed before installing the new one in this Ubuntu? (b)when upgrading LibreO in Ubuntu does the help-pack upgrade automatically together with the main program or must it be installed separately? Please forgive me, I am trying to learn Ubuntu. Pertti Rönnberg On 11.11.2015 0:03, Joel Madero wrote: It is possible. If you want 5.0.2 specifically (not sure why...having identical versions on all machines really isn't required) but here are steps (assuming you're using 64 bit machine): 1. Download the debian package located: https://downloadarchive.documentfoundation.org/libreoffice/old/5.0.2.2/deb/x86_64/LibreOffice_5.0.2.2_Linux_x86-64_deb.tar.gz ; 2. Untar the file (navigate to folder using your file browser, right click on .tar.gz, uncompress it); 3. open terminal 4. use "cd" command to navigate to the DEBS folder inside of the uncompressed folder you just uncompressed, for example if I uncompressed the tar.gz to ~/Downloads then I would be something like this "cd ~/Downloads/[FOLDER NAME]/DEBS 5. sudo dpkg -i *.deb for the help files: https://downloadarchive.documentfoundation.org/libreoffice/old/5.0.2.2/deb/x86_64/ Download the relevant one and install the debian file the same way as described above. Best, Joel On Tue, Nov 10, 2015 at 1:55 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: Joel, I have installed the version LO5.02.2 on both my PC (Win 7, 64bit) and on another laptop and that is why I want to install it on Ubuntu too. But obviously it is not possible -- how come? By the way. Will the LO5.0x.x helppack install on Ubuntu together (automatically) with the LO-upgrade or shall it be installed separately? Pertti On 10.11.2015 23:39, Joel Madero wrote: Sorry that is incorrect - you'll actually get 5.0.3 which is the latest version in the repository. You can also install from the debian packages but this is not recommended for Ubuntu users - it is highly recommended to install from the ppa. Best, Joel On Tue, Nov 10, 2015 at 1:35 PM, Joel Madero <jmadero@gmail.com> wrote: It will install the latest version in the 5.0 repository. You'll get updates until 5.0 is end of life. You'll have to do the same procedure once 5.1 is released (add the 5.1 repository, update, then upgrade). Currently 5.0.2 is the latest version in 5.0 so that's the version that will be installed. On Tue, Nov 10, 2015 at 1:32 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: Joel Madero, Thank you for your reply. But this is one of the confusing details: does your answer not lead to install not the version 5.02.3 but a later/the latest one? Pertti On 10.11.2015 23:17, Joel Madero wrote: Terminal - sudo add-apt-repository ppa:libreoffice/libreoffice-5-0; sudo apt-get update; sudo apt-get install libreoffice Best, Joel On Tue, Nov 10, 2015 at 12:57 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: Hello Linux experts, May I ask for help -- the instructions on the web are too confusing for me. On my laptop (Win7, 64bit) I have recently installed the Oracle VirtualBox and there Ubuntu 14.04.2 LTS. The LibreO version in Ubuntu is 4.2.8 has only Writer, Calc and Impress. I want to replace that old LO4.2.8 version -- upgrade it t
[libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS
Hello Linux experts, May I ask for help -- the instructions on the web are too confusing for me. On my laptop (Win7, 64bit) I have recently installed the Oracle VirtualBox and there Ubuntu 14.04.2 LTS. The LibreO version in Ubuntu is 4.2.8 has only Writer, Calc and Impress. I want to replace that old LO4.2.8 version -- upgrade it to LO5.02.3 with all its components (at least Writer, Calc, Base, Draw and Math) but I do not want the lastest fresh versions. Can somebody tell me the step-by-step process/commands how this is performed? And must the old version be removed before installing the new one?. Thanks in advance. Pertti Rönnberg -- 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
Re: [libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS
Joel Madero, Thank you for your reply. But this is one of the confusing details: does your answer not lead to install not the version 5.02.3 but a later/the latest one? Pertti On 10.11.2015 23:17, Joel Madero wrote: Terminal - sudo add-apt-repository ppa:libreoffice/libreoffice-5-0; sudo apt-get update; sudo apt-get install libreoffice Best, Joel On Tue, Nov 10, 2015 at 12:57 PM, Pertti Rönnberg <p...@elisanet.fi <mailto:p...@elisanet.fi>> wrote: Hello Linux experts, May I ask for help -- the instructions on the web are too confusing for me. On my laptop (Win7, 64bit) I have recently installed the Oracle VirtualBox and there Ubuntu 14.04.2 LTS. The LibreO version in Ubuntu is 4.2.8 has only Writer, Calc and Impress. I want to replace that old LO4.2.8 version -- upgrade it to LO5.02.3 with all its components (at least Writer, Calc, Base, Draw and Math) but I do not want the lastest fresh versions. Can somebody tell me the step-by-step process/commands how this is performed? And must the old version be removed before installing the new one?. Thanks in advance. Pertti Rönnberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org <mailto:users%2bunsubscr...@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 -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com <mailto:jmadero@gmail.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
Re: [libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS
Joel, I have installed the version LO5.02.2 on both my PC (Win 7, 64bit) and on another laptop and that is why I want to install it on Ubuntu too. But obviously it is not possible -- how come? By the way. Will the LO5.0x.x helppack install on Ubuntu together (automatically) with the LO-upgrade or shall it be installed separately? Pertti On 10.11.2015 23:39, Joel Madero wrote: Sorry that is incorrect - you'll actually get 5.0.3 which is the latest version in the repository. You can also install from the debian packages but this is not recommended for Ubuntu users - it is highly recommended to install from the ppa. Best, Joel On Tue, Nov 10, 2015 at 1:35 PM, Joel Madero <jmadero@gmail.com> wrote: It will install the latest version in the 5.0 repository. You'll get updates until 5.0 is end of life. You'll have to do the same procedure once 5.1 is released (add the 5.1 repository, update, then upgrade). Currently 5.0.2 is the latest version in 5.0 so that's the version that will be installed. On Tue, Nov 10, 2015 at 1:32 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: Joel Madero, Thank you for your reply. But this is one of the confusing details: does your answer not lead to install not the version 5.02.3 but a later/the latest one? Pertti On 10.11.2015 23:17, Joel Madero wrote: Terminal - sudo add-apt-repository ppa:libreoffice/libreoffice-5-0; sudo apt-get update; sudo apt-get install libreoffice Best, Joel On Tue, Nov 10, 2015 at 12:57 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: Hello Linux experts, May I ask for help -- the instructions on the web are too confusing for me. On my laptop (Win7, 64bit) I have recently installed the Oracle VirtualBox and there Ubuntu 14.04.2 LTS. The LibreO version in Ubuntu is 4.2.8 has only Writer, Calc and Impress. I want to replace that old LO4.2.8 version -- upgrade it to LO5.02.3 with all its components (at least Writer, Calc, Base, Draw and Math) but I do not want the lastest fresh versions. Can somebody tell me the step-by-step process/commands how this is performed? And must the old version be removed before installing the new one?. Thanks in advance. Pertti Rönnberg -- 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 -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.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
Re: [libreoffice-users] LibreOffice Sort Bug ?
Brian, Thanks for your reply and for the articles you linked to – especially the last one is very interesting. I have been aware of that but not so well explained. As I think you are very cunny both on spreadsheets and how to use them and also the mathematics, I am not able to argue. But I am sure you know what I meant when I said that a spreadsheet is ‘totally’ worthless if you cannot trust it, if it -- the program, its features or functions -- does not work (behave) as supposed. As an engineer I have been working with MSExcel since late 1980 and have since 10 years successively began to use OO/LO. I’ve always tried to crosscheck important calculations and with calculation processes start with some few (random or logical) sample data and/or manual calcs to be sure that the formulas ( combinations of) work OK. Whatever people say about Microsoft, I must say that I have never experienced any problems caused by the program MSExcel itself (perhaps I’ve been lucky) – all my problems have been caused by my typos or my bad planning of the calculation process. But, especially with LibreOffice/Calc I have experienced issues that clearly depend on LO as a program and have caused me a lot of extra doings – the last couple of years LO has become better. Regarding the articles. If the programming of the very big programs is purchased from a third party where the programmer -- the person -- does not have no own knowledge (understanding) about the customer's process, then it is an unavoidable necessity that there will be flaws and serious issues -- regarless of branch. Anyhow, the fact is that Microsoft has a 90 percent market share and every MSO suite includes MSExcel. Above this are e.g. AOO/OO/LOwith roughly 2 mega spreadsheet users and their applications. That means that quite a lot of – some very important -- calculations are globally done with these MSOALO (..etc..) spreadsheets. If the spreadsheets are that unreliable as these articles (and you) explain, should it not then be good - if not a necessity – to warn about it? Experts and “nerds” can manage but not ordinary users like me. I like LibreOffice and respect its intensions and thus I want it to be better. If LO really wants to increase its market share – to beat MSO, a benefit for all users – then it has to eliminate every possible cause of problems especially for the ‘ordinary user’ -- even the small ones like that sorting issue. The ordinary user selects a range and pushes the sort button -- if the sort does not behave as expected, and there is no explanation why or how and the help is too difficult to find -- then he/she considers this a problem. Too many problems is not good for LO. It is the mass of ‘ordinary users’ that build most of the MSO’s market share. The main and final responsibility lies – not on the (unpaid) programmer -- but on the controlling team in the LO organization. It is better to fix problems at a stage of planning and production than after a global distribution(ref. to Quality Management Systems). regards Pertti Rönnberg On 27.3.2015 15:25, Brian Barker wrote: At 12:38 27/03/2015 +0200, Pertti Rönnberg wrote: A spreadsheet program that cannot be fully trusted is totally worthless!! It's perhaps worth a reminder that, in the sense that you mean it, spreadsheets can never be trusted. Since much of their essential functionality is hidden (formulae, formatting, significant options) and they are untestable, you should never rely on the results of a spreadsheet. Your judgement, then (but not mine) is that spreadsheet programs generally are totally worthless. See, for example: http://lemire.me/blog/archives/2014/05/23/you-shouldnt-use-a-spreadsheet-for-important-work-i-mean-it/ I will happily use a spreadsheet to estimate the grades of my students, my retirement savings, or how much tax I paid last year… but I will not use Microsoft Excel to run a bank or to compute the trajectory of the space shuttle. Spreadsheets are convenient but error prone. http://baselinescenario.com/2013/02/09/the-importance-of-excel/ But while Excel the program is reasonably robust, the spreadsheets that people create with Excel are incredibly fragile. http://mba.tuck.dartmouth.edu/spreadsheet/product_pubs_files/Literature.pdf Among those who study spreadsheet use, it is widely accepted that errors are prevalent in operational spreadsheets and that errors can lead to poor decisions and cost millions of dollars. Panko summarized this literature by reporting that 94% of spreadsheets have errors, with an average cell error rate of 5.2%. Brian Barker -- 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
Re: [libreoffice-users] LibreOffice Sort Bug ?
Tim Lloyd's comment is not acceptable! This is not a question of a (unpaid) programmer's likings or priorities -- this is a serious question of Libre Office's liability, because both of the the sort buttons in the toolbar (asc desc) give wrong results as well as there is no clear explanation why and how the sort command in Data= sort must be customized if yopu want a correct result. A spreadsheet program that cannot be fully trusted is totally worthless!! These bugs are a result of very bad planning and an obviously total lack of control testing of the programming before it was accepted as a feature in Calc and the complete LibreOffice suite. Neither is this really not a game -- anyone who goes for to programming something for LibreOffice must feel the responsibility for the result -- as well as the controlling team (if any?). The sort feature is a very important feature why these faults have to be corrected immediately the function of both the sort buttons set to normal sort of a selected range all selections set to blanc in Data=sort=options Pertti Rönnberg On 26.3.2015 2:12, Tim Lloyd wrote: Hi, while LO does allow a certain amount of customisation, at this point in the game this particular menu option can not be changed. This then becomes a feature request, either * change the default * allow the sort options to be customised Once a feature request is submitted it is really up to a (unpaid) programmer to step forward and take on the action. I can't see this being high on the programmer's list of priorities but it may be deemed an easy hack which an aspiring young person could field. Cheers On 26/03/15 10:58, Richard VINCK wrote: Tim Lloyd Thank you for pointing this. Indeed, unticking it works then correctly. But it should be the default, and should remain unticked. (and should be more visible, as it is hidden in the Option tab) Can we make it as default? On 2015-03-26 00:42, Tim Lloyd wrote: A quick look at the doco reveals... Range contains column/row labels – omits the first row or the first column in the selection from the sort Untick this box and you are sorted. Cheers On 26/03/15 10:06, Wade Smart wrote: Hmm I just tried to sort going through the sort menu and I still cant get it to sort properly. It does numbers just fine though. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Wed, Mar 25, 2015 at 6:04 PM, Wade Smart wadesm...@gmail.com wrote: **cough cough** .. feature understood. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Wed, Mar 25, 2015 at 6:02 PM, Michael Tiernan michael.tier...@gmail.com wrote: On 3/25/15 6:53 PM, Wade Smart wrote: I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not working. When I reported it, I provided a great deal of information about it and was told Not a bug and works for me by those who have the power to close bugs. My argument was/is that if you use the sort arrows (as you have done here) then you're asking/telling LO to sort the selected rows with no options. Instead it was deemed correct that instead, LO assumes the first cell found is used as a label regardless of any other settings. This feature (*cough*) cost me a number of hours of work to get around and avoid. The argument is that since you can use the Sort menu option and change this behavior *for each sort occurrence* then there's a work around for the feature and we should be happy with that. -- MCT Michael C Tiernan. http://www.linkedin.com/in/mtiernan Non Impediti Ratione Cogatationis Women and cats will do as they please, and men and dogs should relax and get used to the idea. -Robert A. Heinlein -- 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 -- 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
Re: [libreoffice-users] ### signs in Calc
Best Sirs, From mr Asaibene's message I think it is obvious -- at least we can assume -- that he is rather familiar with using speadsheets (e.g. LO/Calc) and knows the basics, he has reloaded the LO program -- and he described a simple calculation that is all correct but showed the result that is in no way normal whatever his (operating)system is. The answers mr Asaibene has got are of course correct but not relevant. One point is that if a word processor (e.g. Writer) does not work correctly you can see or notice it and correct it, but if a spreadsheet program (e.g. LO/Calc) does not behave or do the calculations correctly you may not be aware of the failures and draw wrong conclutions -- a spreadsheet program is worse than worthless if you cannot trust it 150%. A couple of years ago I experienced some that sort of problems with LO/Calc why I still try to check the results in every project of importance. Mr Asaibene's message is alarming: if a spreadsheet behaves odd in small then there can be more serious issues. I think mr Asaibene should post a bug report. Regards Pertti Rönnberg On 19.2.2015 16:18, Cley Faye wrote: I'm pointing the obvious, but anyway... ### as a formula result usually mean that the cell is too narrow for the result to be displayed. Is that a possibility here? -- 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
Re: [libreoffice-users] Re: Printing from Linux, Kubuntu/Ubuntu
Tim and Frank, As an answer to your kind responding: In fact I had made a live-DVD to check my PC's (64bit) co-operation with Ubuntu14.04.1. My intention is to first install Ubuntu on a VirtualBox because errors are then easier to correct and after that perhaps do a dual-boot install (I am an expert on making errors). And got some real 'challenges': my system is 64bit/8GB RAM/2 TB HD (virtualization enabled) but the Ubuntu(64bit) did not accept to install (memory instruction error???) so I re-installed VMUbuntu as 32bit. The install is now OK but the Ubuntu is very very slw. My printer does not work either. I know -- this not a LO-issue, so I must try to get help from Ubuntu-forum. Best regards Pertti Rönnberg On 25.1.2015 12:12, Tim---Kracked_P_P---webmaster wrote: Is there any need to have Linux in a VirtualBox or could you just boot to Linux on your computer - as a dual booting one? I run laptops with Win7 [pro and home] with Ubuntu on one and Linux Mint on another. There are some things I need to run on Windows, that are easier to use than any Linux counterpart. But my default booting for these laptops is Linux. I went to Linux as my default OS in the Spring of 2010 , when I bought this desktop. I originally was using Linux before that on spare system when the cost of buying the needed software using Windows was getting too much for my budget. I found the needed software functions and applications for free with Linux [Ubuntu and others]. Actually I defaulted to Ubuntu since its Live CD was the only one that allowed my HP laptop's audio to work out of the box. As for old brains, well after 3 strokes, I am lucky my younger brain still works. I think healthy exercise for the brain is important, whether you are in you 40's or 80's. My wife has end-stage Alzheimer's and I really know the importance in keeping you mind as active as you can to help reduce the effects of age on your mental abilities. I am a little slower in doing things due to an illness that just will not go away, but I am learning to live with it, just like learning to live with what the strokes left me to work with. On 01/24/2015 08:55 AM, Pertti Rönnberg wrote: Frank, Thank you very much for your soon reply -- I was just working on the installations. The printer seems to be working on the Windows so let us hope it will work OK with the VirtualBoxUbuntu too. Earlier 10-15years ago I used WindowsUbuntu parallell but then I had to rebuild my PC completely and for some reason never installed the Ubuntu again - perhaps too complicated -- but I never gave up the idea skipping windows. Now I re-installed systemprograms again and decided to start working with Ubuntu again. Next step is to learn using ApacheSQLite for my need of databases. I used to work with MSAccess but am not interested in spending money on purchasing and was told that SQLite is easier and not so heavy as MySQL. Do not know yet. Anyway I find this interesting and think it is a healthy exercise for an old brain too (75y) So any guides and ideas how I shall proceed to get SQLite(3) to run in Ubuntu are welcome. Kind regards Pertti Rönnberg On 24.1.2015 14:22, CVAlkan wrote: Pertti: If you are running Ubuntu (or anything else as far as I know) in a Virtual Box, you don't have access to any hardware unless it is recognized by the host system. But if your printer functions properly on the host system (and you set up virtualbox carefully), it should work fine on Ubuntu. The issues I encounter all seem to be related to LOWriter, so if you have no issues with that on your host, it seems to me fairly likely that you should be ok. In any case, if it doesn't work you haven't lost anything. Just as a matter of curiosity, are you looking to a linux distro just to use SQLite and Apache? Or was there some other consideration driving that choice? Frank -- View this message in context: http://nabble.documentfoundation.org/Printing-from-Linux-Kubuntu-Ubuntu-tp4136908p4137269.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
Re: [libreoffice-users] Re: Printing from Linux, Kubuntu/Ubuntu
Good afternoon, My PC's OS is windows 7prof.-64bit (where LO 4.3.4.1) My intention is to (again try to) convert to Linux and shall now install Ubuntu (vers. 14.04.1 ready on a DVD) in a virtualbox and use that for creating database applications with SQLite(3) ( Apache PHP) and expect having LO/Base as a front end. Am I to understand from this thread that I am getting printing problems with Linux in such an installation? If so, what version of Ubuntu is then safe and reliable? My printer is a KonicaMinolta magicolor 1600w. Grateful for any advice Pertti Rönnberg On 23.1.2015 11:33, Tom Davies wrote: Hi :) I almost always have at least 4 partitions; 1 for swap, 1 for /home or just to put my data on and 2 to have different distros or different versions of the same distro on. On some machines i multi-boot between half a dozen different versions of Ubuntu (but always intend to clean it up down to just 2 or 3). Regards from Tom :) On 22 January 2015 at 17:40, Tim---Kracked_P_P---webmaster webmas...@krackedpress.com wrote: Yes, I agree with you, BUT. . . When I upgrade to a newer version of Ubuntu via the Update Manager system, I get a message about CUPS being depreciated and no longer used. So it is Removed from the upgraded system. That is when I have to reinstall it, along with my CUPS-PDF package. Of course that package gives the depreciated message as well, but I know of no other PDF file printer for Ubuntu either. On 01/22/2015 09:20 AM, CVAlkan wrote: Tom: CUPS still seems to be alive and well; in fact, I'm not sure how we could get along without it. It is listed in the Ubuntu repository, although has always been installed by default on any installation I've done (admittedly, not a whole lot though). If you use the Software Center, make sure to check any other additions you might require (I have everything but OpenPrinting installed). If you need to install it separately, you can download it from http://www.cups.org/software.php. I hope this helps ... Frank -- View this message in context: http://nabble.documentfoundation.org/Printing-from-Linux-Kubuntu-Ubuntu-tp4136908p4137067.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 -- 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
Re: [libreoffice-users] Re: Printing from Linux, Kubuntu/Ubuntu
Frank, Thank you very much for your soon reply -- I was just working on the installations. The printer seems to be working on the Windows so let us hope it will work OK with the VirtualBoxUbuntu too. Earlier 10-15years ago I used WindowsUbuntu parallell but then I had to rebuild my PC completely and for some reason never installed the Ubuntu again - perhaps too complicated -- but I never gave up the idea skipping windows. Now I re-installed systemprograms again and decided to start working with Ubuntu again. Next step is to learn using ApacheSQLite for my need of databases. I used to work with MSAccess but am not interested in spending money on purchasing and was told that SQLite is easier and not so heavy as MySQL. Do not know yet. Anyway I find this interesting and think it is a healthy exercise for an old brain too (75y) So any guides and ideas how I shall proceed to get SQLite(3) to run in Ubuntu are welcome. Kind regards Pertti Rönnberg On 24.1.2015 14:22, CVAlkan wrote: Pertti: If you are running Ubuntu (or anything else as far as I know) in a Virtual Box, you don't have access to any hardware unless it is recognized by the host system. But if your printer functions properly on the host system (and you set up virtualbox carefully), it should work fine on Ubuntu. The issues I encounter all seem to be related to LOWriter, so if you have no issues with that on your host, it seems to me fairly likely that you should be ok. In any case, if it doesn't work you haven't lost anything. Just as a matter of curiosity, are you looking to a linux distro just to use SQLite and Apache? Or was there some other consideration driving that choice? Frank -- View this message in context: http://nabble.documentfoundation.org/Printing-from-Linux-Kubuntu-Ubuntu-tp4136908p4137269.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
Re: [libreoffice-users] Re: LOBase connected to SQLite3
Hi all of you, Thank you for your time and your answers. Now I'll have something to do while waiting for Santa Clause and all the presents. Creating dbs and learning new (HTML, PHP, SQL) is good execise for a 75 years old brain. Merry Christmas and a Happier New Year 2015 Pertti On 17.12.2014 10:30, Alex Thurgood wrote: Le 16/12/2014 14:21, Pertti Rönnberg a écrit : Hi Pertti, My prime intention is to start building database applications using SQLite3. I first tried to install Apache PHPSQLite3 as separate programs but the config process was too much for me why I installed WAMP2.4.As you know is WAMP a package of Apache, PHP and MySQL(v.5.6.) and the SQLite3 is an extension in PHP(v. 5.5.). You can try to connect to your SQLite datasource either via ODBC or JDBC. Using Google to search for drivers brings up a few. An example here of someone on Ubuntu : http://en.libreofficeforum.org/node/2038 Note that there are a few known bugs with current versions of LO and SQLite3, the last one being a limitation of sqlite3 (notourbug) : https://www.libreoffice.org/bugzilla/show_bug.cgi?id=82688 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=86943 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=50575 Alex -- 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] LOBase connected to SQLite3
Good afternoon, May I ask for some help and advice. My prime intention is to start building database applications using SQLite3. I first tried to install Apache PHPSQLite3 as separate programs but the config process was too much for me why I installed WAMP2.4.As you know is WAMP a package of Apache, PHP and MySQL(v.5.6.) and the SQLite3 is an extension in PHP(v. 5.5.). When I have been using LibreO for many years now why it should be nice if I could use LOBase as a front end with SQLite as the db-engine. My question is: is it possible to connect LOBase to SQLite3? And if so, how shall it be done -- where can I find a guide? Is the process similar as when connecting to MySQL? My system is Windows7prof64bit; LO4.3.4. Thanks in advance Pertti Rönnberg (Finland) -- 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
Re: [libreoffice-users] a LibO/Calc problem (SOLVED)
Thank you Paul and Brian for your interesting answers and for your kindness to send them so soon. I have not checked them yet but I am sure that both of them give me what I was looking for. I see thepros and cons in Paul's method: by splitting the calculation in details you can follow both the process and the reliability of the result, but at cost of space. But, there is more fun in Brian's solution; I have always liked to create such complex formulas partly to be familiar with the spreadsheet program and it's functions but now a days mostly because it is very good exercise for an old man's brain --it is a challenge and then a good reason to award yourself with a drink when it finally works. I think I was quite near Brian's solution, but something went wrong, so I had to shout for help. Paul's answer is interesting from another point of view also -- he changes the decimal sign from a comma to a period and replaces the periods replaced by commas to get the correct thousand separator. If you Google (e.g.) decimal dot vs. comma you will get a map that shows How the world separates its decimals. We in Finland, like all European countries -- with the U.K. as the only exception -- use a comma as decimal sign. Another page Decimal and Thousand Separators says: Great Britain and the United States are two of the few places in the world that use a period to indicate the decimal place. Many other countries use a comma instead... Likewise, while the U.K. and U.S. use a comma to separate groups of thousands, many other countries use a period instead, and some countries separate thousands groups with a thin space. Personally I have never understood the need or benefits of any thousand separator -- I have never used it neither private, in technical planning nor in (international)business. Thanks again and best regards Pertti Rönnberg On 12.1.2014 19:22, Paul wrote: I haven't so much tried to answer your question directly, instead I attempted to solve the same problem you did. For me, this gives a simpler answer. Given: Col A: The initial bank value as text Col B: =IF(RIGHT(A1,1)=-,Debit,Credit) Col C: =LEN(A1) Col D: =LEFT(A1,C1-1) Col E: =FIND(,,D1) Col F: =SUBSTITUTE(D1,.,,) Col G: =REPLACE(F1,E1,1,.) Col H: =VALUE(G1) Col I: =IF(B1=Debit, 0-H1, H1) Col A holds the initial value as given by your bank, as text. Col B then looks at the last character of that value, and displays either Debit, if the character was a minus sign, or Credit for anything else. Col C gives the total length of the initial text value Col D gives the initial value stripped of the last character, the plus or minus sign. Col E gives us the position of the comma, so that we can turn it into a period later. Col F gives us the stripped value (from col D) with the periods replaced by commas, for correct thousand separators. Col G gives us the value from col F with the final comma changed to a period, for correct decimal separator. This text string should now be correctly formatted for interpreting as a number. Col H gives us the value from col G interpreted as a number. Col I gives us the final value we want. This is derived from col H, which has the initial value as a number, without the correct plus or minus sign, and we use the value in col B to determine if we should use the number as is, or subtract it from zero to get a negative number. I formatted this column as currency. I tested it with the following: 11.200,33+ == R 11,200.3 2.500.236,65- == R-2,500,236.65 11,25+ == R 11.25 0,96- == R-0.96 If I understand you correctly, this is exactly what you want. No need to mess around with numbers under or over 9.999,99. Of course, you can combine some of those formulas to use less extra cells, but the more you combine stuff, the more complex it becomes, and I don't know where you'd like to draw the line for complexity of formulas vs complexity of page layout, so I leave that part up to you. Hope this helps you out. Paul On Sun, 12 Jan 2014 17:55:17 +0200 Pertti Rönnberg p...@elisanet.fi wrote: Happy New Year Dear LibO experts, Since years back I have copied my bank's digital listing of my bank account(s); first using MSOWord and later on MSOExcel. My intension is to transform these listings so I can calculate with the currency values in LibO-Calc. The bank's table has four cols: colA=date, colBcolC= text and colD is the currency as text. Each listing consists of several hundreds of events (rows). The problem is that the damn bank -- against all standards -- gives the currency values with a dot (.) as thousand separator and + or - chars (plus or minus) in the right end of each number (e.g. 987,65+, 1.234,56-, 23.456,78+) -- which is against Calc's will. By now I have managed to get LibO/Calc to accept all values less than 9.999,99: first dragged (copied) the table from MSWord = MSExcel; MSExcel-file saved in LibO/Calc as ods in Calc = function TRIM(D5) to get rid of non-printable chars
Re: [libreoffice-users] Re: a LibO/Calc problem (SOLVED)
Larry, Here is a copy/paste copy of Brian's comments to my message. I hope Brian does not mind. Regards Pertti Rönnberg Since years back I have copied my bank's digital listing of my bank account(s); first using MSOWord and later on MSOExcel. My intention is to transform these listings so I can calculate with the currency values in LibO-Calc. The bank's table has four cols: colA=date, colBcolC= text and colD is the currency as text. Each listing consists of several hundreds of events (rows). The problem is that the damn bank -- against all standards -- gives the currency values with a dot (.) as thousand separator and + or - chars (plus or minus) in the right end of each number (e.g. 987,65+, 1.234,56-, 23.456,78+) -- which is against Calc's will. By now I have managed to get LibO/Calc to accept all values less than 9.999,99: first dragged (copied) the table from MSWord = MSExcel; MSExcel-file saved in LibO/Calc as ods I'm not sure why you want to use Microsoft Word or Excel. You can open a .doc file in LibreOffice (as a text file) and copy and paste the table into a spreadsheet there. You can open an .xls file directly in LibreOffice. If your bank's original data is plain text or web material, you can import this directly into a LibreOffice spreadsheet. _Question:_ What formula/function gives the same result for the bank's currency values bigger than 9.999,99? e.g. 11.222,33+, 11.222.333,44- It's a bit messy, but this should work: =VALUE(RIGHT(Xn;1)SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Xn;.;);+;);-;)) Cannot get the Fixed() -- when trying to eliminate the separator/dot that way -- working in this 'project' either. This is no help. If you already had correctly interpreted numbers (which you don't: that's the problem), FIXED() would convert these to text (with which you then couldn't calculate) - exactly the opposite of what you are trying to do. Once you have your real numbers, you can control their appearance by choosing appropriate cell formats, of course. I trust this helps. Brian Barker On 13.1.2014 19:15, Larry Evans wrote: On 01/13/14 05:10, Pertti Rönnberg wrote: Thank you Paul and Brian for your interesting answers and for your kindness to send them so soon. I have not checked them yet but I am sure that both of them give me what I was looking for. I see thepros and cons in Paul's method: by splitting the calculation in details you can follow both the process and the reliability of the result, but at cost of space. But, there is more fun in Brian's solution; I have always liked to create such complex formulas partly to be familiar with the spreadsheet program and it's functions but now a days mostly because it is very good exercise for an old man's brain --it is a challenge and then a good reason to award yourself with a drink when it finally works. I think I was quite near Brian's solution, but something went wrong, so I had to shout for help. [snip] Hi Pertti, I don't see Brian's reply to you(maybe he emailed you privately). Could you please post it so other's could see it? -regards, Larry -- 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
Re: [libreoffice-users] a LibO/Calc problem (SOLVED)
Brian, Your formula workes perfect! Fantastic! And I learned a little more about creating formulas. Thanks again! Cheers ; skål (swedish) ; kippis (finnish) Pertti Rönnberg On 13.1.2014 3:13, Brian Barker wrote: At 17:55 12/01/2014 +0200, Pertti Rönnberg wrote: Since years back I have copied my bank's digital listing of my bank account(s); first using MSOWord and later on MSOExcel. My intention is to transform these listings so I can calculate with the currency values in LibO-Calc. The bank's table has four cols: colA=date, colBcolC= text and colD is the currency as text. Each listing consists of several hundreds of events (rows). The problem is that the damn bank -- against all standards -- gives the currency values with a dot (.) as thousand separator and + or - chars (plus or minus) in the right end of each number (e.g. 987,65+, 1.234,56-, 23.456,78+) -- which is against Calc's will. By now I have managed to get LibO/Calc to accept all values less than 9.999,99: first dragged (copied) the table from MSWord = MSExcel; MSExcel-file saved in LibO/Calc as ods I'm not sure why you want to use Microsoft Word or Excel. You can open a .doc file in LibreOffice (as a text file) and copy and paste the table into a spreadsheet there. You can open an .xls file directly in LibreOffice. If your bank's original data is plain text or web material, you can import this directly into a LibreOffice spreadsheet. _Question:_ What formula/function gives the same result for the bank's currency values bigger than 9.999,99? e.g. 11.222,33+, 11.222.333,44- It's a bit messy, but this should work: =VALUE(RIGHT(Xn;1)SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Xn;.;);+;);-;)) Cannot get the Fixed() -- when trying to eliminate the separator/dot that way -- working in this 'project' either. This is no help. If you already had correctly interpreted numbers (which you don't: that's the problem), FIXED() would convert these to text (with which you then couldn't calculate) - exactly the opposite of what you are trying to do. Once you have your real numbers, you can control their appearance by choosing appropriate cell formats, of course. I trust this helps. Brian Barker -- 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 LibO/Calc problem
Happy New Year Dear LibO experts, Since years back I have copied my bank's digital listing of my bank account(s); first using MSOWord and later on MSOExcel. My intension is to transform these listings so I can calculate with the currency values in LibO-Calc. The bank's table has four cols: colA=date, colBcolC= text and colD is the currency as text. Each listing consists of several hundreds of events (rows). The problem is that the damn bank -- against all standards -- gives the currency values with a dot (.) as thousand separator and + or - chars (plus or minus) in the right end of each number (e.g. 987,65+, 1.234,56-, 23.456,78+) -- which is against Calc's will. By now I have managed to get LibO/Calc to accept all values less than 9.999,99: first dragged (copied) the table from MSWord = MSExcel; MSExcel-file saved in LibO/Calc as ods in Calc = function TRIM(D5) to get rid of non-printable chars formula (in E5) : removes the separator/dot and the + sign and changes the value from text to number /=VALUE(IF(RIGHT($E4;1)=+;IF(MID($E4;2;1)=.;CONCATENATE(MID($E4;1;1);MID($E4;3;LEN($E4)-3));MID($E4;1;LEN($E4)-1));0))/ formula (in F5): removes the separator/dot and the - sign and changes the value from text to number /=VALUE(IF(RIGHT(//E4//;1)=-;IF(MID(//E4//;2;1)=.;CONCATENATE(MID(//E4//;1;1);MID(//E4//;3;LEN(//E4//)-3));MID(//E4//;1;LEN(//E4//)-1));0))/ copy(dragged) down the 100-300 rows Copy(cols EF) = PasteSpecial to colG:H gives the desired list of incomes and expences separated in their own cols as acceptable numbers _Question:_ What formula/function gives the same result for the bank's currency values bigger than 9.999,99? e.g. 11.222,33+, 11.222.333,44- I have tried to define the . using the Find() - but have had trouble with it when nested in another function/formula (e.g. an IF() function); the definition of it in Calc/Help is obviously at least unclear if not wrong. Cannot get the Fixed() -- when trying to eliminate the separator/dot that way -- working in this 'project' either. Any advice and help is greatly appreciated. Best regards Pertti Rönnberg computer: PC, win7prof/64bit; LO4.0.4.2 -- 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
Re: [libreoffice-users] Merry Christmas and Happy New Year
Merry Christmas and Happy New Year to you all from Finland too! and thanks for all advice and interesting reading on this list. Pertti Rönnberg On 22.12.2012 13:58, rost52 wrote: Also from Japan a Merry Christmas and Happy New Year to all. Reinhold On 2012-12-22 4:22, webmaster-Kracked_P_P wrote: On 12/21/2012 01:46 PM, RODRIGUEZ FONSECA JORGE ALBERTO wrote: Me too for you and all Regards, Jorge Rodríguez - Mensaje original - De: Eliane Domingos de Sousa elianedomin...@libreoffice.org Para: users@global.libreoffice.org Enviados: Viernes, 21 de Diciembre 2012 7:59:50 Asunto: [libreoffice-users] Merry Christmas and Happy New Year Hi all, Merry Christmas and Happy New Year! A git for you TDF, thanks for all you do for us! http://blog.pt-br.libreoffice.org/2012/12/21/feliz-natal-e-prospero-2013/ From Brazilian LibreOffice Community!!! Best That tree would make a good image to be placed on next year'sLibreOffice.org's opening page. -- 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
Re: [libreoffice-users] Connecting LO Base to an SQL DB [SOLVED]
Hello LibO experts, and congratulations IanW! It has been very interesting to follow this discussion getting Base working with MySQL. Unfortunately -- if I got it right - is Ian's OS a Linux (Ubuntu?) Would it be possible to get the same proceeding described as a step-by-step instruction for Windows7 (64bit)? in plain english (no IT-jargong) starting from the very beginning defining the different programs (versions) and components (ODBC, JDBC, JRE, etc when needed, included) to be installed Since Andreas Säger (one of LibO db-experts) last winter and spring repeatedly pointed out that LibO/Base is not to be considered as a stand-alone database program I have several times tried to create the connection LibO/Base to SQLite and to MySQL (I prefer SQLite as lighter than MySQL), but without success. I am sure that such an instruction could increase the acceptance and usability of LibO and I am sure that we are many that would be happy. Regards Pertti Rönnberg On 6.11.2012 9:54, Steve Edmonds wrote: On 2012-11-06 20:41, Ian Whitfield wrote: Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!) You have all added some pieces to the Jigsaw and I'm pleased to say.. *I now have Base working with a MySQL Database (at last!!)* As Girvin would say My Bad!! I had been looking for the file 'my.cfg' when it should have been 'my.cnf'. This was the last missing piece, once I found it and found the skip-networking line inside it and commented it out everything worked fine. So once again guys - thanks for sticking with me - awesome support and I do appreciate it!! Now the fun starts - I have already designed my Form yesterday but now need to puzzle out how to get all my data out of the old DB into the new SQL DB. And then re-write all my Queries and reports. Greatly appreciated - regards from South Africa IanW Pretoria RSA. If you can get your data out of the old database as a csv file it is real easy to load into MySQL. You can use the command line MySQL command or if you install webmin it makes database admin easy. Steve -- 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
Re: [libreoffice-users] Connecting LO Base to an SQL DB [SOLVED]
Thank you Dan, IanW and Heinrich for your kind answering and encouraging! The other day when some spare time I shall study your advice and try again. Is it not fantastic that we like this can discuss things all across the word!!! Pertti Rönnberg (Finland) On 6.11.2012 15:12, Dan Lewis wrote: Base as a stand alone refers to embedded databases (the database data is contained in the database file. This type of database can lose data. However, this does not mean that you have to use MySQL, Presgresql, or Oracle, ... Nor do you have to install a JDBC or ODBC driver for Base to connect to the data. Base includes its own JDBC driver. Everything you need is included in the installed Base files. The last section of Chapter 3 of the Base Guide discusses how to extract the data from an embedded database and connect to this data using Base. (The data becomes an external data source. I don't have time right now to upload this to the LO Wiki, but I will be doing it in about 6 hours or so. Warning: it is a draft copy, but you are free to study it and make any suggestions or comments about it. --Dan On 11/06/2012 04:34 AM, Pertti Rönnberg wrote: Hello LibO experts, and congratulations IanW! It has been very interesting to follow this discussion getting Base working with MySQL. Unfortunately -- if I got it right - is Ian's OS a Linux (Ubuntu?) Would it be possible to get the same proceeding described as a step-by-step instruction for Windows7 (64bit)? in plain english (no IT-jargong) starting from the very beginning defining the different programs (versions) and components (ODBC, JDBC, JRE, etc when needed, included) to be installed Since Andreas Säger (one of LibO db-experts) last winter and spring repeatedly pointed out that LibO/Base is not to be considered as a stand-alone database program I have several times tried to create the connection LibO/Base to SQLite and to MySQL (I prefer SQLite as lighter than MySQL), but without success. I am sure that such an instruction could increase the acceptance and usability of LibO and I am sure that we are many that would be happy. Regards Pertti Rönnberg On 6.11.2012 9:54, Steve Edmonds wrote: On 2012-11-06 20:41, Ian Whitfield wrote: Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!) You have all added some pieces to the Jigsaw and I'm pleased to say.. *I now have Base working with a MySQL Database (at last!!)* As Girvin would say My Bad!! I had been looking for the file 'my.cfg' when it should have been 'my.cnf'. This was the last missing piece, once I found it and found the skip-networking line inside it and commented it out everything worked fine. So once again guys - thanks for sticking with me - awesome support and I do appreciate it!! Now the fun starts - I have already designed my Form yesterday but now need to puzzle out how to get all my data out of the old DB into the new SQL DB. And then re-write all my Queries and reports. Greatly appreciated - regards from South Africa IanW Pretoria RSA. If you can get your data out of the old database as a csv file it is real easy to load into MySQL. You can use the command line MySQL command or if you install webmin it makes database admin easy. Steve -- 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
Re: [libreoffice-users] Suitability of Lo in Small organisations
Best all you LibO experts and Devs! What Webmaster now says is a good example on all the basic level issues that must be completely eliminated from LibO. Some posts ago I asked what version of LibO at this moment is to be considered as the most reliable and most stable. And got the answer that LibO3.5.7 is the one for newcomers perhaps followed by LibO3.6.2. (But nothing said about Base, that is my main concern and asked for) For all of you that know LibO's build-up, its features and work-arounds and alternative solutions these issues may seem simple. But for users like me they are serious - I do not even know where to start looking for a solution if I meet such a problem. It is really a matter of using LibO or not -- and I do not want to have different programs/suites for different types of need. My main interest is to get the job done and because of limits in time or costs I cannot accept delays caused by the tool I use. Obviously I have to continue - even if I don't want to - to buy MSO. A lack of resources is not a valid excuse as long as you can continue developing new bugs and issues - plus them 1000-2000 already waiting for fixing. I know very well that it is never fun to afterwards repair mistakes - so better not to make them. Waiting for the results of your wise decisions - especially regarding Windows with some 90% of the users. Pertti Rönnberg On 20.10.2012 23:57, webmaster-Kracked_P_P wrote: The freezing and word count issues - was that on 3.5.6, 3.5.7, or some other version. I have noticed that 3.5.7 freezes sometimes on loading/opening with Ubuntu 64-bit 12.04 and MATE desktop. I never saw this with 3.5.6 and Ubuntu 10.04 and GNOME desktop. Since I upgraded to 12.04 on Oct. 8th and 3.5.7 when it came out on the 18th, I did not have much time with 12.04 and 3.5.6 to tell if there was any issues. The freezing happened several times. Once with clicking on the panel launcher and twice with the right-clicking and open with option. The only way to get the LO splash/opening to unfreeze is to reboot. Actually when Ubuntu reboots, LO opens up properly. I have the system set to open any packages with windows open when I log off or shut-down/re-boot. So I do get the freezing splash screen once and a while for 3.5.7. Is this an issue with other users of 3.5.7? On 10/20/2012 03:10 PM, Anthony Easthope wrote: I haven't yet given them the 3.5.7 release as I have still been away! the bugs where mainly freezing wordcount and thelike On Sat, 20 Oct 2012, at 03:49 PM, Tom Davies wrote: Hi :) +1 Was it something that would have been easily fixed by renaming the User Profile? Regards from Tom :) From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Friday, 19 October 2012, 7:17 Subject: Re: [libreoffice-users] Suitability of Lo in Small organisations It would be interesting to learn what version was used, which bugs were observed and if they were all reported an when. On 2012-10-19 10:39, Anthony Easthope wrote: Hi guys I was wondering what would perhaps be the best release of LO to recommend to a small charitable organisation. I had a problem with the latest release as it was quite buggy and the church athletics club I installed it for was not to happy when they found the bugs interrupted their workflow, So what is the most stable release? -- Anthony Easthope antiso...@myopera.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 -- 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 -- 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
Re: [libreoffice-users] Indexing for Search not working?
Tom, That info of yours is not only interesting but very important for me as an user - and most certainly for others too. Unfortunately you add that it is how you imagine it works! Would it be possible that you check that with the board or the devs themselves and then confirm it to us? If I were you I definitely would like to be sure about the proceedings - (a) if such really has been settled or (b) if not settled? Some posts ago I asked what version is for the time being considered the most reliable, especially regarding Base? -- and what version of JRE is in that version needed for Base (if anymore needed)? I have read the release notes and got an picture but what is your opinion? My version now is LibO3.4.6 on Win7Pro/32 and Win7/64. Pertti Rönnberg On 18.10.2012 12:41, Tom Davies wrote: Hi :) The upgrade from 3.5.x to 3.5.7 is extremely unlikely to cause problems. That 3rd digit is roughly like a Service Pack number, but divide it by 2 because MS only does 3 SPs whereas LO does 6 or 7. The 3.x.7 aims at avoiding introducing new features! New features are mostly in the 3.6.x or being lined-up for the 3.7.0. The 3.5.7 is likely to just have fixes for any lingering problems in the 3.5.6. Most of those fixes will be being merging into the 3.6.3 and .4. At least that's how i imagine it works. Certainly once that 3rd digit reaches .4 the branch seems a lot more stable. Regards from Tom :) From: anne-ology lagin...@gmail.com To: Dr. R. O Stapf reinh...@stapf-online.com Cc: users@global.libreoffice.org Sent: Thursday, 18 October 2012, 2:31 Subject: Re: [libreoffice-users] Indexing for Search not working? and now we're 3 :-) On Wed, Oct 17, 2012 at 2:44 AM, Dr. R. O Stapf reinh...@stapf-online.comwrote: On 17.10.2012 16:07, Pertti Rönnberg wrote: BRAVO Anne-Ology!! Exactly that message - only in other words -- I have repeatedly tried to tell to the LibO-experts (devs) since January: they must take a brake in developing and take a certain version (e.g. 3.4.xx) and make every module of the suite - Base included - absolutely free of bugs and inconsistencies both in programming and the instructions and especially the LibO-Help. Every feature shall have a clear explanation and a detailed guiding how-to in the LibO-Help -- easily understood by any average non-expert user. I cannot agree more. I started with 3.5.4 a few month ago and saw some problems disappearing in 3.5.5 and 3.5.6. Currently I am hesitating to upgrade to 3.5.7. I hope the dev-team listens to Pertti's words. -- 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 -- 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
Re: [libreoffice-users] Indexing for Search not working?
BRAVO Anne-Ology!! Exactly that message - only in other words -- I have repeatedly tried to tell to the LibO-experts (devs) since January: they must take a brake in developing and take a certain version (e.g. 3.4.xx) and make every module of the suite - Base included - absolutely free of bugs and inconsistencies both in programming and the instructions and especially the LibO-Help. Every feature shall have a clear explanation and a detailed guiding how-to in the LibO-Help -- easily understood by any average non-expert user. Obviously I've been crying in vain because I have not noticed any (re)actions -- the developing of new versions is continuing with the result of an increasing activity on this list. I have LibO3.4.6 installed (Win7) but avoid using it (Calc, Base) because I have better to do than struggle with problems. I would like to know which LibO version for the time being can be considered as the most reliable and productive -- especially regarding Base. It would also be interesting to see an (valid) evaluation of that reliable usability on a scale 1-10 for each of the the different modules of versions 3.4.xx, 3.5.xx.x, 3.6.xx.x Pertti Rönnberg On 16.10.2012 18:15, anne-ology wrote: This is the reason I have no intention of updating from 3.4 until ALL these bugs are worked out - then I'll update to 3.5; yes, I'll always be behind BUT I don't have the hassles of these bugs ;-) On Mon, Oct 15, 2012 at 9:22 AM, teatimest teatim...@gmail.com wrote: I've been using v3.4 of LibreOffice. I updated to v3.6.2.2 and now the contents of documents are not indexed for search. I'm using 64-bit Windows 7. The extension odt is checked for the indexing option. I also checked the Index Properties and File Contents in the Indexing Option in Windows. When I search, doc files and ppt files appears in the result but not odt and odp. Is it just me or is this known bug? The same thing happened when I updated to v3.5 so I went back to v3.4 for the searchability. Is there any workaround? Tea -- 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
Fwd: Re: [libreoffice-users] Integer part of a number
Hi everybody, When I tried to give an answer to Gilles' basic question I proposed my formula based on the reality that I have never experienced negative voting. The very interesting (theoretical) discussion this caused shows that there may be several correct solutions. I can imagine that Gilles (and me too) is curious to know what is the best answer to his problem. Even if I did (I admit) some overthinking I cannot see that my answer is wrong. So, what is the best way for Gilles to continue? Pertti Rönnberg Original Message Subject:Re: [libreoffice-users] Integer part of a number Date: Mon, 15 Oct 2012 10:49:51 +0300 From: Pertti Rönnberg p...@elisanet.fi To: users@global.libreoffice.org Good morning Gilles others, Provided that I got your problem right, I think the answer is: SumVotes_group1 = 5,78(in Calc e.g. in cellC3) SumVotes_group2 = 7,34(in C4) SumVotes_group3= 0,78(in C5) SumVotes_ group4= 0,99(in C6) The answer could be: a write following formula in(e.g.)cellD3 =IF(c31;0;INT(c3)) b copy the formula to d4..d6 The formula translated into english: if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else (-- if c3 is '1' or bigger then -- ) use the integer of value in c3) I hope this is of help. Pertti Rönnberg On 14.10.2012 12:20, Gilles SICHE wrote: Hello, could anyone tell me which formula I should use for the integer part of a cell to be shown in another cell, and for the value of this cell to be changed, since, for example, 5,77 would become equal to 5? When finding out who won in an election, if one group or party gets a result of 5,28, they get 5 seats, if the result is 0,77, they get no seat at all, I would then want the figure 5 and the figure 0 to appear in a cell. But I need the real value to be 5 and 0, not only to be shown as such, since these values (0 and not 0,77) will be used in another operation (to know which group gets the last remaining seat). I hope my question is not too unclear, thank you for your answers anyway, G. Siche -- 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
Re: [libreoffice-users] MS problems
Dear Wolfgang, I am in no way trying - not even in a a such position - to limit anyone's right to express one's opinions, but I wish you will give the same right to others -- we shall respect all others this list is meant to help LibO and its users - not to humiliate or calling names, nor to write irrelevant bullshit So please, don't insinuate but say clearly what you mean - my english is not good enough to understand what you mean at all - nor expressions like snip. Some posts ago you blamed company managers and called them IT-illiteral morons claiming that they do wrong decisions buying MS/MSO programs forcing the company's employees who do the actual work to be ineffective. I replied that you are barking at a wrong tree -- that it is the IT stuff, the IT-managers and their knowledge you should blame. Now confirm that by blaming that IT-people - hired as consultants or employed experts by these IT-illiteral moron managers - to be too lazy and ignorant to listen to these workers who do the actual work. Can you please explain what you really mean - if you happen to know - and provided that it is of any use for this list. Just blaming Microsoft and its programs is not productive, nor is it relevant - it is only negative. If you have a good medicine how to make LibO better and more used it might be of interest if you tell us. And I can assure you with about 25 years own experience that MSAccess - in practice - is not in any way a pathological data shredder -- no doubt has all the MS/MSO programs been good enough to beat WP, Lotus 123, Symphony, etc. -- even still better than any open source programs. My hope and intention with these posts of mine is that LibO should be enough better to beat MS/MSO as a market leader. Regards Pertti Rönnberg On 6.10.2012 22:49, Wolfgang Keller wrote: I think the market share of MSO has nothing to do with the users being idiots or not. The 90% share is caused by 3 things *snip* 2 - Not many people know about alternatives. That's what I call ignorance. Ignorance plus unwillingness to inform oneself to remedy that ignorance equals idiocy. I don't have anything against idiots, as long as they don't impose their idiocy onto me. 3 - Many IT departments in companies choose MSO because it is easily available and they consider the support as good. IT departments, just like managers choose (in fact, they don't choose at all) MS because it's not them who have to do the actual work, so they can't have a clue. And because they're too lazy and ignorant to get some input from the information workers who have to do the actual work. Keep in mind that introduction of an alternative suit requires a lot of testing in an IT department. The suit must be stable and keep productivity high. With MS products, user productivity will be minimised compared to all available alternatives. Sincerely, Wolfgang -- 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
Re: [libreoffice-users] documentation for LO base
Hi everybody, I agree with Mark. The question itself is interesting but an answer does not explain anything relevant. Let us turn the question around:how many people should use LO-Base if there was a LibO-version available that is ready to use, reliable, and free of problems (bugs). If its installing instructions should be complete, consequent, and placed in one easy to find place the program's every single detail should work -- functions, features, processes at a level (e.g.) similar to MSAccess (2003) --the ability to build decent reports included (and the embedded db-engine and its guides up-dated and supported) the guiding documentation ( help) should be logic, understandable and in every detail correlating with the program With the exception of heavy industrial systems the need and possibilities of up to medium complex databases in everyday life at home are unlimited -- only limited by the decision to start creating. There are really nothing difficult in creating such home databases-- no need to be an Einstein, if only good guidings are available. Creating database applications is also a very interesting form of brain training -- and the feeling when succeeding is a yippee. If you know how to use Writer/Word and Calc/Excel (esp. as databases) you are almost half way. What you still has to do is to study and learn some few basic theories about and how to create the tables and the queries(experiment manually, not with wizards, if you want to learn and understand);creating the forms and the reports is just a matter of following instructions. If you want LibO to be a popular competitor to MSO ( MSAccess), then the rest is only a question of marketing. As far as I have experienced LibO-Base (v. 3.4.5), there are only a few details left to fixed before LibO should be almost perfect. About contributing A basic rule in quality systems (ISO9000) is that if you want improvement you must first identify the problems (faults, weaknesses) -- and then follow up by a plan and an improving activity. LibO might be a very fine and usable suit -- especially if also its Base module (docs included) should work properly, at least as promised in introductions. Mr Dan Lewis is doing a good and valuable work when updating and completing the Base's documentation and it is obvious that without any help his project will take a long time. Last winter I started to read and follow up experimenting Dan's docs with the intension to send my comments as points of views. And hadquite a lot already done. At this list I several times also mentioned some quite basic problems/faults both in Base's docs and especially in the modules's features. I never got any kind of response, I don' t know if my proposals were noticed, nor do I know if the mentioned things have been fixed. So I skipped working any further on experimenting LibO-Base and its docs. (I am now back to OO and tries to learn MySQL) You may take this as some sort of a contribution too. Best regards Pertti Rönnberg On 4.10.2012 18:04, Mark Stanton wrote: Question: How many people do you know use Base, or have tried to use Base? Whilst there is some quite valid criticism of Base, I don't think answering this question says as much about Base as it does about the general usage of databases. They are less familiar than word processors, spreadsheets or drawing packages. Mark -- 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
Re: [libreoffice-users] MS problems
Hi Wolfgang, Most certainly you must be right. I only cannot understand what you mean and on what arguments. But don´worry, be happy! and have a nice weekend. Pertti Rönnberg On 5.10.2012 19:12, Wolfgang Keller wrote: If MSO is a 90% market leader all its users cannot be complete idiots. cynism Thank you for this statement that clearly illustrates the typical pointy haired think (i.e. un-think) of leaders (and their followers). The very simple fact is: LibO has to become better in a SWOT analysis! And what color should that SWOT analysis have? Would Mauve have enough RAM? /cynism Sincerely, Wolfgang -- 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
Re: [libreoffice-users] MS problems
Hi, you all clever guys, I don't think this list is meant for naming or humiliating any others -- not people, nor programs, nor anything -- that behavior rather works like boomerang and shows the quality level of these naming and blaming. I am eagerly looking forward to the day when a seriously made and officially published SWOT analyses -- all costs included -- will give as result that is to LibO's favor compared with commercial suites like MSO. That is a very healthy process for every kind of decision making both for companies and privates. If MSO is a 90% market leader all its users cannot be complete idiots. The very simple fact is: LibO has to become better in a SWOT analysis! Idealism is a good power if correctly focused -- extremism never. Pertti Rönnberg On 30.9.2012 23:17, Jay Lozier wrote: On 09/30/2012 03:31 PM, Wolfgang Keller wrote: Just had a classic from my boss. *snip* He still says there is no problem with IE. The point is not that there are plenty of hopelessly IT-illiterate morons out there, the point is imho that it's exactly these IT-illiterate morons who decide about what those people who have to do the actual work have to work with. +1, In the US they are called Pointy Haired Boss of PHB Sincerely, Wolfgang -- 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
Re: [libreoffice-users] MS problems
Dear Wolfgang Jay, A.so in your opinion people - both young and old - not yet knowing anything about computers, perhaps buying their first unit, are - not only IT-illiterate but also morons B.so you agree that among these IT-illiterate morons (= idiots) are bosses, persons in chief position (managers). When responsible for their dept's/company's strategic and operative effectiveness and economical result, these IT-illiterate morons decide about the need of an IT-department -- and employ an IT-manager to that department to take care of the company's IT-system, programs and personnel included. Are you not barking at a wrong tree - is it not this your IT-superior you should bark at? I take it obvious that neither of you can be in a manager position. C. Obviously you qualify yourselves as highly IT-literate -- perhaps even non-morons. Some weeks ago LibO invited people to take part to make LibO better. Would it not be an good idea that you - instead of blaming others - took the opportunity to practice your high quality IT-knowledge to the benefit of LibO. Best regards Pertti Rönnberg On 30.9.2012 23:17, Jay Lozier wrote: On 09/30/2012 03:31 PM, Wolfgang Keller wrote: The point is not that there are plenty of hopelessly IT-illiterate morons out there, the point is imho that it's exactly these IT-illiterate morons who decide about what those people who have to do the actual work have to work with. +1, In the US they are called Pointy Haired Boss of PHB Sincerely, Wolfgang -- 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
Re: [libreoffice-users] MS problems
Hello Joep, Thank you for your reply. I am happy to say I had the privilege to in business visit your very beautiful and interesting country - and especially Amsterdam - some times very, very many years ago. I am also retired since ten years back and used to work on manager level in some companies mostly in metal industry, planning and delivering plants. But not IT, I am an IT consumer since early 1980 - so you surely know that IT field from 'inside' better than me but I know quite well the decision making in my former environments. I have for years been very well aware of all what you say about MS's behavior and marketing policy - I agree with you completely and do dislike the situation as much as you. In many (most) companies/organizations (other than IT) the managers have quite little own knowledge in IT why they do not have many alternatives: they have to buy the IT from outside (more or less) experts or build up a IT-dept of their own. In both cases they have to rely on other people's knowhow and recommendations. And if all (95% ?) your important contacts, customers, officials, private, etc. use Windows, and all of your own staff know (only) Windows/MSO then the economic calculation says that you must talk the same language -- you can not afford anything else. I strongly disagree with you about Jay's and Wolfgang' s behavior - take a look at my parallel post MS problems some minutes earlier. If these managers concentrate on their own jobs - and buy the IT - it does not qualify them to be called IT-illiteral morons as Jay and Wolfgang did. In 30 years I have had no problems (!) with the Windows' programs (the cost are a relative matter), but from January this year when installing LibO I have had too much problems with Base (and Calc) - and according to this list there are a lot of others having real problems with LibO too. In my opinion there is only one way for LibO: to become in every way better than MSO especially for ordinary private users, user friendly, stable, reliable, free of bugs and problems. These will then make it easier for companies to convert to OpenSource/LibO. Best regards Pertti Rönnberg (Finland) The End! On 1.10.2012 13:51, Joep L. Blom wrote: On 01-10-12 11:57, Pertti Rönnberg wrote: Dear Wolfgang Jay, A.so in your opinion people - both young and old - not yet knowing anything about computers, perhaps buying their first unit, are - not only IT-illiterate but also morons B.so you agree that among these IT-illiterate morons (= idiots) are bosses, persons in chief position (managers). When responsible for their dept's/company's strategic and operative effectiveness and economical result, these IT-illiterate morons decide about the need of an IT-department -- and employ an IT-manager to that department to take care of the company's IT-system, programs and personnel included. Are you not barking at a wrong tree - is it not this your IT-superior you should bark at? I take it obvious that neither of you can be in a manager position. C. Obviously you qualify yourselves as highly IT-literate -- perhaps even non-morons. Some weeks ago LibO invited people to take part to make LibO better. Would it not be an good idea that you - instead of blaming others - took the opportunity to practice your high quality IT-knowledge to the benefit of LibO. Best regards Pertti Rönnberg Pertti, As a Dutch (now retired) manager of a small business in IT I must disagree. Yes, Jay and Wolfgang are not very polite but they surely are right. I won't call them morons or idiots but choosers for safety on false grounds. Don't forget a salesman in a computer-shop will never tell a person that he could use Open Source software when he can sell him buggy Microsoft software with a profit of 30%. He will tell him that on his computer only certified Microsoft software will work correctly. You and I know its complete nonsense but an IT-illiterate layman - especially those that are afraid of everything technical - believes him. The same goes for managers with even less interest in technical matters and a willing ear for equals who sells him there stuff. It is not for nothing that governments (Peru, Germany and many others) demand the use of Open Source software instead of the use of closed source, dangerous and expensive software. Twenty years ago the hard- and software world was completely different and there Microsoft has made his largest impact using unlawful methods to make everybody believe their software was the only one to be used.A small governmental action contrary was when the European Committee forced Microsoft to pay a fine of $ 500,000 and to remove Internet explorer as integral part of their OS. But the main objection against the activities of Microsoft remain valid: the disinformation of managers and decisional people on the fact that they have to pay yearly for service not delivered. Since 1981 when Microsoft began to SELL
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
All the best LibO folks, This discussion about calendars etc. may be interesting perhaps also useful -- but back to the basic question! Microsoft is going to change their behavior. Let us remember that MS is the absolute market leader -- they can't be totally wrong when having 95% and people accept paying. It is no use blaming MS for success -- it is only waste of energy and expresses your foolishness. LibO only have to accept it. Whether you like it or not MS's programs use to work without remarkable problems - and if such happens MS fixes them rather quickly. That is why people and especially companies seem to be prepaired to pay what ever the cost. What I have tried to say is that if LibO wants to get a reasonable share oh this cake -- free of charge or not -- then LibO must offer and also deliver something better than the MS's Office suit it's Access included -- equal is far away from enough. Some of you said that ordinary users -- and even more experienced - seldom use more than a 2-5% of the LibO's (MSO's) features. Why not then identify the 30% of all most used features and make sure that at least these work properly -- Base included. If LibO cannot be made at least as stable, free of bugs and easy to use -- and especially it's help function understandable for every new user -- then there is no larger future for LibO except for a small group of idealists and enthusiasts in their own little kindergarten. I see this as a question of defining priorities - and a strategy. If the goal seems clear and clever then then the resources will at least not disappear. Pertti Rönnberg On 27.9.2012 10:08, Gordon Burgess-Parker wrote: On 26/09/12 12:01, webmaster-Kracked_P_P wrote: I have seen listings on Mozilla's archive system for an extension to help with the syncing to a Google account. Don't need any of those for Google Calendar - you can use Caldav which doesn't require any extension at all. http://support.google.com/calendar/bin/answer.py?hl=enanswer=99358#sunbird -- 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
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
Hi Tom, Thank you for a very informative answer - it is bad that all this is not mentioned as a basic info about LibO. I am prepared to trust it as true but honestly I have to rely on my own experiences both regarding Win/MSO and LibO. I have been using Windows and many of MS programs since early 1980: all of the modules in the MSO suite, Access, Publisher, Visio, Project, etc never any problems with installing never need to send any kind of bug reports never any need to contact any community/list for help cannot remember not one machine crash when using Windows-MS-programs no courses, no teachers in using Windows/MS programs -- I had no problems to learn all by my self mostly thanks to a good help function; when I was working as IT-help/help desk I could even tutor my colleagues in Word, Excel, PP, Access how to use the special features and functions made a lot of Access-dbs, learned to complete them with VBA and got macros work Some /_facts_/ about LibO (first 3.4.5, then 3.4.6 -- I didn't dare to install later versions, so now back to OO) in January this year after downloading LibO I had big problems/crashes with getting Base (similar to MSAccess) working - reason: JRE and bad guidings some basic features/functions in Base does not work -- no help from LibO help nor Base Guide I have some rather big (heavy) applications in Calc (several sheets, 200 rows15-30 cols/sheet, remote referenses between sheets) - I've noticed (when tracking why results are wrong) that Calc in some situations does not have power enough to do the automatic recalc through all the rows/cols/pages: there is nothing wrong, it just does not do the recalc -- which means that I cannot trust the calcs to be 100% correct; this is not only inconvenient but can be fatal in economical calcs (my computers do most certainly have all the power needed) the button LibreOffice Help does not directly lead to any kind of help -- the function is totally of no use until you first learn it's logic (if any) -- to find any help can take hours of digging I should very much like to use LibO only (not only because of costs) but cannot afford wasting time and nerves on all the problems. According to this list there are -- in my opinion -- too many others having problems already from the very beginning, with installing. For me -- I represent the ordinary non-LibO-expert user -- it is obvious why not only companies rely on Windows/MSO. I can not see that this is anything to argue about: LibO must be easy-to-use, stable and free from any basic problems if it wants to be really accepted. Note: I am talking about ordinary people and ordinary companies, who value their time. Pertti Rönnberg On 27.9.2012 17:07, Tom Davies wrote: Hi :) On the contrary. MS do not fix their problems quickly at all. Even known malware threats remain for months and even years. Their strategy is to blame the users. A typical one being to tell users they shouldn't be using macros because of the likelihood of getting an infected or corrupted one. Read The Emperor’s New Clothes. People are told that MS Office is the best and so when they find problems with it they tend to blame themselves rather than the software. For example when using non-MS software someone would quite happily slate the product with this sort of thing I opened my document and deleted tons of stuff and saved it using the same name. now when i open the document it has all that stuff missing! The stupid program can't even find the stuff that i deleted. No, of course i don't have a back-up of the file before my deletions One problem that has never been solved is that when creating an MS document the style keeps randomly changing without the user doing anything noticeable. So, the language keeps switching to US. Bullet-points and numbering styles keep changing. So in a bulleted list the points keep changing shape, size and amount they are indented by. Numbered lists may well miss a few numbers or repeat a few or suddenly change from i), ii) to c), d) or other weirdness. People have learned to accept all this shoddiness from Word because it happens to so many people. Really advanced users have learned to re-impose formatting after completing a document or just accept it. Spelling has gone out the window not just because of the MTV generation but also because MS's spell-checker keeps switching languages back into American (US) so things that are correct are sometimes given a red-wriggle and sometimes blatantly incorrect spellings are not found. LibreOffice tends to stick to the same style throughout, unless the user has deliberately changed styles and is aware of having done so. So, bullet-points line-up and retain the same size. Likewise with numbered lists. Another problem is the way Word can't handle images with much sophistication. MS produce a different product for people to buy
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
Dear mr Webmaster, I agree with you about the risks with Microsoft's possible actions in the future -- let us hope we are wrong. I am afraid you got me wrong -- my fault. What I meant by the break in developing LibO, was that the LibO's developers for a while should stop proceeding. They must take one specific version of LibO (especially for Windows as the main OS) and make it absolutely free of bugs and failures -- and plus that make the documentations complete and understandable (and thus usable) for ordinary non-expert computer users. And then - after that - continue again. Why? Because I have been a Windows user since early -80 and installed OpenO decades ago. Last January this year I downloaded LibO (3.4.5) with the main intention to use Base -- but experienced that much problems - first with the installing JRE and then with many basic functions and especially with the embedded HDBSQL and especially with the quite horrible unlogical documentations -- that I have given up. I am quite sure that I am not alone! Since January I have followed the discussions on this list and am getting even more convinced that LibO is not really meant for ordinary people as an alternative to MSO. It seems mainly to be a playground for a group of open-source enthusiasts with a language of their own. Whom are the new features and finesses meant for, when there is no general info about them and no guiding documentation until 3-4 version generations later? Meanwhile they have only caused problems. When I download a what-ever program for my needs, I want it to work and to work stable and smoothly. I have no need nor time to struggle with different problems, to investigate and test different workarounds -- nor asking for help and waiting perhaps days for an answer that might help if I only happen to understand the advice. Frustration can easily be limited by paying to Microsoft. Best regards Pertti Rönnberg On 19.9.2012 21:48, webmaster-Kracked_P_P wrote: I have not bought any MSO past MSO-2003. I moved to OpenOffice.org [as soon as it read/saved .doc files] till LO 3.3.0 came out. Then I moved to LO for all my systems, Windows and Linux. Now I create/update the NA-DVD [http://libreoffice-na.us/English-3.5-installs/index.html] project and a 773,000 American Spelling Dictionary for LO. On 09/19/2012 01:11 PM, John Clegg wrote: Which is why I started migrating 3 months ago! I haven't had to go back once. On Sep 19, 2012 4:57 PM, webmaster-Kracked_P_P webmas...@krackedpress.com mailto:webmas...@krackedpress.com wrote: No, it is not a good idea to take a break. But it is time to tell those people who do use MSO that they are changing their pricing policy and almost forcing their users to rent their products in the near future. It is time that the users start thinking about their long term use of MS's Office and other business software. You no longer will be able to buy their products in any reasonable price, for MS that is, and not know if you rent it for X dollars for the first year, it will not go up to 150% of X dollars in year two. You will then have to pay their ransom or you loose the ability to use the software on your computer. Then there is the multi-license discount - or should it be the end of the multi-license discount. Businesses with 50 or 100 computers will be required to but a single user license for every computer at $150+ per license. The rental agreement plan is not that much better of an option. So now you can say that every computer they own can have a copy of LO for free. Every updated or new version of LO will be free, unlike MSO's policy. No need to rent or buy anything office suite package anymore. FREE now and FREE in the future. MSO just wants to force a user to pay them over and over for the same software, for as long as you live. Then when you die, you heirs will be forced to pay MS's blood money for the rest of their lives. This maybe a good plan as a revenue generation, but not for the users. On 09/19/2012 11:22 AM, Pertti Rönnberg wrote: Hi LiBO folks and especially LibO developers Microsoft's desicion to start renting their software puts ordinary people (and companies) in a fortune with very uncertain costs ahead. Should it not be now - if ever! - the perfect time for the LibO devs to take a break in developing new features in the LibO suite and from a certain version start making all LibO's functions and its every existing feature working smoothly and and stable and free of problems and bugs -- from the very beginning: from installing (with or without JavaJRE), Base and its embedded HDBAQL and its Report Builder, all included. And to complete-update the guiding documents (esp. LibO Help) to an good working quality level
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
Dan, I feel your point even if hidden. I understand your reaction but what you say is not an explanation nor a solution - it does not change the fact that the Base's documentation is to some extend misleading, uncomplete and not congruent with the programmed features. If you are The Dan that has worked with the docs you have done a good job so far, but it must be finished! And obviously you cannot do everything alone. I personally can not help even if I wanted to: I am no programmer and I do not not know the inner build-up of nor the relationships between Base's features and finesses. I only am (was!) an user and can only contribute by proposing - and that I have done without results - as far as I know. I try again: if you cannot get Base working as a standalone database (like MSAccess) then take the Base module away from the LibO suite or replace the old embedded HDBSQL v1.8 with a modern xxxSQL or make Base clearly an front-end (by totally removing the embedded part) and advice users to an specific real background database (MySQL, SQLite, etc) and give them an easy-to-use and really working softwaredocs for the connecting reprogram LibO/Base so that a form can be built based on a query (not only on a table) and then write/complete docs about how to build forms and subforms manually (no wizard) borrow the Report Builder from OO and make it (really!) working in LibO -- together with working docs about how-to inform the user how to make a cover page (Mainform) for the database from where to open forms, reports, etc That as a beginning. If or when Base works without problems and without bothering that list, I am lazy enough to start using the rest of the LibO-suite. Best regards Pertti Rönnberg On 20.9.2012 14:37, Dan Lewis wrote: The reality of documentation is that very few people are willing to help produce it. This is true of Base more so than the other components of LO. All of it is done by volunteers. If people want better documentation, they need to do something about it. That means personally testing various features and document what they find. It also means people stepping forward to work with others to make the documentation better by collaborating. --Dan On 09/20/2012 07:06 AM, Pertti Rönnberg wrote: Dear mr Webmaster, I agree with you about the risks with Microsoft's possible actions in the future -- let us hope we are wrong. I am afraid you got me wrong -- my fault. What I meant by the break in developing LibO, was that the LibO's developers for a while should stop proceeding. They must take one specific version of LibO (especially for Windows as the main OS) and make it absolutely free of bugs and failures -- and plus that make the documentations complete and understandable (and thus usable) for ordinary non-expert computer users. And then - after that - continue again. Why? Because I have been a Windows user since early -80 and installed OpenO decades ago. Last January this year I downloaded LibO (3.4.5) with the main intention to use Base -- but experienced that much problems - first with the installing JRE and then with many basic functions and especially with the embedded HDBSQL and especially with the quite horrible unlogical documentations -- that I have given up. I am quite sure that I am not alone! Since January I have followed the discussions on this list and am getting even more convinced that LibO is not really meant for ordinary people as an alternative to MSO. It seems mainly to be a playground for a group of open-source enthusiasts with a language of their own. Whom are the new features and finesses meant for, when there is no general info about them and no guiding documentation until 3-4 version generations later? Meanwhile they have only caused problems. When I download a what-ever program for my needs, I want it to work and to work stable and smoothly. I have no need nor time to struggle with different problems, to investigate and test different workarounds -- nor asking for help and waiting perhaps days for an answer that might help if I only happen to understand the advice. Frustration can easily be limited by paying to Microsoft. Best regards Pertti Rönnberg On 19.9.2012 21:48, webmaster-Kracked_P_P wrote: I have not bought any MSO past MSO-2003. I moved to OpenOffice.org [as soon as it read/saved .doc files] till LO 3.3.0 came out. Then I moved to LO for all my systems, Windows and Linux. Now I create/update the NA-DVD [http://libreoffice-na.us/English-3.5-installs/index.html] project and a 773,000 American Spelling Dictionary for LO. On 09/19/2012 01:11 PM, John Clegg wrote: Which is why I started migrating 3 months ago! I haven't had to go back once. On Sep 19, 2012 4:57 PM, webmaster-Kracked_P_P webmas...@krackedpress.com mailto:webmas...@krackedpress.com wrote: No, it is not a good idea to take a break. But it is time to tell those people who do use
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
Hi LiBO folks and especially LibO developers Microsoft's desicion to start renting their software puts ordinary people (and companies) in a fortune with very uncertain costs ahead. Should it not be now - if ever! - the perfect time for the LibO devs to take a break in developing new features in the LibO suite and from a certain version start making all LibO's functions and its every existing feature working smoothly and and stable and free of problems and bugs -- from the very beginning: from installing (with or without JavaJRE), Base and its embedded HDBAQL and its Report Builder, all included. And to complete-update the guiding documents (esp. LibO Help) to an good working quality level so it is understandable and usable for every one. Better late than never if you want LibO to be really accepted! Regards Pertti Rönnberg On 19.9.2012 15:40, webmaster-Kracked_P_P wrote: YES!!! That is why I posted this info to the list. Now there is one more thing that it an advantage of LO over MSO. You do not have to rent it. I do not know how many people would be comfortable with renting software. I really would not trust MS not raising the rental fee for year two. Then there is the issue of having some code that MS will send to either give you another year of service or to disable MSO from being used. I would bet that there will be a virus that would be made and sent out that will disable such a built in enable/disable license code system. On 09/19/2012 12:23 AM, Anthony Easthope wrote: This doesn't really seem to be a good move by Microsoft as it would drive many people away it!. it is such a great thing that Lo exists Mirosław Zalewski mini...@poczta.onet.pl wrote: On 18/09/2012 at 20:13, Doug dmcgarr...@optonline.net wrote: Note, too, that the old argument, I bought it, so it's mine, will be out the window--if it's rented, it clearly is not yours to copy, etc. As far as I remember, it was never yours. Most EULAs forbid e.g. reselling of box copy. They clearly state that they grant you right to use software, nothing more. -- Best regards Mirosław Zalewski -- 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 -- 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
Re: [libreoffice-users] Re: Is 3.5.4 ready for business users?
Dear you LibO folks, I have now wasted a lot of time reading some 30 mails in this thread - it was of no use because most of them did not handle neither give an answer to the original very relevant question: Is 3.5.4 ready for business users? So, what is the conclusion - if there is any? Is 3.5.4. ready for business use, or not -- if not, what version is then in every way at least as or more reliable as e.g. MSOffice MSAccess? the MSO's license fees are peanuts compared with lost efficiency (and costs) if a company's office personnel must struggle with LibO's bugs and issues many hours many days per week per month -- and the company has to employ or buy some extra it-resources for that (and fixing new problems coming with new versions every 'second day') no company can afford bad quality or inflexibility in communication with customers caused by a not-working office program (LibO?) MSO is no doubt the 90% market leader and is most certainly used by any company's most important customers/contacts -- and the rest 10% will follow the majority every time they have to Three weeks ago in another thread I put an similar question asking what is the best LibO version today for a private/home user -- a home user does not have it-experts or own skills in programming to rely on but has the same need of a troublefree program. Thanks to Tom and Andreas for their kindness to answer; but neither of them gave me an exact recommendation: that version is what you need! Perhaps that 'business ready version' of LibO could be the one for me too. If there is no such a reliable version (not for business nor for home) then stop developing for a while and make one: better to have a perfectly well working program with less features than one with plenty of fantastic features that does not work and that produces problems already when being installed! Please, start with fixing Base! Regards Pertti Rönnberg On 4.6.2012 3:49, Andreas Säger wrote: Am 04.06.2012 00:59, Tom Davies wrote: Andreas' and e-letter's answer is to tell people that to use LO they must stop communicating with anyone that uses MS Office, so that is all their customers and clients, their colleagues, their boss and people that work for them, their family and friends. Are you going to start a flame war against me? Be careful, pal. Your assertion is without any substance. -- 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
Re: [libreoffice-users] Re: Is 3.5.4 ready for business users?
Ken, Heinrich and Tom, thank you for your kind replies. (and Andreas, you seem to know a lot and do a good job helping us 'dummies' so please, try to not be so aggressive!) Sorry - I'm getting old and forget easily the obvious: my systems are: LibO3.4.5 on a laptop Win7Prem.Home/64bit and LibO3.4.6 on a PC Win7Prof/32bit my LibO usage: most interested in Base (with embedded HSQL and/or connected to an external db), and then Calc (various economic, technical and other calcs) and to some extend Writer (together with MSWord; letters, protocols, memos, etc). Tom, as you see, I have obeyed your advice last winter and installed Lib3.4.6 but am now curious on if there is something even better. Sounds like there is wrong kind of people in BoD, to sitwait is not the most effective way to get things done. It is a shame to let Base not being completed, when there is so very little left to get it working as promised in the LibO's introductions; the same is for the LibO-Base's documentation (Dan' drafts 2010 for OO-Base!). As it is now LibO and it's Base-module is only causing frustration -- it should be better to remove the module from the package until it has been completed and is working properly. Best regards Pertti Rönnberg On 4.6.2012 18:25, Tom Davies wrote: Hi :) Thanks for your kind words :) Simplest answer is grab the 3.4.6 now if you don't already have LO on your system. If you already have LO then wait 4 weeks until the release of 3.5.5 on the 8th July or else just test-drive 3.5.4 for yourself and decide for yourself. Annoyingly there isn't really a simple Y/n type answer. It depends what you need it for, what functionality you want and all that sort of thing. Is a spoon better than a fork? That type of thing. It's a bit like watching tennis or going to a pantomime at the moment! (Oh yes it is, Oh no it isn't) In both previous branches the .4 was when the branch suddenly settled down a LOT and became a LOT more stable. Unfortunately we wont know for certain until tons of people have been using it for a while. We can't read the future! Tons of people have been using the 3.4.6 for quite a few weeks with very few grumbles reaching this list. I guess each sub-point release is kinda like half a Service Pack. So, 3.5.4 is like saying 3.5 with SP2. Of course LO fans would say that each sub-point release is like a whole Service Pack so it's like 3.5 SP4 but in terms of comparing with other projects where SP2 is about where the project becomes stable i would say that it's the .4 in LO. But we haven't really quantified this objectively yet. It just seems to be the way it's playing out so far. Base still doesn't seem to have many people working on it. TDF's BoD seem to have too many other issues to worry about and still haven't grabbed the steering-wheel and taken charge. They are still unwilling to put any resources or imagination into sorting it out. At the moment their plan for it is to sitwait to see if one of our supporter companies (Redhat, Google, Canonical etc) magically becomes interested and starts sorting it. Regards from Tom :) --- On Mon, 4/6/12, Pertti Rönnbergp...@elisanet.fi wrote: From: Pertti Rönnbergp...@elisanet.fi Subject: Re: [libreoffice-users] Re: Is 3.5.4 ready for business users? To: users@global.libreoffice.org Date: Monday, 4 June, 2012, 15:25 Dear you LibO folks, I have now wasted a lot of time reading some 30 mails in this thread - it was of no use because most of them did not handle neither give an answer to the original very relevant question: Is 3.5.4 ready for business users? So, what is the conclusion - if there is any? Is 3.5.4. ready for business use, or not -- if not, what version is then in every way at least as or more reliable as e.g. MSOffice MSAccess? the MSO's license fees are peanuts compared with lost efficiency (and costs) if a company's office personnel must struggle with LibO's bugs and issues many hours many days per week per month -- and the company has to employ or buy some extra it-resources for that (and fixing new problems coming with new versions every 'second day') no company can afford bad quality or inflexibility in communication with customers caused by a not-working office program (LibO?) MSO is no doubt the 90% market leader and is most certainly used by any company's most important customers/contacts -- and the rest 10% will follow the majority every time they have to Three weeks ago in another thread I put an similar question asking what is the best LibO version today for a private/home user -- a home user does not have it-experts or own skills in programming to rely on but has the same need of a troublefree program. Thanks to Tom and Andreas for their kindness to answer; but neither of them gave me an exact recommendation: that version is what you need! Perhaps that 'business ready version' of LibO could be the one for me too
[libreoffice-users] What versions of LibO and Java-JRE to install today?
Dear you LibO folks, Some days ago as a branch of the thread Base and Java 1.7 - does not work I asked for your advice/recommendation on what versions of LibreO and JRE I shall /_install today_/ when I quite far from home and my laptop as the only computer, at my countryside cottage want to work with Writer, Calc and especially Base without any disturbing bugs and other issues. I think my question is relevant and of interest to others too. All along this winter and springtime this mailing list has handled problems about LibO v.3.5.x not working, LibO-3.5.x crashing, Base not working, with or without Java JRE, connections to db not working, etc. After about 5 months struggling with LibO (-Base) I am sort of fed up -- as a preparation before summer I finally need to decide if continue with LibO, or return to OpenO or skip both of those and look for something else as a reliable working tool, e.g. purchase MSOfficeMSAccess. I've got some kind varying explanations but no exact answers plus that I know that it is not quite true that a 32-bit program (e.g. WinXP progs) runs always OK on a Win7/64-bit. You LibO experts may know about LibO's compatibility features and build-ups and it's more or less hidden wonderful properties (e.g. /_telling now_/ that it is 32-bit and runs on Win7-64bit) but try to remember that out here are many 'dummies' like me that do not - not until we are told. So I repeat my questions: What version of LibreO do you recommend that I shall install on my laptop (Win7-Premium Home-64bit) before summer a what is the best, most reliable and stable version today (esp. concerning Base, no bugs, no other issues) b does that LibO-version require a Java JRE to run Base? -- what JRE-version (surely OK on Win7/64bit)? c what kind of issues do I have to be prepared for with LibO in general, and because of LibO being 32-bits and my laptop Win7/64-bits? d does that recommended LibO (on laptop) communicate without problems with my PC (Win-Prof/32 bit LibO-3.4.6)? Best regards Pertti Rönnberg -- 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
Re: [libreoffice-users] Re: Base and Java 1.7 - does not work
Dear LibreO folks out there, In two of his mails Andreas Säger says In any case it -- (Java 1.7) -- has to be 32 bit because under Windows the office (LibreOffice) is a 32 bit application. The 32/64 Java bits have to match with the LibreOffice bits which means 32 bit on all Windows platforms. At least in Finland since a year back almost all PCs and laptops are Windows7-64bit; I purchased a laptop Win7Premium-64bit last November. It is a little astonishing and worrying to read that LibreO is a 32-bit application under any Windows-OS but I have seen no info about LibreO being only 32-bits - not 64 bits nor 32/64 bits. I have been told that a 64-bit machine needs 64-bits software. In the coming summer at my cottage in the wilderness of deep forest, far from civilization, I should very much like to work with Writer, Calc and Base (continue trying to complete and create databases) without any problems at all. What version of LibreO do you recommend that I install on my laptop (Win7-Premium Home-64bit) what is the best, most reliable and stable version today (esp. Base, no bugs, no other issues) do I have to install a Java JRE to run Base? -- what version? because of the db's future use I prefer to work with the embedded HSQL, and hesitate learning the use of HSQL2.x or SQLite what kind of issues do I have to be prepared for because of LibreO being 32-bits and my laptop 64-bits? Do the LibOs on my machines communicate with each other without problems when my PC's OS is Win-Prof/32 bit and it's LibreO v.3.4.6? Best regards Pertti Rönnberg On 17.5.2012 14:57, Andreas Säger wrote: Am 17.05.2012 02:32, NoOp wrote: Perhaps if you would include some quotation from the post others could understand what you are replying to. I see nothing in the OP that indicates 'steelej' was using a 64 bit version. You are right. Java 1.7 works well with LibO 3.5. I tested with external and embedded HyperSQL on Win7(32) and Linux(32). My H2 database works as well. Older office versions do not even recognize Java 1.7 as a valid Java installation. So the Java version is not a problem anymore as far it is a fairly recent one. _For the casual reader_: The 32/64 Java bits have to match with the LibreOffice bits which means 32 bit on all Windows platforms. -- 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
Re: [libreoffice-users] Combining data rows on one sheet
Kelly, If I understand your question correct you have one workbook/spreadsheet where you have several sheets of data you want to collect specific data from some or all of these sheets to one separate sheet I use to do that using a remote reference -- you can use that feature as well inside one worksheet as between two different sheets; and I have a faint idea that you can 'remote reference' between sheets in two different workbooks too. With the 'remote reference' I mean using (e.g.) the value 123 from cell C7 also in cell F9; then write =C7 in cell F9. And if you need an absolute reference write =$C$7 in cell F9. I use that feature in a Calc-workbook (database) in my hopeless try to keep my family's (wife daughter) economy in order: a workbook with 13 sheets: 12 months named Jan, Feb, ..Dec, and the last 'Sum2012' all worksheets Jan-Dec are equal: colA with row headings and cols B, C,.. for values/data as needed Let us say that I want to sum the values from cell B11 in each sheet (Jan!B11, Feb!B11, ..) to the cell F11 in the last sheet Sum2012: in cell F11 in Sum2012 I write = then go to and click cell B11 in Jan, click sign +, click cell B11 in Feb, click +, click cell B11 in (...etc) and finally after Dec click OK (Enter). And there you are: all values in cells B11 from sheets Jan-Dec are summarized to F11 in sheet Sum2012 If you only want to 'clone' the values from one row (range) A2-D2 in Jan to range C5-F5 in Sum2012, then first 'remote ref' the cell A2 to C5 (as above: in cell C5 in Sum2012 write =, click A2 in Jan, click Enter) and then in Sum2012 drag-copy cell C5 over range C5-F5. If you want to 'clone' the values from a range (e.g. A2..D12 in Feb) to a range (B4-E14) in Dec, then first 'remote ref' the cell A2 (as above) to (e.g.) B4 in Dec then drag-copy the cell B4 over range B4-E4 then mark the row-range B4-E4 and drag-copy it downwards to E14 The absolute reference ($-signs) can be used here too. I hope I could describe the proceeding - and that it is to help. Best regards Pertti Rönnberg 8.5.2012 8:01, Kelly Holman wrote: I need to take data rows from a bunch of sheets, and combine them all on one sheet at the end, so I can do calculations/analysis of all the data. Every way I've tried, doesn't work. I can't make a named range that goes across multiple sheets, to use for a database or a Pivot Table. I can use Consolidate, but it doesn't seem able to update dynamically. Also it includes all the columns in between the ones I'm interested in, and adds them up even though it doesn't make sense for those columns. Is there some way to do this, without programming? -- 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
Re: [libreoffice-users] Combining data rows on one sheet
Kelly, Most certainly you see the flexibility of that use of the 'remote ref': you can have what ever calculations, analyzes and data on different sheets and then collect these values to a dynamic report or for further manipulations. Pertti On 8.5.2012 15:51, Pertti Rönnberg wrote: Kelly, If I understand your question correct you have one workbook/spreadsheet where you have several sheets of data you want to collect specific data from some or all of these sheets to one separate sheet I use to do that using a remote reference -- you can use that feature as well inside one worksheet as between two different sheets; and I have a faint idea that you can 'remote reference' between sheets in two different workbooks too. With the 'remote reference' I mean using (e.g.) the value 123 from cell C7 also in cell F9; then write =C7 in cell F9. And if you need an absolute reference write =$C$7 in cell F9. I use that feature in a Calc-workbook (database) in my hopeless try to keep my family's (wife daughter) economy in order: a workbook with 13 sheets: 12 months named Jan, Feb, ..Dec, and the last 'Sum2012' all worksheets Jan-Dec are equal: colA with row headings and cols B, C,.. for values/data as needed Let us say that I want to sum the values from cell B11 in each sheet (Jan!B11, Feb!B11, ..) to the cell F11 in the last sheet Sum2012: in cell F11 in Sum2012 I write = then go to and click cell B11 in Jan, click sign +, click cell B11 in Feb, click +, click cell B11 in (...etc) and finally after Dec click OK (Enter). And there you are: all values in cells B11 from sheets Jan-Dec are summarized to F11 in sheet Sum2012 If you only want to 'clone' the values from one row (range) A2-D2 in Jan to range C5-F5 in Sum2012, then first 'remote ref' the cell A2 to C5 (as above: in cell C5 in Sum2012 write =, click A2 in Jan, click Enter) and then in Sum2012 drag-copy cell C5 over range C5-F5. If you want to 'clone' the values from a range (e.g. A2..D12 in Feb) to a range (B4-E14) in Dec, then first 'remote ref' the cell A2 (as above) to (e.g.) B4 in Dec then drag-copy the cell B4 over range B4-E4 then mark the row-range B4-E4 and drag-copy it downwards to E14 The absolute reference ($-signs) can be used here too. I hope I could describe the proceeding - and that it is to help. Best regards Pertti Rönnberg 8.5.2012 8:01, Kelly Holman wrote: I need to take data rows from a bunch of sheets, and combine them all on one sheet at the end, so I can do calculations/analysis of all the data. Every way I've tried, doesn't work. I can't make a named range that goes across multiple sheets, to use for a database or a Pivot Table. I can use Consolidate, but it doesn't seem able to update dynamically. Also it includes all the columns in between the ones I'm interested in, and adds them up even though it doesn't make sense for those columns. Is there some way to do this, without programming? -- 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
Re: [libreoffice-users] Workarounds for multiple problems with the legacy Report Designer-Wizard under LO 3.5
Fred, I also want to thank you for an adequate discussion - more of that kind on this mailing list is needed! Let us only hope it will lead to something in practice -- but I am afraid not. May I take part from a slightly another point of view. My system is Windows7/LibO3.4.6 and I do not know anything about LibO3.5.x versions (too much bugs and other problems!) If someone has managed to get LibO-Base work well enough to get a database created and is now ready for creating reports, then he/she is better not to use any (report) wizard, but use a Report Builder (RB) in stead; if RB is not available for LibO yet (if not - why not? sufficient documentation?) then there is an add-on for OpenO-Base -- somebody mentioned that LibO and OpenO are identical. The RB is as easy (if not easier) and straight forward to use and you are free to decide about the report's layout as you want - with the wizard you are (almost) bound to the it's limitations. With the RB you can do everything - and more - as with the wizard, why the wizard is more or less a burden. In my experience the RB worked well but, despite promises in introduction, with the exception of Page/Report Header and Page/Report Footer. These are not only cosmetic matters but very much needed e.g. when a long report covers several pages. you may want the Report Header (report name, date, etc.) plus the Page Header (e.g. column headings) on the first page, but only the Page Header with the column headings repeated on every next pages - no Report Headers are wanted there at the end of every page, in the Page Footer, you may want to count or/and sum some fields per page and finally summarize them at the end of the report, in the Report Footer. (Nor did the 'horisontal-line' button draw any visible lines) As far as I know are these not possible now -- when will these be fixed? In my opinion also the Form Wizard is of no use - it should be skipped. Much better is to create the form manually using Form Design View, provided that both the program/development and the documentation are recreated to a sufficient level of functionality and quality. At least that helps the user to understand what he/she is doing. in LibO there are no easy to reach and sufficient documentation on how to create a form (and a subform) manually using Form Design View in LibO (with embedded HSQL) you are bound to create a form based on a table only (= each form on one table!) - you can not create a form on a query! These errors must be immediately corrected to increase the usability and flexibility of LibO. Best regards Pertti Rönnberg On 6.5.2012 23:01, Tom Davies wrote: Hi :) Nice work Fred! Have you considered joining either the docs team (to help Dan write the guide for Base or develop the Faq further) or the devs team to do some Easy Hacks and then come back to Base? The docs team could really use the help! Regards from Tom :) --- On Sat, 5/5/12, frofafro...@yahoo.com.au wrote: From: frofafro...@yahoo.com.au Subject: [libreoffice-users] Workarounds for multiple problems with the legacy Report Designer-Wizard under LO 3.5 To: users@global.libreoffice.org Date: Saturday, 5 May, 2012, 8:07 After doing a bit more investigation recently, this is a summary of what I've found (so far) regarding the multiple problems with the legacy Report Designer-Wizard (RDW) under LO 3.5. For convenience and succinctness, I thought it might be worth SUMMARIZING the situation in this new message. It seems there are (at least) 3 different problems/bugs with the RDW under LO 3.5. SUMMARY OF PROBLEMS WITH THE REPORT-DESIGNER-WIZARD (UNDER LO 3.5) 1. All reports of course need to be based on an SQL query (whether pre-existing, or generated 'on-the-fly' by the RDW) 2. When building a Report using the LRD, there are 2 situations (specified in the first step of the RDW): a. Select a TABLE from your database b. Select a (pre-existing) QUERY from your database (referencing the TABLE above) 3. In the first case (2a above), using LO 3.5, the wizard DOES generate the appropriate query (with the fields and sorting the user has selected), and stores it in the hidden COMMAND control field. But NOTE, there is still a PROBLEM in the case where the Report needs to have GROUP HEADERS (i.e. GROUPED on one of the database fields). In this case, the auto-generated QUERY is incomplete, and the GROUP BY term is omitted. This can be fixed by simply editing the QUERY in the COMMAND control field and adding the GROUP BY term. This is effectively another BUG, in my opinion (the 'Repeated Headings Bug'). e.g. see here: http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3835807 4. In the second case (2b above), the wizard either does NOT generate the query (or does NOT copy it into the COMMAND control field) - leaving it BLANK. So it has to be entered 'manually'. This is the 'Blank COMMAND field' bug mentioned elsewhere. https
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 20.4.2012 11:00, MiguelAngel wrote: One for you. Much users even don't read the program's help. A light read over all the help, shows very well what the program can do and how, many samples there, and also can solve the majority of the cuestions on daily use. To drive a car is needed a license, in other words known the rules. Nobody was born learned. Miguel Ángel. Miguel, May I correct you, you do not need a license for driving a car! When my son was 10 he had no license but I let him test driving my car! But if you do not know the features of it, e.g. how to handle the gears, then you may study the Instruction Book, the User's Manual or whatever it is called. Just to avoid misunderstanding: I am talking about LibreOffice and it's LibreOffice Help -- not OpenOffice's. When I was new to LibO(-Base) I spent hours on trying to learn the logic of LibreOffice Help. Try your self: Let us say that you need to create a form (Base) in Design View based on a query , because you need fields from two tables in one of which you have a 'birthday' field that you want to be calculated as 'age' and want that age field visible on the form. You know how to do in MSAccess but not in LibO-Base. Start by pushing the LibreOffice Help button (lifebuoy) Good luck! Pertti Rönnberg -- 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
Re: [libreoffice-users] Re: Problems importing an OO database into LO
support Øthe reports is a important part of the data output; there is no Report Builder explicit for LibO-Base or one that works properly Øthese problems all together are too difficult and time wasting for a new user why he begins to look for easier ways to solve his need of a database, other than LibO-Base Øthe BoD is not interested in investing in that part of users The Advanced-LibO-Base will fail because: Øthe Base module as a program is half done (as above) -- can be used only of that minority of users who have the skill to do their own programming to get around problems and failures Øwho have the skill to use real externaldatabases (e.g. SQL) Øthe connection LibO-Base óexternal db does not work (if not recently fixed) Øthe BoD is not interested in investing in Base In not so very far future -- if a total destruction is excluded - our whole world will be computerized, which means that every household must have a computer and at least the most necessary programs for communication (writing, mailing, internet) and calculating and perhaps databases. Most of these private households have to or will prefer to use freeware programs instead of commercials provided that the use is easy, free of any problems and does not require special skills. The fact that MS is a 95% market leader has to be accepted; MS dictates the standards and it's products work well enough. The only real possibility for anyone to compete MSO is a free (low cost) and perfectly functioning product that gets a total acceptance by the children in these grass level households. The application that these children get used to at home and in school will cause the real press on commercial programs also in business. Considering a possible common aim to compete the commercials, it is a waste of valuable resources when open source developersoverlap or compete each others . Cooperate globally? LibO can only hope that the BoD will review its strategy planning or change the members. Best regards Pertti Rönnberg -- 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
Re: [libreoffice-users] (Win7/LibO-Calc) Bug in tool Multiple operations? Issue SOLVED!
Regina, Thank you for your kind interest and for your help: your questions forced me to study my problem once again. Obviously I am getting old -- I had done some bad thinking and caused circular references. To other readers I want to recommend that tool Multiple operations in LibO-Calc/Data. I have a feeling that people does not know about it, as you said, it is sort of hidden and forgotten. This is a shame because it really is very handy for simulating or studying changes by using 1-2 variables. E.g. estimating how the monthly payments of a loan changes with rate and loan length (time) as variables. It is easy and rather straight forward to use after a little training. Best regards Pertti Rönnberg To others On 16.4.2012 23:35, Regina Henschel wrote: Hi Pertti, Pertti Rönnberg schrieb: Hello, LibO folks, In LibO-Calc there is a very interesting and useful tool Data/Multiple operations -- at least as useful as Pivot Table. Yes, it is hidden and cannot be written with the function wizard. But it is possible to write the function manually, you do not need Data Multiple.Operations. When I recently updated an old calculation process created some 3-4 years ago in OpenO and recreated it in LibO-3.4.5, I noticed that one of the tool's flexible features had vanished. In the 'new' Calc the first cells of both row input cell E5 (of E5, F5, G5,..etc.) and column input cell D6 (of D6, D7, D8, ..etc.) require a manually inserted absolute value -- the next values (increasing or decreasing by a difference) can be formulas calculating from the value before. Please provide a small reduced spreadsheet document. It should contain nothing more than those things needed to trigger the error. Please post the content of a cell with the generated Multiple.Operations formula and please post the content of the formula cell, which will be the first parameter in the Multiple.Operations. In the old calculation these first cells (E5 and D6) could refer to formulas ina remote cells which increases the flexibility and the usability of the tool remarkably. What is a remote cell. Do you try to use a cell from a different spreadsheet document? I have not found a regression. But I have difficulties to understand your explanation and therefore might miss something. Kind regards Regina -- 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
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 17.4.2012 12:34, ptoye wrote: Andreas Säger wrote Why can't you run SQL update queries? This is trivial to do in SQL. The SQL is trivial to execute by macro. If you desparately want a graphical query designer for update/insert/delete queries, then you should write one and store your queries somewhere in the .odb container. Of course I can. If I can find out how to do it. But this isn't the point, is it? The real point is that database front-ends and macro languages are meant to make life easy, not difficult. You seem to dislike sugar - worried about your diameter? The computer was made for man, not man for the computer. Why not program in assembler - gives you much more control and isn't really that hard (I speak from years of assembler experience and with my tongue firmly in my cheek)? - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.html Sent from the Users mailing list archive at Nabble.com. Well said Peter! I totally and completely agree with you and Ian Whitfield. And thanks to Ian for the tips about Kexi – I am almost ready for anything but LibO-Base. Since the beginning of this year I have been trying to create a similar member register about a boy scout organization’s senior leaders also collecting memorable info from gone days – before these leaders are gone. The most I got from the efforts is waste of time and frustration. A week ago Dan Lewis kindly sent to me drafts on documentation about creating a Base-db. It is very well written, clear, logic, easy to follow – but it is a draft, written in 2010 for OpenO. As far as I could see, there are nothing similar for LibO-Base yet. Regarding LibO-Base’s situation today, very much should be helped if that Dan’s documentation should be completed and finished and included in the LibO’s (Base) introduction. (When following Dan’s documentation I also noticed that in LibO-Base you can create a form /_based on a query_/ only using the Form Wizard – Design View allows you to create a form /_only based on a table = one table!_/) To the LibO-folks and developers I repeat: Stop developing LibO-Base;go back to the latest stable version and start to complete it and repair all discrepancies in the program and between the program and it’s documentation! There is so much good done in LibO-Base so why not get the rest OK? So it at least should meet the promises in advertising.! Without problems! And: What (in @!?*@!??) can be the clever idea with having in LibO-base a embedded HSQL v.1.8 that is not supported any more when the latest version is 2.2.x? What about e.g. SQLite? As Peter said:thus making the life easier -- and if not easier but not more difficult! Regards Pertti Rönnberg -- 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
Re: [libreoffice-users] [BASE] New to Base - Program stops
Preston, I experienced exactly the same when I in early January this year installed LibreO3.4.5 that at that moment was said to be the latest stable version. Yesterday I upgraded to LO-3.4.6 because there, according to this mailing list, seem to be too much problems with LO-3.5.x versions. Without knowing what-why and without any clear instructions from LibO documentation, I spent about a week on experimenting and finally managed to get LibO to work without the Base-module crashing the hole LibO. My solution was in short: 1 I uninstalled previous LibO-installation (also files from AppsData/Roaming, ProgramFiles/Users) 2 downloaded and installed from Java's homepage a JRE-file named Ixpiinstall.exe 3 finally I installed LibO (note! install JRE before LibO) Voilá - no crashes after that. There are several versions of JRE and you have to consider whether your system is a 32-bit or 64-bit Windows. I tried (almost?) all I could find and the above mentioned was the one that worked with my Win7/prof-32bit (I have OpenO3.2 on my Vista32bit-laptop) There may today be other JRE versions better suited for your LibO (and my too) - I do not know. Perhaps the LibO experts can give you that advice. Would it not be convenient for every new LibO-user if that basic info was said (or had a link to) clearly on LibO's main home page? Yes, there is a 'intallation instruction' but I have not found any instructions about JRE: needed or not needed, how and when to install and what version is recommended and where that version can be found - if needed. As a nice short step-by step instruction. That to be compared with OpenO that rather clearly says that In OpenO the JRE is already included. Best regards Pertti Rönnberg On 11.4.2012 22:48, Preston Smith wrote: Hi, I am trying to learn Base in LO 3.5.2.2 under Vista with all latest updates I start Base - then I follow the steps shown at http://sheepdogguides.com/fdb/fdb1tableone.htm The Base wizard starts; I click 'Create a new database' then 'Next' I say Yes, please register database for me, Open for editing and Create tables using the table wizardthen click the Finish button. I get a Save as dialogue and select /Data Base Projects/FDB004 Phone Book/FDB004.odb And I get the Windows window that says LibreOffice 3.5 has stopped working I tried this process 3 times and each time I get the same message Help!! Thanks, Preston -- 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] (Win7/LibO-Calc) Bug in tool Multiple operations?
Hello, LibO folks, In LibO-Calc there is a very interesting and useful tool Data/Multiple operations -- at least as useful as Pivot Table. When I recently updated an old calculation process created some 3-4 years ago in OpenO and recreated it in LibO-3.4.5, I noticed that one of the tool's flexible features had vanished. In the 'new' Calc the first cells of both row input cell E5 (of E5, F5, G5,..etc.) and column input cell D6 (of D6, D7, D8, ..etc.) require a manually inserted absolute value -- the next values (increasing or decreasing by a difference) can be formulas calculating from the value before. In the old calculation these first cells (E5 and D6) could refer to formulas ina remote cells which increases the flexibility and the usability of the tool remarkably. I cannot think that that negative change has been done deliberately in LibO-Calc -- normally every cell in a spreadsheet can refer to and can be referred to from remote cells no matter if these cells have a formula or not. Is it a bug or what is the explanation? Can I correct this in any way? My PC is a Win7Prof/32bit. Thanks in advance regards Pertti Rönnberg -- 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
Re: [libreoffice-users] Report Bulder in 3.5
Hello, Try to 'google' for OpenOffice Report Builder. May be there are info about if it works with LibO in Ubuntu. regards Pertti Rönnberg On 12.4.2012 19:49, Tom Davies wrote: Hi :) Is it somewhere here http://extensions.libreoffice.org/ ? I'm not sure and haven't looked, sorry! Regards from Tom :) --- On Wed, 11/4/12, capemayalcapema...@gmail.com wrote: From: capemayalcapema...@gmail.com Subject: [libreoffice-users] Report Bulder in 3.5 To: users@global.libreoffice.org Date: Wednesday, 11 April, 2012, 14:10 Does anyone know where to obtain the extension? Thanks, Al Ubuntu 12.04 -- View this message in context: http://nabble.documentfoundation.org/Report-Bulder-in-3-5-tp3902510p3902510.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
Re: [libreoffice-users] Re: Installing MySQL Connector
On 11.4.2012 6:48, Dan Lewis wrote: On Tue, 2012-04-10 at 20:32 +0300, Pertti Rönnberg wrote: On 1.4.2012 20:27, Alexander Thurgood wrote: Le 08/02/12 20:02, Pertti Rönnberg a écrit : Hi Pertti, What exactly is the issue you have had with using the MySQL JDBC connector on Windows ? Documentation : Prerequisites : a JDK or JRE, access to a running mysql server instance, either locally or via the network (beware that internet connections to externally hosted mysql servers can be very slow, or access can be refused to them by hosting service companies for various security reasons). The user attempting to connect to the mysql server instance must have the rights to do so, and also any rights to create, modify ro change tables, table structures, etc, according to what is desired for that user. These must be configured in advance within the mysql server. A database schema (database name) must be created in advance of any attempt to connect via LO and the JDBC connector. A useful tool for this is phpmyadmin. This is included in XAMP for example, which contains a complete apache web server, mysql and php stack, obtainable here : http://www.apachefriends.org/fr/xampp-windows.html via JDBC: (These steps are only valid for the MySQL connector) Get the newest JDBC driver from http://www.mysql.com/downloads/connector/j/ Start LibreOffice Goto Tools Options Java Press the browse button near Classpath and browse for the *.jar file(s) of your driver. The jar file is part of the zip file that you download from the mysql website. Look for the file called mysql-connector-java-5.1.18.jar Restart LibreOffice Open the data source administration dialog (Tools/Data Sources...) or start the database wizard. Press the button New Data Source, in the name field, enter a valid name like MySQL JDBC, and keep JDBC as type. Enter the data source URL mysql://host:3306/Nameofyourdatabase Switch to the tab page JDBC. Now you have to enter the driver class name. For the MySQL connector driver you have to insert: com.mysql.jdbc.Driver. You can test that the driver is loaded correctly by pressing the corresponding button. If the driver doesn't load, then there is either something wrong with your driver setup or your Java installation. Enter the name of the user you wish to connect, and mark the checkbox if this user needs a password. To be sure that your settings will be saved, press the Apply button. You can also test the connection by clicking on the appropriate button. If the connection fails, you will get an error message. If it succeeds, you will get a message telling you so. Save your ODB document with an appropriate name. Once saved, click on the Tables icon in the main Base window, the tables of your mysql database should appear (if you have defined any in advance). Alex Hello Alex ( LibO folks), Thank you for asking and also for your kind instructions - and I am sorry for my late reply. No, there are no specific issues, I just reacted to the discussions about connecting problems -- and a lot of other too, especially in version LibO3.5.x. The reason to my reaction is that I appreciate very much the idea of having a free office suite like LibO and OpenO but I am worried about the strategy of LibO's distribution. In my vocabulary LibO-Base with it's embedded HSQLDB is a database program, a package like MSAccess with it's JET-engine. My knowledge of databases is limited to some 30 apps in MSAccess (VBA macros, forms/subforms, reports, etc, but not SQL more than absolutely needed) almost 15 years ago, some of them quite demanding. So, not interested in buying a new MSAccess for my need of 2-4 quite simple databases ( like an address book plus some date calculations, subforms, reports) nor to learn HTML/PHP languages or SQL, I read the introduction and installed LibO3.4.5 (on PC:Win7Prof/32B; on laptop: Win7Prem/64B) in early January this year. Believing that LibO-Base should be sufficient for my need. I am sure LibO is a powerful package but I have not been able to find this out; I have never experienced a program causing that much problems from the very beginning I had problems first with the installing (no clear info about JRE) then with date calculations that did not work (the embedded HSQL is obviously an old not supported version), then wasting a lot of time and nerves trying to get Report Builder and creating Forms and Subforms in DesignView work as promised in instructions -- they don't! LibO's Help (lifebuoy) opens to a lot of pages telling what different kind of help you can get, but it has not a single link to real immediate help. As an user I shall not be dependent of an ever so fine community's answers, I want to have the help immediately (see MSAccess, OpenO, etc). The LibO documentation and getting started - Base seem to be available only for those who know about them or who know where to look -- not for them who are new to the program. The only help of some
Re: [libreoffice-users] Ubuntu 12.04 LTS [final beta] includes LO 3.5.1.2
May I ask for advice, I have an old spare laptop (HP/Compaq NX9005) and thought of installing a Linux, e.g. Ubuntu on it. are there other Linux-distributions than Ubuntu to be considered as best for private/home use? if Ubuntu, what version do you recommend to start with? can I install Ubuntu without a LibO -- and install LibO separately ? Or OpenO? what LibO version is today best in the Linux/Ubuntu world? Thanks in advance Pertti Rönnberg On 11.4.2012 12:00, Tom Davies wrote: Hi :) I generally get details like that from DistroWatch http://distrowatch.com/table.php?distribution=ubuntu Details about each and every package included in a distro is beyond the scope of a decent press release announcing the new release. Also why would TDF keep a record of what each distro uses? DistroWatch are pretty awesome at what they do and are quick to make changes if you ever find a mistake although that's unlikely. People that attempt to duplicate their work rather than support it tend to end up covering maybe 20 distros at most and fairly badly and out-dated. If anything it would be nice for TDF to give DW a regular donation, however small. Just my tuppence worth Regards from Tom :) --- On Tue, 10/4/12, webmaster-Kracked_P_Pwebmas...@krackedpress.com wrote: From: webmaster-Kracked_P_Pwebmas...@krackedpress.com Subject: [libreoffice-users] Ubuntu 12.04 LTS [final beta] includes LO 3.5.1.2 To: LibreO - Users Globalusers@global.libreoffice.org Date: Tuesday, 10 April, 2012, 3:15 I just installed Ubuntu's 12.04 LTS, in the final beta version, on my laptop that had 11.10. I looked at what LO it installed and it stated 3.5.1.2 - 350m1 [build 102]. I will be removing this version and use 3.4.6, but I had not seen any info about what Ubuntu 12.04 was going to have. Thought someone here might want to know. -- 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 -- 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
Re: [libreoffice-users] Ubuntu 12.04 LTS [final beta] includes LO 3.5.1.2
Tom, Thank you for bothering and a good answer. As many others have noticed, you are really a nice guy, good to deal with. Now I got some links where to check the options you mentioned. Most likely the HP's soul shall be sent to the cyber universe. (in my belief all machines seem to have a soul: it is not once that I threated my lawn-mower that if you not.. then it starts immediately; and the same is with my boat motors and other). Regards Pertti Rönnberg On 11.4.2012 14:48, Tom Davies wrote: Hi :) Ok, it's only got 512Mb of Ram so choosing the heaviest distro in the world (Ubuntu) is probably not the best choice. Perhaps ask in DistroWatch crazy little weekly Reader's Comments thread http://distrowatch.com/ (err and then navigate to their weekly 'magazine type of thing and view all comments so you can add you own at the bottom. They tend to get a bit crazy in there until they are given a problem of finding the 'best' distro for a particular machine and for what you want. Alternatively, or at the same time, ask somewhere in http://www.linuxquestions.org People get quite excited about all this sort of thing so you have to be clear about what you want to use the machine for, eg gaming platform, server, web-browsing and officey stuff, multimedia centre, whatever and don't worry about people being rude as they just can't help it and it can be funny to watch the steam coming out of their ears. I'm getting quite into the idea of trying Lubuntu which is very much lighter than Ubuntu (what isn't!?!) but there are tons of choices. Mageia is nice and was based on Mandriva which was one of the prettiest distros. I tend to download a few different distros and make a Live Usb (bootable usb-stick) or LiveCd/Dvd and then just try them out to see what works best and which i like the look of on a particular machine. A fun day playing around :) Most distros now include LibreOffice by default but you can always download and install the official TDF version from the LibreOffice website. Ubuntu is made to compete with the latest Windows on top-spec machines. It's not really made for old or low-spec ones even with all the effects turned right down it can be a bit heavy. Regards from Tom :) --- On Wed, 11/4/12, Pertti Rönnbergp...@elisanet.fi wrote: From: Pertti Rönnbergp...@elisanet.fi Subject: Re: [libreoffice-users] Ubuntu 12.04 LTS [final beta] includes LO 3.5.1.2 To: users@global.libreoffice.org Date: Wednesday, 11 April, 2012, 12:22 May I ask for advice, I have an old spare laptop (HP/Compaq NX9005) and thought of installing a Linux, e.g. Ubuntu on it. are there other Linux-distributions than Ubuntu to be considered as best for private/home use? if Ubuntu, what version do you recommend to start with? can I install Ubuntu without a LibO -- and install LibO separately ? Or OpenO? what LibO version is today best in the Linux/Ubuntu world? Thanks in advance Pertti Rönnberg -- 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
Re: [libreoffice-users] Re: Installing MySQL Connector
On 1.4.2012 20:27, Alexander Thurgood wrote: Le 08/02/12 20:02, Pertti Rönnberg a écrit : Hi Pertti, What exactly is the issue you have had with using the MySQL JDBC connector on Windows ? Documentation : Prerequisites : a JDK or JRE, access to a running mysql server instance, either locally or via the network (beware that internet connections to externally hosted mysql servers can be very slow, or access can be refused to them by hosting service companies for various security reasons). The user attempting to connect to the mysql server instance must have the rights to do so, and also any rights to create, modify ro change tables, table structures, etc, according to what is desired for that user. These must be configured in advance within the mysql server. A database schema (database name) must be created in advance of any attempt to connect via LO and the JDBC connector. A useful tool for this is phpmyadmin. This is included in XAMP for example, which contains a complete apache web server, mysql and php stack, obtainable here : http://www.apachefriends.org/fr/xampp-windows.html via JDBC: (These steps are only valid for the MySQL connector) Get the newest JDBC driver from http://www.mysql.com/downloads/connector/j/ Start LibreOffice Goto Tools Options Java Press the browse button near Classpath and browse for the *.jar file(s) of your driver. The jar file is part of the zip file that you download from the mysql website. Look for the file called mysql-connector-java-5.1.18.jar Restart LibreOffice Open the data source administration dialog (Tools/Data Sources...) or start the database wizard. Press the button New Data Source, in the name field, enter a valid name like MySQL JDBC, and keep JDBC as type. Enter the data source URL mysql://host:3306/Nameofyourdatabase Switch to the tab page JDBC. Now you have to enter the driver class name. For the MySQL connector driver you have to insert: com.mysql.jdbc.Driver. You can test that the driver is loaded correctly by pressing the corresponding button. If the driver doesn't load, then there is either something wrong with your driver setup or your Java installation. Enter the name of the user you wish to connect, and mark the checkbox if this user needs a password. To be sure that your settings will be saved, press the Apply button. You can also test the connection by clicking on the appropriate button. If the connection fails, you will get an error message. If it succeeds, you will get a message telling you so. Save your ODB document with an appropriate name. Once saved, click on the Tables icon in the main Base window, the tables of your mysql database should appear (if you have defined any in advance). Alex Hello Alex ( LibO folks), Thank you for asking and also for your kind instructions - and I am sorry for my late reply. No, there are no specific issues, I just reacted to the discussions about connecting problems -- and a lot of other too, especially in version LibO3.5.x. The reason to my reaction is that I appreciate very much the idea of having a free office suite like LibO and OpenO but I am worried about the strategy of LibO's distribution. In my vocabulary LibO-Base with it's embedded HSQLDB is a database program, a package like MSAccess with it's JET-engine. My knowledge of databases is limited to some 30 apps in MSAccess (VBA macros, forms/subforms, reports, etc, but not SQL more than absolutely needed) almost 15 years ago, some of them quite demanding. So, not interested in buying a new MSAccess for my need of 2-4 quite simple databases ( like an address book plus some date calculations, subforms, reports) nor to learn HTML/PHP languages or SQL, I read the introduction and installed LibO3.4.5 (on PC:Win7Prof/32B; on laptop: Win7Prem/64B) in early January this year. Believing that LibO-Base should be sufficient for my need. I am sure LibO is a powerful package but I have not been able to find this out; I have never experienced a program causing that much problems from the very beginning I had problems first with the installing (no clear info about JRE) then with date calculations that did not work (the embedded HSQL is obviously an old not supported version), then wasting a lot of time and nerves trying to get Report Builder and creating Forms and Subforms in DesignView work as promised in instructions -- they don't! LibO's Help (lifebuoy) opens to a lot of pages telling what different kind of help you can get, but it has not a single link to real immediate help. As an user I shall not be dependent of an ever so fine community's answers, I want to have the help immediately (see MSAccess, OpenO, etc). The LibO documentation and getting started - Base seem to be available only for those who know about them or who know where to look -- not for them who are new to the program. The only help of some quality is to be gotten in OpenO why I have had OpenO installed on a second
Re: [libreoffice-users]
Good evening Doug, I had MSOffice 2007 2007 2010 running on a PC and on a laptop for many years first together with OpenOffice and from beginning of this year with LibreOffice(v.3.4.5) without any problems using the text editors and spreadsheets. I don't know about PowerPoint. Perhaps I have been lucky. Best regards Pertti Rönnberg On 15.3.2012 7:55, Doug wrote: Hi my name is Doug. i was interested in downloading and running LibreOffice. I currently have ms office home and student 2010 installed. My question is can i run both programs on my computer at the same time with-out encountering any major problems. Many thanks in anticipation, Doug. -- 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
Re: [libreoffice-users] vba doesnt work after saving file on libre
Hello, That was interesting. Like Alexander below I also often used VBA in Excel and Access in my earlier days. Question: Is it possible to program with VBA (or VB) directly in LibreO3.4.5 Calc or/and Base? If 'yes' where can I find some guides? Regards Pertti Rönnberg On 11.3.2012 20:41, Tom Davies wrote: Hi :) It might be good to post a bug-report and go back to the 3.4.5 or an earlier version if that works http://wiki.documentfoundation.org/BugReport Ideally it would be great to test the 3.5.1 pre-release to see if the bug is there too http://www.libreoffice.org/download/pre-releases/ Hopefully it might get fixed faster if you can test it in a version before release as that is when people are focussing on that release most. You can have more than 1 version of LibreOffice installed if you follow this guide http://wiki.documentfoundation.org/Installing_in_parallel So you don't need to lose the version that does work in order to have a test-drive of a newer one that you might be uncertain of. Good luck and regards from Tom :) --- On Sun, 11/3/12, Александър Ценовpawnbroker1...@gmail.com wrote: From: Александър Ценовpawnbroker1...@gmail.com Subject: [libreoffice-users] vba doesnt work after saving file on libre To: users@global.libreoffice.org Date: Sunday, 11 March, 2012, 12:30 I use exel files with vba, under LibreOffice. After installing version 3.5, vba works at the begining, but when I save file(in MSoffice 2003 format) and close it and after that strart it again, my vba doesn't work. If I use OOo and version. 3.3 of Libre it works . What is the difference ? -- 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] This is how I got LibreO installed and working
Hi, all you out there in the crazy world, Many of you seem to have problems with installing LibreO. I experienced that too; first I had problems installing and after that problems with crashing every time I started LO-Base. I don't know what I did wrong or what I did right but now LO on my both computers (seems to!?) work OK. Below I describe what I guess were the main points of how I finally got LO working. 1 I had OpenO (OO) for many years on my both machines:PC-Win7Prof/32bit and Laptop-Win7Prem/64bit- in early January this year I decided to try LO 2 I choosed LO-3.4.5 that at the moment was mentioned to be the latest stable version 3 somewhere I had seen a note that if changing from OO to LO the former program must be completely removed before installing the new, because they use some same components (DLLs ?); meaning that every time I replaced OO=LO and then back LO=OO I first used ControlPanel/Uninstall and then manually removed remaining files from ProgramFiles and Users/user/AppsData/Roaming = reboot to secure changes 4 the Java/JRE is said to be a must for both OO and LO; JRE is already included in OO but not in LO (why not?). The JRE has to be installed on the computer BEFORE installing LO and there are different JRE versions for 32bits and 64bits systems. The laptop was immediately OK but the PC required many trials and errors before I found the JRE version jxpiinstall.exe on Java Home Page. That is how January went by - since then to now I have studied-tried-experimented-guessed-cried-damned to get an idea about LibreO-Base. It is hard days life to be a non-expert LO-user. Good luck - glad if that is to help! Pertti Rönnberg -- 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
Re: [libreoffice-users] Re: This is how I got LibreO installed and working
Andreas, thanks for the completing info - now I/we know better. Some years ago I was an Ubuntu-user but when I happened to buy a laptop which components didn't cooperate with Linux so I had to skip it. Now I have planned to install Ubuntu again so your info can be useful. Thank you also for your good advice concerning subforms (thread Subforms in LibreO). I looked at it preliminary and seems like I got the idea; I shall work on it at the weekend. Pertti Rönnberg On 9.3.2012 15:49, Andreas Säger wrote: Am 09.03.2012 13:40, Pertti Rönnberg wrote: 4 the Java/JRE is said to be a must for both OO and LO; This is a rumor. Both suites run fine without any Java. You can check it out when you disable the use of Java components in the Office options. It is rather unlikely that the avarage user will miss anything. _On a Linux system_ you can install as many OOo/LibO suites as you like. I never uninstall anything before upgrading. If any of the office suites shows unspecific weird behaviour it is always some broken setting or incompatible extension in the profile folder which is not affected by any installation routine. It is possible to run an office suite from extracted package files only without any installation routines. This way minor releases (3.4.x and 3.4.y) can be used on the same machine. -- 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
Re: [libreoffice-users] Re: Subforms in LibreO-Base
Andreas and Alex, Wonderful! Thank You! The weather forecast is not so good for the next weekend in Helsinki area (southern Finland) so now I have a good excuse to tell my wife why I must stay indoors. Otherwise she should take me out skiing (which in fact is nice too!). Kind regards Pertti Rönnberg On 7.3.2012 13:39, Alexander Thurgood wrote: Le 06/03/12 19:28, Pertti Rönnberg a écrit : Oh and this : http://listarchives.libreoffice.org/global/users/msg07304.html Alex -- 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
Re: [libreoffice-users] Re: Table Format
Hi Sylvain, I don´t think that you are missing anything - sometimes an expert forgets that what is obvious for him is not necessarily obvious for others. Provided that I got your problem try this: open your form in edit view = click empty area in the form (= set focus on form) find button 'Form' (on my PC screen it is the fourth button from up on a vertical toolbar to the left) that 'Form'-button opens the main form's properties click 'Data' tab = find 'Navigation bar' OK? Pertti Rönnberg On 6.3.2012 18:16, Sylvain Bromberber wrote: No data tab under properties of the form under Forms after I have opened in edit mode! The main Table has no properties options at all. Your instruction are absolutely clear. I don't see what I am missing. -Original Message- From: Andreas Säger Sent: Tuesday, March 06, 2012 10:24 AM To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Table Format Am 06.03.2012 16:00, Sylvain Bromberber wrote: That picture was very helpful! However I still can't do it. I cannot get that Form Navigation tool bar to show up, as in your picture, or that icon to be added to any toolbar. I click on Form Navigation for toolbars when in a form and the option is available, and it is checked but nothing like the toolbar on your picture appears, nor does that icon seem available anywhere. Puzzle! As already mentioned, the designer of the form can disable the toolbar. By default it is enabled. Open the form in edit mode, get the form properties and enable the navigation bar on the Data tab. In my forms the toolbar always refers to the main form since I set that property to Parent Form for all subforms of the main form. -- 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] Subforms in LibreO-Base
Andreas Säger, In your answer to Sylvain Bromberber (about Table format) you mentioned that you set /that property to Parent Form for all subforms of the main form/. Do you mean that you in LibreO-Base can have two or more subforms in one main form? I need to make a main form with a couple of parallell subforms in it (= both joined to the same field in main form). The Form Wizard lets you 'produce' a (main) form with /_only one_/ subform in it. Is it possible to implant a second (and perhaps a third) subform in that same main form? If so, how? I tried to do like I used to do in MSAccess but it did not work. In MSAccess you can have several parallell subforms (e.g. on separate tabs) and even a main form with a subform in a subform. (My LibreO is 3.4.5/embedded HSQL/Windows7, 32bit) Best Regards Pertti Rönnberg -- 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
Re: [libreoffice-users] Re: Table Format
Sylvain, So far so good. Sorry to say that I myself have only for some months been trying to learn LibreO-Base with all its more or less hidden and working/not working features. I am also curious to know which are the next steps in solving your problem. Best regards Pertti On 6.3.2012 20:25, Sylvain Bromberber wrote: Hi Pertti, All that worked as you described. I found 'Navigation bar'. It was already marked yes! But no visible navigation bar with the icon on your example! Picking Parent form instead of yes made no difference. What is going on? Let me say again how much I appreciate the time and thought you put in helping me. Sylvain -Original Message- From: Pertti Rönnberg Sent: Tuesday, March 06, 2012 12:12 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Table Format Hi Sylvain, I don´t think that you are missing anything - sometimes an expert forgets that what is obvious for him is not necessarily obvious for others. Provided that I got your problem try this: open your form in edit view = click empty area in the form (= set focus on form) find button 'Form' (on my PC screen it is the fourth button from up on a vertical toolbar to the left) that 'Form'-button opens the main form's properties click 'Data' tab = find 'Navigation bar' OK? Pertti Rönnberg On 6.3.2012 18:16, Sylvain Bromberber wrote: No data tab under properties of the form under Forms after I have opened in edit mode! The main Table has no properties options at all. Your instruction are absolutely clear. I don't see what I am missing. -Original Message- From: Andreas Säger Sent: Tuesday, March 06, 2012 10:24 AM To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Table Format Am 06.03.2012 16:00, Sylvain Bromberber wrote: That picture was very helpful! However I still can't do it. I cannot get that Form Navigation tool bar to show up, as in your picture, or that icon to be added to any toolbar. I click on Form Navigation for toolbars when in a form and the option is available, and it is checked but nothing like the toolbar on your picture appears, nor does that icon seem available anywhere. Puzzle! As already mentioned, the designer of the form can disable the toolbar. By default it is enabled. Open the form in edit mode, get the form properties and enable the navigation bar on the Data tab. In my forms the toolbar always refers to the main form since I set that property to Parent Form for all subforms of the main form. -- 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] LibreO-Base report layout problem
Dear you out there, I am working on a database (LibreO-Base 3.4.5, Win7Prof/32bit) that will result in a multipage-multicolumn report and have made the report using the Report Builder. My intention is to have the report's name and the column headings page number on the first page (= sections 'Report Header' 'Page Header' visible) and only column headings page number(s) on the next pages (= section 'Page Header' visible) According to the guides this a real feature and should be possible - like in MSAccess - by means of mixing with the sections 'Report Header/Footer', 'Page Header/Footer', 'Group Header/Footer' and the property options 'Force New Page' and 'visible/not visible'. There is one group name level above the 'detail' level data. I think I have tried all possible combinations and have got the pages 2..(n) OK but the first page still fails: if section 'Page Header' is put to 'not visible' there are no column headings at all nowhere if section 'Page Header' is 'visible' it is on every page - first page included - but placed above the report name if the column heading fields are put in the section 'Report Header' all the text in this section is visible on every page Please somebody, tell me how to do? Where can I find any instructions about the logic procedure in that mixing? A minor problem: There is a tool/button 'horizontal line' but the line drawn is not visible in preview! Regards Pertti Rönnberg -- 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
Re: [libreoffice-users] bug in creating forms
On 24.2.2012 16:06, Dries Feys wrote: see bug id https://bugs.freedesktop.org/show_bug.cgi?id=45891 Can anyone reproduce this issue and add his/her experiences to the above bug? It is quite ennoying to design this way :-( When you create a new XML Form, and put a text box on it, there is a grey line around it. When choosing control on either a rightclick menu, or the toolbarbutton, the session crashes, not allowing you to change any of the properties. This might be the same with other types as well. A workaround to remove the border is to create a Label field first, and replace it with a text box. Good afternoon Dries Feys, Provided that I got your problem correctly try this: A text box is a control you insert in different sheets LibreO-Writer, Calc, Base etc. right-click the text box control and click 'control' the drop down list shows the text box control's properties = find 'border' click the selection arrow (at right hand) and select the border property you desire: e.g. 'no border' OK? Pertti Rönnberg -- 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
Re: [libreoffice-users] Fw: LibreO-Base is lying about my age!
Dennis, Jorge and Drew - thanks!
The functions rounddown() and yearfrac() are both new to me; I shall
study and try them.
Drew,
I think that I have got my problem solved - I'm satisfied.
Not necessary, but of pure interest I should like to know what is wrong
either in the writing of Andreas' solution or elsewhere - when
copy-pasted into a db (LO-Base v.3.4.5) a pop-up window says first
column 'Select ..(etc)' is unknown and then syntax error.
The Andreas' version was (directly copy-pasted here):
SELECT Table.*,
DATEDIFF( 'mm', BirthDate, CURRENT_DATE ) / 12
- CASE WHEN MONTH(BirthDate)=MONTH(CURRENT_DATE) AND
DAY(BirthDate)DAY(CURRENT_DATE) THEN 1 ELSE 0 END AS Age
FROM Table
Regards
Pertti Rönnberg
On 18.2.2012 3:21, Dennis E. Hamilton wrote:
You should display =Now() to see what date format is being understood. If it
is dd/mm/, you haven't had your 73rd birthday yet, according to LO.
Also, dividing by 365 for such a long span is suspicious.
Assuming that you want actual calendar time and the same formulas used by Calc
work, try something like (using my birthday):
A3 =ROUNDDOWN(YEARFRAC(DATE(1939;1;25);NOW();1))
where DATE( ) is used to avoid formatting confusion and the YEARFRAC( )
actual-days basis is used to compute the fractional years from the first date
to the second.
This got my age (73) correctly in LibreOffice 3.3.2 Calc.
- Dennis
-Original Message-
From: jorge [mailto:jrodrigue...@cpcecr.com]
Sent: Friday, February 17, 2012 16:38
To: users@global.libreoffice.org
Cc: p...@elisanet.fi
Subject: Re: [libreoffice-users] Fw: LibreO-Base is lying about my age!
Hi:
I suggest to do this:
If
A1: 2/11/1939
B1: =Now()
Input in A3:
=ROUNDDOWN ((B1-A1)/365)
outcome: 72
Regards,
Jorge Rodríguez
___
El jue, 16-02-2012 a las 13:40 +0200, p...@elisanet.fi escribió:
--- Alkuperäinen viesti ---
Aihe: LibreO-Base is lying about my age!
Päiväys: 15.2.2012 17:46
Lähettäjä: Pertti Rönnberg [p...@elisanet.fi]
Kopio: Pertti Rönnberg [p...@elisanet.fi]
Dear all of you,
First an opinion - correct me if wrong!
I've got the idea that this is kind of a help-desk where every LibreO
user can both ask for help and give info about problems related to
LibreO's components. Without any bad feelings afterwards!
Referring to the irrelevant debates recently and also my own
experiences some weeks ago I would say that a real expert has the
ability to concentrate on the question as-it-is and give a relevant
answer -- he has knowledge enough to understand that there are no silly
or wrong questions.
Every question has its reason - and every question is valuable because
it indicates that there may be something to repair or do better in LibreO.
There is a truth in quality systems (e.g. ISO 9000): without
identifying the weaknesses there is no development.
_And now to my contribution to make LibreO better:_
I need to calculate in LO-Base the difference between an 'olddate' and
today expressed in whole years (no decimals)
The main procedure seems to be the same in LO-Base and OOo as in MSAccess.
The function I placed in the query field is (ref. also to guides in LO
OOo):
datediff('year',table1.olddate,current_date) or
datediff('year',olddate,current_date)
When I inserted my birthdate (2.11.1939) in 'olddate' my computer states
that I am 73 - I'm NOT, I'm still only 72!
The correct result is 72,225 years; and the desired answer without
decimals 72.
I got the same wrong result (73) both in LO-Base and in OOo-Base
the wrong result is not logical - it can not be a rounding up, nor
is it a result of an 'int()'-function
if I replaced 'year' with 'dd' or 'mm' or 'yy' the function works
-- but
when replaced 'year' with '' the function stopped working (why -
'year' and '' ought to be equal!)
the query field does not accept the expression int(datediff(..etc))
the date-format is equal (finnish - see above) in every relevant field
my OS is Windows7Professional/32Bit
I also tried the formula /year(current_date - olddate)/ but the query
did not accept it as a valid expression - can I put that formula
anywhere else?
Anyone there who can tell me how I shall get the LO-Base to be honest?
Regards
Pertti Rönnberg
--
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] LibreO-Base is lying about my age -- The End!
Andreas, Dan, Drew - and others
Thank you very much for your help and giving me your time.
I really admire you for your enthusiasm to helping others.
Even if I did not directly get all the answers, you forced me to
investigate - I have learned a lot!
The situation regarding the function DATEDIFF('year', ...) in
LibreO-Base/HSQLDB seems to be:
1. from SQL's point of view does LO-BHSQLDB calculate the
function quite correctly.
It is not a matter of mathematics - nor are there any int() or
roundings; it is a matter of (not so logical!) definition that you
simply have to be aware of.
DATEDIFF() does not calculate the difference between the given dates:
it calculates the difference between the datepart values that it has
extracted from the given datevalues using the selected datepart type
(year, yy, mm, dd, etc). From two dates 2.11.1939 and 17.2.2012
DIFFDATE('year',..) calculates with the 'year' values 1939 and 2012.
With datepart 'mm' it calculates first from each given datevalue the
total amount of months, extracts them, and then calcs the difference; to
get the result in years the function shall be divided by 12 (as Drew
said). Alternatively do DATEDIFF('dd',...)/365.
2.in most other SQL db-generators '' is a valid abbreviation
for 'year' but obviously not in HSQLDB (v.2.2) and thus not in
LibreO-Base either..
I think that this was not quite clear for all you neither.
I apologize for being a little irritated.
All the best
Pertti Rönnberg
--
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
Re: [libreoffice-users] Re: Fw: LibreO-Base is lying about my age!
Andreas - thank you for answering.
You certainly noticed that in my mail was two (main) issues:
1. I asked for help with a database problem when LibreO-Base's
basic function (DATEDIFF(''...)) calculates a wrong result;
I hope that you realize how important and severe that matter is both for
LibreO and for every user: if a user can't trust the calculations then
better not to use LibreO-Base.
2.I pointed out that there must be a fault in the the function's
programmed construction when the function requires the string 'year' in
stead of '' the latter form is the modeled in 'official' guides.
They ought to be interchangeable.
Without answering or commenting the two points above, you sent to me a
SQL command that - as to my experience - is bullshit
it did not work in my database so I started to test it
I made a simple database backwards from your SQL command: one
table table with tree fields (id, birthdate, age), inserted one
record, let the query wizard make the query and copy-pasted (note!) your
SQL command into the criterion field in column 'age' -- it did not work
neither did it work as an expression in an 'extra' field(column)
your SQL command had syntax errors both in the command build and
the characters used (e.g. ,', [])
As you may understand from my message I had myself already tried to
build up a SQL command similar to yours - but I was not good enough in SQL.
Question:
Does LibreO recognize expressions? if so, what is the syntax?
And then a little psychology
In an recent other thread was a discussion about how to get more people
to use databases - 'how to lower the barriers'. One point of view seemed
to be that ordinary non-professional users feel it too difficult to
design dbs and then also to use them. What do you think if considering
my writings above?
I really want to think that you are an expert on databases - show it!
Please, try again and give me an adequate answer on my first problem.
Without wasting any more of your time.
Pertti Rönnberg
_PS: ref to Tom's and Dan's kind answers today_
Mathematics is an international language with it's commonly fixed rules.
And the only relevant answer is that the calculations in LibreO-Base
(and Calc!) really follow the math's rules!
As I mentioned in my mail: the result is not logical. An INT() function
reduces 72,225 to 72(,oo...) and there is no excuse in the world to
round 7,225 to 73!
I am serious! I do use both Calc and Base in matters where the correct
calculation is important.
I would not want to accept LibreO (nor OOo?) as a kindergarten play!
pr
On 16.2.2012 14:16, Andreas Säger wrote:
SELECT Table.*,
DATEDIFF( 'mm', BirthDate, CURRENT_DATE ) / 12
- CASE WHEN MONTH(BirthDate)=MONTH(CURRENT_DATE) AND
DAY(BirthDate)DAY(CURRENT_DATE) THEN 1 ELSE 0 END AS Age
FROM Table
--
View this message in context:
http://nabble.documentfoundation.org/Fw-LibreO-Base-is-lying-about-my-age-tp3749948p3749995.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
Re: [libreoffice-users] Re: Fw: LibreO-Base is lying about my age!
Andreas, Thanks again for your answer - nothing to argue about because the matter is secondary. I had already read the HSQLDB v2.2 guid that you refer to. And as far as I can understand the '' ought to be as sufficient as 'year'. Here is a copy that confirms it: /Table 10.1. TO_CHAR, TO_DATE and TO_TIMESTAMP format elements 4-digit year * 4-digit year* YY 2 digit year/ Means that LO-Base shall definitely not stop working if '' is used -- which is also the normal format in most other calculating programs. And surely it has to do with LibreO(-Base) if it is a feature of HSQLDB that is embedded in LibreO -- I did load LibreO not HSQLDB. Go and take a look at your car. The car itself runs perfectly well without a steering wheel and the seats, but you as the user (driver) do need them; that is why they are installed (embedded) in the car. You did not focus on my main issue: /_how to get a correct calculation result._/ Now you are wasting not only your time but also mine. I remain waiting Best regards Pertti Rönnberg On 16.2.2012 23:10, Andreas Säger wrote: The problem has nothing to do with LibreOffice. It is a built-in function of the HSQL database engine. I am sure that it is designed to work like this. '' is not a valid argument for the datediff function. This is the home page of that software: http://hsqldb.org/ Version 2.2 is documented here: http://hsqldb.org/doc/guide/ Version 1.8 is the integrated database engine of LibreOffice. Its documentation seems to be gone by now. -- View this message in context: http://nabble.documentfoundation.org/Fw-LibreO-Base-is-lying-about-my-age-tp3749948p3751931.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
Re: [libreoffice-users] database or spreadsheet
Hello everybody – and especially Dan Lewis. I happened to read this thread about a database vs. spreadsheet. First of all I will thank Dan for him mentioning the “Getting Started Guide/Getting Started with Base/chapter 8! I cannot understand how I could have missed it when I for some time have been looking for info about Base (LibreO OOo). It is an excellent briefing into how to build up a database using Base. I think that you LibreO-guys should take a look at the layout where and how you introduce Base, how to get the “Getting started with Base” more visible – sort of nearer her/him who (like me) is looking for a really handy database tool. A week ago I asked your community “how get LibreO-Base working”. That is now OK (I found the JRE-file ”jxpiinstall.exe” and installed it before installing LO). Your Andreas then said that LO-Base is a front-end application, not a database. I’m not arguing but for an ordinary database consumer like me the front-end and the background database engine together mean one total database. After reading Dan’s “Chapter 8” I realized that LO-Base is The solution when a database of medium size/complexity is needed, either using the embedded HSQLDB or connecting to an external “real” database engine (e.g. MySQL or SQLite). Very much like MSAccess but free – no costs. After working some 10 years ago quite a lot with MSAccess I am a great fan of databases. Whenever I can I recommend to people not to limit to spreadsheets but build relational databases especially for their organizations but also at home. One of the great benefits compared with a spreadsheet is that you write input data only once thus minimizing both writing and writing errors - and then using the same data multiple times in different kind of reports. Another is that when a nspreadsheet is flat a (relational) database can handle data multi-dimensional which gives you the possibility to mix/combine data and get the most interesting analyzing results. All the best Pertti Rönnberg On 7.2.2012 14:24, e-letter wrote: On 06/02/2012, Dan Lewiselderdanle...@gmail.com wrote: Or maybe the failure is the refusal to understand the purpose for each part of a database. Tables and forms are for adding, modifying, and deleting data. Queries and reports are for data output. If you want to enter data, you use a table or form. If you want to manipulate data, you use queries. (With Report Builder, you can also manipulate data in a report.) Shouldn't we as users contribute to encouraging other users to always think: what is the most appropriate use for the job? How many questions posted are the result of making a mistake to use a spreadsheet when a database is more appropriate? I wonder how many people who use LO have read chapter 8 of the Getting Started Gude, Getting Started with Base? I know that I have very seldom seen a comment about its contents. (I wrote it and am presently updating it. I'm also working on the Base Guide in its entirety.) Somebody mentioned tutorials about open office base; very good information. Maybe the authors responsible for calc should add more conceptual advice about whether certain tasks are best performed in base, not calc. -- 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
Re: [libreoffice-users] Re: How get LibreO-Base working?
All of you. Thanks very much for your kindness to bother answering - and for the very interesting discussions. My conclusion is that LO-Base (and OO-Base ?) is not yet - and perhaps will not be as mentioned in the desciption at LO-Wikipedia: A database management program http://en.wikipedia.org/wiki/Database_management_program, similar to Microsoft Access .. etc http://en.wikipedia.org/wiki/Microsoft_Access. Its really pity because I think the usability of databases is underrated; quite ordinary people should have plenty of use of databases in their every day life if there only were free, easy installed, easy customized templates and some efforts on marketing. I just got a fancy idea that LO-/OO-Base could be that user-friendly solution. Anyway, I still feel it worth trying to see if there should be a way to get my 32bit LO-Base working! I agree. I am a 72 years oldtimer with a pure interest to keep up. When in office until about 10 years ago I worked quite a lot with MSAccess and VBA macros and got somewhat familiar with SQL too. MSAccess alone was enough for quite complicated projects with informative forms/reports and analyses. So now it is not the MySQL/SQLite, it is the PHP-language and getting the MySQL/PHP/Apache combination working that I feel uncomfortable - I also have tried WASP. Again - thanks and all the best! Pertti Rönnberg On 1.2.2012 9:43, Alex Thurgood wrote: Le 31/01/2012 22:07, Andreas Säger a écrit : Hi Andreas, Am 31.01.2012 20:16, Alexander Thurgood wrote: Yes, the dependency on Java JRE/JDK is a pain in the backside, but unfortunately unavoidable if you want to use Base, at least for the time being. With no Java being installed, I can connect a Base document to any non-Java database, write queries, draw input forms and use Calc as reporting engine. And I would state that that is an unusual user setup. The user here wants a relational database with subforms and reports and does not want to use mysql, so where does that leave him her with regard to Base - IMO, with HSQLDB, the stock db engine provided with LO. For that, you need a JRE/JDK. And Calc for reports is OK, much as is Writer, but for anything a bit more than a simple report, the user will have to deal with not only the idiosyncrasies of the respective tool used for creating the report, plus, in general, learn to use macros. The whole benefit of having a specific reporting tool (the Java based ORB extension) is that this is suppose to ease that pain. Personally, I'd love to be able to say, you get a great and easy to use db reporting engine without Java in LO, but that is simply not the case at the moment. Alex -- 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
Re: [libreoffice-users] Re: How get LibreO-Base working?
Hi again, First Tom: I will try. Let us see what comes from the deeps of my mind and if I can find some old projects to investigate so I can give an understandable answer - I'm a little afraid that not. Andreas: Thank you for very interesting info. Please note that I am talking from a consumers point of view in no way professional in databases. When I worked with MSAccess I plainly saw it as a program - a tool - and tried to learn how to get it producing the needed results, how to do data input - data mixing and processing - data output. The background philosophy and programming details were of no interest - I did not even know to ask. Knowing could have been of help. I am aware of what you say about real relational dbs; my intention is to do the ODBC connection (or JDBC if necessary) between LO-Base and (e.g.) MySQL but if I'm correct the LO-Base (32bit) must first start working stable with or without a JRE. That's why I now put my question how to your admirable community. Best regards Pepe On 1.2.2012 20:51, Andreas Säger wrote: Am 01.02.2012 19:36, Pertti Rönnberg wrote: All of you. Thanks very much for your kindness to bother answering - and for the very interesting discussions. My conclusion is that LO-Base (and OO-Base ?) is not yet - and perhaps will not be as mentioned in the desciption at LO-Wikipedia: A database management program http://en.wikipedia.org/wiki/Database_management_program, similar to Microsoft Access .. etc http://en.wikipedia.org/wiki/Microsoft_Access. The difference amounts to a multi-million Dollar budget and a decade of development. OOo Base was maintained by 2 Sun/Oracle employees. It is similar to Access. Access is named Access because you can access databases with it. In *addition* Access provides the JET database engine which embeds a database backend in the frontend file. Unfortunately, most people work with JET which is why Access has a bad reputation among professionals. I've seen very nice Access frontends for MySQL databases. Base connects ODF documents with databases. In *addition* it can embed a HSQLDB into the frontend file which is basically a zip archive with configuration and Writer documents. Unfortunately, most people use the embedded HSQLDB which is why Base has such a bad reputation. If you ever had created some relational database backend using any database specific, mature tool for the database, you would acknowledge how straight-forward Base connects your database with this office suite. Simply do your database with a database program. Base is not a database program. -- 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] How get LibreO-Base working?
Dear Ladies and Gentlemen out there. I am confused -- can you help me? I recently installed LibreOffice-v3.4.5 after beeing a happy OO-user in many many years. I now need to make a couple of relational databases (subforms -reports) and decided to try LibreO's Base. On my main-PC (AMD Athlon II X3 445, Win7Prof/32bit) the LO's Base caused the program to stop (WriteCalc work OK). I uninstalled LO, removed folders via WinExplorer, rebooted, installed LOv3.4.5 again and when asked for a new JRE I tried to understand the instructions found and first installed JRE8 (jre-8-ea-bin-b21-windows-i586-13_jan_2012.exe) and then JRE7 (jre-7u2-windows-i586.exe) and loaded both as instructed into LO (LO-page: tools/options/LibreOffice/java). Now LO didn't stop but neither of the JREs seem to be sufficient /LibreO requires a JRE to perform this task. The selected JRE is defective. Please select and install a new JRE/ and then /connection to datasource (db-name) could not be established -- no Java installation could be found; check installation/. I did my best several times. Note. After doing exactly same install process on my laptop (Win7Prem/64bit) the LO(64bit), Base included, works fine. Did I do something wrong, wrong versions, is it the 32bit make of LO or the LO-Base itself, is the JRE(32bit) wrong, -- or what? I like the graphical interface but I don't want to go back to OO and I don't want to buy a MSAccess, and for my simple needs a MySQL/PHP/Apache seems too heavy to learn. Thanks in advance. Pepe Rönnberg (Finland) -- 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
