[Libreoffice-ux-advise] [Bug 145384] Writer table cells have address scheme that differs from Calc, "A-Z,a-z,AB-AZ,..." vs "A-Z,AA-AZ,BA-BZ,..."; lowercase cell refs are more error prone for cell formulas

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #27 from Eike Rathke <erack at redhat.com> ---
(In reply to Mike Kaganski from comment #17)
> Heh, so it is NOTABUG.
> Try to insert a table with e.g. 60 columns, and check its columns :-)

It's still a bug because ODF 9.2.1 Referencing Table Cells
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part3-schema/OpenDocument-v1.3-os-part3-schema.html#__RefHeading__1415614_253892949
says that after Z the next column 27 is AA.

However, if this is corrected then
a) import must take care of converting everything above A-Z to the proper
notation
b) writing the proper values of AA... to file will let older versions address
wrong columns
c) when reading file and encountering AA... it needs to decide whether that
could be the old broken notation for value 53... or the new 27..., likely by
inspecting whether it fits into the actual table width
d) though not recommended and frowned upon, it may be necessary to act on the
<meta:generator> value if that is neither LibreOffice nor OpenOffice then
assume the proper ODF conform values were written; if it is LibreOffice then
its version number could help to determine how to handle c)

So, to remedy b) somewhat, when fixing this in master apply changes for current
release branches that when encountering AA... do c) but do *not* the conversion
of a) and b) to not propagate the fixed values to even older release versions
that don't know anything about this.

Good luck ;-)

-- 
You are receiving this mail because:
You are on the CC list for the bug.