https://bugs.documentfoundation.org/show_bug.cgi?id=164152
Bug ID: 164152
Summary: [Request] Add ARRAY_CONSTRAIN function
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Add ARRAY_CONSTRAIN function.
Steps to Reproduce:
Interoperability with Google Sheets
Actual Results:
Error if ARRAY_CONSTRAIN() function is used
Expected Results:
Work if ARRAY_CONSTRAIN() function is used
Reproducible: Always
User Profile Reset: No
Additional Info:
This is useful when there are cells that should not be destroyed in the right
or bottom direction, since the range to be filled by the formula is specified
in advance.
And if the range does not reach the specified value, nothing is displayed, so
the look and feel is the same as a dynamic array formula.
One could argue that this is unnecessary since it can be replaced by an
existing formula.
https://support.google.com/docs/answer/3267036?sjid=16672828875549345965-AP
https://bugs.documentfoundation.org/show_bug.cgi?id=161841#c0
https://bugs.documentfoundation.org/show_bug.cgi?id=161841#c2
--
You are receiving this mail because:
You are the assignee for the bug.
