Re: [libreoffice-users] Libreoffice.org
Hi, There is no Anti-Virus in the list and you :/ Liebe Grüße / Yours, Florian Reisinger Am 03.02.2015 um 22:11 schrieb Rex r.j.stow...@sbcglobal.net: When I go to Libreoffice.org to download the software to a Lenovo Laptop, running Windows 7, I get the following: This time an ad from Cabelas came up first and then I get a small white screen that says there is a virus on my computer, ads by dealpeak for a virus destroyer. I have run the following: Ccleaner Glary Utilities Malwarebytes and AD-Aware. Have I been hacked or have you folks. If I can help in any way, please contact me. Rex Stowers r.j.stow...@sbcglobal.net 636-233-3873 109 King Dr. St. Charles, MO 63303-3501 Thank you. -- 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] Thank you LibreOffice.
Agree as well! john On 03.02.2015 16:18, Mark Phillips wrote: +10 to all the developers and other contributors to this great project! Mark On Mon, Feb 2, 2015 at 7:20 PM, anne-ology lagin...@gmail.com wrote: in agreement. From: Thisis theone thisistheone8...@gmail.com Date: Mon, Feb 2, 2015 at 3:02 PM Subject: [libreoffice-users] Thank you LibreOffice. To: users@global.libreoffice.org I'm proud that a great, free and open source office suite exists. Thank you LibreOffice, thank you in the name of humanity. -- 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] Thank you LibreOffice.
+10 to all the developers and other contributors to this great project! Mark On Mon, Feb 2, 2015 at 7:20 PM, anne-ology lagin...@gmail.com wrote: in agreement. From: Thisis theone thisistheone8...@gmail.com Date: Mon, Feb 2, 2015 at 3:02 PM Subject: [libreoffice-users] Thank you LibreOffice. To: users@global.libreoffice.org I'm proud that a great, free and open source office suite exists. Thank you LibreOffice, thank you in the name of humanity. -- 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
[libreoffice-users] Re: And while I'm here, data extraction
You must not copy any opened table or query. You copy and paste the _icon_ of a query or table. You can also link record sets to spreadsheet ranges and pivot tables which gives quite a powerful report engine. [Tutorial] Using registered datasources in Calc https://forum.openoffice.org/en/forum/viewtopic.php?f=75t=18511 You do not tell us which database you are using (no, Base is _not_ a database). If it happens to be an embedded HSQLDB (indicated on the status bar) then you can use this command: SELECT * INTO TEXT export FROM Table or View This uses the HSQL database engine to export all records of some named table or view into a text file named export.csv in my Linux home directory. The full documentation of your database program can be found here: http://www.hsqldb.org/doc/1.8/guide/ch09.html Finally you can drag a record set from the data source window into a Writer document and choose Text export. In that dialog you can concatenate the wanted fields in one line with some delimiter between the fields. Then save as plain text. -- View this message in context: http://nabble.documentfoundation.org/And-while-I-m-here-data-extraction-tp4138570p4138689.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] Thank you LibreOffice.
Hi :) +1 to everyone here on this mailing list too! Especially the ones who have ever helped anyone or 'just' welcomed people in and made the place friendlier but also to the lurkers who are maybe doing things outside of this mailing list. Also to regular users and people who make us question and think. Also to the Documentation Team and all the translators! Regards from Tom :) On 3 February 2015 at 15:28, john herron paradox.her...@bluewin.ch wrote: Agree as well! john On 03.02.2015 16:18, Mark Phillips wrote: +10 to all the developers and other contributors to this great project! Mark On Mon, Feb 2, 2015 at 7:20 PM, anne-ology lagin...@gmail.com wrote: in agreement. From: Thisis theone thisistheone8...@gmail.com Date: Mon, Feb 2, 2015 at 3:02 PM Subject: [libreoffice-users] Thank you LibreOffice. To: users@global.libreoffice.org I'm proud that a great, free and open source office suite exists. Thank you LibreOffice, thank you in the name of humanity. -- 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 -- 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] And while I'm here, data extraction
Thanks all. I've been thinking about this. Firstly, the cut'n'paste solution isn't working here for me on the results (23 rows, perhaps ten columns) of a query in SQL view with Fedora Linux (20) and LO 4.2.8.2 (please don't suggest I upgrade to the latest as I'm using the OS repos, and there hasn't been any work on Base in that time anyway)(has there?). It doesn't work in design view either I now find. To be clear selecting all the data in the result and pressing ^C (or selecting Copy from the edit menu) then selecting a blank Calc spreadsheet and pressing ^V (or selecting Paste from the edit menu) doesn't produce any data whatsoever in the spreadsheet. I little experimentation has shown me that selecting either a complete column or a single cell in the result set, pressing ^C and then pressing ^V in the spreadsheet *both* give me a single cell output to the spreadsheet. Something does seem to be copying into the spreadsheet. Trying to past multiple cells like this clears the previous contents of the cell but there is nothing to see. Saving the sheet, which looks empty, produces a file of 10.2kb where saving an a truly empty sheet is 10.1kb. Is there some setting I've miss-set? Stope Press Pasting a small table (35 rows five cols) works, although, strangely, it brings in an extra row for column names. Not much use bringing in a table. That's what we need databases for in the first place, to manipulate tables to produce results. Having said all of that, is it ideal that the only way to get a data output from Base is C'n'P? Mark -- 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] And while I'm here, data extraction
On Tue, Feb 3, 2015 at 6:55 AM, Mark Stanton m...@vowleyfarm.co.uk wrote: Having said all of that, is it ideal that the only way to get a data output from Base is C'n'P? No it isn't, not at all. Having used dBase, FoxPro, Paradox and Access and others I can attest that all had multiple result export methods. I would appreciate export in Base also. Unfortunately don't have the skill to code it or the cash to fund development so am left with what is. After a little bit of digging I did find that HSSQL does offer means to export data. So it may be possible to use the SQL command line in Base to perform your exports. I write may because not all commands I've run at the SQL command line seem to be executed as I would expect. And this method certainly isn't as trivial as an Export to option in the UI would be. In any case perhaps this link can help you accomplish your goal... http://hsqldb.org/doc/2.0/util-guide/sqltool-chapt.html#sqltool_csv-sect -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Split Screen in Writer?
Le 03/02/2015 03:30, jonathon a écrit : Hi Jonathon, Didn't that get made into an extension? Or a beta release? Asking, because I remember using tabs on OOo, but have no idea when that was, or what I did to accomplish it. All I remember is that the user experience was worse than using ALTTAB to switch between documents. Yes, it did appear briefly in one (pre)release of OOo, but then got dropped - don't remember why. 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
Re: [libreoffice-users] Re: Split Screen in Writer?
Organon works a bit like Scrivener. Files are organized in a treeview and it's possible to open parts of the project in new tabs. You might open different files in different tabs, but they have to be part of the same project. What it exactly does, is creating textsections, linking files to them and organizing them in a treeview. Best, Xaver Am 03.02.2015 um 18:46 schrieb Tom Davies: Hi :) Back before MS Word became so widely used there was another word-processor that had an excellent way of using tabs helpfully. I don't think it was for different documents but i'm not clear what it used to do. Does anyone here know what program i'm talkign about and what the tabs were used for? Does this Extension do the same thing? I couldn't figure it out what it is doing from the screen-shot. Regards from Tom :) On 3 February 2015 at 06:00, X Roemer x-roe...@web.de wrote: My Extension Organon uses tabs, but maybe not in the manner you were looking for. Here you'll find screenshots: https://github.com/XRoemer/Organon/tree/master/Screenshots and particulary: https://github.com/XRoemer/Organon/blob/master/Screenshots/tabs.png The most recent version of Organon is hosted on github or on the OO extension-site. http://extensions.openoffice.org/en/project/organon (I found LOs extension-site inconvenient for uploaders. Also my last two attempts failed) Best, Xaver Am 02.02.2015 um 13:35 schrieb Alex Thurgood: Le 02/02/2015 12:05, Tom Davies a écrit : Hi Tom, Alex i had no idea about there being an Extension that does do tabs! many thanks for pointing it out! :)) I'd kinda given up on it ever happening in LO tbh and maybe the people who kept on going on about it feel the same way (or else maybe they just got the Extension and are all happy bunnies now). There is no extension today. Code was developed as part of a GSoc project when Sun had the stewardship of the OOo project and never finally got integrated into the main product. The code was abandoned, and has probably disappeared into the annals of history. 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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Re: Split Screen in Writer?
Hi, Tom Davies schrieb am Dienstag, 3. Februar 2015 18:46: Back before MS Word became so widely used there was another word-processor that had an excellent way of using tabs helpfully. I don't think it was for different documents but i'm not clear what it used to do. Does anyone here know what program i'm talkign about and what the tabs were used for? Do you mean Lotus WordPro (Part of Lotus Smartsuite)?? I was working many years from 1996 to 2010 with this word-processor at job, and tabs were the only thing I really missed in OOo and LO. Tabs could be used to open multiple documents, to organize master documents, parts of documents and even ranges within documents - in hierarchical manner if you wanted to... regards Stefan -- system: opensuse 13.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] Re: Re: Split Screen in Writer?
It also had the ability to have 'Sections' that included connected/imported documents that could be expanded/collapsed by clicking on the TAB. A wonderful easy to see and use system. I miss it also. On 2/3/2015 2:30 PM, Stefan Gruber wrote: Hi, Tom Davies schrieb am Dienstag, 3. Februar 2015 18:46: Back before MS Word became so widely used there was another word-processor that had an excellent way of using tabs helpfully. I don't think it was for different documents but i'm not clear what it used to do. Does anyone here know what program i'm talkign about and what the tabs were used for? Do you mean Lotus WordPro (Part of Lotus Smartsuite)?? I was working many years from 1996 to 2010 with this word-processor at job, and tabs were the only thing I really missed in OOo and LO. Tabs could be used to open multiple documents, to organize master documents, parts of documents and even ranges within documents - in hierarchical manner if you wanted to... regards Stefan -- 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: Split Screen in Writer?
Hi :) Back before MS Word became so widely used there was another word-processor that had an excellent way of using tabs helpfully. I don't think it was for different documents but i'm not clear what it used to do. Does anyone here know what program i'm talkign about and what the tabs were used for? Does this Extension do the same thing? I couldn't figure it out what it is doing from the screen-shot. Regards from Tom :) On 3 February 2015 at 06:00, X Roemer x-roe...@web.de wrote: My Extension Organon uses tabs, but maybe not in the manner you were looking for. Here you'll find screenshots: https://github.com/XRoemer/Organon/tree/master/Screenshots and particulary: https://github.com/XRoemer/Organon/blob/master/Screenshots/tabs.png The most recent version of Organon is hosted on github or on the OO extension-site. http://extensions.openoffice.org/en/project/organon (I found LOs extension-site inconvenient for uploaders. Also my last two attempts failed) Best, Xaver Am 02.02.2015 um 13:35 schrieb Alex Thurgood: Le 02/02/2015 12:05, Tom Davies a écrit : Hi Tom, Alex i had no idea about there being an Extension that does do tabs! many thanks for pointing it out! :)) I'd kinda given up on it ever happening in LO tbh and maybe the people who kept on going on about it feel the same way (or else maybe they just got the Extension and are all happy bunnies now). There is no extension today. Code was developed as part of a GSoc project when Sun had the stewardship of the OOo project and never finally got integrated into the main product. The code was abandoned, and has probably disappeared into the annals of history. 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 -- 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] And while I'm here, data extraction
On 3/02/2015, at 22:55, Mark Stanton m...@vowleyfarm.co.uk wrote: I've been thinking about this. Firstly, the cut'n'paste solution isn't working here for me on the results (23 rows, perhaps ten columns) of a query in SQL view with Fedora Linux (20) and LO 4.2.8.2 (please don't suggest I upgrade to the latest as I'm using the OS repos, and there hasn't been any work on Base in that time anyway)(has there?). It doesn't work in design view either I now find. You do not select the cells from an open query. Just select the query in the Query panel i.e the actual name of the query and copy that. Then paste that into your spreadsheet and all your data should be imported. So don't open the query just copy the query name. Hope this makes sense. Tony Bray -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: And while I'm here, data extraction
Le 03/02/2015 21:49, tonybsa a écrit : You do not select the cells from an open query. If you want individual records from your query result window, select the grey cell at the lefthand end of the grid. Use Ctrl-click to select non-contiguous results. With the rows highlighted, maintain the left mouse button clicked and drag to the Calc sheet. The drag icon will change to a dropped plus symbol indicating that multiple records are selected. The field names are also copied over. 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] Re: Split Screen in Writer?
Le 03/02/2015 18:46, Tom Davies a écrit : Hi Tom, Back before MS Word became so widely used there was another word-processor that had an excellent way of using tabs helpfully. I don't think it was for different documents but i'm not clear what it used to do. Does anyone here know what program i'm talkign about and what the tabs were used for? Lotus Word Pro, and in my opinion, one of the handiest functions I ever used to get my work done when drafting long documents. 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
Re: [libreoffice-users] And while I'm here, data extraction
Hmm You must not copy any opened table or query. You copy and paste the _icon_ of a query or table. That's not what the three answers above said, nor indeed what is intuitive (to me), and indeed cutting and pasting small amounts of data from the result set does work, which I would expect/hope for (without the small), but I'll give it a go... Wow! *That* works really well. I'd say that it requires a very odd intuitive leap, and I don't remember seeing it written in the docs anywhere, did I just miss it? You can also link record sets to spreadsheet ranges and pivot tables which gives quite a powerful report engine. Am I right this is only almost great? I don't see how to define a datasource, it just seems to be picking up data from the last icon I dragged to the sheet. [Tutorial] Using registered datasources in Calc https://forum.openoffice.org/en/forum/viewtopic.php?f=75t=18511 That is very good, thank you. I must remember to look in the OpenOffice areas more often. You do not tell us which database you are using (no, Base is _not_ a database). With over thirty years of database coding and consulting I'm very well aware that Base isn't a database. In the previous thread I said, MariaDb (under Fedora). If it happens to be an embedded HSQLDB Yes, I saw this, but decided to ignore it. Given the trouble it causes, surely it's not a good idea to recommend embedded HSQLDB for any purpose, is it? Finally you can drag a record set from the data source window into a Writer document and choose Text export. In that dialog you can concatenate the wanted fields in one line with some delimiter between the fields. Then save as plain text. Wild! I don't see a text export though, other than saving the Writer file as a text file. Mark Stanton One small step for mankind... -- 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] Libreoffice.org
When I go to Libreoffice.org to download the software to a Lenovo Laptop, running Windows 7, I get the following: This time an ad from Cabelas came up first and then I get a small white screen that says there is a virus on my computer, ads by dealpeak for a virus destroyer. I have run the following: Ccleaner Glary Utilities Malwarebytes and AD-Aware. Have I been hacked or have you folks. If I can help in any way, please contact me. Rex Stowers r.j.stow...@sbcglobal.net 636-233-3873 109 King Dr. St. Charles, MO 63303-3501 Thank you. -- 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