Error 508?

Discuss the spreadsheet application

Error 508?

Postby Urmas » Mon Jun 28, 2010 4:23 am

Formula "=COUNTBLANK(generic?)" gives me 508 error, why? GENERIC? is a range name.
OOo 3.1.0 on Ubuntu 10.x + Windows XP
Urmas
 
Posts: 14
Joined: Sat Nov 15, 2008 12:25 am

Re: Error 508?

Postby ken johnson » Mon Jun 28, 2010 4:44 am

Drop the "?" from the range name and the error goes away.
The "?" is not an allowed character in a name. The following is from Calc Help...
Names in Calc can contain letters, numeric characters, and some special characters. Names must start with a letter or an underline character.
Allowed special characters:
underline (_)
period (.) - allowed within a name, but not as first or last character
blank ( ) - allowed within a name, but not as first or last character, and not for a cell range
Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell.
Names for cell ranges must not include blanks. Blanks are allowed within names for single cells, sheets and documents.

It is odd though that Calc does not protest about the "?" in "Generic?" when defining the named range.

Ken Johnson
AOO 4.0.1 on Ms Windows 7
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
ken johnson
Volunteer
 
Posts: 840
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests