[Libreoffice-ux-advise] [Bug 127633] Relative Cells

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Sep 23 09:01:17 UTC 2019


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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needsUXEval

--- Comment #3 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
If you want to enter =AA281+AB283 the easy way is per clicking the cells. In
case you have more advanced it's possible to use the INDIRECT() function, eg.
BA1==AA, BA2==281, BB1==AB, BB2==283 -> =INDIRECT(BA1&BA2)-INDIRECT(BB1&BB2).

While the use case is clear I doubt the relative area is a good solution. It
wouldn't be clear what cells are calculated precisely since you may always have
so relation. There might be solutions but I cannot imagine anything absolute
clear for every user.

So my take: WF.

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


More information about the Libreoffice-ux-advise mailing list