Bug 166333 - Not possible to set/use SHIFT+Enter (or another shortcut) to insert break line inside the cell
Summary: Not possible to set/use SHIFT+Enter (or another shortcut) to insert break lin...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-25 07:21 UTC by Orwel
Modified: 2025-05-05 21:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Orwel 2025-04-25 07:21:42 UTC
Description:
A lot of software use the SHIFT+ENTER shortcut to insert a line break which brings you to next line (e. g. Firefox, Thunderbird, MS Word...). This can be also set in writer using Customize Keyboard using "Insert Manual Row Break" function. But for some reason this is not possible to do in sCalc, which uses a hard command "go to upper cell" (means moving 1 cell up).

This is behavior of LO sCalc forces to remember the specific shortcut CTRL+ENTER in sCalc especially, which is almost impossible, since man works automatically and subconsciously. As I said, all the software I work with uses SHIFT+ENTER to scroll down a line, even in Writer I can set it up. Only sCalc can't. I'm talking about the case where I'm editing a cell directly through F2 (i.e. I'm inside the cell). The strangest thing is that if I edit the cell via the Input line, the SHIFT+ENTER works in the same way as CTRL+ENTER. LibreOffice is great in that it can be customized, so I guess this is some kind of bug.

Steps to Reproduce:
1. Try SHIFT+ENTER inside the cell (F2).
2. Try SHIFT+ENTER in the input line.
3. Try to set keyboard shortcut for SHIFT+ENTER ("Insert row break")


Actual Results:
1. Moving 1 cell up
2. Inserting line break
3. Setting a keyboard shortcut for SHIFT+ENTER ("Insert row break") does nothing. 

Expected Results:
We should be able to set a working "Insert row break" shortcut to SHIFT+ENTER for the purpose of editing a cell (F2) to act the same way as in the Input line (and other SW).


Reproducible: Always


User Profile Reset: No

Additional Info:
I tried to set the  "Insert row break" function for another free shortcuts, but without success. It seems the editing of the cell is protected from using user-defined shortcuts. As mentioned, it is confusing that SHIFT+ENTER acts as CTRL+ENTER in the input line.
Comment 1 Mateusz Wlazłowski 2025-04-25 16:30:42 UTC
Shift+Enter adds a line break only after we Ctrl+Enter first in the F2 mode


Confirm from the oldest version I have installed



Version: 7.2.0.1 / LibreOffice Community
Build ID: 32efc3b7f3a71cfa6a7fa3f6c208333df48656cc
CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded


Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded


Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f355ddcbf2bf037263e336724829b5467b94ef40
CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: CL threaded