Bug 97551 - add “formula marker” feature like in Quattro Pro
Summary: add “formula marker” feature like in Quattro Pro
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-UX
  Show dependency treegraph
Reported: 2016-02-04 09:13 UTC by Brolin Empey
Modified: 2019-02-04 20:46 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

The same simple test document is open in both Quattro (70.87 KB, image/png)
2016-02-04 09:13 UTC, Brolin Empey

Note You need to log in before you can comment on or make changes to this bug.
Description Brolin Empey 2016-02-04 09:13:56 UTC
Created attachment 122371 [details]
The same simple test document is open in both Quattro

Version 9 and later of Quattro Pro for Windows (QPW) have a useful and unique “formula marker” feature that draws a blue triangle in the bottom-left corner of a cell that contains a formula.  When pointing over the blue triangle, the formula is shown in a tooltip even if a different cell is selected.  Please add this feature to LibreOffice Calc.
Comment 1 Brolin Empey 2016-02-04 09:28:40 UTC
I prematurely submitted this bug by accidentally pressing Enter instead of Shift whilst writing a description of the attached file.  Now I cannot edit the description of the attached file in the prematurely-submitted bug because I always get the following error page:

“Software error:

DBD::Pg::db do failed: ERROR:  value too long for type character varying(255) [for Statement "UPDATE attachments SET description = ? WHERE attach_id = ?"] at Bugzilla/Object.pm line 385
	Bugzilla::Object::update('Bugzilla::Attachment=HASH(0x30c9ec8)') called at Bugzilla/Attachment.pm line 890
	Bugzilla::Attachment::update('Bugzilla::Attachment=HASH(0x30c9ec8)', '2016-02-04 09:22:15') called at /srv/bugzilla//bugzilla-4.4.6/attachment.cgi line 714
	main::update() called at /srv/bugzilla//bugzilla-4.4.6/attachment.cgi line 103
For help, please send mail to this site's webmaster, giving this error message and the time and date of the error.”

The description of the attached file is supposed to be:

“The same simple test document is open in both Quattro Pro and LibreOffice Calc.  The mouse cursor, which is not included in the screen capture, is pointing at the formula marker (blue triangle) in the bottom-left corner of cell C6 in the document in Quattro Pro.”

Please correct the description of the attached file.
Comment 2 Buovjaga 2016-02-10 18:57:30 UTC
I daresay, UX team, would you mind taking a look at this?
Comment 3 Yousuf Philips (jay) (retired) 2016-02-22 19:57:27 UTC
We currently have an indicator to show when a cell has a comment, so having a similar one for when a cell has a calculation isnt unreasonable for those who wish to notice this at a glance. This feature is available also in WPS/Kingsof Office, which puts the green indicator in the top left corner.

LibreOffice does have the option Tools > Options > Calc > View > Display > Value highlighting, that colors numeric and formula values blue and green respectively.

@Eike: Any opinions about this?
Comment 4 Brolin Empey 2018-10-23 18:12:10 UTC
Bump.  Any news?  Apparently we never heard from Eike.  I requested this feature to be added to Google Sheets too:

Comment 5 Eike Rathke 2018-10-23 19:54:55 UTC
Shrug, if people find such thing useful and someone implements it..
I'd avoid an additional "blue triangel" or whatever marker though, which would be just distracting (if people want to distinguish formulas and other content there's value highlighting already). Displaying the formula in a tip help when hovering with the mouse on a cell for some decent time is sufficient.
Comment 6 Heiko Tietze 2018-10-24 10:21:44 UTC
Let's go with an option. I'm a bit concerned of all the indicators, font color, highlighting, triangles etc. not having a concept like "type of content is shown as color triangle", "kind of variable is denoted per font color" etc.