Bug 100961 - After inserting Fixed Date, and saving in DOC format, the date is not fixed anymore
Summary: After inserting Fixed Date, and saving in DOC format, the date is not fixed a...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, filter:doc, filter:docx, regression
: 107533 (view as bug list)
Depends on:
Blocks: DOCX DOC Fields
  Show dependency treegraph
 
Reported: 2016-07-17 05:06 UTC by Steve Guss
Modified: 2019-01-05 08:28 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
A DOC with const date and time fields saved with Word 2003 (19.50 KB, application/msword)
2019-01-05 08:28 UTC, Mike Kaganski
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Steve Guss 2016-07-17 05:06:04 UTC
User-Agent:       Mozilla/5.0 (Windows NT 10.0; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0
Build Identifier: LibreOffice 5.1.3.2

Running in Windows 10 64 bit I insert a date using the fixed date field using the full day, month, date, year it inserts the date, but when I open the document a week later it shows that date rather then the original date. ie:
Date when inserted - Sunday, July 3, 2016.
Date when opened one week later - Sunday, July 10, 2016
This document is saved twice in .DOC and .ODT formats. It happens in both documents.

Reproducible: Always

Steps to Reproduce:
1.<Insert>
2.<Field>
3.<More Fields>
4.Document Tab, Type=Date, Select=Date (Fixed) Format=Friday, December 31, 1999, Offset in Days=0
Actual Results:  
The date of the current date is inserted in this case Sunday, July, 3, 2016.  

Expected Results:  
It should have remained Sunday, July 3, 2016, when I opened the document a week (7 days) later.  Instead the date read Sunday, July 10, 2016.  

[Information automatically included from LibreOffice]
Locale: en-US
Module: TextDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes


Reset User Profile?No
Comment 1 Steve Guss 2016-07-17 05:10:53 UTC
It inserts a dynamic date instead of a fixed date
Comment 2 MM 2016-07-18 19:16:50 UTC
Unconfirmed with v5.1.5.1 under windows 7 x64.

Fixed date stays fixed. Maybe you wanna try a newer version and let us know if it's fixed or not....
Comment 3 Aron Budea 2016-07-18 23:18:39 UTC
I can't reproduce it, either (LibreOffice 5.1.4.2 / Windows 7), I tested with changing the system date manually. Could you upload a minimal example with a fixed date? Then we could easily see days later what happens with the date field.
Comment 4 Aron Budea 2016-07-20 07:59:34 UTC
Someone just commented this in a different bug: https://bugs.documentfoundation.org/show_bug.cgi?id=63535#c7

It seems the fixed date becomes just date when saved in DOC, then if saved back to ODT, it won't be fixed. I can confirm this part of the bug.
However if you keep ODT format, the date remains fixed for me. What was the process you saved to DOC and ODT?
Comment 5 Aron Budea 2016-07-21 07:52:52 UTC
Some additional experience with DOCX format:
"I tried again with two new documents in .docx (WW 2017-2013 and Open XML). It is was almost good, but French date month is converted to English :
"21 juillet 2016" come back to "21 July 2016" in "Date (fixed)"."
https://bugs.documentfoundation.org/show_bug.cgi?id=63535#c11
Comment 6 Steve Guss 2016-07-21 13:22:38 UTC
This is a weekly report kept for a year.  It has been around for years.  Every year I delete all but one page, delete the weekly data, leave the headings and insert the new date.  It is then saved in both the .DOC and .ODT format (I got zapped by ransomware so I use .DOC for aharing and .ODT in hopes that if it happens again it won't zap that).

I will create two new documents one .Doc one .ODT wait a day or two see what happens and then cross save to see what happens.  I'll report back next week.
Comment 7 Aron Budea 2016-07-30 04:55:15 UTC
Setting to NEW, as the issue has been reproduced.
So there are two, closely related issues:
-fixed date is not fixed anymore when exported to DOC,
-fixed date can come back in different language when exported to DOCX.
Comment 8 Telesto 2016-11-27 10:43:41 UTC
(In reply to Aron Budea from comment #7)
> Setting to NEW, as the issue has been reproduced.
> So there are two, closely related issues:
> -fixed date is not fixed anymore when exported to DOC,
> -fixed date can come back in different language when exported to DOCX.

Confirming with:
Version: 5.3.0.0.beta1
Build ID: 690f553ecb3efd19143acbf01f3af4e289e94536
CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; Layout Engine: new; 
Locale: nl-NL (nl_NL); Calc: C
Comment 9 V Stuart Foote 2017-05-01 20:41:37 UTC
*** Bug 107533 has been marked as a duplicate of this bug. ***
Comment 10 Telesto 2017-06-14 18:28:26 UTC
About fixed date is not fixed anymore when exported to DOC

Repro with
Version: 5.5.0.0.alpha0+
Build ID: 076ed447f694239d5c67adee528ea6e471d909ff
CPU threads: 4; OS: Windows 6.19; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-06-09_23:54:20
Locale: en-US (nl_NL); Calc: CL

and with
Version: 5.0.2.2
Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe-GL
Locale: en-US (nl_NL)

but not with 
Versie: 4.4.6.3 
Build ID: e8938fd3328e95dcf59dd64e7facd2c7d67c704d
Locale: nl_NL
Comment 11 Buovjaga 2018-05-23 17:16:08 UTC
(In reply to Telesto from comment #10)
> but not with 
> Versie: 4.4.6.3 
> Build ID: e8938fd3328e95dcf59dd64e7facd2c7d67c704d
> Locale: nl_NL

With 4.4.7 and 4.3.0, the field turns into regular text when exporting to DOC, so I would not call this a regression. Am I missing something? Can someone share a DOC created with pre-5.0 that shows a working fixed date field?
Comment 12 Aron Budea 2018-11-14 05:28:48 UTC
I checked what's possible in Word, and it appears Word inserts fixed dates as a piece of text, and nothing else. Perhaps it's just an unsupported type in DOC formats. However, in that case possibly the old behavior was the correct one, which turned fixed dates into a piece of text - the fieldness is removed, but the date remains fixed.
Comment 13 Mike Kaganski 2019-01-05 01:32:35 UTC
(In reply to Aron Budea from comment #12)
> I checked what's possible in Word, and it appears Word inserts fixed dates
> as a piece of text, and nothing else. Perhaps it's just an unsupported type
> in DOC formats. However, in that case possibly the old behavior was the
> correct one, which turned fixed dates into a piece of text - the fieldness
> is removed, but the date remains fixed.

Saving a test document to DOCX results in correct roundtrip (wrt this specific issue that is about const-ness of fields); Word also opens the generated DOCX with fields in it, having const values. Then, you can save the DOCX to DOC using Word, and get a DOC with const fields - so the DOC format supports the const date/time fields. But opening the resulting DOC (generated by Word) using LO gives non-const date/time fields - so it's at least import filter issue.
Comment 14 Mike Kaganski 2019-01-05 08:28:29 UTC
Created attachment 148057 [details]
A DOC with const date and time fields saved with Word 2003