[Libreoffice-bugs] [Bug 144766] New: Constant reference to cell address using "$$" prefix notation.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144766
           Summary: Constant reference to cell address using "$$" prefix
                    notation.
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: michael.truenorth at protonmail.com

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

-- 
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/20210928/4e236b74/attachment.htm>