https://bugs.documentfoundation.org/show_bug.cgi?id=150062
Bug ID: 150062
Summary: Calc Csv import unable to import as date a column with
dash separator , ok with slash
Product: LibreOffice
Version: 7.3.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When importing a csv file with calc, you can specify import format for some
columns/fields of csv file.
>From version 7.3.x ( tested with 7.3.4 French), for a field formatted as
YYYY-MM-DD , even if you specify "date YMD", the import is made as text column.
It's ok with YYYY/MM/DD field ( slash separator instead of dash) or YYYY.MM.DD
(dot separator).
Regression , because it's was ok in version 7.2.7 ... and annoying because
YYYY-MM-DD is a very common date format while exporting from a database.
Language settings are the same in 7.3.4 and 7.2.7, especially "Date acceptance
patterns : D/M/Y;D/M;D.M.Y;D-M-Y"
Steps to Reproduce:
With import_dash.csv file attached to this bug report :
1. with open csv file with a date field formatted with dash separator
2. specify the field as date in the text import dialog
3. the field / column is imported as text
Actual Results:
2022-06-11
Expected Results:
11/06/2022 ( french date format, 'cause french version of Libreoffice.
Reproducible: Always
User Profile Reset: No
Additional Info:
Import process should be able to judge dash as a correct separator to import
date field ( was ok in version 7.2.7 and previous).
Version: 7.3.4.2 (x64) / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: en-GB
Calc: CL
( UI temporarily in en-GB to have english version of menu entry. )
--
You are receiving this mail because:
You are the assignee for the bug.
