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
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
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
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
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?
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
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.
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
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
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?
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
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
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
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
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
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
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
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
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
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
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
21 matches
Mail list logo
