https://bugs.freedesktop.org/show_bug.cgi?id=68441
Priority: medium
Bug ID: 68441
Assignee: [email protected]
Summary: FORMATTING: conditional custom cell formatting
expressions fail with @ token
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.5 all versions
Component: Spreadsheet
Product: LibreOffice
Created attachment 84465
--> https://bugs.freedesktop.org/attachment.cgi?id=84465&action=edit
spreadsheet demonstrating the bug
Problem description:
Consider the following cell format : [<0.05][BLUE]"small";[<0]"negative";@
it should print "small" for numbers between 0 and 0.05, "negative" for negative
numbers and treat all other data as text.
Steps to reproduce:
Try entering a number like 42 into a cell formatted with the expression above.
Current behavior:
When you enter a number like 42, the cell remains empty.
Expected behavior:
The cell should print 42 formatted as text. This is the way it works on MS
Excel.
Operating System: All
Version: 3.5 all versions
--
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
