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.89k stars 1.1k forks source link

Threaded comments created in spreadsheet editor are absent in downloaded XLSX document #1253

Open sk-esper opened 3 years ago

sk-esper commented 3 years ago

Do you want to request a feature or report a bug?

Bug

What is the current behavior?

Threaded comments created in the spreadsheet editor are not present when loading the document in other spreadsheet applications (Microsoft Excel, Open Office, etc)

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.

  1. Comment on a spreadsheet cell
  2. Add at least one reply to the comment
  3. Download the workbook as an XLSX document
  4. Open the spreadsheet in MS Excel, Apple Numbers, Open Office, etc

Cell comment in OnlyOffice: image

Cell comment in MS365 Excel: image

What is the expected behavior?

Threaded comments are present

Did this work in previous versions of DocumentServer?

Haven't tested

DocumentServer version:

Developer Edition 6.2.0-123

Operating System:

macOS Mojave 10.14.6

Document server running in docker using image onlyoffice/documentserver-de:6.2.0.123

Browser version:

Chrome 90.0.4430.93

Rita-Bubnova commented 3 years ago

Hello, @sk-esper. We know of this behavior. This happens because desktop MS Excel does not display threads comment. Threads comment are supported only on MS Office365 (Web Version). Now we have no solutions to this problem and I created a new issue 50369 in our private issue tracker to discuss with our team.

sk-esper commented 3 years ago

Interesting! To clarify, I am observing the issue in Office 365 (that's what my screenshot is from).

Looking at the raw XML files in the XLSX archive exported by OnlyOffice, I don't see the ThreadedComments block anywhere (as defined by the MS extensions to the OOXML SpreadsheetML format), which is how I would expect threaded comments to be exported. I do see the threaded comment content embedded in VML drawings, which could explain why importing the document back into OnlyOffice retains the threaded comments, but it appears that this is insufficient for the threaded comment to show up when opening the file with MS Excel 365 in the browser.