https://bugs.documentfoundation.org/show_bug.cgi?id=158625
--- Comment #11 from ady <[email protected]> --- (In reply to Guus Ellenkamp from comment #0) > Steps to Reproduce: > 1. Format cell to date format mm/dd/yy. > 2. Save file. > 3. Open file. > 4. Date changed back to mm-dd-yy. @Guus, I am trying to reproduce your steps using your attachment 191354 (an xlsx spreadsheet file), but I must be misunderstanding something. When I open attachment 191354 I see 2 worksheets. "Sheet2" has nothing relevant to this report. "Sheet1" has a list of dates. The cells containing the dates are already formatted as "MM/DD/YY" and are displayed accordingly, meaning that there is nothing to initially change or re-format (trying to follow your steps), but rather save the file "as-is" (using a different name). Saving the file with the same xlsx format (with a different name), closing and re-opening it, I still see the dates formatted as MM/DD/YY and displayed in the same way. So, there is no "Date changed back to mm-dd-yy" (and it never was). Perhaps we need more specific steps, and/or a different spreadsheet file. It is also possible that I am seeing different things than you are. Or maybe I am misunderstanding something. -- You are receiving this mail because: You are the assignee for the bug.
