I've never submitted an issue before, I'm not a developer. I don't exactly know what I'm doing reporting an issue so if I've done it incorrectly, forgive me.
Description:
Entering a formula that uses the IFS function into a spreadsheet cell crashes the editor the instant I press Enter. Instead of evaluating, or returning a normal cell-level error like #NAME?, the whole editing session dies and throws the generic "An error occurred during the work with the document. Use the 'Download as' option to save the file backup copy to a drive." dialog.
Steps to reproduce:
- Open a spreadsheet. In cell D2, put a text value such as Year, Quarter, Month, or Week.
- In another cell, enter:
=C2/IFS(D2="Year",12,D2="Quarter",3,D2="Month",1,D2="Week",.25)
- Press Enter.
- The error dialog appears immediately (screenshot below).
Expected behavior
IFS should evaluate normally. Failing that, an unsupported or malformed formula should produce a cell-level error, not crash the entire editing session.
Workaround
Rewriting the same logic with nested IF works correctly and does not crash:
=C2/IF(D2="Year",12,IF(D2="Quarter",3,IF(D2="Month",1,IF(D2="Week",.25,1))))
Environment
- Spreadsheet Editor version: 9.3.1, build 37 (9.3.1.918)
- Deployment: Nextcloud AIO v13.2.1 (latest channel), nextcloud-aio-eurooffice container
- Host OS: Debian 13
- Client: Firefox 152, Linux x86_64
Relevant log out??
From /var/log/euro-office/documentserver/docservice/out.log. Reproduced 4 times with an identical stack trace:
[2026-06-29T21:13:35.311] [ERROR] [localhost] nodeJS - clientLog: changesError: Error: TypeError: can't access property "type", ec is undefined
Script: .../sdkjs/cell/sdk-all.js
Line: 6889:376
StackTrace: nb.prototype.qyi@.../sdk-all.js:6889:376
nb.prototype.Scd@.../sdk-all.js:6891:138
nb.prototype.parse@.../sdk-all.js:6917:307
t.prototype.eFd@.../sdk-all.js:10939:418
$a@.../sdk-all.js:10948:494
f8g@.../sdk-all.js:10951:232
e.prototype.close@.../sdk-all.js:10224:467
I've never submitted an issue before, I'm not a developer. I don't exactly know what I'm doing reporting an issue so if I've done it incorrectly, forgive me.
Description:
Entering a formula that uses the IFS function into a spreadsheet cell crashes the editor the instant I press Enter. Instead of evaluating, or returning a normal cell-level error like #NAME?, the whole editing session dies and throws the generic "An error occurred during the work with the document. Use the 'Download as' option to save the file backup copy to a drive." dialog.
Steps to reproduce:
=C2/IFS(D2="Year",12,D2="Quarter",3,D2="Month",1,D2="Week",.25)Expected behavior
IFS should evaluate normally. Failing that, an unsupported or malformed formula should produce a cell-level error, not crash the entire editing session.
Workaround
Rewriting the same logic with nested IF works correctly and does not crash:
=C2/IF(D2="Year",12,IF(D2="Quarter",3,IF(D2="Month",1,IF(D2="Week",.25,1))))Environment
Relevant log out??
From /var/log/euro-office/documentserver/docservice/out.log. Reproduced 4 times with an identical stack trace: