[Libreoffice-bugs] [Bug 103000] Text paste into spreadsheet clears cell formatting if in Text Import dialog Column type set to Date (YMD)

[bugzilla-daemon at bugs.documentfoundation.org]

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

TBeholder <turbobeholder at mail.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |turbobeholder at mail.ru

--- Comment #18 from TBeholder <turbobeholder at mail.ru> ---
In other words, everything is pasted into cells with its own format, if at all
possible — unless you paste it into during cell editing or into formula bar
rather than cell.

Seems to be the same, but appears in slightly different circumstances.
I select a fragment of text from one cell and pasting into another via primary
buffer (MMB in Linux, support in Options-LibreOffice-View). But this pastes
text with its old format, even though it was just a selection, not cell.
Format-Clear Formatting (Ctrl-M) resets to the cell's assigned old format.

IMHO not too bad, just make it controllable, especially in case of Text Import
dialog, much like Paste/Special does.

That's most likely what causes another problem (I wanted to submit a bug, but
now it looks like it would be a duplicate): there's no way to explicitly set
the intended format, and the field's own format is circumvented by pasting,
thus there's no way to avoid having pasted text like "00234E67" (hexadecimal
value) converted (into 2.34000000000000E+69). Which is bad, because data is
borked and Ctrl-M isn't going to fix this.

-- 
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/20190224/27e64455/attachment-0001.html>