Bug 79397 - EDITING: Make error code in Calc related to formulas easier to understand
Summary: EDITING: Make error code in Calc related to formulas easier to understand
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: low enhancement
Assignee: Not Assigned
Whiteboard: BSA
: 101085 (view as bug list)
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
Reported: 2014-05-29 07:47 UTC by bugquestcontri
Modified: 2018-12-18 08:31 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

a image of an mock-up to illustrate my idea (10.53 KB, image/png)
2014-05-29 07:47 UTC, bugquestcontri

Note You need to log in before you can comment on or make changes to this bug.
Description bugquestcontri 2014-05-29 07:47:30 UTC
Created attachment 100085 [details]
a image of an mock-up to illustrate my idea

Problem description: 
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: release
Comment 1 Joel Madero 2014-07-16 20:43:20 UTC
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
Comment 2 Aron Budea 2016-07-25 05:30:10 UTC
*** Bug 101085 has been marked as a duplicate of this bug. ***
Comment 3 Jouni Järvinen 2017-01-22 16:39:53 UTC
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.