Created attachment 102612 [details] example xlsx file Load the axample file and save as .xlsx Close and reopen the file in LibreOffice. Cell format is altered: all figures in the table are displayed as 0's and 1's.
Hello.. I just realized no difference in cell number format. Can't confirm with LO 4.2.5.2 and 4.3.0.2 in Ubuntu 12.04 x86. Have you tried resetting user profile?
Created attachment 102841 [details] result file (after saving in LibreOffice)
Hi, I resetted my user profile and get the same result as described previously. I just uploaded the file I get after saving as xlsx from LibreOffice so you can try to load it. Best Regards, Eric Ficheux
Hello, I can reproduce it on Debian: Version: 4.2.5.2 Build ID: 420m0(Build:2) Regards
(In reply to comment #0) > Created attachment 102612 [details] > example xlsx file Still don't understand why I can't reproduce with the file. Also with 4.2.6.1, result is the same.
Using fresh profile also makes no difference. I'm using standard English installation package, perhaps it's the cause?
Looks like it: I'm using French. I changed the language to English and tested, it worked fine.
On pc Debian x86-64 with master sources updated today, I could reproduce this. Here's the format I notice: _-* # ##0 _€_-;-* # ##0 _€_-;_-* -?? _€_-;_-@_-
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" "_€_-;_-* -??" "_€_-;_-@_-
As Gnumeric is able to import correctly import attachment 102612 [details] 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 ***
Created attachment 125912 [details] Test case file with fraction formats and normal escape char (build with Excel 2010) Test file to test the commit