Re: [libreoffice-users] Shall we waste twelve more years promoting Free office suites instead of...

2013-11-10 Thread Gordon Burgess-Parker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/11/2013 19:33, Kracked_P_P---webmaster wrote: Open File Formats I still have State agency people send out MSO 2010 or 2013 Word .docx files to other agency people who still have MSO 2007 and did not have the budget to buy 2010 or 2013.

[libreoffice-users] paste special problem

2013-11-10 Thread yahoo-pier_andreit
on my opensuse 12.3 and libreoffice Version 4.0:build-305 and also with Version: 4.1.1.2 paste special doesn't works any more. if I select a group of cells with formulas, move in another position and I perform paste special, a paste special window appear with only: source: unknown source

Re: [libreoffice-users] Subject: DRM books

2013-11-10 Thread zuke
On 11/09/2013 10:49 PM, Daniel wrote: Is there an extension in LO in order to read DRM ebooks? Thanks Daniel LibreOffice really isn't the tool for this. Although you can convert to epub with some plugins, they really aren't very comprehensive and not worth the time, tbh. If you're

[libreoffice-users] Calc fields lose formatting

2013-11-10 Thread Oogie McGuire
I'm having a consistent problem with some fieldd in a very large Calc spreadsheet. I'm on a Mac and running LO Version 3.6.6.2 (Build ID: f969faf) One of my columns is a wide field with a lot of text. I have my default font set to Geneva and the size to 10. For some reason in some of the

Re: [libreoffice-users] Subject: DRM books

2013-11-10 Thread James Knott
Daniel wrote: Is there an extension in LO in order to read DRM ebooks? Why would you want to read ebooks in an office suite, when there are already many apps for that task? BTW, other than library books, I try to avoid DRM. I don't have a single DRM book that I own a copy of. The books I buy,

Re: [libreoffice-users] Subject: DRM books

2013-11-10 Thread John Meyer
Yeah, kinda OT, but Calibre is the best program for this. you can even e-mail your books to your Kindle. On 11/10/2013 7:20 AM, zuke wrote: On 11/09/2013 10:49 PM, Daniel wrote: Is there an extension in LO in order to read DRM ebooks? Thanks Daniel LibreOffice really isn't the tool for

Re: [libreoffice-users] paste special problem

2013-11-10 Thread Tanstaafl
On 2013-11-10 6:53 AM, yahoo-pier_andreit pier_andr...@yahoo.it wrote: on my opensuse 12.3 and libreoffice Version 4.0:build-305 and also with Version: 4.1.1.2 paste special doesn't works any more. if I select a group of cells with formulas, move in another position and I perform paste special,

[libreoffice-users] paste special problem

2013-11-10 Thread teppisti-xpla
on my opensuse 12.3 and libreoffice Version 4.0:build-305 paste special doesn't works any more. if I select a group of cells with formulas, move in another position and I perform paste special, a paste special window appear with only: source: unknown source selection: unformatted text and the

Re: [libreoffice-users] paste special problem

2013-11-10 Thread yahoo-pier_andreit
On 11/10/2013 06:00 PM, Tanstaafl wrote: On 2013-11-10 6:53 AM, yahoo-pier_andreit pier_andr...@yahoo.it wrote: on my opensuse 12.3 and libreoffice Version 4.0:build-305 and also with Version: 4.1.1.2 paste special doesn't works any more. if I select a group of cells with formulas, move in

[libreoffice-users] Engaging users: initial results of the survey

2013-11-10 Thread Charles-H. Schulz
Hello, As there were some exchanges about the survey here and as I advertised it on this mailing list as well, I thought you might be interested by my initial analysis: http://standardsandfreedom.net/index.php/2013/11/10/users-the-final-frontier/ Thank you for your participation! -- Charles-H.

Re: [libreoffice-users] paste special problem

2013-11-10 Thread Tanstaafl
On 2013-11-10 1:26 PM, yahoo-pier_andreit pier_andr...@yahoo.it wrote: On 11/10/2013 06:00 PM, Tanstaafl wrote: I have been having serious problems with 'Paste Special' working, then not working, then working again, on many different spreadsheets (most if not all created a long time ago, some

Re: [libreoffice-users] Subject: DRM books

2013-11-10 Thread Marc Grober
+1 there are several threads about this in the archive as well On 11/10/13, 5:20 AM, zuke wrote: On 11/09/2013 10:49 PM, Daniel wrote: Is there an extension in LO in order to read DRM ebooks? Thanks Daniel LibreOffice really isn't the tool for this. Although you can convert to epub with

[libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Oogie McGuire
I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers. However they come in as text and the manuals and

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Joel Madero
http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates That extension should do the trick - we're trying to incorporate it into the core code but so far you need the extension. All the best, Joel On 11/10/2013 01:57 PM, Oogie McGuire wrote: I have a

Re: [libreoffice-users] Engaging users: initial results of the survey

2013-11-10 Thread Dale Erwin
On 11/10/2013 1:46 PM, Charles-H. Schulz wrote: Hello, As there were some exchanges about the survey here and as I advertised it on this mailing list as well, I thought you might be interested by my initial analysis: http://standardsandfreedom.net/index.php/2013/11/10/users-the-final-frontier/

[libreoffice-users] Re: Engaging users: initial results of the survey

2013-11-10 Thread Urmas
Charles-H. Schulz: The only way users can contribute is when they are paying. If a developer is paid for non-user-related applications, it will have the ubiquitous opensource mentality: I'm a GOD and you insolent worm will crawl on all fours at my feet because it pleases me to do so.

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers. However they come in as text and the manuals

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Jay Lozier
On Mon, 2013-11-11 at 02:56 +0200, Ady wrote: I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers.

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Brian Barker
At 14:57 10/11/2013 -0700, Oogie McGuire wrote: I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers.

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Paul
On Mon, 11 Nov 2013 02:56:51 +0200 Ady ady...@hotmail.com wrote: As a simple user, I see this hidden addition of the initial single quotation mark as a _BUG_, and as one of those basic features that work poorly in LibreOffice Calc than in several other spreadsheet tools. I don't know if

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
If you are importing a txt or csv file into Calc you can use INSERT SHEET FROM FILE. The first part of the wizard will you can click OK. The second dialog has a section Other Options. In this section check Detect Special Numbers. There is a preview screen which shows what the data will look

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Brian Barker
At 14:57 10/11/2013 -0700, Oogie McGuire wrote: I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers.

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Brian Barker
At 02:56 11/11/2013 +0200, Ady Noname wrote: If the numbers (formatted as text) are already saved in your spreadsheet, I would normally suggest a simple procedure involving paste special and multiply (by 1). This has worked for me in several other spreadsheet tools. But Calc will (currently?)

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
As a simple user, I see this hidden addition of the initial single quotation mark as a _BUG_, and as one of those basic features that work poorly in LibreOffice Calc than in several other spreadsheet tools. I don't know if this behavior can be corrected or improved. As far as I

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Jay Lozier
On Mon, 2013-11-11 at 03:40 +0200, Paul wrote: On Mon, 11 Nov 2013 02:56:51 +0200 Ady ady...@hotmail.com wrote: As a simple user, I see this hidden addition of the initial single quotation mark as a _BUG_, and as one of those basic features that work poorly in LibreOffice Calc than in

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Brian Barker
At 21:17 10/11/2013 -0500, Jay Lozier wrote: Why not set a cell to the formula =right(len(CELL)-1) which returns the all the characters except for the first. That's =RIGHT(Xn;LEN(Xn)-1) - but that won't strip the single quote mark because it's *not there*! The simpler formula

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Joel Madero
On 11/10/2013 06:32 PM, Brian Barker wrote: At 21:17 10/11/2013 -0500, Jay Lozier wrote: Why not set a cell to the formula =right(len(CELL)-1) which returns the all the characters except for the first. That's =RIGHT(Xn;LEN(Xn)-1) - but that won't strip the single quote mark because it's *not

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
Why not set a cell to the formula =right(len(CELL)-1) which returns the all the characters except for the first. -- No, that won't work. You probably meant: =RIGHT(A1,LEN(A1)-1) where A1 is the 'text' cell. But that one will fail too, because the initial single quotation mark is not

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Brian Barker
At 18:43 10/11/2013 -0800, Joel Madero wrote: Why is everyone straying away from the fact that there is a simple extension developed by Cor (one of our brilliant devs) which accomplishes all of this? Just curious if there's a benefit to doing these formula techniques instead of just pushing a

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Joel Madero
On 11/10/2013 07:05 PM, Brian Barker wrote: At 18:43 10/11/2013 -0800, Joel Madero wrote: Why is everyone straying away from the fact that there is a simple extension developed by Cor (one of our brilliant devs) which accomplishes all of this? Just curious if there's a benefit to doing these

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
Why is everyone straying away from the fact that there is a simple extension developed by Cor (one of our brilliant devs) which accomplishes all of this? Just curious if there's a benefit to doing these formula techniques instead of just pushing a button on a nice gui I could ask you the

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Joel Madero
On 11/10/2013 07:10 PM, Ady wrote: Why is everyone straying away from the fact that there is a simple extension developed by Cor (one of our brilliant devs) which accomplishes all of this? Just curious if there's a benefit to doing these formula techniques instead of just pushing a button on a

[libreoffice-users] Re: paste special problem

2013-11-10 Thread Denis Navas Vega
El 2013-11-10 01:59 p.m., Tanstaafl escribió: On 2013-11-10 1:26 PM, yahoo-pier_andreit pier_andr...@yahoo.it wrote: On 11/10/2013 06:00 PM, Tanstaafl wrote: I have been having serious problems with 'Paste Special' working, then not working, then working again, on many different spreadsheets

Re: [libreoffice-users] Engaging users: initial results of the survey

2013-11-10 Thread Ady
Hello, As there were some exchanges about the survey here and as I advertised it on this mailing list as well, I thought you might be interested by my initial analysis: http://standardsandfreedom.net/index.php/2013/11/10/users-the-final-frontier/ Thank you for your participation! --

Re: [libreoffice-users] Re: paste special problem

2013-11-10 Thread Steve Edmonds
On 2013-11-11 17:09, Denis Navas Vega wrote: El 2013-11-10 01:59 p.m., Tanstaafl escribió: On 2013-11-10 1:26 PM, yahoo-pier_andreit pier_andr...@yahoo.it wrote: On 11/10/2013 06:00 PM, Tanstaafl wrote: I have been having serious problems with 'Paste Special' working, then not working, then

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Jean-Francois Nifenecker
Le 10/11/2013 22:57, Oogie McGuire a écrit : I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers. This

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Jean-Francois Nifenecker
ooops! forgot to specify the first step: 1. select the column to set as numbers first. Le 11/11/2013 07:03, Jean-Francois Nifenecker a écrit : 2. do that: Call the menu Data / Numbers as text (freely translated from my FR install) then just click OK in the window that opens without

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Brian Barker
At 07:03 11/11/2013 +0100, Jean-Francois Nifenecker wrote: Call the menu Data / Numbers as text (freely translated from my FR install) ... In English, that's Data | Text to Columns... . Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Jean-Francois Nifenecker
Le 11/11/2013 07:44, Brian Barker a écrit : At 07:03 11/11/2013 +0100, Jean-Francois Nifenecker wrote: Call the menu Data / Numbers as text (freely translated from my FR install) ... In English, that's Data | Text to Columns... . thanks! -- Jean-Francois Nifenecker, Bordeaux -- To