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

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" behaviour, but you do have a strong

(BTW, I still think something "fishy" is happening with the single 
quotation mark in LO Calc.)
The single quote is a red herring. It is correct behaviour, and the
same as other spreadsheet software. It is the implicit conversion
of the text to a value that differs.

On the other hand, there are (less efficient) alternatives to 
eventually get to the same final result in LO Calc.
And perhaps more "correct" ones. Correct in the sense that I'm not sure
implicit conversions should be done on values. But it is a convenient

Seeing the current ratio of bug reports vs. bugs resolved, where in
many of them there is no alternative available so to get the desired
result using LO Calc, I am slightly reticent to actually report this
as a bug (or as a potential enhancement, whichever the adequate term
would be for this case). When other issues regarding paste (and/or
paste special) get to be resolved, perhaps then this issue will get
improved too.
Yeah, there is something funny up with cut and paste, I'll post in a
separate email, but I'm guessing the system needs an overhaul, which
might mean this is looked at at the same time.


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.