Bug 79397 - EDITING: Make error code in Calc related to formulas easier to understand (e.g. with hints in a tooltip)
Summary: EDITING: Make error code in Calc related to formulas easier to understand (e....
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 101085 151669 (view as bug list)
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
 
Reported: 2014-05-29 07:47 UTC by bugquestcontri
Modified: 2024-03-11 03:06 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


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

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: 4.2.4.2 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)

New
Enhancement
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.
Comment 4 Stéphane Guillou (stragu) 2023-04-28 22:11:14 UTC
*** Bug 151669 has been marked as a duplicate of this bug. ***