https://bugs.documentfoundation.org/show_bug.cgi?id=161841
Bug ID: 161841
Summary: Add ARRAYFORMULA 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:
Alternative to pressing Ctrl+Shift+Enter (CSE formulae) (or Cmd+Shift+Enter on
macOS) while editing a formula
https://support.google.com/docs/answer/3093275
Thank you
Steps to Reproduce:
Interoperability with Google Sheets
Actual Results:
Error if ARRAYFORMULA() function is used
Expected Results:
Work if ARRAYFORMULA() function is used
Reproducible: Always
User Profile Reset: No
Additional Info:
ARRAYFORMULA
https://support.google.com/docs/answer/3093275
Enables the display of values returned from an array formula into multiple rows
and/or columns and the use of non-array functions with arrays.
Sample Usage
ARRAYFORMULA(SUM(IF(A1:A10>5, A1:A10, 0)))
ARRAYFORMULA(A1:C1+A2:C2)
Syntax
ARRAYFORMULA(array_formula)
* array_formula - A range, mathematical expression using one cell range or
multiple ranges of the same size, or a function that returns a result greater
than one cell.
Notes
* Many array formulas will be automatically expanded into neighboring cells,
obviating the explicit use of ARRAYFORMULA.
* Pressing Ctrl+Shift+Enter while editing a formula will automatically add
ARRAYFORMULA( to the beginning of the formula.
* Note that array formulas cannot be exported.
See Also
ARRAY_CONSTRAIN: Constrains an array result to a specified size.
https://support.google.com/docs/answer/3267036?sjid=16672828875549345965-AP
--
You are receiving this mail because:
You are the assignee for the bug.
