2.5.166 XLNameWideString

The XLNameWideString structure specifies a defined name.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

string (variable)

...

string (variable): An XLWideString (section 2.5.169) structure that specifies the name. The length of the string MUST NOT exceed 255 characters.

The string MUST adhere to the following grammar:

 string =  name-start-character *name-character  
  
 name-start-character =  "_" /   "\" / az-letter / Unicode-character 
  
 name-character =  name-start-character  / "?" / 0x061F / "."  /  Unicode-digit 

This applies where Unicode-character is any code point greater than 0x7F that is a character as defined by the Unicode character properties, section 4 of [UNICODE4.0].

Unicode-digit is any code point that is a digit as defined by the Unicode character properties, Chapter Four of [UNICODE4.0].

The string MUST NOT equal "TRUE" or "FALSE" (case-insensitive).

The string MUST NOT be an A1 cell reference and MUST NOT begin with an R1C1 cell reference.

An R1C1 cell reference is defined to be:

 R1C1-cell-reference =  R1C1-row / R1C1-column / R1C1-row R1C1-column / R1C1-column R1C1-row 
  
 R1C1-row = letter-r row-number
  
 letter-r = "R" / "r"
  
 R1C1-column = letter-c column-number
  
 letter-c = "C" / "c"
column-number = 1-16384
; A string composed of Unicode digits (see earlier definition) that represents an unsigned integer that is greater than or equal to 1 and less than or equal to 16384
row-number = 1-1048576
; A string composed of Unicode digits (see earlier definition) that represents an unsigned integer that is greater than or equal to 1 and less than or equal to 1048576.

An A1 cell reference is defined to be:

 A1-reference  = A1-column A1-Row
  
 A1-row = row-number
  
     ; See definition of row-number in R1C1 cell reference grammar earlier. 
  
  
 A1-column = 1*2 az-letter / aw-letter az-letter az-letter / "X" ae-letter az-letter / "X" "F" ad-letter
  
 ad-letter = "A" / "B" / "C" / "D" / "a" / "b" / "c" / "d"

ae-letter = ad-letter / "E" / "e"

 aw-letter = ae-letter / "F" / "G" / "H" / "I" / "J" / "K" / "L" / "M" / "N" / "O" / "P" / "Q" / "R" / "S" / "T" / "U" / "V" / "W" / "f" / "g" / "h" / "i" / "j" / "k" / "l" / "m" / "n" / "o" / "p" / "q" / "r" / "s" / "t" / "u" / "v" / "w"
  
az-letter = aw-letter / "X" / "Y" / "Z" / "x" / "y" / "z"