[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2024-05-31 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 Eike Rathke changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2024-01-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 --- Comment #12 from Stéphane Guillou (stragu) --- (Sorry Mike, excuse the repeated info, I somehow completely missed how you already mentioned the standard in comment 8!) -- You are receiving this mail because: You are the assignee

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2024-01-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 --- Comment #11 from Eike Rathke --- (In reply to Mike Kaganski from comment #8) > 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

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2024-01-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 Stéphane Guillou (stragu) changed: What|Removed |Added Ever confirmed|0 |1

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2023-12-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 --- Comment #9 from Mike Kaganski --- Note also, that there is an interoperability aspect here. Gnumeric, Google Sheets, and some other spreadsheet programs (though not Excel, notably) do support the requested syntax. -- You are

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2023-12-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 Mike Kaganski changed: What|Removed |Added Resolution|NOTABUG |--- Severity|normal

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2023-12-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2023-12-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 --- Comment #6 from Jonathan Watt --- Sure, I understand it doesn't currently work that way, as shown in comment 0 when I asked "Could support...be added?" But Google Sheets and Zoho Sheets both support this FWIW. And it seems

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2023-12-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 Werner Tietz changed: What|Removed |Added Resolution|--- |NOTABUG

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2023-12-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 --- Comment #4 from Jonathan Watt --- Hello. Yes, it works on cell ranges. But if you do any operation on the cell range before passing it to SUMIF it won't work because the range is converted to an array. For example, that can be seen

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2023-12-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 --- Comment #3 from Werner Tietz --- Hallo for example: =SUMIF(A1:A4;">0") -- You are receiving this mail because: You are the assignee for the bug.

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2023-12-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 --- Comment #2 from Jonathan Watt --- Thank you for being kind enough to take the time to read between the lines and try to solve the issue I'm encountering. I appreciate that. But I did intend for this to be a legitimate, standalone

[Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays

2023-12-19 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=158789 --- Comment #1 from ady --- Several points. In addition to this tdf#158789, you also filed tdf#158788, apparently trying to solve some issue with how to arrive to some result. Please understand that most of us are volunteers here. This