Calc version 5.2 includes formula tips (during cell edit mode) that have been expanded to include a context sensitive explanation of each parameter. Under 5.1 the tip is: SUMIFS(sum_range,range 1,criteria 1,range 2,criteria 2,...) Under 5.2 the tip changes depending on the cursor position: SUMIFS(sum_range,range 1,criteria 1,range 2,criteria 2,...):The range from wich the values are to be totalled. SUMIFS(sum_range,range 1,criteria 1,range 2,criteria 2,...):Range1,range2,... are the ranges to be evaluated by the criteria given. SUMIFS(sum_range,range 1,criteria 1,range 2,criteria 2,...):Criteria 1, criteria 2,... are the criteria to be applied to the ranges given. This is excellent for new users and perhaps most users but for experienced users these extended & dynamic tips can be visually distracting. For tool bar tips the user can choose between standard or extended tips as follows: Tools > Options > LibreOffice > General :: Help Extended Tips = [Y|N] The enhancement request is to add user choice for formula tips like: Tools > Options > LibreOffice > General :: Help Formula Tips = [Y|N] or Tools > Options > LibreOffice > General :: Help Formula Tips = [None|Standard|Extended] (Where Standard means a tip like provided under 5.1)
Thanks for the report Bruce. Set to new. Cor
The second option of a choice between None ,Standard and Extended is good and should cover all Tooltips.
*** Bug 129234 has been marked as a duplicate of this bug. ***
I'm seeing the same kind of problem as 129234 (which I disagree is the same bug as this -- 129234 is misplacement of the tooltip, which could be resolved by placing the tooltips sensibly; this issue would provide a workaround for it, but not a fix). It's making it *very* difficult to use a complex formula, as I can't see the formula at preceisely the point I'm typing into. I'm using version 7.0.4.2 on Debian.
Created attachment 169921 [details] Screen shot illustrating issue Screenshot illustraing the issue -- I can't see the immediate context of the formula around the cursor.