| Summary: | UI conditional formatting: no feedback when editing | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Maarten Brouwers <freedesktop.org> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | enhancement | ||
| Priority: | medium | ||
| Version: | 4.2.2.1 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 87351 | ||
reproducible with LO 4.2.2.1 (Win 8.1), I would agree that a warning dialog would be better Marked as RESOLVED-WORKSFORME The dialog now reports "Strings without quotes are interpreted as column/row labels" 5.1.4.2 on macOS 10.12.4 |
Problem description: There is no feedback when you are editing the condition for a conditional format to appear. For example equal to 'A' doesn't work (it should be equal to "A") Steps to reproduce: 1. Create document 2. Type "A" in first cell (without the quotes) 3. Format -> Conditional Format -> Condition ... 4. Choose [Cell value] [is equal to] [A] 5. Apply style [Header style] Current behavior: No warning whatsoever that this is not going to work, similarly, 'A' is also not leading to any warnings Expected behavior: When you type in a cell =FIND('A';A1) in B2 (instead of the correct =FIND("B";A1) ) the preview should at least show "#VALUE!" like when a formula contains an incorrect value (I believe that even this warning should be improved (but that would be a different issue))