Bug 123842 - Shortcut for absolute cell reference during cell selection
Summary: Shortcut for absolute cell reference during cell selection
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-04 14:19 UTC by pentike
Modified: 2019-03-04 14:42 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description pentike 2019-03-04 14:19:57 UTC 
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!
Comment 1 Mike Kaganski 2019-03-04 14:40:50 UTC 
Like F4?
Comment 2 Eike Rathke 2019-03-04 14:42:08 UTC 
Exactly F4 ;-)
Works even on a currently selected (i.e. the last) reference while editing or assembling a formula.