[Libreoffice-bugs] [Bug 123842] New: Shortcut for absolute cell reference during cell selection

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Mar 4 14:19:57 UTC 2019


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

            Bug ID: 123842
           Summary: Shortcut for absolute cell reference during cell
                    selection
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: pentike at gmail.com

By default while building a formula and selecting cells with the mouse or
keyboard, the cells are referenced relatively.

If I would like to calculate monthly interests, I would select the first month
(A1) and multiply principal (B1) by interest rate (A2). If I would like to copy
the formula to A2 I first have to edit it and add the absolute reference to
$A$2.

It would be nince to have a shortcut for adding absolute references. i.e. Ctrl.
+ Click

Thanks!

-- 
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/20190304/d2ea6135/attachment-0001.html>


More information about the Libreoffice-bugs mailing list