[Solved+Issue] Tooltip hints for formula fields

[IKStool]

In the old office (v3.3), the formula hint showed the formula itself. In subsequent versions, this was "broken." The tooltip shows the meaning of the expression, which I already see on the page. How to return "old" hints?

https://disk.yandex.com/i/uCx2cVXea-jzLg -- new Office (3.4+)

202402230837.jpg (37.88 KiB) Viewed 3029 times

https://disk.yandex.com/i/bJON3uWUHUj1wg -- "True Hints" Office 3.3

202402230838.jpg (11.26 KiB) Viewed 3029 times

[FJCC]

I don't know of a way to change the tooltip, but you can see the desired information by pressing the keys CTRL + F9 to toggle between the field value and the field name.

[Nick N,]

In the old office (v3.3), the formula hint showed the formula itself. In subsequent versions, this was "broken." The tooltip shows the meaning of the expression, which I already see on the page. How to return "old" hints?

https://disk.yandex.com/i/uCx2cVXea-jzLg -- new Office (3.4+)202402230837.jpg


https://disk.yandex.com/i/bJON3uWUHUj1wg -- "True Hints" Office 3.3202402230838.jpg

Hi,

How did you get that?

Nick

[IKStool]

I don't know of a way to change the tooltip, but you can see the desired information by pressing the keys CTRL + F9 to toggle between the field value and the field name.

I understand, but this is completely inconvenient. Formatting is completely lost. For big documents, it's a problem.
We need a hint, as in the "old" office

[IKStool]

How did you get that?

What exactly?

[Zizi64]

Formatting is completely lost. For big documents, it's a problem.

What formatting is lost? The formatting of the Fields?
What type of the fields are you using in the Writer document showed by your attached images? Can you upload an ODF type sample file here? What settings (of the fields or of the hints) are you using to display the field name and the field value in same time?

We need a hint, as in the "old" office.

I can not find such function even in my LibreOffice Writer, when I am using the available Field types, even is I have set the "Extended Tips" option.
Maybe the only one "solution" is to use the archaic old OOo version, what has such feature.

[cwolan]

Archaic LibreOffice 3.3.0.4 vs brand new 7.5.6.2
⠀

juxtaVER.gif (97.66 KiB) Viewed 2736 times

⠀

Edit: By "brand new" I obviously meant 7.6.5.2 (in text and in recording)

[Hagar Delest]

I agree, the former behavior makes much more sense. Why display as a tooltip the information already in clear in the text??? Showing what is the source or the formula resulting in the value is way more useful.

You should file a bug report, I think it can be considered as a regression (maybe it has already been filed, I have not checked): [Tutorial] Reporting bugs or suggestions.

[Nick N,]

How did you get that?

What exactly?

Do apologize for the remark, thus i cannot figure out what for is to raise such query, if it's only a matter of product feature.

Regards

Nick

[IKStool]

Formatting is completely lost. For big documents, it's a problem.

What formatting is lost? The formatting of the Fields?

If the formula is long, then it "stretches" the document.
Example. Source document 4 pages. After "Ctrl + F9" - 52 pages. It is difficult to find the one, the most necessary formula.

Clipboard02.jpg (123.1 KiB) Viewed 2220 times

[Zizi64]

Example. Source document 4 pages. After "Ctrl + F9" - 52 pages. It is difficult to find the one, the most necessary formula.
Image

Please upload a real, ODF type sample file here.

[Hagar Delest]

Anyway, even if we can see the formula by another mean, that is with field display (Ctrl+F9), it defeats the point of a meaningful tooltip.

[cwolan]

In case of LibreOffice: tdf#159446 ("UX Design/Technical Writing: Collect and analyze tooltip text on fields") might be relevant.

[JeJe]

You can place a (transparent) form control label and set its tooltop to whatever you want.

[Hagar Delest]

I think that the point is not really how to display the formula but to correct a regression.
We will always be very good at finding workarounds. At some point, better fix what is broken.

[IKStool]

Please upload a real, ODF type sample file here.

Please:

exampe1.odt

(9.42 KiB) Downloaded 118 times

))))

I have a lot of this formatting in documents. and a dilemma arises - the convenience of working with formulas (OpenOffice v3.3) or the use of modern extensions (OpenOffice v4 +)

[Zizi64]

From your sample file:

Code: Select all

a=1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6;     b=-689+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+3;2

Why you use such huge formulas?

[IKStool]

Why you use such huge formulas?

Production necessity. Corporate design standards. And so on...

[JeJe]

The attached document implements the label tooltip suggestions - the macro has added a form control over all the textfields with the content (formula) as the tooltip. it works with your sample as a run once upon document completion, but would be fiddly if edits were needed afterwards.

As suggested, a bug/feature request in LibreOffice might be listened to, but the timescale might not be short.

[Hagar Delest]

As suggested, a bug/feature request in LibreOffice might be listened to, but the timescale might not be short.

It depends.
Since it is a regression, it may be possible to easily go back to the initial behavior.

[IKStool]

The attached document implements the label tooltip suggestions - the macro has added a form control over all the textfields with the content (formula) as the tooltip. it works with your sample as a run once upon document completion, but would be fiddly if edits were needed afterwards.

As suggested, a bug/feature request in LibreOffice might be listened to, but the timescale might not be short.

Thanks! Almost a working option. If the formula in the line is one, then it works. If the formula is not the first in the line, then the hint is shifted, and the second and third formulas do not work.

[JeJe]

Fixed that and tidied the macro up a bit.

[IKStool]

Fixed that and tidied the macro up a bit.

THANKS!!!! SUPER!!!!