https://bugs.documentfoundation.org/show_bug.cgi?id=158789
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|NOTABUG |--- Severity|normal |enhancement Status|RESOLVED |UNCONFIRMED --- Comment #8 from Mike Kaganski <[email protected]> --- (In reply to Werner Tietz from comment #5) The "doesnt (and wasnt!) work this way" is *never* a reason to close an enhancement request. Enhancements are exactly to make something to happen, that wasn't here before. OP didn't set the Enhancement properly; but they made an effort to express this ("Could support for passing arrays to SUMIF and SUBTOTAL be added?" in comment 0, also in comment 2). Triaging should not behave in a robotic way. I support the request - based on comment 7, which definitely shows that the functions do support inline arrays *in some form*, so not supporting them without the optional third argument is inconsistent; and the specific detail of the *current* behavior is a real bug: *if* the functions follow ODF spec literally (as in "Constraints: Does not accept constant values as the reference parameter" on ODF 1.3 6.13.9 COUNTIF, 6.16.62 SUMIF, etc.), then it must emit an *error* when user passes inline array with constant values in that argument, not a 0 with absent third argument, nor a correct result with the third argument present. So the current 0 is a bug from any point of view. I revert it back to UNCONFIRMED. Please update the status based on some better arguments. -- You are receiving this mail because: You are the assignee for the bug.
