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@lists.freedesktop.org ReportedBy: prophnov...@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. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs