[Libreoffice-ux-advise] [Bug 157089] Support mixed column/row references like in Google Sheets like =SUM(A1:3)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=157089

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|libreoffice-ux-advise at lists |heiko.tietze at documentfounda
                   |.freedesktop.org            |tion.org,
                   |                            |rb.henschel at t-online.de
           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 <heiko.tietze at documentfoundation.org> ---
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 on the CC list for the bug.