Implicit intersection operator "@" is forcefully being inserted into formulas and breaking them (v9.3)

Desktop editors
,
1

Description:
After updating to version 9.3 with the new Dynamic Arrays support, some of the formulas in my spreadsheets evaluate to wrong values. It seems that the engine now forcefully inserts the implicit intersection operator (@) into functions with (multiple) ranges as arguments.

Steps to Reproduce:
Example 1 (COUNT with multiple ranges):

  1. Fill A1:A4 with 1.
  2. Enter the following formula into any cell:
    =COUNT(A1:A2;A3:A4)
  3. Press Enter.
  4. The count evaluates correctly to 4 but parser also automatically overwrites the formula to:
    =COUNT(A1:A2;@A3:A4)
  5. Reevaluating the cell yields an incorrect count of 2 due to the implicit intersection operator being forced in and the second range being ignored.
    Result: It only counts the first range properly. The subsequent ranges return errors (ignored by COUNT) because implicit intersection fails if the formula’s row doesn’t overlap with the ranges. Excel does not force the @ operator in these cases and correctly maintains the formula and the count of 4.

implicit intersection operator

Example 2 (SUMPRODUCT with boolean arrays):

  1. Enter the following formula:
    =SUMPRODUCT((C3:C13<>0)*1) + SUMPRODUCT((C16:C23<>0)*1)
  2. Press Enter.
  3. The parser rewrites the formula, inserting @ before the ranges:
    =SUMPRODUCT((@C3:C13<>0)*1) + SUMPRODUCT((@C16:C23<>0)*1)
    Result: The arrays are broken and only evaluate against the current row.

Expected Behavior:
The parser should evaluate what is passed and not apply implicit intersection (@) to these arguments.

Actual Behavior:
The @ symbol is forced onto the ranges, breaking existing spreadsheets and causing incorrect data evaluation.

Workarounds currently required:

  • Using only one range per COUNT. Wrapping ranges in INDEX(range; 0) prevents the parser from inserting the @ symbol (e.g., SUMPRODUCT((INDEX(C3:C13; 0)<>0)*1)).

Additional Context:

1 Like
2

Do you want to: Ask a how-to question
OS version: linux, appimage
App version: 9.3
Downloaded from: ONLYOFFICE website / Other (specify). onlyoffice website
Any relevant details about the situation. You can also attach images and videofile to the post (or to place them to external storage).

i just noticed that oo sreadsheets is adding the “@” symbol to some of my formulas after entering them. I could not find documentation on this, what does it do?

ex.
=IF($H76<>“”,SUM(FILTER(@I$54:I$73,@$F$54:$F$73=$H76,“”)),“”)

1 Like
3

Hey @sittingDuck, :wave:

Thanks for the extremely well-structured report and video — this is helpful! I see the problem is indeed serious.
I’ve already passed everything to the dev team. A bug has been created, and I’ll update you right here as soon as there’s any progress or a fix.

Thank you again for the clear reproduction steps — really appreciate it! :hugs:

5

Hello, @anthony_c !
Thank you for reaching out. We’ve added your report to the existing thread for this issue. We’ll post an update here as soon as we have any news to share.

6

Hey @sittingDuck, @anthony_c, :wave:

Huge thanks to both of you — seriously, these are some of the best bug reports we’ve seen! Clear steps, examples, video, screenshots, workarounds… you guys are amazing.

The @ forced insertion bug is definitely nasty and we’ve given it high priority. We’re actively working on it and hope to have a fix in one of the upcoming releases.

I’ll keep this thread updated with any news (fix version, beta, etc.).
Thank you again — reports like yours make a real difference!

1 Like
7

Hello,
We have released Docs v.9.4. This release contains a fix for the bug reported in this thread.
Desktop app will be released as soon as possible.