Applying a formula to a whole column

I have tested two different keyboards – USB/Bluetooth aren’t relevant for you:

  1. USB with extra numeric keypad and
  2. the second with Bluetooth without a numeric keypad.

The key combination [Ctrl/Strg]+[/] only exists on 1),
the key combination on 2) doesn’t exist because the [/7] key is not the [/] key on the numeric keypad!
The LO help menu doesn’t explain this clearly enough! The {Matrix} function is explained just as vaguely there.

By trial and error I have found that changing the {matrix} range is simple and quick and intuitive, if you know how – without any keyboard shortcut gimmicks:

  • a) select the entire {matrix} range,
  • b) change the {matrix} formula in the calculation field (with the curly brackets removed!),
  • c) finish as usual with the three-key combination, whereupon the curly brackets enclose the new formula.

a file to play with and learn within:
1_LO-CALC_Matrix{}-Bereich verändern_102916.ods (33.3 KB)