| Summary: | FORMATTING: conditional formatting | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | th <tomhuber68> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | starmatz71 |
| Priority: | high | ||
| Version: | 3.5.0 Beta3 | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
LO calc file conditional formatting
File with correct entry "POS" |
||
Could you please attach a test document showing this behavior? Created attachment 54780 [details]
LO calc file conditional formatting
attachment as per markus mohrhard's request. regards tom
I can confirm this behavior in LibreOffice 3.5 beta3 I have create a conditional format in a cell "cell is equal to POS" and create a new style sheet, which has a green background. After this, if the cell is EMPTY it's backgroundcolor is GREEN and if i write POS into this cell it's backgroundcolor is WHITE! But the behavior should be GREEN if POS is in the cell WHITE if the cell is EMPTY I find out, you have to enter "POS" in the value field of the conditional format window. After this you can enter POS in the cell and it turns green and goes white if it is empty. Conditional format works how it should be. Created attachment 55814 [details]
File with correct entry "POS"
|
Problem description: set condition to "equal to" and assign color-background if condition is met; Steps to reproduce: 1. ....set condition to e.g. "equal to" 2. ....assign color background if condition met 3. ....click ok; LO will mark all cells that do NOT meet condtions Current behavior: Expected behavior: Platform (if different from the browser): Browser: Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.12 Safari/535.11