Bug 103024 - Fileopen XML: Date format not recognized in a column and opened as general number (comment 6)
Summary: Fileopen XML: Date format not recognized in a column and opened as general nu...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Kohei Yoshida
: 86100 121572 (view as bug list)
Depends on:
Blocks: MSO-XML2003
  Show dependency treegraph
Reported: 2016-10-05 19:27 UTC by sthue100
Modified: 2019-09-02 08:29 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Problem xml (477.34 KB, text/xml)
2016-10-05 19:28 UTC, sthue100
Problem XML compared MSO LO (115.58 KB, image/png)
2019-08-19 09:14 UTC, Timur

Note You need to log in before you can comment on or make changes to this bug.
Description sthue100 2016-10-05 19:27:14 UTC
With an xml file downloaded from MarketScope (FXCM) the date is correct in the cell, but the time is always listed as 12:00 A.M. It usually takes 2 attempts to open the xml file with CALC. This works correctly with Excel.

Steps to Reproduce:
1.Open xml file with Calc

Actual Results:  
09/30/16 12:00 AM
09/30/16 12:00 AM
09/30/16 12:00 AM
09/30/16 12:00 AM

Expected Results:
09/30/16 12:00 AM
09/30/16 12:30 AM
09/30/16 1:00 AM
09/30/16 1:30 AM

Reproducible: Always

User Profile Reset: No, Happens on multiple machines

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143 Safari/537.36
Comment 1 sthue100 2016-10-05 19:28:37 UTC
Created attachment 127830 [details]
Problem xml
Comment 2 Jean-Baptiste Faure 2016-10-06 18:35:17 UTC
I reproduce the problem with LibreOffice and the master under Ubuntu 16.04 x86-64.

If you look inside the xml file with a text editor, you will see that this xml document says:
1/ the date & time format is "MM\/dd\/yyyy HH:mm:ss"
2/ the date & time values are in fact in the form 2016-09-30T13:00:00

Best regards. JBF
Comment 3 QA Administrators 2017-10-23 14:07:49 UTC Comment hidden (obsolete)
Comment 4 Jean-Baptiste Faure 2017-10-28 18:15:26 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2018-10-29 03:58:23 UTC Comment hidden (obsolete)
Comment 6 Timur 2018-11-01 18:00:02 UTC
Repro 6.0.
LO 6.1 opens column "Date" as general number (likely another issue) but when converted to Date, previews OK. 
So could set this one WFM and open a new bug, but let's just update it.
Comment 7 Timur 2018-11-01 18:01:41 UTC
Another example attachment 119140 [details] from Bug 94643
Comment 8 Timur 2018-11-21 13:42:55 UTC
*** Bug 121572 has been marked as a duplicate of this bug. ***
Comment 9 Timur 2018-11-21 13:43:25 UTC
*** Bug 86100 has been marked as a duplicate of this bug. ***
Comment 10 Timur 2019-08-19 09:14:22 UTC
Created attachment 153498 [details]
Problem XML compared MSO LO

Still repro with master~2019-08-15_22.57.26_LibreOfficeDev_6.4.0.0.alpha0_Win_x64
Comment 11 Kohei Yoshida 2019-08-29 12:58:02 UTC
The commit


should finally fix this.