Skip to content

SUMPRODUCT with cross-sheet references: @ operator auto-inserted, causes #VALUE! #3634

@kritikostony

Description

@kritikostony

Version: Document Server v9.3.1 (App v1.2.8)
OS: Self-hosted (Docker/Nextcloud)

Steps to reproduce:

  1. Open an .xlsx file exported from Google Sheets
  2. Enter the following formula in any cell:
    =SUMPRODUCT((Salary!$A$2:$A$3))
  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

Metadata

Metadata

Assignees

No one assigned

    Labels

    confirmed-bugIssues with confirmed bugsfixed-releaseIssues that fixed on next release, waiting to be released

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions