The ALPHABETIC switch argument has no documented ST_NumberFormat equivalent. This shades doubt upon the value of the switch argument, or else a potential hole in ST_NumberFormat values.

Create a ST_NumberFormat value that matches the ALPHABETIC switch argument or (better) suppress the need for the switch argument, either by using an ST_NumberFormat type in a proper XML notation for number formats in the context of fields, or simply by suppressing it from the OOXML proposal altogether.

page 1501, line 0 Part 4, Section 2.16.4.3 General formatting

te

Proposed Disposition of DIS 29500 Comment FR-0089 (Modified: 2007-11-24) Agreed; the following change will be made to Part 4, section 2.16.4.3, page 1,501: ALPHABETIC Formats a numeric result as one or more occurrences of an uppercase alphabetic Latin character. Value 1 results in the letter A, value 2 results in the letter B, and so on up to value 26, which results in the letter Z. For values greater than 26, 26 is repeatedly subtracted from the value until the result is 26 or less. The result value determines which letter to use, and the same letter is repeated for each time 26 was subtracted from the original value. [Example: =54 \* ALPHABETIC results in "BBB" as subtracting 26 from 54 two times, produces results in the value 2, which is represented by the letter B. end example] Corresponds to an ST_NumberFormat value of upperLetter . Similar Comments: BR-0015 ,

Tag and Go

No Comments

Sorry, the comment form is closed at this time.

  • 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)