<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - F4 shortcut for switching between relative and absolute cell references doesn't work in range pickers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142341">142341</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>F4 shortcut for switching between relative and absolute cell references doesn't work in range pickers
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>stephane.guillou@member.fsf.org
</td>
</tr></table>
<p>
<div>
<pre>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@86-TDF, Branch:master, Time:
2021-05-14_04:32:30
Calc: threaded</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>