Bug 128552 - Paste special loses date
Summary: Paste special loses date
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-02 14:18 UTC by Jonny Grant
Modified: 2019-11-03 10:19 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Paste special test case (8.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-11-02 14:18 UTC, Jonny Grant 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jonny Grant 2019-11-02 14:18:55 UTC 
Created attachment 155466 [details]
Paste special test case

Can anyone reproduce this in latest version?

Paste Special Shift+Ctrl+V loses the date from the attached file, and turns it into a number 43450


Easy to reproduce

1. Copy cell A1
2. Select another cell
3. Shift+Ctrl+V
4. click OK
5. Observe 43450

why is this a bug?

If you copy from a TXT file "16 Dec 2018" and do the same Shift+Ctrl+V, Calc recognises it as a date


Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); Calc: group
Comment 1 Xavier Van Wijmeersch 2019-11-02 15:17:42 UTC 
When following the steps you give its past as Unformatted text
You need when dialog past special is showing to check in selection the formats 
and then you will have the correct value of the date
so no bug a WFM

Version: 6.4.0.0.alpha1+
Build ID: 80109586e6cb6d3e2e0a53a9079c3125ec9b8368
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 2 Jonny Grant 2019-11-02 17:04:03 UTC 
(In reply to Xavier Van Wijmeersch from comment #1)
> When following the steps you give its past as Unformatted text
> You need when dialog past special is showing to check in selection the
> formats 
> and then you will have the correct value of the date
> so no bug a WFM
> 
> Version: 6.4.0.0.alpha1+
> Build ID: 80109586e6cb6d3e2e0a53a9079c3125ec9b8368
> CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3; 
> Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
> Calc: threaded

Yes, when i copy a cell, and then Shift+Ctrl+V I have "Selection" "Date & time" ticked. It doesn't work for me. Does that work for you in latest?

If you open a TXT file copy paste from that with Shift+Ctrl+V it works, so feels some issue...
Comment 3 Xavier Van Wijmeersch 2019-11-02 18:01:52 UTC 
format in that dialog box need also to be ticket and then the date will be not a number
Comment 4 Jonny Grant 2019-11-02 18:16:38 UTC 
(In reply to Xavier Van Wijmeersch from comment #3)
> format in that dialog box need also to be ticket and then the date will be
> not a number

Ok, yes that aspect works. It's not clear why "Date & time" is not working alone though.

Finally, outstanding - why is it different to Shift+Ctrl+V from a TXT file?
Comment 5 Xavier Van Wijmeersch 2019-11-03 10:19:00 UTC 
The why is the shortcuts
with kde4 or kf5 the example Shift+Ctrl+V+t for transpose data is working in calc
but with gtk3 it does not, so i think with date&time the same
Shift+Ctrl+V does open the dialog past special and i need also to tick the transpose item
very annoying i know