<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 - Constant reference to cell address using "$$" prefix notation."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144766">144766</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Constant reference to cell address using "$$" prefix notation.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</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>michael.truenorth@protonmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Currently a constant reference to cell in formulas is given using
"$<column>$<row>" notation. When editing a formula, one can click on a desired
cell to fill the address into the formula, however, that does not allow a full
constant reference. One can prefix the click with a '$' to have constant column
reference. When constant row reference is also required, one has to click in
editing line to move the formula cursor before the column reference to type in
another '$'. Normally arrow keys move the cells' cursor (which is useful in
general). I have added a macro (will attach to the bug), that activates on cell
change and implements that notation, it seems useful. The macro could help with
current and previous versions, but I think it might be a good idea to implement
that functionality in the program itself.
Steps to Reproduce:
1.Start filling formula into cell, e.g. "=3+$$"
2.Click on a desired cell, e.g. D4
3.Press Enter
Actual Results:
The edited cell reports a syntax error.
Expected Results:
The cell would be filled with formula "=3+$D$4", or left with original text,
but with the meaning of constant cell reference.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.1.6.2 (x64) / LibreOffice Community
Build ID: 0e133318fcee89abacd6a7d077e292f1145735c3
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL</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>