ISSUE-462: Human readable formats for numeric percentages

Human readable formats for numeric percentages

Raised by:
Richard Ishida
Opened on:
follow this issue at

6.2.2 Formats for numeric types

"When parsing the string value of a cell against this format specification, implementations MUST recognise and parse numbers that consist of:"

the list that follows this makes allowances for groupChar and decimalChar, but still fails to capture real life formats from various cultures, when it comes to percentages.

For example, CLDR[1] shows formats where the percent sign appears to the left of the numeric sequence (Basque, Turkish), or where the percent sign is separated from the numeric sequence by white space (about 30 locales).

It's also not clear to me how pattern properties (which would appear to be the alternative) are taken into consideration in the validation checks (which actually are well-formedness checks, aren't they?).

It unfortunately seems a little too restrictive, and the alternative property values seem a little too simplistic, for international use.

Is there a way we can improve on that?

I'm wondering whether the spec should:
1. only specify required formats for normalized numbers (ie. converted to the canonical form)
2. do 1 and require applications to convert from real world scenarios as a separate step, taking into account the possible variations represented in CLDR
3. do 1 and provide a property that specifies a locale, which recognises values that cover all the CLDR alternatives
4. something else

Related Actions Items:
No related actions
Related emails:
  1. RE: Closure of tabular-data-model issues (from on 2015-09-20)
  2. Closure of tabular-data-model issues (from on 2015-09-17)
  3. I18N-ISSUE-462: Human readable formats for numeric percentages ⓟ [tabular-data-model] (from on 2015-04-24)

Related notes:

No additional notes.

Display change log ATOM feed

Addison Phillips <>, Chair, Richard Ishida <>, Fuqiao Xue <>, Atsushi Shimono <>, Staff Contacts
Tracker: documentation, (configuration for this group), originally developed by Dean Jackson, is developed and maintained by the Systems Team <>.
$Id: index.php,v 1.326 2018/10/13 17:29:51 vivien Exp $