Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.1.888 Part 4 Section 3.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:
© 2015 Microsoft