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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jun 18 11:25:29 UTC 2021


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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEEDINFO
     Ever confirmed|0                           |1

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Dagur from comment #0)

What you describe is normal, and worked that way from the start IIUC. The
"number" is not a format coming with pasted text, but is coming from the cells
that you are *pasting to*: the plain text is inserted, processed as normal
input (as if you typed those texts sin formula bar), and interpreted according
to the usual rules (cells having a numeric number format try to interpret the
strings as numbers). You need to have cells pre-formatted as text to avoid
automatic conversion of input to numbers.

> Additional Info:
> This is a regression

This is unexpected; so please provide necessary info: in which version was it
different. I have just tested with OOo 1.0.3 from 2002, and it already worked
this way there.

-- 
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/05b99727/attachment.htm>


More information about the Libreoffice-bugs mailing list