Bug 132429

Summary: CSV "Save cell contents as shown" Ignores Date Format
Product: LibreOffice Reporter: flywire <flywire0>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INVALID    
Severity: normal CC: himajin100000, miguelangelrv
Priority: medium    
Version: 6.4.1.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=106678
Whiteboard:
Crash report or crash signature: Regression By:

Description flywire 2020-04-26 10:19:23 UTC 
Issue: The 2 digit year in the date is being saved in the csv as a 4 digit year.

To reproduce:

In cell A1 Enter 25/04/2020
format, cells, date, format as dd/mm/yy
File, Save As, Save as type Text CSV (*.csv)

Export Text File (Tried both ticked and unticked options for 'Save cell content as shown'.)

Saved as 25/04/2020, want 25/04/20
Comment 1 m_a_riosv 2020-04-26 11:03:50 UTC 
Please attach a sample documento for test.
Comment 2 flywire 2020-04-26 12:16:34 UTC 
It's an interface issue. Data entry in one cell as shown in first post.
Comment 3 QA Administrators 2020-04-27 03:42:42 UTC Comment hidden (obsolete)
Comment 4 Eike Rathke 2020-04-28 01:05:49 UTC 
Can't reproduce, saves fine with a 2-digits year if "as shown" is checked and 4-digits year if not. Tried with 6.2 and 6.4 on Linux.