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.
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:
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.
I daresay, UX team, would you mind taking a look at this?
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?
Bump. Any news? Apparently we never heard from Eike. I requested this feature to be added to Google Sheets too:
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.
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.