https://bugs.documentfoundation.org/show_bug.cgi?id=158788
Bug ID: 158788
Summary: Applying math formula (MAX()) to individual array
elements
Product: LibreOffice
Version: 7.6.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I'm trying to clamp the values in an array to some lower and upper bounds,
before doing further operations on the resulting array.
I can provide a fuller spreadsheet example as an attachment if necessary, but
the following demonstrates the issue:
=SUM(MAX({-10,10,20,30},0))
What I'd like to achieve, is for MAX() to be applied to each array element in
turn, resulting in an array with values {0,10,20,30}, with SUM() returning the
value 60.
--
You are receiving this mail because:
You are the assignee for the bug.
