ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.65k stars 312 forks source link

Cells within Documents: Date/time tags with automatic update enabled are not updated when the document is opened #1482

Open v3DJG6GL opened 5 months ago

v3DJG6GL commented 5 months ago

This issue is unique.

Operating System

Windows 10 / 8.1 / 7

Version information

7.5.1

Expected Behavior

Regardless of the row or column: The date/time should be updated when the document is opened.

Actual Behavior

Only the date/time in the upper left cell is updated. All other date/time tags are not updated - although the Update automatically option is activated for all of them. In addition, the upper left cell that updates date/time, seems to catch the wrong time: If my local time is 17:03, the cell is updating the time to 4:03 PM (aka. 16:03). But as soon as i manually update the time field Context menu -> Update field, the time is set correctly to 5:03 PM (aka. 17:03). Maybe something related to daylight saving time...?

Document_Editor_Date-Time

Reproduction Steps

  1. Open a new docx Document and insert some cells with at least two rows.
  2. Insert Date & Time tags in all the cells with the option Update automatically activated.
  3. After saving & closing the document, only the upper (left) date tag gets updated, all other stay the same.

Additional information

No response

maruacat commented 4 months ago

Hello @v3DJG6GL!