diff options
author | Luboš Luňák <l.lunak@collabora.com> | 2022-05-27 19:51:40 +0200 |
---|---|---|
committer | Luboš Luňák <l.lunak@collabora.com> | 2022-05-28 05:44:27 +0200 |
commit | 7674399aac661eb503d7badc53b9a4d68bd9839d (patch) | |
tree | 1d5a5ed31a1e10d175da3232cccfe92a0a931fc1 /offapi | |
parent | e3d3adbcde43965b517473387acda81e53e248ed (diff) |
It's possible to do reduce range of COUNTIFS to non-empty data too,
since empty cells cannot contribute to the result, as long as
the criteria do not require matching empty cells. Without this
queries like =COUNTIFS($A:$A,...) can spend most of their time
clearing and searching the vConditions vector that's big and
not useful for the trailing empty cells in that column.
Change-Id: I8d1e7977f172ac9b2cf84af3f982e945be3cb46c
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135049
Tested-by: Jenkins
Reviewed-by: Luboš Luňák <l.lunak@collabora.com>
Diffstat (limited to 'offapi')
0 files changed, 0 insertions, 0 deletions