https://bugs.documentfoundation.org/show_bug.cgi?id=161841
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |stephane.guillou@libreoffic | |e.org --- Comment #2 from Stéphane Guillou (stragu) <[email protected]> --- The example formula ARRAYFORMULA(A1:C1+A2:C2) (in cell D1) is exported from Google Sheets as e.g.: - ODF: <table:table-cell table:style-name="ce7" table:number-matrix-columns-spanned="3" table:number-matrix-rows-spanned="1" table:formula="of:=[.A1:.C1]+[.A2:.C2]" office:value-type="float" office:value="5" calcext:value-type="float"><text:p>5</text:p> - OOXML: <c r="D1" s="4"><f t="array" ref="D1:F1">A1:C1+A2:C2</f><v>5</v></c> When imported in LO, it is displayed in the curly braces syntax, in both ODF and OOXML. and is imported back in Google Sheets wrapped in ARRAY_CONSTRAIN(): =ARRAY_CONSTRAIN(ARRAYFORMULA(A1:C1+A2:C2), 1, 3) Would be good to inverstigate what happens in the case "use of non-array functions with arrays". -- You are receiving this mail because: You are the assignee for the bug.
