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

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.

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

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.

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

On Nov 17, 2013, at 12:01 PM, Paul 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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ P

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

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 o

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

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 for

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

On Sun, 17 Nov 2013 11:33:36 -0600 Charles Smith 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 programs. At least i

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

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 par

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

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

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

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 st

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

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

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

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

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 gove

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

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

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

> Hi Ady, > > On Thu, 14 Nov 2013 15:45:33 +0200 > Ady 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 sur

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

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

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

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. Miguel Ángel. -- View

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

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 be

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

Hi Ady, On Thu, 14 Nov 2013 15:45:33 +0200 Ady 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 it is "correct" b

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

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

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

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

On Thu, 14 Nov 2013 07:07:53 +0200 Ady 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 to add a new

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

> On Mon, 11 Nov 2013 20:54:54 -0600 > Denis Navas Vega 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

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

On Mon, 11 Nov 2013 20:54:54 -0600 Denis Navas Vega 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 (format @). The

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

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

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

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

El 2013-11-11 04:00 p.m., David Gast escribió: Spreadsheets use the MVC (model view controller) paradigm. That means that the model (how the data are actually stored) and how you view the data are separated. You can take a number like 4.5 and view it as a date, a date and time, a real numbe

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

El 2013-11-11 01:46 p.m., Paul escribió: On Mon, 11 Nov 2013 11:30:11 -0600 Denis Navas Vega 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 still don't understan

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

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 Oth

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

On Mon, 11 Nov 2013 11:30:11 -0600 Denis Navas Vega 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 a text string. You

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

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

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

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