Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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 it is not 
completely consistent with how Excel implements this. In particular,
I still am unable to simply paste special a cell containing the
number 1 onto a cell (or range of cells) containing a text
representation of a number and, using the multiply choice, have that
cell's contents converted to a number from text. This is what is done
widely among Excel users.
You are confusing two issues here. The first regards the apostrophe
marking cell contents as text when they appear to be numbers. The
second is the issue of allowing pasting and multiplying over cells
containing a text representation of a number.

You are correct in that the second issue is not consistent with Excel.
However, I was speaking specifically of the first issue when I said
that the behaviour is correct and consistant. In this discussion a few
people have confused the two, thinking that the apostrophe is somehow
connected to, and possibly the cause of, the second issue. I'm trying
to say that the apostrophe is a separate issue, and is *not* a bug, as
some have suggested. The apostrophe shows correct behaviour, purely in
and of itself. As a separate issue, Calc does not allow one to paste
and multiply over cells that contain numbers as text, and that,
completely aside from the issue of the apostrophe, is inconsistant with

Just trying to clear up some of the confusion.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.