Bug 75903 - FORMATTING: Copying a user defined date format results in wrong date
Summary: FORMATTING: Copying a user defined date format results in wrong date
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.5.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-08 05:20 UTC by kg6jhq
Modified: 2015-01-23 14:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
simple test case for bug 75903 (5.50 KB, application/vnd.ms-excel)
2014-03-08 17:29 UTC, kg6jhq
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kg6jhq 2014-03-08 05:20:31 UTC
Problem description: 
When copying a cell that has been formatted with a user defined format, when pasted to another cell that has that same format, the date is wrong.
Steps to reproduce:
1. Format a column of cells to a date format of MMM YY
2. Enter a date, for example 12/31/2013.  Note it displays correctly as Dec 13.
3. Select the cell and use ctrl-c to copy the contents.
4. Select a cell below and use ctrl-v to paste the contents.  The date displays as Dec 14.  And the value shows 12/13/2014.

Current behavior:
The date displays as Dec 14.  And the value shows as 12/13/2014.

Expected behavior:
Expect the same value e.g.: Dec 13, and the value should show as 12/31/2013.
       
Operating System: Windows 7
Version: 4.1.5.3 release
Comment 1 A (Andy) 2014-03-08 08:53:52 UTC
not reproducible with LO 4.2.1.1 (Win 8.1)

@Bug Reporter: Does this issue still also persist for you with the latest release of LO?
Comment 2 kg6jhq 2014-03-08 17:29:53 UTC
Created attachment 95363 [details]
simple test case for bug 75903
Comment 3 kg6jhq 2014-03-08 17:31:29 UTC
(In reply to comment #1)
> not reproducible with LO 4.2.1.1 (Win 8.1)
> 
> @Bug Reporter: Does this issue still also persist for you with the latest
> release of LO?

I downloaded v. 4.2.1.1 and tried again. Unfortunately, I got the same result. I attached my test worksheet to this bug. Thanks for looking at it.
Comment 4 m_a_riosv 2014-03-08 17:44:34 UTC
Hi kg6jhg, thanks for reporting.

Not reproducible with:
Win7x64Ultimate
Version: 4.1.6.0.0+ Build ID: 3ce626c81ac4a9b4b70c61d9fa576f6ae2c85c8

Please try resetting the user profiles, sometimes strange issues are resolved.
Comment 5 m_a_riosv 2014-03-08 17:47:16 UTC
I forgot the link about now to do it:
https://wiki.documentfoundation.org/UserProfile

If it doesn't resolve the issue, please can you inform what is your language for LibreOffice, and what is the time zone in your operating system.
Comment 6 kg6jhq 2014-03-08 19:49:48 UTC
Thank you for your troubleshooting suggestions.  I think I know what my problem was.  I was using a clipboard utility called ArsClip (http://www.joejoesoft.com/vcms/97/).  When I disabled this utility and tried to reproduce the problem, I was unable to do so.  Thanks so much for your time, I do appreciate it.