2.1.859 Part 1 Section 18.17.2.1, Constants

a.   The standard does not specify the set of productions for constant using EBNF.

Office writes the productions for constant using the following EBNF:

 constant=
   error-constant  |
   logical-constant  |
   numerical-constant  |
   string-constant  |
   array-constant  ;
 error-constant=
   "#DIV/0!"  |  "#N/A"  |  "#NAME?"  |  "#NULL!"  |  
   "#NUM!"  |  "#REF!"  | "#VALUE!" | "#GETTING_DATA"; 
 logical-constant=
   "FALSE"  |  "TRUE"  ;
 numerical-constant=
   [neg-sign],  significand-part, [exponent-part] ;
 significand-part=
   whole-number-part, [fractional-part] |
   fractional-part ;
 whole-number-part=
   digit-sequence;
 fractional-part=
   full-stop, digit-sequence  ;
 exponent-part=
   exponent-character, [ sign ], digit-sequence  ;
 full-stop=
   "."    ;  (* also known as “period” *)
 sign=
   "+"  |
   neg-sign  ;
 neg-sign=
   "-" ;
 exponent-character=
   "E" | "e" ;
  
 digit-sequence=
   decimal-digit,  {decimal-digit}  ;
 nonzero-digit-sequence=
 nonzero-decimal-digit,  {decimal-digit}  ;
 decimal-digit=               
   "0"  |  nonzero-decimal-digit  ;
 nonzero-decimal-digit=
   "1"  |  "2"  |  "3"  |  "4"  |  
   "5"  |  "6"  |  "7"  |  "8"  |  "9"  ;
  
 string-constant=
   double-quote, [string-chars], double-quote  ;
 string-chars=
   string-char,  {string-char}  ;
 string-char=
   escaped-double-quote  |
   character  -  double-quote  ;   (* any character except double-quote *)
 escaped-double-quote=
   ' "" '  ;   (* consecutive double-quotes, with no space between them *)
 double-quote=
   ' " '  ; (* one double-quote character*)
 character=
   as defined by the production Char in the XML 1.0 specification, §2.2.

b.   The standard does not specify the set of productions for array-constant using EBNF.

Office writes the productions for array-constant using the following EBNF:

 array-constant=
   "{",  constant-list-rows,  "}"  ;
 constant-list-rows=
   constant-list-row,  {  semicolon,  constant-list-row  }  ;
 semicolon=
   ";"    ;
 constant-list-row=                     
   constant,  {  comma,  constant  }  ;

c.   The standard does not list #GETTING_DATA as being saved in any formulas.

Office saves #GETTING_DATA in formulas.

Show: