Version: Document Server v9.3.1 (App v1.2.8)
OS: Self-hosted (Docker/Nextcloud)
Steps to reproduce:
- Open an .xlsx file exported from Google Sheets
- Enter the following formula in any cell:
=SUMPRODUCT((Salary!$A$2:$A$3))
- Press Enter
Expected result:
Formula evaluates correctly and returns a numeric value.
Actual result:
OnlyOffice automatically rewrites the formula to:
=SUMPRODUCT((@salary!$A$2:$A$3))
This causes #VALUE! error. Removing @ manually has no effect — it is reinserted on confirm.
Additional notes:
- Simple cross-sheet references like =Salary!A1 work correctly
- The issue is specific to cross-sheet ranges inside SUMPRODUCT
- File originated as Google Sheets exported to .xlsx (Excel 2007 format)
- SUMIFS with cross-sheet references appears unaffected
Version: Document Server v9.3.1 (App v1.2.8)
OS: Self-hosted (Docker/Nextcloud)
Steps to reproduce:
=SUMPRODUCT((Salary!$A$2:$A$3))
Expected result:
Formula evaluates correctly and returns a numeric value.
Actual result:
OnlyOffice automatically rewrites the formula to:
=SUMPRODUCT((@salary!$A$2:$A$3))
This causes #VALUE! error. Removing @ manually has no effect — it is reinserted on confirm.
Additional notes: