Bug 76625

Summary: UI conditional formatting: no feedback when editing
Product: LibreOffice Reporter: Maarten Brouwers <freedesktop.org>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: medium    
Version: 4.2.2.1 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:

Description Maarten Brouwers 2014-03-26 09:43:48 UTC
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))
Comment 1 A (Andy) 2014-03-28 21:30:37 UTC
reproducible with LO 4.2.2.1 (Win 8.1), I would agree that a warning dialog would be better

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.