LO 6.0.2.1 Calc cannot switch between documents on a Mac

Yesterday I updated LO to 6.0.2.1, then I cannot use Command + ` to swtich between documents as the 5.x version does. The shortcut seems bind to a new function, like to mask cells which containing formulas.

I cannot find how to change the shortcut bindings. Tools → Customize… not work.

How to set Command + ` to switch between documents?

I wish I knew. It seems to work with Write documents, but not Calc.

This key combination is a toggle that “Displays or hides the formulas instead of the values in all cells.” (Search for the back-tick on that page to see the instructions/explanation.)

This is a known bug: fdo#103388. At least since January it has been registered as an issue for OSX. (And I can confirm!) [ Update - As noted by @vsfoote, this has been fixed, and will be available when you get v. 6.0.3+ for OSX. I’m still on 6.0.1, though.]

There is a workaround, but it is very much USE AT YOUR OWN RISK :slight_smile:

  • Open LibO Preferences (⌘,)

  • Open the first category, LibreOffice > Advanced,

  • click on Open Expert Configuration.

  • in the “search” bar in the new pop-up, type: “toggleFormula” and hit ENTER. This will bring up a function that includes QUOTELEFT_MOD1:

    Double-click that line, and clear the value .uno:ToggleFormula from the box that pops up.

  • Click OK (for each of the three pop-up windows).

Now ⌘` will work on the system level, and you’ll be able to use that key combination to switch between Calc windows.

It is a simple matter to reverse this operation, of course, but you now need to search on QUOTELEFT_MOD1 to find that function.
 

The uno:ToggleFormula command’s shortcut was reassigned from QUOTELEFT_MOD1 (Cmd+`) to QUOTELEFT_MOD3 (Ctrl+`) on macOS builds. Available at 6.0.3 and 6.1.0 release, restoring the macOS UI HIG usage. See tdf#114858.

This affects earlier builds as well (the assignment was inherited from OOo era). The Expert Configuration change listed is effective (just revert it when moving to 6.0.3) or alternatively just use macOS Shift+Cmd+` to move between app windows in reverse order–same effect.

I’m on a Mac OSX build on this machine, using 6.0.1.1, and it’s still set to Cmd+`, I’m afraid. :frowning: Hopefully this will come through at some point (soon). Good suggestion about Shift+Cmd+`, though.

I’m sorry but that’s just completely ridiculous. You don’t mess with system wide default keyboard shortcuts.I don’t know what’s going on with LO lately, but somewhere in the 5.x line people started really letting this app go. The Document Foundation needs to get it’s act together.

And this is an answer??