Created attachment 9093 [details]
an exemple of my problem

Hi,

I tried to reproduce it with OOo11rc4 and was not able to do so. Under
all conditions I've tested, I got the 8,97.

Please test it again using OOo1.1rc4.

For now I set the resolution to worksforme. Feel free to reopen it if
your problem still exist in RC4.

Frank

set resolution to worksforme

Hello

I downloaded and installed OOo_1.1rc4_Win32Intel_install.zip
and the problem remains : when opening the file test.sxc the display is 
0.01 and the value is 8,97

The format string is : 
[>0]# ##0,00 ;[<0](# ##0,00);- 

Created attachment 9132 [details]
Case test

Created attachment 9133 [details]
screen capture

Hi,

the problem is, you need a french locale to reproduce it !

I assign it to Eike as he is responsible for the numberformatter.

Eike it seems that the decimal separator in the user defined format is
interpreted as thousands seperator.

Frank

PS Eike could you evaluate the problems that may occur. If they are
not so big, Prio and Target can be adjusted.

Well, what shall I say.. it's not a bug, it's a feature ;-)

No, really, it would have been obvious in another locale, but
unfortunately the french group (AKA thousands) separator is a blank,
so it took me quite some seconds to realize that this number format code
[>0]# ##0,00 ;[<0](# ##0,00);- 
contains a trailing blank in the positive subformat, which in this
case acts as a separator like documented: the number is divided by
thousand.

However, this reveals another bug: those trailing group separators are
not converted if loaded in a different locale, otherwise it would have
been obvious in an English-US locale, the converted code should read
[>0]#,##0.00,;[<0](#,##0.00);-,
instead of
[>0]#,##0.00 ;[<0](#,##0.00);- 

I adjust the priority to a normal P3 but keep OOo1.1.1 as a target as
this may display wrong values in interchanged documents.

According to the roadmap of OpenOffice.org 1.1
(http://tools.openoffice.org/releases/OpenOffice_org_1_x.html) this
issue has been scheduled for 1.1.2.

Because of limited resources for OOo1.1.2, we have decided to fix this problem
in OOo2.0. I changed the target.

I regret you delayed the resolution of this problem : 
This is clearly an internationalization item  ( In France the space is used as
thousand delimiter ) and such limitation, associated with the interpertation of
the dot on the numeric keypad ( which gives a dot instead of a coma as in Excel)
completely bans OpenOffice from french organizations.

Hi Patrice,

As stated above, what you experienced at first hand (number displayed
differently) is not a bug; if the format code has trailing group separators
(which happens to be a space in fr_FR locale) the number is displayed dividing
it by multiples of 1000. This is a feature and documented. What this issue now
is about, is the fact that upon loading the document in _another_ locale the
trailing group separators aren't converted properly and the displayed number is
not divided by multiple of 1000. This is a very special case of trailing
separators being used _and_ working under different locales (and some Xcl file
conversion issue too, since the format code should be preserved), this
regardless of the locales being used. IMHO there's no reason why this should
restrain someone from using OOo in a French production environment.

Eike

I don't know what happened to the documents, but they seem to be broken somehow.
If I load them once in a fr_FR locale, save them again, and then load them in an
en_US locale, the number format is converted correctly and results in
[>0]#,##0.00,;[<0](#,##0.00);- 
note the trailing ',' group separator in the first subformat that displays 8.97
as 0.01. This works both in a recent OOo1.1.2/SO7PPx and the OOo1.9.m54 snapshot
build =>  resolve wontfix.

Close wontfix.