[Libreoffice-bugs] [Bug 142930] [Regression] Pasting unformatted text is still formatted as numbers

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142930

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Dagur from comment #2)
> paste the new IDs with ctrl+v and choose unformatted text. 

I assume you mean some other key combination (Ctrl+Shift+V maybe?), because
Ctrl+V does not allow you to choose a kind of special paste, but uses default
paste - automatically using the best format.

> I recently upgraded Ubuntu from 20.10 to 21.04 so I was using whatever
> version of Libreoffice that 20.10 had.

If you also used paste special -> plain text in previous version of Ubuntu,
then I simply don't believe that pasting the two numbers that you cite - "0123"
and "456" - were pasted differently. In *all* versions of LibreOffice, and its
predecessor OpenOffice.org, pasting these *as plain text* into a cell with
*numeric* number format would result in numbers being pasted.

But if you happened to clear direct cell formats in your spreadsheet that you
are working with, that could be the real reason for the changed behavior,
having nothing to do with OS / LibreOffice upgrade, nor with regressions: it
would mean that the textual cell formatting, that was previously made incoming
text to be inserted as text, was lost, and is replaced by your actions
(clearing direct formatting in some way) by numeric. You could e.g. press
Backspace instead of Del, and then, in the dialog, chose "Delete all", which
clears formats.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210618/0c69a27c/attachment.htm>