[libreoffice-users] Re: And while I'm here, data extraction
Mark Stanton wrote Hmm Wild! I don't see a text export though, other than saving the Writer file as a text file. Well, yes. Saving in any other file format than ODF is an export indeed. So we can use Calc, Writer and the underlying database engine to export database data as plain text. Base is nothing more than a bridge between office documents and some database engine. Base itself does not provide any features other than storing connection data and providing some tabular preview with basic sorting and filtering features. All the rest (forms and reports) is provided by office documents. -- View this message in context: http://nabble.documentfoundation.org/And-while-I-m-here-data-extraction-tp4138570p4138809.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: And while I'm here, data extraction
On Wed, Feb 4, 2015 at 6:20 PM, Andreas Säger saege...@t-online.de wrote:
Am 04.02.2015 um 01:26 schrieb Alan B:
select * into text newfile' from Sheet1;
Well, it's obvious. Isn't it?
:-) when you put it that way.
Gave me hope for a moment it was my error. Unfortunately I must have made a
typo in my email. I went back with a corrected statement (below is cut and
paste from command window) and got the same error. :-(
select * into text newfile from Sheet1;
1: syntax error, unexpected NAME, expecting ':' or '?' or '['
also tried...
select * into text 'newfile' from 'Sheet1';
select * into text 'newfile' from Sheet1;
select * into text 'newfile' from Sheet1;
select * into text newfile from Sheet1;
select * into text newfile from Sheet1;
select * into text newfile from 'Sheet1';
select * into text newfile from Sheet1;
select * into text newfile from 'Sheet1';
select * into text newfile from Sheet1;
All above are cut and paste from command window. All produced the same
error.
If {into text newfile} is removed and the command
select * from Sheet1;
is run the command succeeds with Sheet1 and Sheet1 but fails with
'Sheet1'.
--
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] Repository with LibreOffice 4.4 for Fedora 21+?
Hi, the best suggestion is to grab the latest from the LO site (you will have to monitor the site for updates): http://www.libreoffice.org/ As well as monitoring for updates you also have to install remove manually. As you are using Fedora I assume you are familiar with that process but any problems pls sing out. Cheers On 05/02/15 11:59, avamk wrote: Hello, LibreOffice in the Fedora 21 repositories are currently in the 4.3 series. Is there an updated LibreOffice repository for Fedora 21 (and also future versions) that have LibreOffice 4.4? I like to use the newest version of LibreOffice on Fedora if possible. Thanks! -- View this message in context: http://nabble.documentfoundation.org/Repository-with-LibreOffice-4-4-for-Fedora-21-tp4138819.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Repository with LibreOffice 4.4 for Fedora 21+?
Hello, LibreOffice in the Fedora 21 repositories are currently in the 4.3 series. Is there an updated LibreOffice repository for Fedora 21 (and also future versions) that have LibreOffice 4.4? I like to use the newest version of LibreOffice on Fedora if possible. Thanks! -- View this message in context: http://nabble.documentfoundation.org/Repository-with-LibreOffice-4-4-for-Fedora-21-tp4138819.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re-docking the formatting bar
Somehow I got this undocked and I can't seem to put it back. LO Writer 4.3 MR -- 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.org
Try Anti-virus packages like Comodo Internet Suite [great free version]. That is what I run on my Win7 systems. You might even try using their root-key utility to make sure that part of your system is clean. On 02/03/2015 04:11 PM, Rex wrote: 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
Re: [libreoffice-users] [Calc] how to compare not exactly equal values?
Subtract the numbers and check the absolute value On Feb 4, 2015 8:40 AM, gordom gord...@wp.pl wrote: Hallo everyone. I do realize my post title is not very descriptive. Sorry for that. I have 2 (or sometimes more) values (numbers) and want to compare them and check if they are more-less equal. Let say the condition is fulfilled if the numbers are exactly equal or the difference is not higher than (+/-) 1. Here is the example: 3,1 3 TRUE 5,9 6 TRUE 7 -5 FALSE 10 9 TRUE -6 -6 TRUE Any clues how I can do this? Regards, gordom -- 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] [Calc] how to compare not exactly equal values?
Hallo everyone. I do realize my post title is not very descriptive. Sorry for that. I have 2 (or sometimes more) values (numbers) and want to compare them and check if they are more-less equal. Let say the condition is fulfilled if the numbers are exactly equal or the difference is not higher than (+/-) 1. Here is the example: 3,1 3 TRUE 5,9 6 TRUE 7 -5 FALSE 10 9 TRUE -6 -6 TRUE Any clues how I can do this? Regards, gordom -- 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.org
Hi :) Rex, it sounds like a Phishing exercise! Anything that claims there is a problem of any type with your computer and then asks you to download their program to fix it is likely to be an attempt to trick you into installing some malware/virus onto your machine. It does sound like either your machine is already infected or that somehow you got to a wrong website/web-page that is trying to mimic our download page. As Tim recommended, it is a good idea to get an antivirus program or anti-malware suite or entire Security Suite and then scan your machine with that. I use AVG but i've never tried the one Tim recommends so i don't know which is best. I just use AVG on all machines (except the non-Windows ones where i sometimes use ClamAv) and have done quite happily for years. In some surveys it's listed as the best of the free ones. In the meantime it might be a good idea to use our official download web-page, unless it's the one you just tried. Did you use either this one? http://www.libreoffice.org/download/libreoffice-still/ or this one? http://www.libreoffice.org/download/libreoffice-fresh/ Either of those should be safe. We usually develop 2 branches at the same time. Fresh tends to have newer features and better compatibility with MS Formats but may have a few unexpected things broken (although most people generally don't dig around enough to find them). Still tends to be more solid and reliable but lacks the newer features and may not have such good compatibility with MS Formats. I think most of us on this mailing list tend to use Still for most of our clients machines and on ones we don't have easy access to or don't want to have to keep trying to fix but then try use Fresh on our own machine or on a test machine. Regards from Tom :) On 4 February 2015 at 12:46, Tim---Kracked_P_P---webmaster webmas...@krackedpress.com wrote: Try Anti-virus packages like Comodo Internet Suite [great free version]. That is what I run on my Win7 systems. You might even try using their root-key utility to make sure that part of your system is clean. On 02/03/2015 04:11 PM, Rex wrote: 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] [Calc] how to compare not exactly equal values?
At 14:40 04/02/2015 +0100, Gordom Noname wrote: I have 2 (or sometimes more) values (numbers) and want to compare them and check if they are more-less equal. Let say the condition is fulfilled if the numbers are exactly equal or the difference is not higher than (+/-) 1. Here is the example: 3,1 3 TRUE 5,9 6 TRUE 7 -5 FALSE 10 9 TRUE -6 -6 TRUE Any clues how I can do this? For two numbers, =ABS(A1-B1)=1 For more than two numbers, =MAX(A1;B1;C1;...)-MIN(A1;B1;C1;...)=1 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
Re: [libreoffice-users] [Calc] how to compare not exactly equal values?
W dniu 2015-02-04 o 14:46, Andrew Pitonyak pisze: Subtract the numbers and check the absolute value Thanks for this, gordom -- 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] [Calc] how to compare not exactly equal values?
W dniu 2015-02-04 o 15:24, Brian Barker pisze: At 14:40 04/02/2015 +0100, Gordom Noname wrote: I have 2 (or sometimes more) values (numbers) and want to compare them and check if they are more-less equal. Let say the condition is fulfilled if the numbers are exactly equal or the difference is not higher than (+/-) 1. Here is the example: 3,1 3 TRUE 5,9 6 TRUE 7 -5 FALSE 10 9 TRUE -6 -6 TRUE Any clues how I can do this? For two numbers, =ABS(A1-B1)=1 For more than two numbers, =MAX(A1;B1;C1;...)-MIN(A1;B1;C1;...)=1 I trust this helps. Brian Barker Thank you very much. That's very helpful. Regards, gordom -- 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
