https://bugs.documentfoundation.org/show_bug.cgi?id=40497
Laurent BP <jumbo4...@yahoo.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
CC| |jumbo4...@yahoo.fr
Resolution|--- |NOTABUG
--- Comment #14 from Laurent BP <jumbo4...@yahoo.fr> ---
(In reply to russianneuromancer from comment #12)
> Jean-Baptiste, what do you get in latest LO with Default - English (USA) and
> this format:
> # ###.00 "something"
> If number in cell is 1600?
I agree with Jean-Baptiste, there is no bug.
With EN, space has no special meaning, (it is comma which is considered as
thousand separator) so
# ###.00 "something"
will insert two space characters in the result, but no thousand separator. You
can check with a huge value bigger than 1 million: 1,243,456 gives
1234 567.00 something
But if you use a language which considers space as thousand separator (like RU
or FR), then LibO considers the two spaces as million and thousand separator,
and simply ignores second one if value is less than one million.
# ###,00 "something"
gives for 1,243,456
1 234,57something
which can be read as 1,234.57 thousands
As said by Jean-Baptiste, or in your comment 0 step 9, you have to insert your
second space character inside your quotes (it is not a workaround, it is as it
has to be written):
# ###,00" something"
Otherwise, LibO can not guess if you insert a thousand separator or text space
character.
Conclusion: when you change language, you have to adapt both decimal and
thousand separators.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
