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 selec

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 cells

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 th

Re: [libreoffice-users] paste special problem

2013-11-10 Thread Tanstaafl
On 2013-11-10 6:53 AM, yahoo-pier_andreit 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, a "paste special" wind

[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 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 per

[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 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 as old as Openoffice 1.

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

[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 help

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 sprea

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". Obvio

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 man

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 n

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. Howeve

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

2013-11-10 Thread Paul
On Mon, 11 Nov 2013 02:56:51 +0200 Ady 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 this behavior

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

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. Howeve

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

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 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 sever

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 =RIGHT(Xn;LEN(X

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 b

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 f

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 t

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 ni

[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 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 create

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 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

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 chang

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? http://www.li

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 --