Bug 126640 - Date format is incorrect after copying & pasting
Summary: Date format is incorrect after copying & pasting
Status: RESOLVED DUPLICATE of bug 126581
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2019-07-31 14:40 UTC by andy2017
Modified: 2019-07-31 17:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description andy2017 2019-07-31 14:40:09 UTC
In cell A1, I entered 30/7. The date displayed is 30/07/19 as expected. I then copied row 1 and pasted it into row 2. I then change A2 to 31/7 and the date displayed is 31/07/2019. IE the formatting on A2 is different from the formatting on A1. If I look at the formatting on A1, it's a date, format 31/12/99. If I look at the formatting on A2, it's a date, format 31/12/1999 (ie a four digit date).
The format used to be copied as well as the cell contents until I upgraded to

Steps to Reproduce:
1. See description

Actual Results:
Formatting is not taken from A1 to A2.

Expected Results:
Format should be copied from A1 in the copy and paste as it used to.

Reproducible: Always

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 Oliver Brinzing 2019-07-31 17:06:09 UTC
i think this issue is also a duplicate of
Bug 126581 - FORMATTING - Date format default changes

*** This bug has been marked as a duplicate of bug 126581 ***