[Libreoffice-bugs] [Bug 81222] FILESAVE: save as xlsx modifies cells number format ( French only)

[bugzilla-daemon]

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

--- Comment #11 from Laurent BP  ---
Created attachment 125912
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125912=edit
Test case file with fraction formats and normal escape char (build with Excel
2010)

Test file to test the commit

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

[Libreoffice-bugs] [Bug 81222] FILESAVE: save as xlsx modifies cells number format ( French only)

[bugzilla-daemon]

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

Laurent BP  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #10 from Laurent BP  ---
As Gnumeric is able to import correctly import attachment 102612 with format
_-* # ##0\ _€_-;-* # ##0\ _€_-;_-* -??\ _€_-;_-@_-
I suggest it is a duplicate of bug 81939
Escape character not imported from XLSX

*** This bug has been marked as a duplicate of bug 81939 ***

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

[Libreoffice-bugs] [Bug 81222] FILESAVE: save as xlsx modifies cells number format ( French only)

[bugzilla-daemon]

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

Laurent BP  changed:

   What|Removed |Added

 CC||jumbo4...@yahoo.fr

--- Comment #9 from Laurent BP  ---
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

[Libreoffice-bugs] [Bug 81222] FILESAVE: save as xlsx modifies cells number format (French only)

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 CC||serval2...@yahoo.fr
   Hardware|x86 (IA32)  |All
 OS|Windows (All)   |All

--- Comment #8 from Julien Nabet  ---
On pc Debian x86-64 with master sources updated today, I could reproduce this.
Here's the format I notice: _-* # ##0 _€_-;-* # ##0 _€_-;_-* -?? _€_-;_-@_-

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81222] FILESAVE: save as xlsx modifies cells number format (French only)

[bugzilla-daemon]

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

Michael Stahl mst...@redhat.com changed:

   What|Removed |Added

 Attachment #102612|application/octet-stream|application/vnd.openxmlform
  mime type||ats-officedocument.spreadsh
   ||eetml.sheet

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81222] FILESAVE: save as xlsx modifies cells number format (French only)

[bugzilla-daemon]

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

Michael Stahl mst...@redhat.com changed:

   What|Removed |Added

 Attachment #102841|application/octet-stream|application/vnd.openxmlform
  mime type||ats-officedocument.spreadsh
   ||eetml.sheet

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81222] FILESAVE: save as xlsx modifies cells number format (French only)

[bugzilla-daemon]

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

ign_christian ign_christ...@yahoo.com changed:

   What|Removed |Added

Summary|FILESAVE: save as xlsx  |FILESAVE: save as xlsx
   |modifies cells number   |modifies cells number
   |format  |format (French only)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs