https://bugs.documentfoundation.org/show_bug.cgi?id=158788
Jonathan Watt <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |enhancement --- Comment #8 from Jonathan Watt <[email protected]> --- (In reply to m.a.riosv from comment #6) > A formula like > =SUMPRODUCT({-10;10;20;30};CURRENT()>0) > seems to work as you expect, looking simple. Gosh, I hadn't thought to use CURRENT in this scenario. Very interesting that that works. (I assume it creates an array of boolean values, but the Function Wizard just shows "Err:518" -- despite it working -- so I can't be sure.) > Don't expect a function like you want implemented, there are enough > functions pending to develop for compatibility with Excel. Missing Excel functionality does indeed seem like it would be higher priority. Thanks for the expectation setting. Please feel free to close this as WONTFIX or something if you think that this request will just be bug clutter with no real prospect of ever being implemented. -- You are receiving this mail because: You are the assignee for the bug.
