Description: I have created a dictionary using calc and tried use name definition to quickly go to the first entry i.e all words stating with the letter A thru the letter Z. I am able to define all single letters of the alphabet except for C and R. Steps to Reproduce: 1.sheet 2.named ranges and expressions 3.define Actual Results: will not accept characters C or R when entered Expected Results: All characters of the alphabet should be able to be defined Reproducible: Always User Profile Reset: No Additional Info: Version: 25.2.2.2 (X86_64) / LibreOffice Community Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac CPU threads: 2; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
https://help.libreoffice.org/latest/en-US/text/scalc/guide/value_with_name.html?DbPAR=CALC > Names must not start with the letters C or R followed by a number; also single > characters C and R are not allowed as names. See the ADDRESS function for more > information. This is not a bug, and caused by R1C1 address notation. It is documented. Closing.