search

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

Spreadsheet add comment, after local office edit,then open by onlyoffice agian, comment show tc={xxxxxxx} and increase by comment times #2720

Open kingsleyooo1 opened 3 weeks ago

kingsleyooo1 commented 3 weeks ago

This issue is unique.

Operating System of DocumentServer

Docker

Version information

8.0.0.99

Expected Behavior

issue: Spreadsheet add comment, after local office edit,then open by onlyoffice agian, comment show tc={xxxxxxx} and increase by comment times

image

Except: Show normal, not code"tc={xxxx}"

Actual Behavior

onlyoffice comment, can not be edit by local office ,otherwise can not show user correctly.

But if not edit by local ,it will show normal

Reproduction Steps

  1. open by SpreadsheetEditor and add comment
  2. downloas as xlsx to local computer and editor by local office tool
  3. open by SpreadsheetEditor again then user show tc={xxxxxx}
  4. add another cell comment, repeat step 2，then show tx={xxxxx},tx={xxxxx2}...

Additional information

i think most of onlyoffice version(7.0~8.0) have this issue

kingsleyooo1 commented 3 weeks ago

image

rsnegirev commented 3 weeks ago

Hi @kingsleyooo1

I tried reproduce this behavior but without any problems like yours. Maybe you can send a file example?

kingsleyooo1 commented 3 weeks ago

Hi @kingsleyooo1

I tried reproduce this behavior but without any problems like yours. Maybe you can send a file example?

Hi @Rita-Bubnova could you see the gif, i reproduce this behavior reproduce-behavior

【Behavior】 https://github.com/ONLYOFFICE/DocumentServer/assets/50653996/6c7d6234-6526-4f09-a77b-2d15444a3198

kingsleyooo1 commented 3 weeks ago

Hi @rsnegirev 3221 (1) (1).xlsx 3221 (1).xlsx 3221.xlsx

the issue looks like ：After WPS or Microsoft office edit ,the data format has changed， Onlyoffice comment Unable to recognize the comment user then show tc={xxxx}

And because of comment by onlyoffice ,the code will parse data by onlyoffice format ,But it can‘t be parse (I guess ^_^)

kingsleyooo1 commented 3 weeks ago

Hi ,Any update

rsnegirev commented 2 weeks ago

Hi @kingsleyooo1

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

Thank you for the report!