https://bugs.documentfoundation.org/show_bug.cgi?id=81222

Laurent BP <jumbo4...@yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jumbo4...@yahoo.fr

--- Comment #9 from Laurent BP <jumbo4...@yahoo.fr> ---
When you first open the XLSX file, LibO reads formatted content in the file.
But, when you close and reopen, LibO tries to create formatted content, and
fails due to conflict between space as character and space as thousand
separator.
(In reply to Julien Nabet from comment #8)
> On pc Debian x86-64 with master sources updated today, I could reproduce
> this.
> Here's the format I notice: _-* # ##0 _€_-;-* # ##0 _€_-;_-* -?? _€_-;_-@_-
Lets give some details:
_- leave space for a '-' character
*  (with extra space) complete free space with character spaces
# ##0 display integer part with thousand separator
Up to here, everything is correct. The problem is with the next space, which
should be treated as a space character (with quotes) but is seen as a thousand
separator in French. As there is no digit after this, LibO display only
thousands.
_€ leave space for a '€' character
_- leave space for a '-' character

So LibO should import this format as
_-* # ##0" "_€_-;-* # ##0" "_€_-;_-* -??" "_€_-;_-@_-

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

Reply via email to