[Libreoffice-bugs] [Bug 52510] New: Calc removes trailing semicolon in custom format , breaking Excel compatibility

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Thu Jul 26 07:35:53 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=52510

             Bug #: 52510
           Summary: Calc removes trailing semicolon in custom format ,
                    breaking Excel compatibility
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.5.3 release
          Platform: x86 (IA32)
        OS/Version: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: prophnovsky at gmail.com


When using user-defined formats for cells in Calc, trailing semicolons are
automatically removed.  This is likely because Calc believes that the end
result is incorrect; however, Excel treats the trailing semicolon as an
exception rule for the format.

To reproduce this problem in Calc, do the following steps:

1. Enter zero ('0') in the first two rows of the first column of a new
spreadsheet (actual cell position is irrelevant).
2. Use "Format->Cells" menu or the "Format Cells..." right-click item to do
custom formatting on the cell.
3. In the category list, select "User-defined."
4. Enter a Format code of "_($* #,##0.00_);_($* (#,##0.00);"

Similarly, this can be reproduced in Excel:

1. Enter zero ('0') in the first two rows of the first column of a new
spreadsheet (actual position is irrelevant).
2. Use "Format Cells" menu or the "Format Cells..." right-click item to do
custom formatting on the cell.
3. In the category list, select "Custom."
4. Enter a Type of "_($* #,##0.00_);_($* (#,##0.00);"

In both examples, only enter the formatting text between the quotation marks.

Excel leaves the semicolon and formats the cell with a blank entry. 
Libreoffice Calc removes the semicolon and formats the cell using the existing
entries with a result of "$0.00"

The expected behavior is to simply blank out the cell if none of the entries
match - the semicolon gives the exception case, similar to an else statement.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list