Bug 144181 - Date changed when copying sheet to new file
Summary: Date changed when copying sheet to new file
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.5.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-08-30 11:47 UTC by victor.fedlnx
Modified: 2021-08-30 19:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
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 victor.fedlnx 2021-08-30 11:47:13 UTC 
Description:
Copied sheet (from multisheet file) to file containing single sheet. Column with dates had 4 years added to all dates on new file.

Steps to Reproduce:
1.copy sheet
2.to new document
3.copy

Actual Results:
sheet copied but all dates increased by 4 years (day month OK)

Expected Results:
same date


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
file:///home/Vic_Lnx/Pictures/Screenshot_20210830_074417.png
Comment 1 Xisco Faulí 2021-08-30 12:09:20 UTC 
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 Mike Kaganski 2021-08-30 12:30:54 UTC 
(In reply to victor.fedlnx from comment #0)
> all dates increased by 4 years (day month OK)

Please check if the two files have the same value of Epoch (set at Options->Calc->Calculate, under "Date" group).
Comment 3 victor.fedlnx 2021-08-30 12:39:46 UTC 
Thx. That was the issue