https://bugs.freedesktop.org/show_bug.cgi?id=49976
Bug #: 49976
Summary: FORMATTING - # Character Sometimes Resulting in
Different Formatting in LibreOffice Compared to Excel
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.3 release
Platform: x86 (IA32)
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 61698
--> https://bugs.freedesktop.org/attachment.cgi?id=61698
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.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs