ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
https://www.onlyoffice.com
GNU Affero General Public License v3.0
4.48k stars 1.04k forks source link

Imported xslx file notes have timestamps #2724

Open siaarzh opened 3 weeks ago

siaarzh commented 3 weeks ago

This issue is unique.

Operating System

Windows 10 / 8.1 / 7

Version information

8.0.1

Expected Behavior

MS Office and Google Docs have a "Add Note" feature that adds a "postIt"-type comment without a timestamp. When opening such files in OnlyOffice, any note SHOULD converted to a "comment thread" where:

Example, where I reopen the file in MS Office:

example-from-ms-office

Actual Behavior

MS Office and Google Docs have a "Add Note" feature that adds a "postIt"-type comment without a timestamp. When opening such files in OnlyOffice, any note is converted to a "comment thread" where:

Example, from current build:

example-from-current-build

Reproduction Steps

  1. Create XLS document in google docs or ms office
  2. Add a "note" to a cell (not a comment!)
  3. Save this file and reopen in OnlyOffice
  4. Note the timestamp on the "note" (TS1)
  5. Edit the "note", reply to the "note" (note those times as TS2 and TS3, respectively)
  6. Close and reopen the file after a couple of minutes
  7. Notice the "note"'s timestamp has changed to current time (when you opened the file) and that this time is always larger than TS1, TS2, and TS3 every time you open the file.
  8. Notice the comment button in the left menu has a yellow icon saying you have new comments. This is not true.

Additional information

No response

rsnegirev commented 3 weeks ago

Hi @siaarzh

I can confirm, this is the bug number 67904. When some fixes will be done we'll text you here in this issue.

And we're moving this issue to DocumentServer repo, since it's our base product and problem actual there too.

Thank you for the report!