Bug 132429 - CSV "Save cell contents as shown" Ignores Date Format
Summary: CSV "Save cell contents as shown" Ignores Date Format
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-04-26 10:19 UTC by flywire
Modified: 2020-04-28 01:13 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 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.