Bug 44089 - Calc FILEOPEN: Problem with opening file xml 2003 with DateTime value (data shown correctly, but time zeroed)
Summary: Calc FILEOPEN: Problem with opening file xml 2003 with DateTime value (data s...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium major
Assignee: Kohei Yoshida
Depends on:
Blocks: Cell-Formula MSO-XML2003
  Show dependency treegraph
Reported: 2011-12-23 00:49 UTC by StirLiZ
Modified: 2019-09-02 08:53 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

xml 2003 file with error (10.30 KB, text/xml)
2011-12-23 00:49 UTC, StirLiZ
xml compared MSO LO62 LO64+.png (239.42 KB, image/png)
2019-09-02 08:48 UTC, Timur

Note You need to log in before you can comment on or make changes to this bug.
Description StirLiZ 2011-12-23 00:49:47 UTC
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
Comment 1 sasha.libreoffice 2012-05-02 08:42:11 UTC
reproduced in 3.5.3 on Fedora 64 bit
Date in cells I4 and k4 shown correct, but time is zeroed.
Comment 2 thomas.nt 2012-08-07 07:54:45 UTC
reproduced in 3.5.5 on Windows 7 x86
Comment 3 mondane.woodworker 2012-08-22 08:29:04 UTC
reproduced in (build-id 932b512) on Windows XP x86
Comment 4 Peter 2012-09-28 15:45:02 UTC
Date/Time issue confirmed on Win7.
The date loads correctly but the time shows as 0:00
Comment 5 sasha.libreoffice 2012-09-29 06:03:39 UTC
@ 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.
Comment 6 Peter 2012-10-01 15:44:27 UTC
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.
Comment 7 QA Administrators 2015-01-05 17:52:15 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2015-01-28 13:36:56 UTC

Win 7 Pro 64-bit Version:
Build ID: 784d069cc1d9f1d6e6a4e543a278376ab483d1eb
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-25_23:07:36
Comment 9 Peter 2015-02-02 20:37:01 UTC
The bug is confirmed using Win 7 Home Premium SP1 64-bit with LibreOffice 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.
Comment 10 mondane.woodworker 2015-02-03 19:14:54 UTC
Confirmed on

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
Comment 11 Peter Jentsch 2015-02-08 23:16:10 UTC
time value gets cut off around line 6880 in file spreadsheetml2ooo.xsl in template "create-table-cell-attributes".
Comment 12 Marten Feldtmann 2017-06-22 18:58:19 UTC
Confirmed LibreOffice under Linux Ubuntu 16.04
Comment 13 Buovjaga 2017-06-23 09:44:08 UTC
(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?
Comment 14 Xisco Faulí 2017-09-22 07:47:05 UTC
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.
Comment 15 QA Administrators 2018-11-17 03:47:41 UTC Comment hidden (obsolete)
Comment 16 Peter 2018-12-10 14:31:15 UTC
Version: (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"
Comment 17 Kohei Yoshida 2019-08-29 12:56:29 UTC
This is now fixed after this commit:


which updates the orcus library to 0.15.2.  Both the truncation of time values and the display issue should be gone now.
Comment 18 Timur 2019-09-02 08:48:13 UTC
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".