https://bugs.documentfoundation.org/show_bug.cgi?id=157089
Heiko Tietze <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org |tion.org, | |[email protected] Keywords|needsUXEval |needsDevAdvice Summary|support mixed column/row |Support mixed column/row |references like in Google |references like in Google |Sheets |Sheets like =SUM(A1:3) --- Comment #6 from Heiko Tietze <[email protected]> --- My first thought was that this is not defined in ODF but it is ---- 9.2.4 Column and Row Range Addresses Column and row addresses are cell range addresses that reference entire rows or columns. The syntax of a row address is the same as a cell address, except the alphabetic values that indicate the column are omitted. The syntax of a column address is the same as a cell address, except the numeric values that indicate the row are omitted. ---- https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#__RefHeading__1415618_253892949 GSheet silently exports the formula "=sum(A1:3)" as "table:formula="of:=SUM([.A1:.Z3])" which is of course completely wrong (I guess the same is true for docx). Bottom line: be cautious with this type of range definition. -- You are receiving this mail because: You are the assignee for the bug.
