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.
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
Hi. Would it be possible to resolve this bug? It is really annoying that I automatically press SHIFT+ENTER each time, which takes me to another cell....I hope this does not require a big workaround to at least enable to set a shortcut also for SHIFT+ENTER. (In reply to Mateusz Wlazłowski from comment #1) > Shift+Enter adds a line break only after we Ctrl+Enter first in the F2 mode In Windows Environment, this does not work at all. Also if you are within the cell (after F2), SHIFT+ENTER brings you to the next upper cell.
Please get into cell's edit mode (F2) (although, this is not always a precondition), then type-in you first line within the cell, then simultaneously press CTRL-ENTER and then type your second line within the cell. The SHIFT-ENTER combination _usually_ moves the focus one cell up (also in Excel and other spreadsheet tools).
(In reply to ady from comment #3) > Please get into cell's edit mode (F2) (although, this is not always a > precondition), then type-in you first line within the cell, then > simultaneously press CTRL-ENTER and then type your second line within the > cell. I am familiar with CTRL-ENTER (after F2), as explained in the report at the begining. > > The SHIFT-ENTER combination _usually_ moves the focus one cell up (also in > Excel and other spreadsheet tools). I do not use Excel and I think a compare with Excel is not relevant. A lot of other software use SHIFT-ENTER in hte way CTRL-ENTER is used in sCalc (e. g. Firefox, Thunderbird, MS Word to mention only few...) The MAIN issue is, that SHIFT-ENTER can not be set as a shortcut for anything else than the default "move to upper cell", although you can set a shortcut in Menu-View-Toolbars-Customize-Shortcuts (it is not grayed out). If you set a shortcut, it is not working, that is the issue. LO is/should be fully customizable so I do not understand, why it is not possible to change this specific shortcut (in my case to "Insert row break"). I think there is some bug preventing to set SHIFT-ENTER to anything else.
The reason I mentioned Excel is not for comparison, but for ease of use across _multiple_ spreadsheet tools, for decades. Calc > menu Tools > Options > Calc > General > (Input Settings) "Press Enter to move selection" sets the direction for the [ENTER] key. Usually, combining it with [SHIFT] moves the focus to the opposite direction; and a similar case is for [TAB]. Maybe this is the reason for the problem of customizing [SHIFT]+[ENTER] for some other command; IDK. At any rate, without explicitly using F2, the default case is "move the focus to the opposite direction of [ENTER] (whether you are typing-in a value or not), which is expected for most use cases – spreadsheets are mostly aimed at numeric values, after all. This is why, for at least the first break line within the same cell in Calc, you need to use [CTRL]+[ENTER], and you don't need F2 for the most part. BTW, there are currently bugs regarding "Wrap text" that are triggered by the usage of [CTRL]+[ENTER], but that's another matter. Spreadsheets are not web browsers, nor email managers, word processors... The request _could_ be, perhaps, to allow the usage of [SHIFT]+[ENTER] and [SHIFT]+[TAB] as customized keyboard shortcuts, without changing the current defaults at all. My POV regarding that is, that there are already too many common keyboard shortcuts that do not work as expected (for years) and allowing these 2 special customizations might add more issues than it is worth.
Thank you for the explanation. Just to clarify, the SHIFT+F2 shortcut I have set (Insert row break) doesn't work, even I've turned off the setting in Calc > Tools > Options > Calc > General > Input Settings: "Press Enter to move selection".