Page 1 of 1

Spreadsheet locks updated cells

Posted: Wed Mar 24, 2021 7:37 pm
by michalcharvat
Do you have any hint what's wrong when spreadsheet locks updated cells for user who just modified the cell? I dont see in log any error or any requests to CRM server. Editor is in autosave mode. However I tried switch the configuration to forceSave but the result is the same. Also the strange thing is save button is always enabled even there are no changes. The same problem is with images in document editor.

Code: Select all

[2021-03-24T19:27:05.376] [DEBUG] nodeJS - postData request: docId = 1511616613468;url = http://192.168.1.21/groupoffice/onlyoffice/file/151?token=605a3742962605e6f234f48618f6d30ad702f4d6e5a81&type=track;data = {"key":"1511616613468","status":1,"users":["1"],"actions":[{"type":1,"userid":1}]}
[2021-03-24T19:27:05.471] [DEBUG] nodeJS - postData response: docId = 1511616613468;data = {"error":0,"status":"success"}
[2021-03-24T19:27:05.475] [DEBUG] nodeJS - sendData: docId = 1511616613468;type = authChanges
[2021-03-24T19:27:05.477] [DEBUG] nodeJS - sendData: docId = 1511616613468;type = auth
[2021-03-24T19:27:05.477] [DEBUG] nodeJS - Start command: docId = 1511616613468 {"withAuthorization":true,"c":"open","id":"1511616613468","userid":1,"format":"xlsx","url":"http://192.168.1.21/groupoffice/onlyoffice/file/download/151?token=605a3742962605e6f234f48618f6d30ad702f4d6e5a81","title":"file.xlsx","nobase64":true}
[2021-03-24T19:27:05.483] [DEBUG] nodeJS - Response command: docId = 1511616613468 {"type":"open","status":"ok","data":{"Editor.bin":"http://192.168.1.45/cache/files/1511616613468/Editor.bin/Editor.bin?md5=QhYc07DNwsm-Ag8b2_JBmw&expires=1619206026&disposition=attachment&filename=Editor.bin","media/image1.png":"http://192.168.1.45/cache/files/1511616613468/media/image1.png/image1.png?md5=DngDcD1swe9_osKYGPEBJA&expires=1619206026&disposition=attachment&filename=image1.png"}}
[2021-03-24T19:27:05.484] [DEBUG] nodeJS - sendData: docId = 1511616613468;type = documentOpen
[2021-03-24T19:27:05.484] [DEBUG] nodeJS - End command: docId = 1511616613468
[2021-03-24T19:27:07.919] [DEBUG] nodeJS - Start saveFromChanges: docId = 1511616613468
[2021-03-24T19:27:07.922] [DEBUG] nodeJS - saveFromChanges status mismatch: docId = 1511616613468; row: 1; 0; expected: 1622915
[2021-03-24T19:27:08.344] [INFO] nodeJS - data.type = unLockDocument id = 1511616613468
[2021-03-24T19:27:19.201] [INFO] nodeJS - data.type = getLock id = 1511616613468
[2021-03-24T19:27:19.202] [INFO] nodeJS - getLock docid: 1511616613468
[2021-03-24T19:27:19.202] [DEBUG] nodeJS - sendData: docId = 1511616613468;type = getLock
[2021-03-24T19:27:20.226] [INFO] nodeJS - data.type = isSaveLock id = 1511616613468
[2021-03-24T19:27:20.226] [DEBUG] nodeJS - isSaveLock: docId = 1511616613468; lockRes: true
[2021-03-24T19:27:20.227] [DEBUG] nodeJS - sendData: docId = 1511616613468;type = saveLock
[2021-03-24T19:27:20.232] [INFO] nodeJS - data.type = saveChanges id = 1511616613468
[2021-03-24T19:27:20.232] [INFO] nodeJS - Start saveChanges docid: 1511616613468; reSave: undefined
[2021-03-24T19:27:20.235] [INFO] nodeJS - saveChanges docid: 1511616613468 ; deleteIndex: -1 ; startIndex: 15 ; length: 1
[2021-03-24T19:27:20.239] [DEBUG] nodeJS - sendData: docId = 1511616613468;type = unSaveLock

Re: Spreadsheet locks updated cells

Posted: Wed Apr 07, 2021 4:36 pm
by Alexandre
Hello michalcharvat.
There’re no errors in provided log. Please provide us with detailed description about your issue scenario. What exactly are the difficulties and what do you want to achieve?