[Libreoffice-bugs] [Bug 140840] New: libreoffice calc can't parse and convert dates in opened file

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: fanen.ahua at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210306/3a6dd18c/attachment.htm>