GNOME Bugzilla – Bug 415503
Absolute cell reference key, F4, undocumented
Last modified: 2008-02-06 14:47:25 UTC
When entering a formula, it would be handy if I could click to get a cell reference (e.g A10), or alt-click to get absolute reference (e.g. $A$10). I often have some table like this: count thing 6 orange 24 pear 20 jackfruit sum() Then I want to create a column for percentage. This involves clicking the cell with the sum then clicking for the count, then hand editing the sum to be an absolute $ reference.
(If I could just hit "cursor back" to edit the formula, that would be nice also. But Gnumeric uses the cursor keys for something else in this case)
Already there. Just use F4 to cycle through the four $-combination after you click the cell.
Cool. Not as easy as pressing ALT, but good. Reopening as a doc bug, since the docs only list: F4 repeat the last action. A tooltip or something would make this more discoverable.
It's buggy. Take this list: count percentage 5 4 1 10 total count percentage 5 4 1 10 total and try to calculate the percentage. When you get to the second cell and press F4 it repeats the last action rather than cycling through the absolute cell references. I repeat the original feature request:: much nicer for ALT-Click to insert an absolute cell reference. It's less moving back and forth from keyboard to mouse.
Verified still buggy as of 1.7.11 F4 sort of randomly makes a cell reference absolute, or repeats the last action.
Here's a patch against 1.7.11 as supplied by SUSE: From "GNOME_Gnumeric-gtk.xml", remove the "Repeat" action: <accelerator name="FormatClearBorders" action="FormatClearBorders"/> <!-- <accelerator name="Repeat" action="Repeat"/> --> <accelerator name="EditSelectAllXL" action="EditSelectAllXL"/> You also have to patch the documentation, which documents this key as repeat not change cell reference type.
The proper fix was in 1.7.12 and now in 1.8.x 2007-07-29 Jody Goldberg <jody@gnome.org> [#461284] * src/wbcg-actions.c : Move 'Repeat' back into the standard actions so that it will be disabled while editing just like the other actions. * src/workbook-control-gui.c : handle the sensitivity of repeat here, manually. * src/wbc-gtk.c (wbc_gtk_init_undo_redo) : rather than initializing cb_chain_sensitivity down here to handle it. (cb_chain_sensitivity ) : use gtk_action_GET_sensitive rather than _IS_sensistive to avoid group effects. *** This bug has been marked as a duplicate of 461284 ***