News for hackers. Stuff that matters.

A comment on Some Excel users pop F1 off their keyboards (2012).

Re:Some Excel users pop F1 off their keyboards (2012) by edw on Friday September 22, 2017 @03:31PM (#15315037)
This may be 90% cargo culting, 10% reality. One of my former co-workers desperately wanted to be perceived as an Excel ninja, and had heard that people who had achieved guru-level Excel mastery would remove their F1 keys, and so one day pried off her F1 key. Meanwhile the person in our office who probably could have written Minecraft in Excel and then built an Excel simulator in Excel Minecraft had a keyboard with a conspicuously intact F1 key.

Same thing happens in programming circles. I am not exempt: All my MacBook keyboards get their caps lock keys remapped to control, in honor of my Apple II childhood and SunOS pizza box college heritage.

[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by ctrl-j on Friday September 22, 2017 @03:45PM (#15315151)
> All my MacBook keyboards get their caps lock keys remapped to control

You must be an emacs heathen.

Caps lock gets remapped to ESC.

[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by tremendo on Friday September 22, 2017 @03:49PM (#15315190)
Control when held in combination with other keys, ESC when tapped by itself.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by ovatsug25 on Friday September 22, 2017 @04:25PM (#15315482)
How can you do that???
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by feifan on Friday September 22, 2017 @04:28PM (#15315512)
Use Karabiner and the first one here: https://pqrs.org/osx/karabiner/complex_modifications/
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by jimmcslim on Friday September 22, 2017 @05:34PM (#15316048)
Isn't the hardcore move to map Caps Lock to Hyper?

http://brettterpstra.com/2017/06/15/a-hyper-key-with-karabin...

[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by tremendo on Monday September 25, 2017 @01:15AM (#15328230)
on Linux (Ubuntu) the same can be achieved with xcape
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by grayrest on Friday September 22, 2017 @03:57PM (#15315252)
> Caps lock gets remapped to ESC

15 year vimmer here. Caps -> Ctrl and use C-[ for going to normal mode.

[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by keeganpoppen on Friday September 22, 2017 @04:48PM (#15315656)
i also remap caps -> ctrl, but have bindings for `fj` & `jf` in insert mode to exit back to normal mode, on the theory that you basically never have to type either of those letter combos (it has come up maybe twice in the five years i've had it set up). and even if you do have to type one of those letter combos, all you have to do is wait for ~half second between keystrokes and it works fine.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by eridius on Friday September 22, 2017 @04:49PM (#15315672)
Same, but I use `jk`, which only requires one hand.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by dogecoinbase on Friday September 22, 2017 @05:16PM (#15315877)
A similar binding once nearly drove me insane trying to copy/paste an api key.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by eridius on Friday September 22, 2017 @05:20PM (#15315907)
Vim should disable all mappings during a paste. And if it's not, you should be able to hit F8 (or `:set paste`) to toggle paste mode.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by dogecoinbase on Friday September 22, 2017 @05:28PM (#15315982)
Ideally, yes. I don't recall all the details -- I typically run fairly lightweight in terms of vim customizations as I'm often multiple SSH sessions deep, sometimes on systems with vi but no vim (they exist!), so automatic pastetoggle is usually off the table regardless.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by kps on Friday September 22, 2017 @09:53PM (#15317577)
Edsger Dijkstra does not approve.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by zem on Saturday September 23, 2017 @02:10AM (#15318419)
another long-time vimmer here, and i'm perfectly happy to reach up and hit esc. caps lock is a lot more useful as ctrl.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by petepete on Friday September 22, 2017 @06:10PM (#15316331)
I use the one true keyboard and CTRL is already correctly-positioned. Once you ascend there's no going back.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by kps on Friday September 22, 2017 @09:52PM (#15317572)
You use an ADM-3A for vim? I am impressed.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by edw on Friday September 22, 2017 @03:52PM (#15315218)
Guilty as charged. Does mapping right option to hyper aggravate my sins?
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by hxta98596 on Saturday September 23, 2017 @04:31PM (#15321554)
This is spot on. My comment on this thread tried to give some background on how the cargo cult part. The experienced Excel users I know also keep the F1 key right on the keyboard and remap it.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by sunkencity on Friday September 22, 2017 @03:41PM (#15315120)
well, emacs, or terminal usage in general on a mac with the control key not on edge of keyboard is extremely unergonomic. So yay to control in the right place.
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by edw on Friday September 22, 2017 @03:48PM (#15315184)
I'm with you; you're talking to a more than twenty-five year user of Emacs here. I do try, however, to be no less circumspect of my own actions than I am of others'.

Is saving my pinkie from cramping worth losing the ability to type on anyone else's keyboard? I'd say so, but there is a cost.

[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by alreadyhere on Friday September 22, 2017 @03:45PM (#15315155)
Yup, I remapped mine out of a reaction to RSI, not nostalgia. I never even thought of that angle before!
[ Parent | on HN ]
Re:Some Excel users pop F1 off their keyboards (2012) by GatorD42 on Friday September 22, 2017 @05:35PM (#15316061)
Caps lock to control is also super useful for switching tabs in safari. I miss it on my iPad keyboard.
[ Parent | on HN ]