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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140580
           Summary: Calc Editing Paste Special Values changes the pasted
                    data to the assigned Autoformat NOT WYSIWYG
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Description:
Sample file attached.
If text signifying a time (17:21) is copied and pasted special into a cell with
either a time or number format then the pasted data becomes 0.7229166666*.
If the same clipboard contents are simply pasted into non-formatted cells then
it pastes the format which is automatically assigned by the editor to the
original cells.
>From sample:-
Observe the values in A7:A9
Observe the format of C7:C9
Observe the format of E7:E9
If you wish to test the reality then simply:-
format say G7:G9 and H7:H9 in identical formats to C7:C9 & E7:E9 - NOTE: E7:E9
were originally formatted as text but paste reformats them according to its own
autoformat criteria
Copy A7:A9
PasteSpecial to G7:G9
PasteSpecial to H7:H9
This issue became apparent after pasting a simple text message stating 17:21 -
which was a bus departure time - into a spreadsheet register of SMSs. Message
dates and times were correctly interpreted but the conversion of 17:21 in a
predefined text field to 0,72291666* was a bit of a surprise.

Steps to Reproduce:
If you wish to test the reality then simply:-
format say G7:G9 and H7:H9 in identical formats to C7:C9 & E7:E9 - NOTE: E7:E9
were originally formatted as text but paste reformats them according to its own
autoformat criteria
Copy A7:A9
PasteSpecial to G7:G9
PasteSpecial to H7:H9

Actual Results:
Original text first converted to a time format in the opening cells (A7:A9) and
then reformatted to decimal formats in the paste special cells C8:C9) and
autoformatted in paste cells

Expected Results:
In old money WYSIWYG BUT in many - NOT ALL -  circumstances the autoformatting
to realistic date and time formats would not be amiss. It may be considered
that C9 should indeed be a decimal representation but arguably, only when the
user had defined the source cell as a number, NOT when it was originally
defined as text. I feel it's potentially a catch 22 situation. Is the
anticipation of the time formats generally more acceptable than a true
representation of the underlying data?


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded

-- 
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/9c133fbf/attachment.htm>