<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc Editing Paste Special Values changes the pasted data to the assigned Autoformat NOT WYSIWYG" href="https://bugs.documentfoundation.org/show_bug.cgi?id=140580#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc Editing Paste Special Values changes the pasted data to the assigned Autoformat NOT WYSIWYG" href="https://bugs.documentfoundation.org/show_bug.cgi?id=140580">bug 140580</a> from <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>