[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 Baole Fang changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |baole.f...@gmail.com |desktop.org | --- Comment #17 from Baole Fang --- I've submitted a patch [1] for this ticket according to [2]. It should disable "=","+","-" formula in text cell. Not sure if it is expected. [1] https://gerrit.libreoffice.org/c/core/+/152356 [2] https://bugs.documentfoundation.org/show_bug.cgi?id=131638#c3 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 ady changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||1638 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 Stéphane Guillou (stragu) changed: What|Removed |Added Version|6.3.4.2 release |Inherited From OOo CC||stephane.guillou@libreoffic ||e.org OS|FreeBSD |All See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||9369 --- Comment #16 from Stéphane Guillou (stragu) --- This is very much related to bug 129369, in which Eike already mentioned it could be resolved with an extra option to turn off formula mode when starting with +/- (see bug 129369 comment 7). Possibly a duplicate if we agree it should be turned into an enhancement request. A cell formatted as Text will still enter formula mode when starting with "=", so that's not specific to -/+. And this is the case since OOo 3.3 times. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 Heiko Tietze changed: What|Removed |Added Status|NEW |NEEDINFO -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #15 from ady --- (In reply to Heiko Tietze from comment #14) > (In reply to ady from comment #13) > > I am having some difficulty understanding the inconvenience/problem. > > Grzegorz wants to insert a minus or plus character but starts formula > editing. But if that is all, I've just posted a workaround (use those keys instead of arrow keys) which has been well-known for decades. So, my thinking was that there must be some other initial situation or use-case that triggered this report, and I wanted to understand/know what _that_ was. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #14 from Heiko Tietze --- (In reply to ady from comment #13) > I am having some difficulty understanding the inconvenience/problem. Grzegorz wants to insert a minus or plus character but starts formula editing. Comment 3 is pretty clear in WF, and quoting is always possible. We should resolve this request as WF/NAB. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #13 from ady --- I am having some difficulty understanding the inconvenience/problem. I'll write here a certain procedure, and I'd like to know what is exactly that I am missing. 1. Select an area (or the whole spreadsheet) and format cells as text. 2. In the first cell, press the minus sign. 3. Press [ENTER]. The cell now contains a minus and the focus moved to the cell below it. * If instead of moving down, I want to move up, then step 3 would be to press [SHIFT]+[ENTER]. * If instead of moving down, I want to move right, then step 3 would be to press [TAB]. * If instead of moving down, I want to move left, then step 3 would be to press [SHIFT]+[TAB]. * Instead of the minus sign, the same goes for the plus sign. The only possible inconvenience here would be if the cells are not adjacent and I want to go directly from one to the other without using [ENTER] or [TAB]. But even in that case, I could just copy+paste. So, for adjacent cells, the procedure is not complicated. Only for non-adjacent cells there is some minimal extra work, or copy-paste can be used. I am not seeing the use-case that is not overcome by [ENTER], [TAB] and [SHIFT] keys instead of using the arrow keys. Perhaps these keys are not as comfortable or as close to a numeric pad as the arrow keys. Is that it? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 BogdanB changed: What|Removed |Added CC||buzea.bog...@libreoffice.or ||g Blocks||108253 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108253 [Bug 108253] [META] Calc cell formula bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #12 from Grzegorz Junka --- > I am able to do it in Version 6.3.4.2 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #11 from Michael Warner --- (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 6.3.4.2 by pressing tab after entering '-' or '+'. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #10 from Heiko Tietze --- (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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #9 from Grzegorz Junka --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 Heiko Tietze changed: What|Removed |Added CC||er...@redhat.com --- Comment #8 from Heiko Tietze --- (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? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #7 from Grzegorz Junka --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org --- Comment #6 from Heiko Tietze --- 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". -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Severity|minor |enhancement Status|REOPENED|NEW --- Comment #5 from Roman Kuznetsov <79045_79...@mail.ru> --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #4 from Grzegorz Junka --- Actually I also completely lost why this has been marked as a duplicate of a localization bug. Reopened. Can someone please add some reasoning? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 Grzegorz Junka changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|DUPLICATE |--- -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 --- Comment #3 from Eike Rathke --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 Heiko Tietze changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #2 from Heiko Tietze --- Request to optionally disable this feature was recently refused. *** This bug has been marked as a duplicate of bug 133203 *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 Buovjaga changed: What|Removed |Added Ever confirmed|0 |1 Whiteboard| QA:needsComment| CC||libreoffice-ux-advise@lists ||.freedesktop.org Keywords||needsUXEval Status|UNCONFIRMED |NEW --- Comment #1 from Buovjaga --- In AskLibO, Mike asked to create this report. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode
https://bugs.documentfoundation.org/show_bug.cgi?id=132026 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
