Bug 49976 - FORMATTING - Different Formatting in LibreOffice Compared to Excel using ##0.000E+00 format
Summary: FORMATTING - Different Formatting in LibreOffice Compared to Excel using ##0....
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 34312 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-05-15 14:27 UTC by junk_2010
Modified: 2015-08-19 18:49 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Excel 2007 (xlsx) file (10.02 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-05-15 14:27 UTC, junk_2010 		Details
pdf document showing formatting in Excel 2007 (77.74 KB, application/pdf)
2012-05-15 14:31 UTC, junk_2010 		Details
pdf document showing formatting in LibreOffice 3.5.3.2 (13.64 KB, application/pdf)
2012-05-15 14:32 UTC, junk_2010 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description junk_2010 2012-05-15 14:27:21 UTC 
Created attachment 61698 [details]
Excel 2007 (xlsx) file

Running LibreOffice 3.5.3.2 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 3.5.3.2, 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.
Comment 1 junk_2010 2012-05-15 14:31:01 UTC 
Created attachment 61699 [details]
pdf document showing formatting in Excel 2007
Comment 2 junk_2010 2012-05-15 14:32:34 UTC 
Created attachment 61700 [details]
pdf document showing formatting in LibreOffice 3.5.3.2
Comment 3 junk_2010 2012-07-24 19:28:58 UTC 
Still present in version v3.6.0.2 run on MacOSX.
Comment 4 bfoman (inactive) 2012-11-05 13:56:34 UTC 
(In reply to comment #0)
> #,##0.00;[Red]-#,##0.00 - same display
> ##0.000E+00 - different display

Confirmed with:
LO 3.6.3.2 + Excel 2010
Build ID: 58f22d5
Windows 7 Professional SP1 64 bit

Results:
Excel 2010: 
7654321987654,320	##0.000E+00	7,654E+12
LO:
7654321987654,320	##0.000E+00	765,432E+10

Changed summary slightly, platform.
Comment 5 junk_2010 2013-01-12 18:15:33 UTC 
I can confirm that this is still an issue with LibreOffice 4.0.0.1 tested on a macbook running OSX 10.6 (Snow Leopard).
Comment 6 junk_2010 2013-01-12 18:18:05 UTC 
*** Bug 34312 has been marked as a duplicate of this bug. ***
Comment 7 junk_2010 2013-08-03 17:47:27 UTC 
This bug is still present in LibreOffice 4.1.0.4.
Comment 8 junk_2010 2013-10-05 08:58:42 UTC 
Still present in 4.1.2.3
Comment 9 junk_2010 2014-02-16 17:35:36 UTC 
Still present in 4.2.0
Comment 10 junk_2010 2014-02-22 19:01:12 UTC 
Still present in 4.2.1
Comment 11 junk_2010 2014-04-26 18:40:22 UTC 
Stil present in 4.2.3.3.
Checked on Windows 8.1 platform.
Comment 12 junk_2010 2014-09-15 20:00:10 UTC 
Still present in LibreOffice 4.3.1.2 on Windows 8.1.
Comment 13 junk_2010 2014-09-27 19:54:26 UTC 
Still present in LibreOffice 4.3.2.2 on Windows 8.1.
Comment 14 junk_2010 2014-11-01 18:59:52 UTC 
Still present in LibreOffice 4.3.3.2 on Windows 8.1.
Comment 15 junk_2010 2015-01-31 17:41:52 UTC 
Still present in LibreOffice 4.4.0.3 on Windows 8.1.
Comment 16 junk_2010 2015-08-19 18:40:23 UTC 
Solved in LibreOffice 5.0.0.5.
Tested on Windows 8.1