Created attachment 200880 [details] "Manage Names" window with error message In order to avoid confusions I propose to adjust the error message in the "Manage Names" window in Calc. The error message could look like “Invalid name. Start with a letter, except c,C or r,R followed by a number. Use only letters, numbers and underscore.”
+ Adjust extended tip as well.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/44fbe5b8d92f48ffdabc0af12f4d653ddaf24c3d tdf#166662 Improve ext tips for named range naming rules. It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b8f23b6946f819f57c4115d2f6fd75b923b76c6b tdf#166662 Improve bad range name error msg. It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply comment #3) > Olivier Hallot committed: > https://git.libreoffice.org/core/commit/ > b8f23b6946f819f57c4115d2f6fd75b923b76c6b >It must start with a letter >(excluding c, C, r, or R followed by a number) or underscore. > ^ > | Shouldn't parenthesis be in this position?: It must start with a letter (excluding c, C, r, or R) followed by a number or underscore. ^ |
A name like "a1qweq" is valid. A name like "r1qweq" is not allowed. So, the restriction on number is only when letters r,R,c,C are followed by any number, no matter what follows that number. Also, the name cannot represent a cell address, such as a123. Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: c674ba2e7aafae1955f43ad377fa8369b5f1eb11 CPU threads: 16; OS: Linux 6.14; UI render: default; VCL: x11 Locale: pt-BR (pt_BR.UTF-8); UI: pt-BR Calc: threaded