[Libreoffice-bugs] [Bug 132026] Entering "-" in a cell formatted as text puts Calc into formula-entering mode

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132026

--- Comment #9 from Grzegorz Junka <list1 at gjunka.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200715/8451f64a/attachment.htm>