Large spreadsheet fails to load, is there a timeout?

In my nextcloud installation which uses a standalone CODE instance (not the Nextcloud built-in) most spreadsheets open fine. However, on spreadsheet always fails to open. This spreadsheet is quite complex with many interlinked formulas. It opens fine in Libreoffice locally. Is it possible that there is some kind of timeout happening when I try to open it? If so, can I adjust this to make it bigger to see if this solves the issue?

Hi @crobar thanks for reporting this. Let’s try to gather some info:

  • What’s your CODE and Nextcloud version?
  • Could you please paste here what you see in your web browser console (F12Console)
  • Also could you upload that spreadsheet document? (so we can test it?)

Nextcloud 24.0.3
Nextcloud Office 6.2.0
CODE 22.05.5-2

CODE is installed on the same machine as the Nextcloud instance.

Console log from Chromium below. Generated by navigating to the folder containing the spreadsheet in the Files app, then clearing the console and clicking on the file.

Unfortunately I can’t share the spreadsheet publicly, I could maybe share privately.

+
VM427:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
_onClickFile @ merged-index.js?v=a212353c-50:4936
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
_onClickFile @ merged-index.js?v=a212353c-50:4947
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
_onClickFile @ merged-index.js?v=a212353c-50:4947
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
getActions @ merged-index.js?v=a212353c-50:3108
getDefaultFileAction @ merged-index.js?v=a212353c-50:3204
getCurrentDefaultFileAction @ merged-index.js?v=a212353c-50:3176
_onClickFile @ merged-index.js?v=a212353c-50:4954
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
getActions @ merged-index.js?v=a212353c-50:3112
getDefaultFileAction @ merged-index.js?v=a212353c-50:3204
getCurrentDefaultFileAction @ merged-index.js?v=a212353c-50:3176
_onClickFile @ merged-index.js?v=a212353c-50:4954
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
getActions @ merged-index.js?v=a212353c-50:3121
getDefaultFileAction @ merged-index.js?v=a212353c-50:3204
getCurrentDefaultFileAction @ merged-index.js?v=a212353c-50:3176
_onClickFile @ merged-index.js?v=a212353c-50:4954
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
getActions @ merged-index.js?v=a212353c-50:3127
getDefaultFileAction @ merged-index.js?v=a212353c-50:3204
getCurrentDefaultFileAction @ merged-index.js?v=a212353c-50:3176
_onClickFile @ merged-index.js?v=a212353c-50:4954
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
_notifyUpdateListeners @ merged-index.js?v=a212353c-50:2967
action @ merged-index.js?v=a212353c-50:3020
_onClickFile @ merged-index.js?v=a212353c-50:4957
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
elementToFile @ merged-index.js?v=a212353c-50:5411
fileList.elementToFile @ merged-index.js?v=a212353c-50:12420
e.elementToFile @ share.js:115
e.elementToFile @ filesplugin.js:129
getModelForFile @ merged-index.js?v=a212353c-50:4657
Ca @ FilesActionHandler.js:35
action @ merged-index.js?v=a212353c-50:3023
_onClickFile @ merged-index.js?v=a212353c-50:4957
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
_notifyUpdateListeners @ merged-index.js?v=a212353c-50:2967
action @ merged-index.js?v=a212353c-50:3026
_onClickFile @ merged-index.js?v=a212353c-50:4957
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
_onClickFile @ merged-index.js?v=a212353c-50:4965
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
ConsoleLogger.js:33 [INFO] viewer: Opening viewer for file  {app: 'viewer', uid: 'rcrozier', path: '/REOS-SHARED/Financial/Management Accounts and Projections/Projections Master Template v2.xlsx'}
[Violation] Forced reflow while executing JavaScript took 48ms
ConsoleLogger.js:29 [DEBUG] viewer: Fetching additional files... {app: 'viewer', uid: 'rcrozier'}
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
elementToFile @ merged-index.js?v=a212353c-50:5411
fileList.elementToFile @ merged-index.js?v=a212353c-50:12420
e.elementToFile @ share.js:115
e.elementToFile @ filesplugin.js:129
getModelForFile @ merged-index.js?v=a212353c-50:4657
(anonymous) @ Office.vue:178
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
z @ collabora.js:48
i @ collabora.js:48
Promise.then (async)
z @ collabora.js:48
i @ collabora.js:48
Promise.then (async)
z @ collabora.js:48
i @ collabora.js:48
(anonymous) @ collabora.js:48
(anonymous) @ collabora.js:48
mounted @ Office.vue:162
We @ vue.runtime.esm.js:1863
un @ vue.runtime.esm.js:4235
insert @ vue.runtime.esm.js:3158
_ @ vue.runtime.esm.js:6390
bo.nodeOps @ vue.runtime.esm.js:6609
e._update @ vue.runtime.esm.js:3963
r @ vue.runtime.esm.js:4081
bn.get @ vue.runtime.esm.js:4495
bn.run @ vue.runtime.esm.js:4570
An @ vue.runtime.esm.js:4326
(anonymous) @ vue.runtime.esm.js:1989
et @ vue.runtime.esm.js:1915
Promise.then (async)
Ke @ vue.runtime.esm.js:1942
it @ vue.runtime.esm.js:1999
(anonymous) @ vue.runtime.esm.js:4418
bn.update @ vue.runtime.esm.js:4560
de.notify @ vue.runtime.esm.js:730
set @ vue.runtime.esm.js:1055
Cn.set @ vue.runtime.esm.js:4644
(anonymous) @ Viewer.vue:386
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
Ka @ Download.vue?b226:19
a @ Download.vue?b226:19
Promise.then (async)
Ka @ Download.vue?b226:19
a @ Download.vue?b226:19
(anonymous) @ Download.vue?b226:19
(anonymous) @ Download.vue?b226:19
openFile @ Viewer.vue:344
file @ Viewer.vue:256
We @ vue.runtime.esm.js:1863
bn.run @ vue.runtime.esm.js:4584
An @ vue.runtime.esm.js:4326
(anonymous) @ vue.runtime.esm.js:1989
et @ vue.runtime.esm.js:1915
Promise.then (async)
Ke @ vue.runtime.esm.js:1942
it @ vue.runtime.esm.js:1999
(anonymous) @ vue.runtime.esm.js:4418
bn.update @ vue.runtime.esm.js:4560
de.notify @ vue.runtime.esm.js:730
set @ vue.runtime.esm.js:1055
value @ Viewer.js:183
Ca @ FilesActionHandler.js:40
action @ merged-index.js?v=a212353c-50:3023
_onClickFile @ merged-index.js?v=a212353c-50:4957
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
capabilities.js:35 OC.getCapabilities is deprecated and will be removed in Nextcloud 21. See @nextcloud/capabilities
getCapabilities @ capabilities.js:35
(anonymous) @ Office.vue:201
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
z @ collabora.js:48
i @ collabora.js:48
(anonymous) @ collabora.js:48
(anonymous) @ collabora.js:48
load @ Office.vue:190
(anonymous) @ Office.vue:184
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
z @ collabora.js:48
i @ collabora.js:48
Promise.then (async)
z @ collabora.js:48
i @ collabora.js:48
Promise.then (async)
z @ collabora.js:48
i @ collabora.js:48
(anonymous) @ collabora.js:48
(anonymous) @ collabora.js:48
mounted @ Office.vue:162
We @ vue.runtime.esm.js:1863
un @ vue.runtime.esm.js:4235
insert @ vue.runtime.esm.js:3158
_ @ vue.runtime.esm.js:6390
bo.nodeOps @ vue.runtime.esm.js:6609
e._update @ vue.runtime.esm.js:3963
r @ vue.runtime.esm.js:4081
bn.get @ vue.runtime.esm.js:4495
bn.run @ vue.runtime.esm.js:4570
An @ vue.runtime.esm.js:4326
(anonymous) @ vue.runtime.esm.js:1989
et @ vue.runtime.esm.js:1915
Promise.then (async)
Ke @ vue.runtime.esm.js:1942
it @ vue.runtime.esm.js:1999
(anonymous) @ vue.runtime.esm.js:4418
bn.update @ vue.runtime.esm.js:4560
de.notify @ vue.runtime.esm.js:730
set @ vue.runtime.esm.js:1055
Cn.set @ vue.runtime.esm.js:4644
(anonymous) @ Viewer.vue:386
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
Ka @ Download.vue?b226:19
a @ Download.vue?b226:19
Promise.then (async)
Ka @ Download.vue?b226:19
a @ Download.vue?b226:19
(anonymous) @ Download.vue?b226:19
(anonymous) @ Download.vue?b226:19
openFile @ Viewer.vue:344
file @ Viewer.vue:256
We @ vue.runtime.esm.js:1863
bn.run @ vue.runtime.esm.js:4584
An @ vue.runtime.esm.js:4326
(anonymous) @ vue.runtime.esm.js:1989
et @ vue.runtime.esm.js:1915
Promise.then (async)
Ke @ vue.runtime.esm.js:1942
it @ vue.runtime.esm.js:1999
(anonymous) @ vue.runtime.esm.js:4418
bn.update @ vue.runtime.esm.js:4560
de.notify @ vue.runtime.esm.js:730
set @ vue.runtime.esm.js:1055
value @ Viewer.js:183
Ca @ FilesActionHandler.js:40
action @ merged-index.js?v=a212353c-50:3023
_onClickFile @ merged-index.js?v=a212353c-50:4957
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
index.js:46 No OC found
getLanguage @ index.js:46
value @ gettext.js:45
26932 @ l10n.js:3
a @ bootstrap:19
13084 @ legacy-loader.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
index.es.js:2337 Proxying an event bus of version 2.1.1 with 1.3.0
t @ index.es.js:2337
70903 @ index.es.js:3314
a @ bootstrap:19
71894 @ requesttoken.js:11
a @ bootstrap:19
22200 @ index.js:25
a @ bootstrap:19
13084 @ index.js:323
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
jquery-migrate.min.js:2 JQMIGRATE: Migrate is installed, version 3.4.0
index.es.js:2337 Proxying an event bus of version 2.1.1 with 1.3.0
t @ index.es.js:2337
70903 @ index.es.js:3314
n @ bootstrap:19
71894 @ requesttoken.js:11
n @ bootstrap:19
22200 @ index.js:25
n @ bootstrap:19
(anonymous) @ make namespace object:6
(anonymous) @ document.js:628
(anonymous) @ document.js:628
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
(anonymous) @ document.js:87
(anonymous) @ document.js:628
(anonymous) @ document.js:628
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
(anonymous) @ document.js:603
(anonymous) @ document.js:628
(anonymous) @ document.js:628
script?v=1:133 Uncaught TypeError: Cannot read properties of null (reading 'parentNode')
    at script?v=1:133:23
    at script?v=1:136:7
(anonymous) @ script?v=1:133
(anonymous) @ script?v=1:136
session-heartbeat.js:103 session heartbeat polling started
postMessage.tsx:57 PostMessageService.sendPostMessage parent loading
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
initSession @ document.js:521
(anonymous) @ document.js:619
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
initSession @ document.js:523
(anonymous) @ document.js:619
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
document.js:220 Waiting for page to render…
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
onStartup @ document.js:503
(anonymous) @ document.js:626
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
postMessage.tsx:57 PostMessageService.sendPostMessage parent loading
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
showEditor @ document.js:230
(anonymous) @ document.js:219
setTimeout (async)
showEditor @ document.js:219
loadDocument @ document.js:531
(anonymous) @ document.js:526
l @ jquery.js:3500
add @ jquery.js:3559
initSession @ document.js:525
(anonymous) @ document.js:619
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
showEditor @ document.js:232
(anonymous) @ document.js:219
setTimeout (async)
showEditor @ document.js:219
loadDocument @ document.js:531
(anonymous) @ document.js:526
l @ jquery.js:3500
add @ jquery.js:3559
initSession @ document.js:525
(anonymous) @ document.js:619
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
url.js:39 [getWopiUrl] https://nextcloud.reoptimizesystems.com/index.php/apps/richdocuments/wopi/files/635217_ocgcv9nemegb
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
showEditor @ document.js:251
(anonymous) @ document.js:219
setTimeout (async)
showEditor @ document.js:219
loadDocument @ document.js:531
(anonymous) @ document.js:526
l @ jquery.js:3500
add @ jquery.js:3559
initSession @ document.js:525
(anonymous) @ document.js:619
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
showEditor @ document.js:251
(anonymous) @ document.js:219
setTimeout (async)
showEditor @ document.js:219
loadDocument @ document.js:531
(anonymous) @ document.js:526
l @ jquery.js:3500
add @ jquery.js:3559
initSession @ document.js:525
(anonymous) @ document.js:619
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
showEditor @ document.js:254
(anonymous) @ document.js:219
setTimeout (async)
showEditor @ document.js:219
loadDocument @ document.js:531
(anonymous) @ document.js:526
l @ jquery.js:3500
add @ jquery.js:3559
initSession @ document.js:525
(anonymous) @ document.js:619
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
showEditor @ document.js:258
(anonymous) @ document.js:219
setTimeout (async)
showEditor @ document.js:219
loadDocument @ document.js:531
(anonymous) @ document.js:526
l @ jquery.js:3500
add @ jquery.js:3559
initSession @ document.js:525
(anonymous) @ document.js:619
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
showEditor @ document.js:333
(anonymous) @ document.js:219
setTimeout (async)
showEditor @ document.js:219
loadDocument @ document.js:531
(anonymous) @ document.js:526
l @ jquery.js:3500
add @ jquery.js:3559
initSession @ document.js:525
(anonymous) @ document.js:619
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
setTimeout (async)
(anonymous) @ jquery.js:4131
(anonymous) @ jquery.js:28
19755 @ jquery.js:14
a @ bootstrap:19
13084 @ windows-phone.js:30
a @ bootstrap:19
(anonymous) @ startup:4
a.O @ chunk loaded:25
(anonymous) @ startup:5
(anonymous) @ startup:5
script?v=1:70 Uncaught TypeError: Cannot read properties of null (reading 'addEventListener')
    at HTMLBodyElement.<anonymous> (script?v=1:70:26)
    at T (sideMenu.js?v=a212353c-50:24:259)
(anonymous) @ script?v=1:70
T @ sideMenu.js?v=a212353c-50:24
setTimeout (async)
T @ sideMenu.js?v=a212353c-50:24
setTimeout (async)
T @ sideMenu.js?v=a212353c-50:24
328 @ sideMenu.js?v=a212353c-50:24
n @ sideMenu.js?v=a212353c-50:1
(anonymous) @ sideMenu.js?v=a212353c-50:1
(anonymous) @ sideMenu.js?v=a212353c-50:1
VM454:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
10[Violation] Added non-passive event listener to a scroll-blocking <some> event. Consider marking event handler as 'passive' to make the page more responsive. See <URL>
bundle.js:1 Blocked autofocusing on a <textarea> element in a cross-origin subframe.
onAdd @ bundle.js:1
_layerAdd @ bundle.js:1
whenReady @ bundle.js:1
addLayer @ bundle.js:1
initialize @ bundle.js:1
NewClass @ bundle.js:1
L.map @ bundle.js:1
(anonymous) @ bundle.js:1
(anonymous) @ bundle.js:1
(anonymous) @ bundle.js:1
[Violation] Forced reflow while executing JavaScript took 43ms
postMessage.tsx:57 PostMessageService.sendPostMessage loolframe {"MessageId":"Host_PostmessageReady","SendTime":1660205091902,"Values":{}}
VM465:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
[Violation] Forced reflow while executing JavaScript took 37ms
VM467:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM469:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM471:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM473:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM475:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM477:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM479:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
2bundle.js:1 missing popover data
closePopover @ bundle.js:1
(anonymous) @ bundle.js:1
setTimeout (async)
onJSDialog @ bundle.js:1
fire @ bundle.js:1
_onJSDialog @ bundle.js:1
_onMessage @ bundle.js:1
showSnackbar @ bundle.js:1
_onSocketClose @ bundle.js:1
VM481:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM483:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
Office.vue:198 FAILED
(anonymous) @ Office.vue:198
setTimeout (async)
(anonymous) @ Office.vue:197
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
z @ collabora.js:48
i @ collabora.js:48
(anonymous) @ collabora.js:48
(anonymous) @ collabora.js:48
load @ Office.vue:190
(anonymous) @ Office.vue:184
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
z @ collabora.js:48
i @ collabora.js:48
Promise.then (async)
z @ collabora.js:48
i @ collabora.js:48
Promise.then (async)
z @ collabora.js:48
i @ collabora.js:48
(anonymous) @ collabora.js:48
(anonymous) @ collabora.js:48
mounted @ Office.vue:162
We @ vue.runtime.esm.js:1863
un @ vue.runtime.esm.js:4235
insert @ vue.runtime.esm.js:3158
_ @ vue.runtime.esm.js:6390
bo.nodeOps @ vue.runtime.esm.js:6609
e._update @ vue.runtime.esm.js:3963
r @ vue.runtime.esm.js:4081
bn.get @ vue.runtime.esm.js:4495
bn.run @ vue.runtime.esm.js:4570
An @ vue.runtime.esm.js:4326
(anonymous) @ vue.runtime.esm.js:1989
et @ vue.runtime.esm.js:1915
Promise.then (async)
Ke @ vue.runtime.esm.js:1942
it @ vue.runtime.esm.js:1999
(anonymous) @ vue.runtime.esm.js:4418
bn.update @ vue.runtime.esm.js:4560
de.notify @ vue.runtime.esm.js:730
set @ vue.runtime.esm.js:1055
Cn.set @ vue.runtime.esm.js:4644
(anonymous) @ Viewer.vue:386
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
Ka @ Download.vue?b226:19
a @ Download.vue?b226:19
Promise.then (async)
Ka @ Download.vue?b226:19
a @ Download.vue?b226:19
(anonymous) @ Download.vue?b226:19
(anonymous) @ Download.vue?b226:19
openFile @ Viewer.vue:344
file @ Viewer.vue:256
We @ vue.runtime.esm.js:1863
bn.run @ vue.runtime.esm.js:4584
An @ vue.runtime.esm.js:4326
(anonymous) @ vue.runtime.esm.js:1989
et @ vue.runtime.esm.js:1915
Promise.then (async)
Ke @ vue.runtime.esm.js:1942
it @ vue.runtime.esm.js:1999
(anonymous) @ vue.runtime.esm.js:4418
bn.update @ vue.runtime.esm.js:4560
de.notify @ vue.runtime.esm.js:730
set @ vue.runtime.esm.js:1055
value @ Viewer.js:183
Ca @ FilesActionHandler.js:40
action @ merged-index.js?v=a212353c-50:3023
_onClickFile @ merged-index.js?v=a212353c-50:4957
ge @ _executeBound.js:8
(anonymous) @ bind.js:10
(anonymous) @ restArguments.js:16
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
VM485:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM487:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM489:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM491:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM493:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM495:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM497:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM499:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM501:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM503:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
core-main.js?v=a212353c-50:2 [Violation] 'setInterval' handler took 50ms
VM505:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM507:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM509:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM511:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM513:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM515:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM517:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136
VM519:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0
    at JSON.parse (<anonymous>)
    at window._notify_push_ws.onmessage (index.js:136:45)
window._notify_push_ws.onmessage @ index.js:136

There was more but post length is limited to 32000 characters and I assume the FAILED office error is the interesting one.

Screenshot

Yes, there is a setting in /etc/coolwsd/coolwsd.xml, <per_document> / <limit_load_secs>, which is 100 by default. You could disable the limit by changing it to 0, and see if the file can be opened then.

1 Like

@bearon thanks, I tried that, and it didn’t help.

However, I did some more investigation and the plot has thickened. If I move the spreadsheet to another folder it opens fine! I discovered this by first noticing that none of the spreadsheets in the particular folder appear to be opening in CODE. If I move them elsewhere they open, if I move them back they stop opening!

I definitely have all the required permissions to edit this folder etc. The folder is a subfolder of a group folder (but I doubt it’s relevant). Spreadsheets also seem to fail to open in subfolders of this folder. The folder tree looks like this:

REOS-SHARED/Financial/Management Accounts and Projections

I then tried to create a spreadsheet in this folder by going to ±>New Spreadsheet in nextcloud that also fails. I tried to create a spreadsheet called test_CODE_opening_issue.ods. After the failure the file is present in the directory but cannot be opened in CODE. After syncing locally, it seemed I could open it in libreoffice, but I didn’t test extensively, and the libreoffice spinner kept spinning after i opened it, and I closed the file before it stopped, so I don’t know if there is any corruption.

Further to this spreadsheets in another path won’t load:

REOS-SHARED/Business Documentation/Board Meetings and Minutes/Board Meeting 2022-08-17

Is there an issue with path length? Or spaces in paths or something?

I created a github issue here