NamedRange naming rules

[MikeMcClain46]

mike@RPI4b3:~> uname -a
Linux MikesPI 6.1.0-rpi7-rpi-v8 #1 SMP PREEMPT Debian 1:6.1.63-1+rpt1 (2023-11-24) aarch64 GNU/Linux

Version: 7.4.7.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: x11
Locale: en-US (C); UI: en-US
Raspbian package version: 4:7.4.7-1+rpi1+deb12u8
Calc: threaded
While exploring named ranges I named such a range “C3”.
addNewByName() kept throwing errors like so:
“Message: Invalid name. Reference to a cell, or a range of cells not allowed”
If I weren’t nuts already I would have been by the time I changed the name for said range to “Oops” and suddenly I got no more complaints.
Thinking perhaps the name “C3” showed up somewhere in the code I switched it to “Z4” again I got the above error message.
Had the message stopped only saying “Invalid name.” I might have caught on hours sooner.
Has anyone seen naming rules for named ranges?
If so please post here.
Thanks,
Mike

[mikekaganski]

C3, Z4 - why not A1? Or even A1:C3? Doesn’t “Reference to a cell, or a range of cells not allowed” tell you what doesn’t it like? Suppose you named your named range “C3”. OK, but how will you now call "cell in column C, row 3"?

@MikeMcClain46

Has anyone seen naming rules for named ranges?

https://help.libreoffice.org/latest/en-US/text/scalc/guide/value_with_name.html?DbPAR=CALC

[MikeMcClain46]

Thank you.
You’re absolutely correct, I just don’t think in those terms since all that I do is in the R1C1 notation except when I run across some function in Calc that requires A1 notation then I have to write a macro that converts R1C1 ro A1.
Thanks for the pointer.
Be well,
Mike