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
Created attachment 175316 [details] Basic Macro that implements the notation described in the bug. Basic is not my preferred script language, but it was the only one available for the task in LibreOffice I had (on Linux) when I created that macro.
The solution is to press F4, that is the default key to cycle through all possible relative/absolute combinations [1]. I close this as WONTFIX. There's no need to introduce this new way to get what is already possible using an existing feature. Thanks for the suggestion anyway! [1] https://help.libreoffice.org/latest/en-US/text/scalc/guide/relativ_absolut_ref.html?DbPAR=CALC