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

Hi Ady,

On Thu, 14 Nov 2013 15:45:33 +0200
Ady <ady-sf@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 it is "correct" behaviour, but you do have a strong
argument.

> (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
shortcut...

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

Paul

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted