Apache OpenOffice (AOO) Bugzilla – Issue 45177
Wrong editing time statistic reported in Word97/2000/XP *.doc files (HH:MM:SS instead of [HH]:MM:SS)
Last modified: 2017-05-20 11:25:40 UTC
If a word format file is opened in OOo writer, the editing time under the statistics window is not displayed correctly, i.e accordingly to the time reported under MSWord. Here's some example (TOTAL EDITING TIMES reported in properties.../general window): Word 2k Ooo writer 9008 minutes 06:08:00 8508 minutes 21:48:00 6787 minutes 17:07:00 8857 minutes 03:37:00 3757 minutes 14:37:00 4404 minutes 01:24:00 2295 minutes 14:15:00 You see that the last digit always match, the minute (0-59) count is correct. But whole hours doesn't match, as you see at the first line: 9000 minutes is 150 hours. It is probably not a problem of hour count being to short (2-digit), because it is broken even under 5999 minutes (99 hours and 59 minutes), although I think that two-digit hour count is too small - I have edocuments edited 150 hours and more, and it wasn't some over-intensive work. Now with low values the hour number matches. Note that the minute count is allways proper (I guess – the last digit is the same). 602 minutes 10:02:00 914 minutes 15:14:00 The revision numbers always match, on the other hand. I don't know if this happens with saving in *.sxw or *.odt format too, because I don't have any file in these format with sufficient editing time. (I found this defect in OOo versions 1.1.0, 1.1.2 and 1.9.77 (snapshot build), runing on win98 and win98SE systems. *.doc files were created in MS Office 2000 without any service packs).
MRU->MBA: this seem only be for documents with VERY long editing times. E.g. a document with 119 minutes in Word was correctly converted to 1:59 in OO Writer. I'll attach a document, where you can see this (it was taken from issue 4216). There the time in Word is 5754 minutes, in OO it has 23:54. Maybe OO has a wrong overflow when reaching 24 hours?
Created attachment 23932 [details] Mentioned document from issue 4216. Shows OO's problem with editing time
Bug also affects versions 1.1.4 and 1.9.100. When you save a *.doc file with too high editing time (sample counts mentioned above), the count drops to a lower value. Probably due to this same issue.
I think I understand this now. This issue must be caused by the import filter (or what does the editing time translation) - as odt format is not (apparently) affected - which I think nullifies the hour count when reaching 24 hours. Problem is, there is no day count that would reflect this. If there is one, pardon me, but it's not displayed. Anyway, open document files do have hour counts over 24 (even like 1025 - I checked) and (therefore) no day counter, so editing time count for *.doc files should be probably made the same. Here is table of editing time count translation from *.doc format into OOo. (I made it via adjusting the system time while "editing" in MS Word, than comparing in OOo) MSWORD* OOo* (minutes) (hours:minutes) 2881 -----) 00:01 (reality: 48:01) 2880 -----) 00:00 (reality: 48:00) 2879 -----) 23:59 (reality: 47:59) ... 1787 -----) 05:47 (reality: 29:47) ... 1441 -----) 00:01 (reality: 24:01) 1440 -----) 00:00 (reality: 24:00) Nullified, but day counter is missing. 1439 -----) 23:59 OK 1434 -----) 23:54 OK 1382 -----) 23:02 OK 1322 -----) 22:02 OK * Versions: MS WORD 2000; OOo 1.9.100 (brief-checked 1.1.0 and 1.1.4: seem to behave the same way) You see this issue is clearly caused by a day-count-feature idea being implemented somewhere. As stated before, I think this should be removed so that hour counter would be "the last" (as with *.odt files), of course it must not be limited to "0-24" then. Sadly, I can't fix it in the source code, I am no programer.
The defect stil present in 2.0 beta build 1.9.118. It also causes inconsistencies (wrong statistics) when importing to open document format.
This bug (conversion of editing time statistic with *.doc files) is still present in second beta build (1.9.125). However, I was wrong in asuming that open document format doesn't have day count in this statistic. This is stated in meta.xml of an opendocument file: <meta:editing-duration>P34DT0H24M53S</meta:editing-duration> In the statistics window, days are converted to hours (correctly).
extending summary so that it is clear what is wrong right from the beginning.. HH:MM:SS → 24-hour format [HH]:MM:SS → format that "does not wrap" correcting subcomponent since this is when loading a word-doc...
Reset assigne to the default "issues@openoffice.apache.org".