When Saving ODS with comment, cell is lost and comment move one column to the right

[cpot]

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

BUG (CRITICAL)

What is the current behavior?

When Saving ODS with comment, cell is lost and comment move one column to the right

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

1. create an ods file with a cell with content and a comment in Libreoffice or Office (or use attached file)
2. open it in Onlyoffice 7.1 and save it
3. cell content has been deleted and comment has moved 1 column to the right

What is the expected behavior?

Cell is not deleted and comment stays in the cell

Did this work in previous versions of DocumentServer?

Don't know

DocumentServer version:

7.1

Operating System:

ALL

Browser version:

Firefox 103 and all other, Desktop version also

[cpot]

here is the test file Issue with Comments in ODS.ods

[Rita-Bubnova]

Hello @cpot. Thank you for report. I can confirm, this is bug - issue 58769 in our private issue tracker.

[Rita-Bubnova]

This issue fixed (https://github.com/ONLYOFFICE/core/commit/27ea7c9ffc29e2c1012bf08ce552407d2c3ee4dd) in future major release.

[ShockwaveNN]

DocumentServer v7.2 is released. This issue should be fixed

Feel free to comment or reopen it if you got further questions

[cpot]

Problem still occur in 7.2.1 please reopen

[Rita-Bubnova]

Problem still occur in 7.2.1 please reopen

Sorry, I can't reproduce this problem in version 7.2.1.34 (Windows 11, Chrome 07.0.5304.107). I use your file "Issue.with.Comments.in.ODS.ods". Could you attach a video with a demonstration problem?

[cpot]

sorry, error on our side, it is fixed