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