RE: [office] <number:embedded-text>

["Dennis E. Hamilton" <dennis.hamilton@acm.org>]

Eike,

Your comment reminds me of a related problem.

Is there a way to over-ride the locale or specify a different locale at the
element level?

I notice that, on my operating system, I can over-ride locale default
settings and use my personal preferences (such as always using 8601-style
yyyy-mm-dd dates, 24-hour time, and so on, though I haven't gone so far as
to use UTC).  I can also choose my own separator characters, including in
number forms.

Many applications notice and honor those customizations.  Others are
inconsistent (e.g., displaying correctly but having internal logic that
expects a particular format, as when comparing dates using strings).  Some
applications also allow me to choose the rendering at the application and
even field level.  

If there is no way to customize the locale behavior for number grouping, it
is very difficult to accomplish by other means, since it depends on the
number of digits in the presented value, etc.

In addition to allowing idiosyncratic usages, and perpetuating them between
processors as intended, this also allows for situations where treatment
relative to different locales occurs in the same document (e.g., when
presenting a value in the currency of another locale using the grouping
style of that locale).

I suppose this is something for ODF-next if not currently provided for.

 - Dennis



-----Original Message-----
From: Eike Rathke [mailto:erack@sun.com] 
http://lists.oasis-open.org/archives/office/200904/msg00056.html
Sent: Monday, April 20, 2009 06:27
To: office@lists.oasis-open.org
Subject: Re: [office] <number:embedded-text>

Hi,

On Wednesday, 2009-04-15 09:19:19 +0200, Michael Brauer wrote:
http://lists.oasis-open.org/archives/office/200904/msg00041.html
> If so: <number:grouping> specifies a text that is used to insert  
> grouping characters into a a formatted number. For instance, if you  
> specify <number:grouping>,</number:grouping>, and the number that is  
> formatted is 1000000, the the result is "1,000,000".

number:grouping is not an element but an attribute instead,
number:grouping="true" just says that grouping is used. The actual
delimiter depends on the locale the data is displayed in. Also the
grouping itself depends on the locale, e.g. in Indian locales the
grouping would be 10,00,000

  Eike

-- 
 OpenOffice.org / StarOffice Calc core developer and i18n transpositionizer.
 SunSign   0x87F8D412 : 2F58 5236 DB02 F335 8304  7D6C 65C9 F9B5 87F8 D412
 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS