https://bugs.documentfoundation.org/show_bug.cgi?id=140840
Bug ID: 140840
Summary: libreoffice calc can't parse and convert dates in
opened file
Product: LibreOffice
Version: 7.1.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
load a CSV with dates in an unconventional but obvious format.
It is not easy to recognise this field as a date and reformat it.
It should possible to when formatting a cell as date to specify the current
format that the source data is in and a desired target format.
For example, in a sheet with the following dates:
20070320
20070319
20070316
20070315
20070314
20070313
20070312
20070309
20070308
These are obvious to a human as "YYYYMMDD", but there is no obvious way to get
Calc to recognise and reformat these dates.
Steps to Reproduce:
1. create a new calc sheet with the following data in a column
20070320
20070319
20070316
20070315
20070314
20070313
20070312
20070309
20070308
2. attempt to convert (format cells) that into a date format in YYYY-MM-DD
format. It doesn't handle the date correctly
3.
Actual Results:
Convert the date into the desired format
Expected Results:
it converts it into an invalid date
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 16; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
