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

Reply via email to