https://bugs.documentfoundation.org/show_bug.cgi?id=152091
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=13 | |8070 CC| |stephane.guillou@libreoffic | |e.org Status|UNCONFIRMED |NEEDINFO --- Comment #8 from Stéphane Guillou (stragu) <[email protected]> --- (In reply to LeroyG from comment #1) > I think that it is not a bug. > > You must opt for =SUM(A1:A2;A5:A6;A9:A10) (or not usually with > =SUM(A1:A2~A4:A5~A7:A8)) > > =A1:A2;A5:A6;A9:A10 will give Err:509 Operator missing. > > Just try in B1 with =A1:A2 and you will get only the A1 value. And with the > same formula in B2 you will get only the A2 value. I was trying to see where this interesting "formula that is a cell range will return the unambiguous value located at the corresponding coordinate" behaviour is documented, but couldn't find it: - https://help.libreoffice.org/latest/en-US/text/scalc/guide/relativ_absolut_ref.html - https://help.libreoffice.org/latest/en-US/text/scalc/guide/formulas.html - https://help.libreoffice.org/latest/en-US/text/scalc/guide/formula_enter.html Any idea where that is / where it should be? If it is an expected behaviour, we should turn this bug into a documentation issue. -- You are receiving this mail because: You are the assignee for the bug.
