[Libreoffice-bugs] [Bug 130786] New: Bug in Text to Column function

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130786

            Bug ID: 130786
           Summary: Bug in Text to Column function
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: e688497 at urhen.com

Description:
Test Data (type TEXT):

Apr. 02, 2019, 12:34 PM
Apr. 04, 2019, 07:34 PM
Apr. 04, 2019, 07:34 PM
Apr. 25, 2019, 08:30 AM
Apr. 25, 2019, 09:56 PM
Apr. 26, 2019, 06:18 AM
May. 03, 2019, 01:00 PM
May. 21, 2019, 08:36 PM
May. 21, 2019, 08:41 PM
May. 21, 2019, 08:41 PM
May. 21, 2019, 09:01 PM
Jun. 03, 2019, 09:15 AM
Jun. 03, 2019, 03:18 PM
Jun. 03, 2019, 03:18 PM
Jun. 03, 2019, 03:18 PM
Jun. 04, 2019, 01:11 AM
Jun. 04, 2019, 01:11 AM
Jun. 04, 2019, 07:18 AM
Jun. 12, 2019, 08:45 AM


If the Text to column function is used on the above data with the column type
"US English" all the dates get converted correctly except May. Every cell
containing May is not converted at all

If "May" is changed to any other month in a text editor the conversion does
work.  

This also happens if converted from CSV. 

Steps to Reproduce:
1. Copy test data into new table ( use unformated text don't split)
2. select column and go to data -> text to column
3. select collumn with test data and select data type "US English" 

Actual Results:
43557,52
43559,82
43559,82
43580,35
43580,91
43581,26
May. 03, 2019, 01:00 PM
May. 21, 2019, 08:36 PM
May. 21, 2019, 08:41 PM
May. 21, 2019, 08:41 PM
May. 21, 2019, 09:01 PM
43619,39
43619,64
43619,64
43619,64
43620,05
43620,05


Expected Results:
I'm not converting this by hand.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes

-- 
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/20200219/5622b1ee/attachment.htm>