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

2013-11-19 Thread Denis Navas Vega
El 2013-11-14 05:07 p.m., mariosv escribió: I have forgot in my previous post, another option: First copying the text to convert [Ctrl+c]. From the right-arrow in the icon. selecting unformatted text, we get the same option as importing csv files.

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

2013-11-19 Thread Denis Navas Vega
The only way I have to know that the numbers are in reality text, are that they are originally left aligned. Numbers are right aligned. In other matter, I get the ' when I apply a number format to a cell previously formatted as text. If I edit it (F2) I can reach the ' and edit it by hand.

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

2013-11-17 Thread Charles Smith
On 11/15/13 4:11 PM, Paul wrote: the behaviour is correct, and consistant with other spreadsheet programs. Sorry, no. The behavior may be correct, but it is not completely consistent with other spreadsheet programs. At least it is not completely consistent with how Excel implements this. In

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

2013-11-17 Thread Paul
On Sun, 17 Nov 2013 11:33:36 -0600 Charles Smith c...@chucsmith.org wrote: On 11/15/13 4:11 PM, Paul wrote: the behaviour is correct, and consistant with other spreadsheet programs. Sorry, no. The behavior may be correct, but it is not completely consistent with other spreadsheet

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

2013-11-17 Thread James E Lang
I've been following this debate with great interest. One big question comes to mind: Why would someone use the apostrophe construct in the first place if he intended to perform arithmetic calculations using the cell content? I understand ending up with a text string rather than a number by

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

2013-11-17 Thread Charles Smith
Hello, I can only speak for myself, but numbers get formatted as text in two ways: 1. Import of a tab delimited or csv file. 2. Spreadsheets sent to me from other users who have imported such files. Usually I format the import to avoid the problem, but if I just double click a csv file, it

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

2013-11-17 Thread Charles Smith
On Nov 17, 2013, at 12:01 PM, Paul paulste...@afrihost.co.za wrote: Just trying to clear up some of the confusion. Paul Thanks, Paul. That was helpful. Charles -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

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

2013-11-15 Thread Brian Barker
At 01:30 15/11/2013 +0200, Ady Noname wrote: To be clear, the 'text' format of the cell shouldn't block the multiplication ... Text isn't (just) a format: it's a separate data type. You can format cells as number or text, but that doesn't change what's stored in them (except that it governs

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

2013-11-15 Thread Brian Barker
At 08:01 15/11/2013 +0100, Stefan Weigel wrote: Am 14.11.2013 22:39, schrieb Brian Barker: It's worth mentioning that this is a misunderstanding of what is happening. There is no apostrophe in the cell to remove. Yes there is! Sorry, but that's simply untrue - and you can easily show it.

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

2013-11-15 Thread Stefan Weigel
Am 15.11.2013 12:06, schrieb Brian Barker: Type '1234 into a cell, so that you get the four-character text string 1234 in the cell (not the five-character string '1234). I you do this, the content of the cell will be '1234 and the cell will display the text 1234 as a result. Now put

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

2013-11-15 Thread Paul
Ok, I can't seem to refute this, because it would work exactly the same was as what I and Brian described works. The only difference would be in the internal representation of the cell contents, and I am not about to go diving into the code to check that out. Either way you think of it you will

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

2013-11-15 Thread Stefan Weigel
Hi Paul, Am 15.11.2013 23:11, schrieb Paul: the behaviour is correct, and consistant with other spreadsheet programs. I never doubted. :-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

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

2013-11-14 Thread Paul
On Thu, 14 Nov 2013 07:07:53 +0200 Ady ady...@hotmail.com wrote: Well, the procedure I mentioned involves copying one cell only, which means it is a faster method, as oppose to having to copy perhaps a lot of cells (e.g. a whole column; or having to add many new VALUE formulas; or having

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

2013-11-14 Thread Ady
Although the Tools - Text to Columns... method in Calc is nice, the procedure I am describing is more flexible. I'm not sure why you say it is more flexible. Text to columns would be the correct way of doing this, and I can't right now think of a case where you would need your way. Can you

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

2013-11-14 Thread Tinkerer
These solutions are far too complex especially if you have very large sheets. Why not use the extension CT2N? It is simple, very straightforward and you can decide ,whole sheet, or just parts. The ' is just removed. I understand it is to be included as standard, in which case there will be no need

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

2013-11-14 Thread Paul
Hi Ady, On Thu, 14 Nov 2013 15:45:33 +0200 Ady ady...@hotmail.com wrote: On one hand, this method is effective, efficient and well-known in several other spreadsheet programs, and for users that already know it, it seems at least strange that LO Calc doesn't support it. I'm still not sure

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

2013-11-14 Thread Brian Barker
At 12:30 14/11/2013 -0800, J Taylor wrote: Why not use the extension CT2N? The ' is just removed. It's worth mentioning that this is a misunderstanding of what is happening. There is no apostrophe in the cell to remove. The apostrophe indicates (in the Input Line) that what may appear to

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

2013-11-14 Thread mariosv
I have forgot in my previous post, another option: First copying the text to convert [Ctrl+c]. From the right-arrow in the icon. selecting unformatted text, we get the same option as importing csv files. http://nabble.documentfoundation.org/file/n4083240/Captura.png Miguel Ángel. -- View

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

2013-11-14 Thread Ady
These solutions are far too complex especially if you have very large sheets. Why not use the extension CT2N? It is simple, very straightforward and you can decide ,whole sheet, or just parts. The ' is just removed. I understand it is to be included as standard, in which case there will be

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

2013-11-14 Thread Ady
Hi Ady, On Thu, 14 Nov 2013 15:45:33 +0200 Ady ady...@hotmail.com wrote: On one hand, this method is effective, efficient and well-known in several other spreadsheet programs, and for users that already know it, it seems at least strange that LO Calc doesn't support it. I'm still

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

2013-11-14 Thread Stefan Weigel
Hi, Am 14.11.2013 22:39, schrieb Brian Barker: It's worth mentioning that this is a misunderstanding of what is happening. There is no apostrophe in the cell to remove. Yes there is! It's because these cell contents are very different that the apostrophe is necessary as a warning. It´s

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

2013-11-13 Thread Paul
On Mon, 11 Nov 2013 20:54:54 -0600 Denis Navas Vega denis.na...@gmail.com wrote: Paul, Make this test. 1. Open a new worksheet. Format some cells, say from A5:A10 as text. Write some numbers on those cells. Ok 2. Copy those cells to other column, say to C5:C10 and format as number

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

2013-11-13 Thread Ady
On Mon, 11 Nov 2013 20:54:54 -0600 Denis Navas Vega denis.na...@gmail.com wrote: Paul, Make this test. 1. Open a new worksheet. Format some cells, say from A5:A10 as text. Write some numbers on those cells. Ok 2. Copy those cells to other column, say to C5:C10 and format

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

2013-11-12 Thread Tinkerer
Brian If you are using a Mac 10.9 then you can move a Tool Bar icon simply by clicking on the gap to the right of the icon. When the object frame appears, drag the fame to where you want the icon, let go and the icon will move. I use CT2N when I copy and paste from a web site and it works, with

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

2013-11-12 Thread David Gast
From: David Gast Sent: Tuesday, November 12, 2013 11:37 To: Denis Navas Vega Subject: RE: [libreoffice-users] Re: CALC convert text to numbers It does not contradict my assertion. I did not discuss multiplication. The answer is that it depends on how you multiply. You did not state how you

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

2013-11-11 Thread Denis Navas Vega
El 2013-11-10 07:40 p.m., Paul escribió: 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

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

2013-11-11 Thread Joel Madero
On 11/11/2013 09:30 AM, Denis Navas Vega wrote: El 2013-11-10 07:40 p.m., Paul escribió: 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

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

2013-11-11 Thread Paul
On Mon, 11 Nov 2013 11:30:11 -0600 Denis Navas Vega denis.na...@gmail.com wrote: The problem is with the symbol ' It can't be searched and replaced. That's why Ady consider it a bug. That's because it isn't actually there. It's just an indicator of the fact that the number is not a number, but

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

2013-11-11 Thread mariosv
1) When data is in the spreadsheet, is simple to do it in one column. Select the cell(s) to convert from text to number in one column. Menu/Data/Text to columns - Separating by (nothing selected) 2) With Search Replace Search for:.* Replace with: With regular expression selected in

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

2013-11-11 Thread Denis Navas Vega
El 2013-11-11 01:46 p.m., Paul escribió: On Mon, 11 Nov 2013 11:30:11 -0600 Denis Navas Vega denis.na...@gmail.com wrote: The problem is with the symbol ' It can't be searched and replaced. That's why Ady consider it a bug. The only solution, which I used yesterday, is multiply by one. I

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

2013-11-11 Thread Denis Navas Vega
...@desertweyr.com] Sent: Monday, November 11, 2013 09:17 To: Joel Madero Cc: Brian Barker; users@global.libreoffice.org Subject: Re: [libreoffice-users] CALC convert text to numbers For me dealing with an extension, installing it, making sure it doesn't conflict with something else was more effort than