Bug 158247 - Allow F1 in Formula Bar inside formulas to work as in Function Wizard's Formula
Summary: Allow F1 in Formula Bar inside formulas to work as in Function Wizard's Formula
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Formula-Bar Calc-Function Help-Link
  Show dependency treegraph
 
Reported: 2023-11-16 17:42 UTC by Mike Kaganski
Modified: 2023-11-30 20:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2023-11-16 17:42:20 UTC
Currently, when creating formulas in Calc's Function Wizard, putting cursor inside brackets of a function, and pressing F1, brings one to the online help for that function.

* In any cell, execute Insert->Function Ctrl+F2;
* In the Formula box, type formula '=LOG(1;2)';
* Put cursor inside brackets (say, between "1" and ";");
* Press F1.

=> It will either open offline help for LOG function, or navigate to online helf for it.

OTOH, pressing F1 in Calc's Formula Bar does simply nothing (at least on Windows).

The proposal is to allow the same behavior as explained above for the Formula box inside the Function Wizard.
Comment 1 Stéphane Guillou (stragu) 2023-11-30 20:13:33 UTC
Agreed that opening the corresponding formula help is ideal.

In OOo 3.3 and 7.0, it would open the Input Line help page, using HID=SC_HID_INSWIN_INPUT#bm_id3150084.
Since 7.1, I get a 404 with HID=modules/scalc/ui/inputbar/sc_input_window, regardless of it the formula bar contains nothing, or the cursor is inside the parentheses or in the function name.

So we should:
1. restore the Input Line documentation as the default. The new HID should point to https://help.libreoffice.org/latest/en-US/text/scalc/02/06050000.html
2. implement the link to formula help

If editing the cell directly, F1 leads to the main help page with HID=SC_HID_SC_WIN_GRIDWIN#bm_id3155335 – but that's already tracked in the closely related bug 157020.

Version: 24.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 5589659829f8a1cef8ca1c8a468732105bbe231b
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded