The cell reference syntax seems to allow decimal numbers. It should not.

Restrict the numbers to integers.

Part 4, 3.17.2.3

te

Proposed Disposition of DIS 29500 Comment ECMA-0031 (Modified: 2007-12-05) Agreed; in response to comments AU-0011, CA-0043, FR-0436, GB-0361, and US-0245, the grammar for SpreadsheetML formulas has been completely rewritten using the notation defined by ISO/IEC 14977:1996, “Syntactic metalanguage — Extended BNF”. As a result, the syntax for cell references is, as follows: A1-reference= A1-column, ":", A1-column | A1-row, ":", A1-row | A1-column, A1-row ; A1-column= A1-relative-column | A1-absolute-column ; A1-relative-column= letter, {letter} ; (* see semantic rules at 3.17.2.3.1 *) letter= "a"|"b"|"c"|"d"|"e"|"f"|"g"|"h"|"i"|"j"|"k"|"l"|"m"| "n"|"o"|"p"|"q"|"r"|"s"|"t"|"u"|"v"|"w"|"x"|"y"|"z"| "A"|"B"|"C"|"D"|"E"|"F"|"G"|"H"|"I"|"J"|"K"|"L"|"M"| "N"|"O"|"P"|"Q"|"R"|"S"|"T"|"U"|"V"|"W"|"X"|"Y"|"Z" ; A1-absolute-column= "$", A1-relative-column ; A1-row= A1-relative-row | A1-absolute-row ; A1-relative-row= digit-sequence ; (* must be non-zero; see 3.17.2.3.1 *) A1-absolute-row= “$”, A1 -relative-row ;

Tag and Go

No Comments

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

  • Argentina (1)
  • Australia (30)
  • Austria (1)
  • Belgium (1)
  • Brazil (64)
  • Bulgaria (3)
  • Canada (79)
  • Chile (217)
  • China (1)
  • Colombia (237)
  • Czech Republic (75)
  • Denmark (168)
  • Ecma (76)
  • Ecuador (1)
  • Finland (15)
  • France (592)
  • Germany (162)
  • Ghana (12)
  • Greece (113)
  • India (82)
  • Iran (58)
  • Ireland (12)
  • Israel (33)
  • Italy (2)
  • Japan (82)
  • Jordan (1)
  • Kenya (81)
  • Malaysia (23)
  • Malta (5)
  • Mexico (7)
  • New Zealand (54)
  • Norway (12)
  • Peru (10)
  • Philippines (7)
  • Poland (4)
  • Portugal (118)
  • Singapore (2)
  • South Africa (17)
  • South Korea (25)
  • Spain (1)
  • Switzerland (19)
  • Thailand (1)
  • Tunisia (3)
  • Turkey (1)
  • UK (635)
  • Uruguay (18)
  • USA (288)
  • Venezuela (73)