Created attachment 100085 [details]
a image of an mock-up to illustrate my idea
Beginners in Calc raise very often very simple question about errors of formulas in Calc. The explanation in the status bar is often not seen (it took me also a while!) but then not very suitable for a beginner.
II created a mock-up of my "best version". It would be very helpful for beginners.to provide easier to understand the problem.
For me personally the information in the status bar is good an helps me typically to make corrections. But the beginners...
Operating System: All
Version: 22.214.171.124 release
Valid enhancement request but seems quite hard to implement with all of the different things that a user can do wrong when they enter a new formula (literally, thousands of combinations)
Low - the error code now gives enough info to at least google a bit, this will be hard to implement (might even be impossible to perfectly implement). The example provided is a clear cut example but I can imagine the majority of user errors for formulas are much harder to "guess" at what they did incorrectly
*** Bug 101085 has been marked as a duplicate of this bug. ***
Even without looking at the source code, LO can't (and shouldn't) be using manually coded reactions, just like any coder-friendly programming language, meaning an automatic parser, which is where the "explanation[s]" and/or "clue[s]" are/would be constructed since the parser follows a set of syntax. Or it should.
*** Bug 151669 has been marked as a duplicate of this bug. ***