https://bugs.freedesktop.org/show_bug.cgi?id=61996
Priority: medium
Bug ID: 61996
Assignee: [email protected]
Summary: FORMATTING: user-defined cell formatting fails with
semicolon between quotation marks
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.0.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 76139
--> https://bugs.freedesktop.org/attachment.cgi?id=76139&action=edit
correct and incorrect cell formatting examples
Problem description:
--------------------
The cell-formatting parser does not recognize the semicolon inside quotation
marks (as string limiter) correctly as string, as the semicolon is also used as
separator between positive and negative format information.
Steps to reproduce:
-------------------
a1. Select some cells
a2. Open 'Format cells...' dialogue
a3. Select 'user-defined'
a4. Enter first format code "L#"0"s@";"L#"-0"s@" (with quotation marks)
a5. Click OK
a6. Enter a number (e.g. '123') into one of the formatted cells
a7. Displayed result is 'L#123s@' (= correct)
a8. Enter a negative number (e.g. '-123') into one of the formatted cells
a9. Displayed result is 'L#-123s@' (= correct)
b1. Select some cells
b2. Open 'Format cells...' dialogue
b3. Select 'user-defined'
b4. Enter second format code "L#"0"s;";"L#"-0"s;" ('@' is replaced by ';')
b5. Click OK
b6. Enter a number (e.g. '123') into one of the formatted cells
b7. Displayed result is 'L#123"s' (= incorrect)
b8. Enter a negative number (e.g. '-123') into one of the formatted cells
b9. Displayed result is '"' (= incorrect)
Expected behaviour:
-------------------
User-defined cell formatting of number (e.g. '123') shall lead to output like
'L#123s;' (with 'L#" before the number and 's;' after the number).
--
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
