[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