There should be a way to disable auto-entering formulas in Calc, similar to disabling auto correction. Currently entering dash "-" or plus "+" and trying to move to the next cell triggers a formula-entering mode. This behavior persists even for cell explicitly formatted as text.
Without such option it's impossible to enter dash in a few adjacent cells without workarounds, i.e. after entering "-" to press Enter, which moves cursor to the cell below, then cursor Up and Right (4 strokes instead of 2).
Raised originally here:
When I enter "-" or "+" into a cell and press cursor right to move to the next cell LibreOffice thinks that I am starting to write a formula and automatically highlights the cell I moved into. I formatted all cells as text but it doesn't change this behavior. Is there a toggle that prevents this, similar to Auto correction?
Steps to Reproduce:
1. Enter "-"
2. Press cursor right
Formula entering mode.
Cursor moved to the next cell.
User Profile Reset: No
The software should not enter into formula enter mode when the cell is formatted as text (menu Format -> Cells...) or should provide an option to disable this behavior, similar to disabling auto correction.
In AskLibO, Mike asked to create this report.
Request to optionally disable this feature was recently refused.
*** This bug has been marked as a duplicate of bug 133203 ***
Actually this is not a duplicate of bug 133203 and not related to AutoCorrection but '-' and '+' being accepted to start a formula instead of '=' is a feature for those who enter data on a numeric keypad.
Actually I also completely lost why this has been marked as a duplicate of a localization bug. Reopened. Can someone please add some reasoning?
Today that behavior is a feature but not a bug. It may be as an enhancement to disable "edit formula mode" when you start typing with sign minus
Reason for the feature is stated in comment 3 and I still suggest to resolve as WF referring to bug 133203 comment 8. Adding -A1 is simply done per ="-A1".
It might be a feature for numeric cells, but when a cell is explicitly formatted as text it's an impediment into entering that text. Basically, user can't enter any text starting with or containing - or + and move to the next cell.
I never stated that this is related to auto correction. I only stated that disabling the ability of entering such text without allowing the user to enable it is a bug.
As an example, imagine that there is no option to disable auto correction and that every time user enters "WMvare" the editor changes the spelling to "Wmvare", which is incorrect. When the editor forces an incorrect behavior a feature becomes a bug.
In this case it's very similar. User can't enter "-" and move to next cell without triggering the formula entering mode.
Note, that there is no other way of moving across cells in Calc than using keyboard. Think about disability and UX issues when users try to use Calc without a mouse. A somehow helpful feature that is always forced and can't be disabled becomes a bug.
This issue is present not only when entering '-' or '+' but also when entering '--', '- ', '--- ', '===-+_-', '-- a --' ... basically even when the formula is invalid.
The simplest resolution would probably be to disable this for cells formatted as text. A proper solution would be to add a position in the menu to disable "formula mode" or how it's called, similarly to auto correct. There is also plenty of space in LibreOffice Calc - Formula tab in Options.
Sorry for this long explanation. I appreciate your work on the software. I just don't see how some custom behavior triggered by a specific combination of characters that can't be disabled is not a bug. Imagine driving a car where pressing the break, left turn indicator, and then low beam headlights, in that order, causes the airbag to blow up.
(In reply to Grzegorz Junka from comment #7)
> A proper solution would be to add a position in the menu to disable "formula mode"
It's not that I cannot follow the use case, it's annoying for me as well sometimes. But point is, Calc is a spreasheet tool and we should make it comfortable for working with numbers not text.
And I disagree with too many options, in particular exposed at the main menu or toolbars. Keep it simple!
> The simplest resolution would probably be to disable this for cells
> formatted as text.
Could imagine this solution. Eike, what do you think?
Thanks for looking into this.
I would argue that most people use Calc to enter tabular data, i.e. texts and numbers. The vast majority of users doesn't use formulas. Those who do most likely just use SUM. At my work I rarely encounter spreadsheets that do anything more than gather data. Some people might have heard about formulas but very few understand them. Basically someone needs to work with spreadsheets the majority of their time to use formulas to any extent.
Do you have any statistics about how often features are used, in particular formulas, and even more specifically, by entering them as starting with -/+ in a cell?
I understand the argument that it must be comfortable to work with numbers, but from my experience this is a slim minority of use cases. The majority is mixed use of text, numbers and dates with a significant usage just as a tool to work with text-based data.
I am also not after too many options but as I noted, the Options window for Formula already presents a bunch of other less useful settings that the user can turn on and off. I don't see a problem adding an option to disable auto-formula mode.
And to reiterate, if the user made the effort to format a cell specifically as text then making these cells to work as number cells with respect to entering formulas is a bit overboard.
(In reply to Grzegorz Junka from comment #9)
> Do you have any statistics about how often features are used...
Unfortunately not, planned a survey on this for some time. Let's see what the master of Calc, Eike, thinks.
(In reply to Grzegorz Junka from comment #7)
> In this case it's very similar. User can't enter "-" and move to next cell
> without triggering the formula entering mode.
I am able to do it in Version 18.104.22.168 by pressing tab after entering '-' or '+'.
> I am able to do it in Version 22.214.171.124 by pressing tab after entering '-' or
Yes, can work as a workaround when you want to move to the next cell, but not when you want to move up, down or left.