Created attachment 61698 [details]
Excel 2007 (xlsx) file
Running LibreOffice 184.108.40.206 in Ubuntu 12.04 (32bit).
I have found issues in some cases with the "#" formatting character resulting in different formatting in some cases in LibreOffice 220.127.116.11, compared to Microsoft Excel 2007.
I have created a simple test case, using Excel 2007 in Windows 7, using two different formats using the "#" character, one of which displays the same between LibreOffice and Excel and one that does not.
#,##0.00;[Red]-#,##0.00 - same display
##0.000E+00 - different display
As well as the Excel document (xlsx) I have attached two pdf files, that show the different displays in LibreOffice and Excel.
Created attachment 61699 [details]
pdf document showing formatting in Excel 2007
Created attachment 61700 [details]
pdf document showing formatting in LibreOffice 18.104.22.168
Still present in version v22.214.171.124 run on MacOSX.
(In reply to comment #0)
> #,##0.00;[Red]-#,##0.00 - same display
> ##0.000E+00 - different display
LO 126.96.36.199 + Excel 2010
Build ID: 58f22d5
Windows 7 Professional SP1 64 bit
7654321987654,320 ##0.000E+00 7,654E+12
7654321987654,320 ##0.000E+00 765,432E+10
Changed summary slightly, platform.
I can confirm that this is still an issue with LibreOffice 188.8.131.52 tested on a macbook running OSX 10.6 (Snow Leopard).
*** Bug 34312 has been marked as a duplicate of this bug. ***
This bug is still present in LibreOffice 184.108.40.206.
Still present in 220.127.116.11
Still present in 4.2.0
Still present in 4.2.1
Stil present in 18.104.22.168.
Checked on Windows 8.1 platform.
Still present in LibreOffice 22.214.171.124 on Windows 8.1.
Still present in LibreOffice 126.96.36.199 on Windows 8.1.
Still present in LibreOffice 188.8.131.52 on Windows 8.1.
Still present in LibreOffice 184.108.40.206 on Windows 8.1.
Solved in LibreOffice 220.127.116.11.
Tested on Windows 8.1