[Libreoffice-bugs] [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 the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190923/8df40594/attachment.html>
More information about the Libreoffice-bugs
mailing list