[Libreoffice-bugs] [Bug 140580] Calc Editing Paste Special Values changes the pasted data to the assigned Autoformat NOT WYSIWYG

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Feb 21 18:07:28 UTC 2021


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

--- Comment #8 from Colin <that.man.colin at gmail.com> ---
Perhaps I should also clarify that if you hover your mouse over A8 or A9 it is
quite clear that I typed 17:21 everywhere and LO calc autoformatted but when
the Col A source is cut and pasted to Col C & E the format is again autochanged
from the time representations to decimal 0,7229166667 which is not an accurate
rendition of the data in the source cells.
     OR is it now treating the typed data as a formula and copying the result
of that "formula" in the "new" numerical format it assigned?

C8 is neither the original source data nor is it presented according to the
DATE/TIME format I predefined for it and would expect to see with "paste
special"

The jury is out on C9 - I no longer know what to expect.

-- 
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/20210221/fdf6a258/attachment.htm>


More information about the Libreoffice-bugs mailing list