Description: In a Calc spreadsheet, I have a column of dates with the entire column declared to use format MM/DD/YY. Adding a new line to the table with copy/paste, the new date is in format MM/DD/YYYY. Both the source cell, and the entire column containing both the source and destination, are declared to use format MM/DD/YY. I can edit the new cell format to be MM/DD/YY, but that gets annoying. This is relatively new behavior, but I'm not positive when it crept in; I've been putting up with it for a bit before reporting it. Steps to Reproduce: 1. Enter a date in a cell, e.g. 09/14/19. 2. Set the date format for the column of the cell to MM/DD/YY. 3. Copy the cell, then paste it into the cell just below it. Actual Results: The date in the new cell (target of paste) is 09/14/2019 Expected Results: The date in the new cell should be 09/14/19 Reproducible: Always User Profile Reset: No Additional Info:
there were some issues with date formats: Bug 126116 - Displayed form of date changes to dd-mm-yyyy when date is changed in cell with format dd-mm-yy should be fixed starting with LO 6.2.6 can you please try with LO 6.2.7?
The issue seems fixed in 6.2.7.1. Thank you. Sorry, I did search before opening the bug, just not well enough apparently. I will leave it to developers to close it as a duplicate, rather than mess things up trying to do it myself. Changing back to UNCONFIRMED as requested by the note.
*** This bug has been marked as a duplicate of bug 126116 ***