Issue 40569 - more informative message when invalid name chosen for data range
Summary: more informative message when invalid name chosen for data range
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 680m69
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-13 12:08 UTC by richlv
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description richlv 2005-01-13 12:08:06 UTC
when data range is created (data->define range) and an invalid name is chosen 
(for example, a1), error message says "invalid name".

it should be more informative, explaining constraints placed on it, something 
like rauf abdul wrote on users list :
"Only numbers and characters are allowed for named ranges. Every
combination which could be a cell reference (e.g. A1 - IV65536) is not allowed."
Comment 1 frank 2005-01-13 13:17:13 UTC
requirements
Comment 2 nostabo 2006-05-15 03:19:29 UTC
The suggested message "Only numbers and characters are allowed for named ranges.
Every combination which could be a cell reference (e.g. A1 - IV65536) is not
allowed."
Is not completely true, you can use underscores (_), periods (.) colons (:), 
dollar signs ($), and question marks (?); at least in my version (English USA) 2.0.2

But I agree that the message is vague, however it is consistent with other
spreadsheet applications.