https://bugs.documentfoundation.org/show_bug.cgi?id=161841
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #7 from Eike Rathke <[email protected]> --- Makes no sense to me. This is just Google's way to UI write array formulas when a formula is entered with Ctrl+Shift+Enter (CSE), which in Calc and Excel display as ={...} Note that per comment 2 import/export apparently is flawless. The "use of non-array functions with arrays" is exactly what makes array formula mode (matrix evaluation) differ from normal formula mode, functions taking single scalar arguments iterate over a cell range or array instead for cell ranges forming an implicit intersection with the formula cell position, see ODFF 3.3 Non-Scalar Evaluation (aka 'Array expressions') https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017866_715980110 and Calc help on Array Functions https://help.libreoffice.org/24.8/en-GB/text/scalc/01/04060107.html?DbPAR=CALC -- You are receiving this mail because: You are the assignee for the bug.
