Summary: | Option to REQUIRE pressing F2 or Enter to switch to cell edit mode and ignore any data entry attempts otherwise | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | freeware |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | danielmoisiowork, heiko.tietze |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=63374 https://bugs.documentfoundation.org/show_bug.cgi?id=74375 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108019, 112128 |
Description
freeware
2023-06-17 08:33:30 UTC
tl;dr I request an option to make it so pressing F2 or ENTER (if enabled in the general options) is REQUIRED to enter the cell edit mode to enter/modify the content. freeware, Interesting idea - and I get what you are asking for. However, this is not a bug. As for methods and alternatives - you noted a few that could work - but frankly having a button like f2, which is already used in calc work, suddenly be the guardian of edit-ability does not seem right because hypothetically you could accidentally hit f2 and edits would occur anyway. Hazards of end user computing type software in my view. Thank you (In reply to danomois from comment #2) > this is not a bug. @danomois, this is set as ENHANCEMENT request, not reporting a bug of an already-established feature/behavior. Someone might think this is worth implementing, a discussion and a decision might arise. I am changing the status back from NAB to UNCONFIRMED, as it was before. Thank you for quick response. I must add one thing. In Tools>Options>Libreoffice Calc>General there is this weird option called "Press Enter to switch to edit mode". First time I saw it I've incorrectly assumed that if this options is checked then pressing enter is REQUIRED to switch to edit mode, not just optional. Why? Because it is both redundant and inconsistent. Firstly I can hit F2 to do the same thing, and secondly, why is this option even there, and NOT a part of Tools>Customize settings. Thus me longing for an option to actually make it a requirement to hit enter (or any other custom key) to begin editing cell content. And about that other part of my rant concerning accidental drag and drop cell/area. If you ask me, MOVING cell/areas by mouse should be disabled by default entirely. Same with grabbing the bottom right corner to replicate. There should be separate options to restrict such operations using a mouse, touchpad, stylus etc. Spreadsheet is NOT a drawing program, isn't it? The other bug/feature where you can cancel data validation by just copying over another cell is another rich idea. IMO there should be MORE effort needed to do that, not the other way around, where CTRL+V as it is now copies EVERYTHING. In general IMO data entry in a spreadsheet should be rethinked and redesignd altogether with most focus put on NOT helping the (inexperienced) user to modify or destroy existing data. Hey, but that's just me. Cheers. Could imagine an advanced option or maybe also on the UI to block direct input. > Could imagine an advanced option or maybe also on the
> UI to block direct input.
Do we have any examples for other spreadsheet software doing this? I am a bit concerned about introducing an unusual mode of operation that is hard to get in- and out of.
> Spreadsheet is NOT a drawing program, isn't it? It can be. See for yourself: https://mymodernmet.com/tatsuo-horiuchi-excel-spreadsheet-paintings/ We discussed the topic in the design meeting. Such an option might be dangerous for average users. But there is no objection to add it as an expert feature, if someone wants to volunteer. Bug 63374 discusses the same topic with the idea to give better feedback when in the edit mode. And bug 74375 might be another See Also. |