Configure shortcuts, toolbars and accessibility navigation

Customize one command at a time and keep a way back. A Calc-only shortcut and a document-scoped toolbar can make repeated work easier without unnecessarily changing every OpenOffice application or every workbook.

Scope and a keyboard-friendly test sheet

Use Apache OpenOffice Calc 4.1 desktop, English menus, and Windows/Linux keyboard conventions. The exact Keyboard controls are documented in AOO 4.1.16 help. This is not a claim of native assistive-technology testing, screen-reader compatibility or accessibility certification. Operating systems may reserve shortcuts.

Create a disposable ODS workbook with A1=Item, B1=Units, A2=Paper, B2=10, A3=Toner and B3=2. Use readable labels and avoid merged cells in this tiny data block. The aim is to navigate and format known cells without depending on color or a mouse-only target.

Before changing shortcuts, open Tools > Customize > Keyboard. Select Calc rather than OpenOffice in the scope selector. Use Save to save the current keyboard configuration to a separate local file. Loading a saved configuration replaces the existing one, so retain this baseline and do not overwrite it during the experiment.

Assign one reversible shortcut

1. On the Keyboard tab, select a combination shown as unassigned in Shortcut keys that your operating system does not reserve. Do not repurpose Ctrl+S, F1 or another familiar command.
2. In Category expand Styles and choose Cell Styles. In Function select Heading.
3. Click Modify. Apache OpenOffice uses Modify here, not the Assign label used by some other versions or products.
4. Verify the selected key combination now appears for Heading, then click OK.
5. Select A1:B1 and press your chosen combination. Inspect the resulting cell style and confirm only the headings were selected.

Move to A2 and use the same shortcut as a deliberate changed-target test. The style should now apply to A2, demonstrating that the command acts on the current selection. Undo that second application so the data cell returns to its previous style. The cell content Paper must remain unchanged throughout.

If nothing happens, check that Calc has focus, that the selected combination was actually assigned, and that the operating system did not intercept it. Do not keep trying random reserved shortcuts. Return to the Keyboard tab and inspect the assignment.

Put a useful command on a document toolbar

Choose Tools > Customize > Toolbars. Click New, name the toolbar Review tools, and choose this disposable document in Save In. This is a different scope choice from the Calc-only keyboard setting.

Select the new toolbar, click Add, choose the category containing Navigator, select Navigator and click Add. Close the Add Commands dialog, then confirm customization with OK. Use View > Toolbars to show Review tools if it is not visible. Click its Navigator command and verify Navigator opens; use the standard F5 shortcut as a comparison.

Document scope keeps this experimental toolbar attached to the workbook rather than assuming every Calc document should have it. Save and reopen the workbook to check the toolbar persists in the intended scope.

Verify navigation separately from customization

Press Ctrl+Home to return to the start of the sheet. Use arrow keys to move between the labeled cells and confirm which cell is active in the Name box. Use Ctrl+Shift+F5 to move focus to the Name box, type B3 and press Enter; the selected cell should contain 2. Change it to 3, then undo to restore the fixture.

These are bounded keyboard checks, not proof that every dialog works with every accessibility tool. Clear labels, sensible reading order and non-color cues remain useful design choices even when no customization is made.

Restore safely

To restore the saved keyboard setup, return to the same Calc scope and use Load with the baseline configuration. Be aware it replaces that configuration, including later changes; do not load an old baseline over unrelated new customizations. Remove the test toolbar through its customization controls if it is no longer needed, or discard the disposable workbook.

Official references

Apache OpenOffice 4.1.16 Keyboard help, captured 20 October 2026; Calc Guide, Chapter 14 and Appendix A. Native key interception and saved-state behavior remain unverified.