Skip to main content
Determines if calculations that reference a range are evaluated before the row limit by default.

​
Syntax

calcs_default_pushdown: <true|false>

​
Properties

​
query
boolean
When true, calculations that reference a range (e.g. =SUM(B:B), =RANK(B1, B:B, 0)) are evaluated before the row limit by default, so they see the full underlying dataset instead of only the visible rows. Users can override this on a per-calculation basis from the column menu in the workbook.