Error 508?
Posted: Mon Jun 28, 2010 4:23 am
Formula "=COUNTBLANK(generic?)" gives me 508 error, why? GENERIC? is a range name.
User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
https://forum.openoffice.org/en/forum/
It is odd though that Calc does not protest about the "?" in "Generic?" when defining the named range.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.