Description: 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 2. 3. 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
Created attachment 127830 [details] Problem xml
I reproduce the problem with LibreOffice 5.2.3.0+ 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
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Remove myself from CC: not interested anymore in issues with MS things. Best regards. JBF
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.
Another example attachment 119140 [details] from Bug 94643
*** Bug 121572 has been marked as a duplicate of this bug. ***
*** Bug 86100 has been marked as a duplicate of this bug. ***
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
The commit https://cgit.freedesktop.org/libreoffice/core/commit/?id=df2b4a9daa643e66b705a7b39d8988a3d97d731e should finally fix this.