[Libreoffice-bugs] [Bug 142341] New: F4 shortcut for switching between relative and absolute cell references doesn't work in range pickers

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142341

            Bug ID: 142341
           Summary: F4 shortcut for switching between relative and
                    absolute cell references doesn't work in range pickers
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stephane.guillou at member.fsf.org

Description:
When picking a cell reference (aka "coordinate") in a range picker, like the
one used in the Function Wizard or the chart's Data Range dialogue, it is not
possible to use the F4 shortcut to circle through the different combinations of
relative and absolute cell references.

Steps to Reproduce:
1. Create a new Calc sheet
2. Add "1" in cell A1
3. Click in cell B1
4. Click the Function Wizard button
5. Double-click on the first function "ABS"
6. Click on cell A1 to fill the "Number" field with its reference
7. Press the key F4 to try and cycle through absolute and relative options

Actual Results:
The F4 shortcut does not work in this dialogue. It doesn't work either when
using the "shrinked" data range picker (by clicking the button to the right of
the field), or using the range picker in the Chart dialogue (Data Range tab).

Expected Results:
The shortcut works both when editing the formula in the cell or when using a
data range picker.


Reproducible: Always


User Profile Reset: No



Additional Info:
Note that I don't know if this used to work or not before branch 7.0. I just
know that the shortcut does work in Microsoft Office Excel when using a range
dialogue.

Tested in versions:

Version: 7.0.4.2
Build ID: 00(Build:2)
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.4_rc2-0ubuntu0.18.04.2
Calc: threaded

Version: 7.1.3.2 / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 6b09276d157abada74e1a4989700139167207778
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64 at 86-TDF, Branch:master, Time:
2021-05-14_04:32:30
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210518/fc9fa4c6/attachment.htm>