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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
