Created attachment 54740 [details] xml 2003 file with error I have a problem with cells I4 and k4. I wrote a DateTime value in thees Cells. But, when I try to open this file, I can see the Time Path of DateTime value in cells I4 and k4
reproduced in 3.5.3 on Fedora 64 bit Date in cells I4 and k4 shown correct, but time is zeroed.
reproduced in 3.5.5 on Windows 7 x86
reproduced in 3.6.0.4 (build-id 932b512) on Windows XP x86
Date/Time issue confirmed on 3.5.6.2 Win7. The date loads correctly but the time shows as 0:00
@ Peter Thanks for interesting in this bug. Please, do not change picker's settings. "Version" for example, means most early version of LO where bug reproduced. Not current version. Changing back to 3.4.4 release.
Our application consists of a graphing program that is capable of exporting date/time stamped data in multiple columns for further analysis by other software. The time-of-day component of the date/time is critical to this task. Currently this system has only the LO spreadsheet application installed for the purpose of reading the Excel file. I will have to identify and install other software for this task if I can't get LO to work by the time this application goes into production. It looks like the DateTime component uses date/time format in ISO 8601 which is well documented and should be relatively simple to parse.
** 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 on a currently supported version of LibreOffice (4.3.5 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) Thank you for your help! -- The LibreOffice QA Team
Confirmed. Win 7 Pro 64-bit Version: 4.5.0.0.alpha0+ Build ID: 784d069cc1d9f1d6e6a4e543a278376ab483d1eb TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-25_23:07:36
The bug is confirmed using Win 7 Home Premium SP1 64-bit with LibreOffice 4.4.0.3. The date is correct but the time is 0:00 for all entries. Opening the same file in MS office does display the correct time of day.
Confirmed on Versie: 4.4.0.3 Build ID: 40m0(Build:3) Locale: nl_NL OS: Linux 3.16.0-30-generic x86_64 Description: Ubuntu 14.10 Release: 14.10 Codename: utopic
time value gets cut off around line 6880 in file spreadsheetml2ooo.xsl in template "create-table-cell-attributes".
Confirmed LibreOffice 5.1.6.2 under Linux Ubuntu 16.04
(In reply to Peter Jentsch from comment #11) > time value gets cut off around line 6880 in file spreadsheetml2ooo.xsl in > template "create-table-cell-attributes". Peter: this report is assigned to you. Are you still going to work on a fix?
Hello Peter Jentsch, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
** 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
Version: 6.1.3.2 (x64) Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: en-CA (en_CA); Calc: group threaded In LO, Cell I4 displays as "40891.661377". In Excel Version 1811 (Build 11029.20079) the same cell displays in a date format "2011-12-14 15:52"
This is now fixed after this commit: https://cgit.freedesktop.org/libreoffice/core/commit/?id=df2b4a9daa643e66b705a7b39d8988a3d97d731e which updates the orcus library to 0.15.2. Both the truncation of time values and the display issue should be gone now.
Created attachment 153815 [details] xml compared MSO LO62 LO64+.png I guess this is OK now. Date format is different but in XML I see only "General Date".