Apache OpenOffice (AOO) Bugzilla – Issue 97743
Floating toolbar causes Calc windows not to receive focus when cycling via keyboard shortcut.
Last modified: 2013-01-29 21:52:28 UTC
Summary On OSX, the command-tilde keyboard shortcut cycles through windows of the current application. The switched-to window should receive the focus. With Calc, it doesn't. (Note that OO Draw windows correctly receive the focus.) To Replicate: 1) Start OO. 2) File | New | Spreadsheet 3) File | New | Spreadsheet 4) File | New | Text Document 5) command-tilde to cycle through the three open windows. Note how the Calc spreadsheets don't receive focus on switch (while the Draw window does).
I have just discovered that an extra step needs to be inserted below. Prior to step 5, you need to create a floating toolbar (e.g., the "font color" toolbar). It is the presence of the floating toolbar that prevents Calc windows from receiving focus when cycling via the keyboard short-cut (again, Draw handles this okay).
Confirmed as described. Also, Cmd-` doesn't switch away from Calc windows, regardless of floating toolbar, though it will switch to a Calc window.
It looks like cmd-tilde is bound to some command that toggles between "display formula" and "display value". To replicate: 1) create a new spreadsheet 2) enter a formula e.g. "=42+42" into a cell 3) hit cmd-tilde Instead of cycling windows, the cell with the formula switches between "84" and "=42+42". In my opinion this is not a sensible key binding on OSX. I have no idea how to change the binding... tools/customize didn't help me.
Ah. There is a difference between cmd-` and cmd-~, i.e. whether the shift key is held down. The current behaviour is: cmd-`: formula/value toggle cmd-~: window cycling Maybe these should be switched around?