Re: [libreoffice-users] Upgrading
Hi, On Sat, Jul 23, 2011 at 4:14 PM, Oedipe wrote: > Is it really necessary to uninstall previous version before upgrading to a > new one ? No, you just download the new version and you can install it straight over the top without problem. -- David Nelson -- 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] a problem of Chinese Version of LibreOffice Writer
Hi Alexander, cpfun wrote (22-07-11 18:29) > My name is Alexander Rong from China. I’am a LibreOffice Writer > user. Yesterday I found a problem about the project list number of the > LibreOffice Writer. Thanks for writing! > I like to use Chinese project list number，for example: > 一、Tom > 二、Kate > 三、John > > But when I save the file as ‘*.doc’ for share with my friends who have no > LibreOffice Writer but Mirosoft Word and open it again, all the Chinese > project list will be conerted to such lists as: > > 1 Tom > 2 Kate > 3 John. > > I fail to know to resolve this problem. It exists both V3.3 and V3.4. > I don’t know if it is a bug. I hope to get your help. Well, for sure that must be a bug. I just happen to see it is already listed as bug for saving as .doc in general (not specific for Chinese): https://bugs.freedesktop.org/show_bug.cgi?id=34814 So I guess that is the same issue... Kind regards, -- - Cor - http://nl.libreoffice.org -- 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] [Spam]
At 20:26 25/07/2011 +0100, Tom Davies wrote: Hi :( Sorry for the spam there :( Regards from Tom :) Good to hear, though, that you were responsible for it - along with so much else. Brian Barker -- 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: Can Font Included in Mac LibreOffice Package Be Deleted?
Oh, those fonts? Lol, yes you have your answer :) Regards from Tom :) From: noibs To: users@global.libreoffice.org Sent: Mon, 25 July, 2011 21:48:02 Subject: [libreoffice-users] Re: Can Font Included in Mac LibreOffice Package Be Deleted? I deleted the fonts and LO seems to be fine. Guess that answers it. If anyone has any additional technical information, I would like to read it. Thanks. -- View this message in context: http://nabble.documentfoundation.org/Can-Font-Included-in-Mac-LibreOffice-Package-Be-Deleted-tp3198627p3198680.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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] Can Font Included in Mac LibreOffice Package Be Deleted?
Hi :) I think you probably need quite a few for menus and other programs and for the system. If you have a dual-boot system or a Linux Cd that you have already tried as a LiveCd then I guess you could try moving the fonts to a different folder and see if anything goes horribly wrong. Then just use the other side of a dual-boot or a LiveCd or something to move the fonts back if you need them or delete them if you don't. If you are really desperately short of space then emptying your emailer's wastebin and clearing temp folders might help a bit until you can add a 'new' external hard-drive. Regards from Tom :) From: noibs To: users@global.libreoffice.org Sent: Mon, 25 July, 2011 21:28:25 Subject: [libreoffice-users] Can Font Included in Mac LibreOffice Package Be Deleted? There are several fonts included within the Mac OS X LibreOffice package. The only one I care about and use--DejaVu--I already have on my system because I previously downloaded and installed that font. The rest just clutter up my font list in LibreOffice. Can I delete my unwanted fonts from the LibreOffice package without causing harm? Thanks. -- View this message in context: http://nabble.documentfoundation.org/Can-Font-Included-in-Mac-LibreOffice-Package-Be-Deleted-tp3198627p3198627.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Can Font Included in Mac LibreOffice Package Be Deleted?
I deleted the fonts and LO seems to be fine. Guess that answers it. If anyone has any additional technical information, I would like to read it. Thanks. -- View this message in context: http://nabble.documentfoundation.org/Can-Font-Included-in-Mac-LibreOffice-Package-Be-Deleted-tp3198627p3198680.html Sent from the Users mailing list archive at Nabble.com. -- 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] a problem of Chinese Version of LibreOffice Writer
Hi :) Perhaps you are using different fonts? Do they have similar trouble when they save numbers? When you open the xls on your own machine does it show the numbers proerly? Regards from Tom :) From: cpfun To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 17:29:01 Subject: [libreoffice-users] a problem of Chinese Version of LibreOffice Writer Hello My name is Alexander Rong from China. I’am a LibreOffice Writer user. Yesterday I found a problem about the project list number of the LibreOffice Writer. I like to use Chinese project list number，for example: 一、Tom 二、Kate 三、John But when I save the file as ‘*.doc’ for share with my friends who have no LibreOffice Writer but Mirosoft Word and open it again, all the Chinese project list will be conerted to such lists as: 1 Tom 2 Kate 3 John. I fail to know to resolve this problem. It exists both V3.3 and V3.4. I don’t know if it is a bug. I hope to get your help. Thank you! Sincerely, Alexander Rong -- 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 -- 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: libre-office calc page preview problem
Hi :) Try changing the colour from grey to something much more visible Tools - Options - LibreOffice - Appearance In the bottom box scroll down to Writer and change the various types of "breaks" to light red or something. Then scroll further down to change the options for Calc. Hopefully it's just been that slightly different shades of grey are difficult to distinguish from each other! Good luck and regards from Tom :) From: Rebeca To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 21:14:39 Subject: [libreoffice-users] Re: libre-office calc page preview problem Cor Nouws nouenoff.nl> writes: > > Hi Nico, > > Nico van Vliet wrote (18-05-11 09:44) > > > Using libreoffice 3.3.1 om opensuse 11.4 > > > > I have a problem with calc. > > It seems that the View -> Page Break Preview only works on sheet1 > > sheet2 stays gray even if I type some thing on this sheet. > > Hmm, sorry that I cannot reproduce the problem. > I tried 331rc2 and 340beta5 and the default Ubuntu version. > However, as you can read, this is on Ubuntu. > > > Would appreciate help here. > > I think the best is trying with a recent/default version. >http://www.libreoffice.org/download/ >http://www.libreoffice.org/download/pre-releases/ > > http://wiki.documentfoundation.org/Main_Page/nl#Invoeren_en_Behandelen_van_Bugs > > Maybe it is solved there, and is the bug specific to the opensuse version? > > kind regards, > Cor > Hi Nico, I had the same problem but it was when I clicked on 'delete all manual breaks', if you don´t touch that, I think it will be ok. Now, I am still having problems with 'undisplayed calc page and header / footer borders' this error was supposed to be fixed in version 3.4.1, but they are still the same as when I had v. 3.4.0. Please if you could know what the problem is, it will be very helpful for me. Regards, Rebk -- 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 -- 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] Upgrading
Hi :) +1 I agree and i think the devs are working on that already but you might want to post a bug-report yourself http://wiki.documentfoundation.org/BugReport Regards from Tom :) From: Oedipe To: users@global.libreoffice.org Sent: Sat, 23 July, 2011 14:14:35 Subject: [libreoffice-users] Upgrading Hi, [Windows Vista here] Is it really necessary to uninstall previous version before upgrading to a new one ? (An automated upgrade to the last version should be mandatory in the next versions... Actually it's a "pain in the a** to download the full new file, uninstall previous, reinstall new version process) -- Oedipe -- 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 -- 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] Can Font Included in Mac LibreOffice Package Be Deleted?
There are several fonts included within the Mac OS X LibreOffice package. The only one I care about and use--DejaVu--I already have on my system because I previously downloaded and installed that font. The rest just clutter up my font list in LibreOffice. Can I delete my unwanted fonts from the LibreOffice package without causing harm? Thanks. -- View this message in context: http://nabble.documentfoundation.org/Can-Font-Included-in-Mac-LibreOffice-Package-Be-Deleted-tp3198627p3198627.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: change to move/copy
Tried it and it worked fine using LibreOffice 3.4.1 Windows 7 -- View this message in context: http://nabble.documentfoundation.org/change-to-move-copy-tp3198226p3198572.html Sent from the Users mailing list archive at Nabble.com. -- 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] change to move/copy
Robert Rennie wrote: Redesigned Move/Copy Sheet dialog (Edit->Sheet->Move/Copy) to improve its ergonomics. (Joost Eekhoorn, Christoph Noack) This redesign is causing a writte error when trying to save after using copy. Had no problem with make a copy prior to this change. Rgrennie It works here with no problem. Use it several times a week in fact. LibO 3.4.1 under Ubuntu 11.04 and Win7. Andy -- 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]
Hi :( Sorry for the spam there :( Regards from Tom :) From: Peter Tselios To: d...@orthology.gr; eleftherios.kouva...@siemens.com; francesco.formis...@accenture.com; idgia...@athens2004.com; johni...@lycos.com; ktselio...@yahoo.gr; n...@lists.manyfish.co.uk; pi...@core.gr; elgrecoho...@yahoo.gr; peter.tsel...@gmail.com; postfix-us...@postfix.org; hkonto2...@yahoo.gr; kelefther...@hotmail.com; mich...@orlitzky.com; fact...@otenet.gr; f.bon...@esiee.fr; mikael@yandex.ru; victori...@uma.es; pniko...@webstudent.gr; users@global.libreoffice.org; ptsel...@tellas.gr; comingwo...@gmail.com; supp...@smilentango.com Sent: Mon, 25 July, 2011 20:23:58 Subject: [libreoffice-users] its been hard living on my own nothing seemed to work for me I consider myself lucky to have found this! http://jasmenadas.ja.funpic.de/GaryJones91.html have a new found respect for me sorry im in such a rush You will love me for this! -- 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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Enter works as paste, even when Enter is reserved for edit mode.
Am 22.07.2011 22:11, Tom Davies wrote: Hi :) It might be better to use a different key. Enter can get messy and confusing Regards from Tom :) Well, LibreOffice introduced the Enter key for pasting, imitating one of the most irritating Excel features. But in Excel one can turn off this annoyance. And then they introduced these marching ants when you copy a cell range but in such an idiotic way that it keeps on marching when you select something different in another window, even in the same application, even in the same component. It is not necessary to imitate Excel. Two shorttcuts shouldn't overlap like this. I didn't find a preference to turn of Enter-pasting. Hit Escape after copying to stop the marching ants. Then it Enter and Ctrl+V behave normally. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: libre-office calc page preview problem
Cor Nouws nouenoff.nl> writes: > > Hi Nico, > > Nico van Vliet wrote (18-05-11 09:44) > > > Using libreoffice 3.3.1 om opensuse 11.4 > > > > I have a problem with calc. > > It seems that the View -> Page Break Preview only works on sheet1 > > sheet2 stays gray even if I type some thing on this sheet. > > Hmm, sorry that I cannot reproduce the problem. > I tried 331rc2 and 340beta5 and the default Ubuntu version. > However, as you can read, this is on Ubuntu. > > > Would appreciate help here. > > I think the best is trying with a recent/default version. > http://www.libreoffice.org/download/ > http://www.libreoffice.org/download/pre-releases/ > > http://wiki.documentfoundation.org/Main_Page/nl#Invoeren_en_Behandelen_van_Bugs > > Maybe it is solved there, and is the bug specific to the opensuse version? > > kind regards, > Cor > Hi Nico, I had the same problem but it was when I clicked on 'delete all manual breaks', if you don´t touch that, I think it will be ok. Now, I am still having problems with 'undisplayed calc page and header / footer borders' this error was supposed to be fixed in version 3.4.1, but they are still the same as when I had v. 3.4.0. Please if you could know what the problem is, it will be very helpful for me. Regards, Rebk -- 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] a problem of Chinese Version of LibreOffice Writer
Hello My name is Alexander Rong from China. I’am a LibreOffice Writer user. Yesterday I found a problem about the project list number of the LibreOffice Writer. I like to use Chinese project list number，for example: 一、Tom 二、Kate 三、John But when I save the file as ‘*.doc’ for share with my friends who have no LibreOffice Writer but Mirosoft Word and open it again, all the Chinese project list will be conerted to such lists as: 1 Tom 2 Kate 3 John. I fail to know to resolve this problem. It exists both V3.3 and V3.4. I don’t know if it is a bug. I hope to get your help. Thank you! Sincerely, Alexander Rong -- 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] change to move/copy
Redesigned Move/Copy Sheet dialog (Edit->Sheet->Move/Copy) to improve its ergonomics. (Joost Eekhoorn, Christoph Noack) This redesign is causing a writte error when trying to save after using copy. Had no problem with make a copy prior to this change. Rgrennie -- 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] How to import a txt file into an existing Calc sheet?
Le 25/07/2011 13:10, George R. Kasica a écrit : OK..that gets the file in, but the first 4 rows that are always locked with Headers get replaced as well even if I say from Line 4, and I've tried both before and after sheet options. Also there are some calc lines at the bottom that in Excel are automatically moved down if there is more data than what is there now. With Calc it blows them away and replaces them with data, BIG problem as some of the formulas are quite time consuming to reenter and there's at least one and possibly as much as 3 for each column (Max, Min, etc) In such a situation, I import into a file (always named identically) which I then use as a source for an external worksheet where the actual computations are done. This way, the import never breaks anything. -- Jean-Francois Nifenecker, Bordeaux -- 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] Given up spellchecking?
Hi Tom, Thanks for taking the time with this one. > I am sure it's something to do with just settings. There was a thread about > it > a few months ago. "Webmaster at Kracked Press" had a good answer but i can't > find the thread. I'll have a look. > I don't know if this is it but in > Tools - Options - LibreOffice - Paths > is AutoCorrect set at something like > /home/username/.libreoffice/3/user/autocorr Yup. Although there are no files in that directory. Perhaps that's not important. > Also in > Tools - Options - LibreOffice - "Language Settings" - Languages > there are 4 drop-downs. The top one often reverts to "English (USA)" I can't get it to say anything else. Where can a reset a language to give me more options for this dropdown? I've reset the locale & language in Fedora, that doesn't seem to do it! :-( > But i > think they all 'should' be on "Default - English (UK)" ecept currency which > 'should' by "Default - GBP" Default doesn't seem to be an option, they're all countries & currencies. Mine is set to GBP. > In the top box of the 3 boxes in > Tools - Options - LibreOffice - "Language Settings" - "Writing Aids" > I have "Hunspell SpellChecker" ticked. This seems to be the crux of it. Hunspell doesn't appear in that box, and I don't see any way to add it, from this dialogue anyway. > In the middle box i have 4 > "dictionaries" ticked > standard [ALL] > soffice [ALL] > technical [ALL] > IgnoreAllList [ALL] I have added a couple of dictionaries, but I have these you mention too. > In the bottom box i have ticked "check spelling as you type" along with most > of > the rest of them except "Check words with numbers" and "Hyphenate without > inquiry". Yup, pretty much my setup too. > I have CC'd the message directly to you in the hope that you get the attached > screen-shots that way in case they look completely different from yours. Nope, not got that. Im haste Mark Stanton One small step for mankind... -- 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 to import a txt file into an existing Calc sheet?
I think I have it worked out. Thanks On Mon, Jul 25, 2011 at 10:34 AM, Alexander Thurgood < alex.thurg...@gmail.com> wrote: > Le 25/07/11 15:32, Tom Davies a écrit : > > Hi all, > > > > I think i would approach this by using a database program rather than > importing > > into a spreadsheet program. A database program such as Base should be > able to > > read the text-files directly. Queries, Forms and Reports can be set-up > to do > > the required calculations. > > > > Yes, you can bind text files directly to the HSQLDB backend : > > http://hsqldb.org/doc/guide/ch06.html > > in order to access them from LibreOffice, you would first need to create > an empty ODB database document, e.g. using the Database Creation Wizard. > Once the file has been created and saved, close it, reopen it, and then > execute the SQL statement provided in the HSQLDB documentation to bind > your text tables into the database. The SQL commands are executed from > the menu Tools > SQL... and not from the Query UI of the ODB container. > > Alternatively, open your CSV in Calc, and then copy the whole sheet over > to the new DB as a new table. Things to be aware of if you are going the > Calc to Base route: > > - type recognition between Base and Calc is not perfect, i.e. the engine > used for type recognition of data types sometimes gets it horribly wrong > for certain data types like decimal point containing data, date or > date/time data, especially if the locale is not EN-US. > > - there is a bug in the date calculation engine that appears to cause > some dates to be misdisplayed or miscalculated with an offset of 1 or 2 > days - this is a recurring old bug that has never been nailed because it > was too hard to track down exactly where the problem was coming from. > > Good luck > > Alex > > > -- > 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 > -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How to import a txt file into an existing Calc sheet?
Le 25/07/11 15:32, Tom Davies a écrit : Hi all, > I think i would approach this by using a database program rather than > importing > into a spreadsheet program. A database program such as Base should be able > to > read the text-files directly. Queries, Forms and Reports can be set-up to do > the required calculations. > Yes, you can bind text files directly to the HSQLDB backend : http://hsqldb.org/doc/guide/ch06.html in order to access them from LibreOffice, you would first need to create an empty ODB database document, e.g. using the Database Creation Wizard. Once the file has been created and saved, close it, reopen it, and then execute the SQL statement provided in the HSQLDB documentation to bind your text tables into the database. The SQL commands are executed from the menu Tools > SQL... and not from the Query UI of the ODB container. Alternatively, open your CSV in Calc, and then copy the whole sheet over to the new DB as a new table. Things to be aware of if you are going the Calc to Base route: - type recognition between Base and Calc is not perfect, i.e. the engine used for type recognition of data types sometimes gets it horribly wrong for certain data types like decimal point containing data, date or date/time data, especially if the locale is not EN-US. - there is a bug in the date calculation engine that appears to cause some dates to be misdisplayed or miscalculated with an offset of 1 or 2 days - this is a recurring old bug that has never been nailed because it was too hard to track down exactly where the problem was coming from. Good luck Alex -- 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] How to import a txt file into an existing Calc sheet?
>Hi :) >I think i would approach this by using a database program rather than >importing >into a spreadsheet program. A database program such as Base should be able to >read the text-files directly. Queries, Forms and Reports can be set-up to do >the required calculations. Interesting idea, and I'm open to change as long as it gives accurate results I'm open to it. >Setting it up would not be trivial! It could be quite tricky especially if >you >have never used a database program before. I would guess that it was not >trivial to set it up for Excel either. It wasn't, I'm an IT guy by trade so am familiar with several DB products. >Could you send me attachments off-list so i could have a copy of an original >text-file, the blank you import the text into and an example of a completed >sheet? I might have enough time to have a quick poke around and perhaps show >to >some databasing experts over the next couple of weeks. Look for them shortly along with the Excel sheet as well. >Until you can get Calc or Base or something to do the task you will need to >keep >going back to Windows and MS Office. Migrating away from systems you have >spent >years becoming familiar with often means returning for odd 1 or 2 tasks until >you are ready. There is no harm in running both systems alongside each other >until you are ready to move over completely. That's what I'm doing now, no hurry here, I'm just finally getting time to work on moving off 2007 because I don't want to pay huge $$ to go to 2010 for a few items I use it for. >Good luck and regards from >Tom :) Thanks, I'm sure we'll be emailing quite a bit. Files to Follow. George -- 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] How to import a txt file into an existing Calc sheet?
Hi :) I think i would approach this by using a database program rather than importing into a spreadsheet program. A database program such as Base should be able to read the text-files directly. Queries, Forms and Reports can be set-up to do the required calculations. Setting it up would not be trivial! It could be quite tricky especially if you have never used a database program before. I would guess that it was not trivial to set it up for Excel either. Could you send me attachments off-list so i could have a copy of an original text-file, the blank you import the text into and an example of a completed sheet? I might have enough time to have a quick poke around and perhaps show to some databasing experts over the next couple of weeks. Until you can get Calc or Base or something to do the task you will need to keep going back to Windows and MS Office. Migrating away from systems you have spent years becoming familiar with often means returning for odd 1 or 2 tasks until you are ready. There is no harm in running both systems alongside each other until you are ready to move over completely. Good luck and regards from Tom :) From: George R. Kasica To: users@global.libreoffice.org Sent: Mon, 25 July, 2011 12:10:52 Subject: Re: [libreoffice-users] How to import a txt file into an existing Calc sheet? >At 07:48 23/07/2011 -0500, George R. Kasica wrote: >>I have a currently existing Excel 2007 sheet that I can do a (In >>Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt ... > >So that's a file available to your system? Yes, its a flat file created from some weather equipment. >>... which is a te[x]t file in the format of: [...] and is properly >>formatted automatically by a Text-To-Columns setup already in the MS >>Excel sheet so all I need to do each day is Refresh All and select >>the filename and it pulls in the data in the proper column. >> >>For the life of me I cannot see how to do this in Calc...and opening >>the existing sheet gets the right format, but I'm at a loss of how >>to get new data into it without redoing the whole text to columns >>every time ... > >Try this: >o Go to Insert | Sheet From File..., browse to your .txt file, and >click Insert. >o In the Text Import dialogue, under "Separator options", select >"Separated by", "Space", and "Merge delimiters". >o Click OK. >o In the Insert Sheet dialogue, select the position of your new >sheet and - crucially - tick Link. >o Click OK. OK..that gets the file in, but the first 4 rows that are always locked with Headers get replaced as well even if I say from Line 4, and I've tried both before and after sheet options. Also there are some calc lines at the bottom that in Excel are automatically moved down if there is more data than what is there now. With Calc it blows them away and replaces them with data, BIG problem as some of the formulas are quite time consuming to reenter and there's at least one and possibly as much as 3 for each column (Max, Min, etc) >Each time you open this spreadsheet, you will have the option to >update this new sheet; alternatively, you can go to Edit | Links... >and click Update. Note that, since the entire sheet is updated, any >calculations you perform on that sheet will be lost - so you will >have to move your calculations to other sheets. OK...so I have to make a 2nd sheet then to do my calcs? Let me look at that today once. >If this data is downloaded from the web, you may prefer instead to >use Insert | Link to External Data... and import directly from the web page. No, its local, though it could be accessed by web as well. Let me look at this as well. >>... (not an option due to time constraints here each day when this >>has to happen...data is available at 59 past the hour and needs to >>just come in to be used by 15 past the next hour. > >You can do a lot in sixteen minutes! Like I said, the automated linking and calcs are critical to this working. Much of the process I do it cookie cutter hence the premade sheet etc. >I trust this helps. I'll work with it a bit today and let you know where I end up. -- ===[George R. Kasica]===+1 262 677 0766 President +1 206 374 6482 FAX Netwrx Consulting Inc. Jackson, WI USA http://www.netwrx1.com geor...@netwrx1.com ICQ #12862186 -- 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 -- 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 Li
Re: [libreoffice-users] How to import a txt file into an existing Calc sheet?
>At 07:48 23/07/2011 -0500, George R. Kasica wrote: >>I have a currently existing Excel 2007 sheet that I can do a (In >>Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt ... > >So that's a file available to your system? Yes, its a flat file created from some weather equipment. >>... which is a te[x]t file in the format of: [...] and is properly >>formatted automatically by a Text-To-Columns setup already in the MS >>Excel sheet so all I need to do each day is Refresh All and select >>the filename and it pulls in the data in the proper column. >> >>For the life of me I cannot see how to do this in Calc...and opening >>the existing sheet gets the right format, but I'm at a loss of how >>to get new data into it without redoing the whole text to columns >>every time ... > >Try this: >o Go to Insert | Sheet From File..., browse to your .txt file, and >click Insert. >o In the Text Import dialogue, under "Separator options", select >"Separated by", "Space", and "Merge delimiters". >o Click OK. >o In the Insert Sheet dialogue, select the position of your new >sheet and - crucially - tick Link. >o Click OK. OK..that gets the file in, but the first 4 rows that are always locked with Headers get replaced as well even if I say from Line 4, and I've tried both before and after sheet options. Also there are some calc lines at the bottom that in Excel are automatically moved down if there is more data than what is there now. With Calc it blows them away and replaces them with data, BIG problem as some of the formulas are quite time consuming to reenter and there's at least one and possibly as much as 3 for each column (Max, Min, etc) >Each time you open this spreadsheet, you will have the option to >update this new sheet; alternatively, you can go to Edit | Links... >and click Update. Note that, since the entire sheet is updated, any >calculations you perform on that sheet will be lost - so you will >have to move your calculations to other sheets. OK...so I have to make a 2nd sheet then to do my calcs? Let me look at that today once. >If this data is downloaded from the web, you may prefer instead to >use Insert | Link to External Data... and import directly from the web page. No, its local, though it could be accessed by web as well. Let me look at this as well. >>... (not an option due to time constraints here each day when this >>has to happen...data is available at 59 past the hour and needs to >>just come in to be used by 15 past the next hour. > >You can do a lot in sixteen minutes! Like I said, the automated linking and calcs are critical to this working. Much of the process I do it cookie cutter hence the premade sheet etc. >I trust this helps. I'll work with it a bit today and let you know where I end up. -- ===[George R. Kasica]===+1 262 677 0766 President +1 206 374 6482 FAX Netwrx Consulting Inc. Jackson, WI USA http://www.netwrx1.com geor...@netwrx1.com ICQ #12862186 -- 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
