Skip to content

[Bug] Formula fails =SUBTOTAL(103, OFFSET(J$16, ROW(J$16:J$107)-MIN(ROW($J$16:$J$107)),0)) #5884

@olyashok

Description

@olyashok

Before you submit this issue, have you checked the following

  • Is this really a problem?
  • I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

0.10.8 sheets

Reproduction link

paste this anywhere in empty sheet
=SUBTOTAL(103, OFFSET(J$16, ROW(J$16:J$107)-MIN(ROW($J$16:$J$107)),0))
produces #VALUE! but works in excel

Expected behavior

produces column of 0s

Actual behavior

#VALUE!

System information

No response

Metadata

Metadata

Assignees

Labels

bug 🐛Something isn't working

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions