Frequently asked questions - Calc

    From The Document Foundation Wiki
    < Faq‎ | Calc


    Some keyboard shortcuts that I used in OpenOffice.org don't work like before.

    Some shortcuts are different from the ones in OpenOffice.org. See the table below:

    LibreOffice OpenOffice.org
    Del. Deletes the content Opens the dialog

    Edit ▸ Delete

    ← Backspace Opens the dialog

    Edit ▸ Delete

    Deletes the content
    Ctrl + D Sheet ▸ Fill cells ▸ Fill down Selection list
    Ctrl + ⇧ Shift + D versions 3.3.x

    Alt +  versions 3.4 and later.

    Selection list


    If you want to continue using the shortcuts from OOo, you can set this in the options:
    Tools ▸ Options ▸ LibreOffice Calc ▸ Compatibility ▸ OpenOffice.org legacy

    Keyboard shortcuts for autocompletion are also different:

    Tab ↹ validates the entry and positions the cursor in the next column on the same row.

    Ctrl + Tab ↹ scrolls through previous cell contents.

    These bindings are not affected by the option setting shown above.