https://bugs.documentfoundation.org/show_bug.cgi?id=158789
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO Blocks| |108827 URL| |https://ask.libreoffice.org | |/t/is-there-an-alternative- | |to-sumif-for-arrays/99693 CC| |[email protected], | |stephane.guillou@libreoffic | |e.org --- Comment #10 from Stéphane Guillou (stragu) <[email protected]> --- I agree with Mike that the inconsistency is problematic, and would support more interoperability with other tools. However, looking at the ODF specification[1], I understand using an array on the first argument is not allowed: "Constraints: Does not accept constant values as the range parameter." ...which contradicts the working example in comment 7. Regina, what is your opinion? Any potential future evolution in ODF here? Or maybe I am reading the spec wrong? Regarding SUBTOTAL: arrays already work, e.g.: =SUBTOTAL(1,{1,2,3,4,5}) Jonathan, can you confirm? [1]: https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1018584_715980110 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
