Description: Conditional formatting with condition of greater than a number is not working the same for cells with text and – symbol when opened in LO. Steps to Reproduce: 1. Create a new xlsx in Excel. 2. Create a new conditional formatting rule with greater than a number condition. 3. Write some numbers and some texts in the cells in the range, also some - symbols 4. Save it and open it in LO 5. Notice the differences. Actual Results: Only the numbers that are greater than the given number are formatted in LO while in MSO the text and the – symbol is formatted as well. Expected Results: Expected results: It should be formatted the same as in MSO. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 147529 [details] The original file.
Created attachment 147530 [details] Screenshot of the original document side by side in Excel and Calc.
confirmed different behaviour between Excel and Calc in Version: 6.3.0.0.alpha0+ Build ID: 3c964980da07892a02d5ac721d80558c459532d0 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45 Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded but I'm not sure that in Excel made right. IMHO Calc absolutely right work with the condition in this case.
Also reproduced in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.15; Render: default; and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
This is probably a duplicate to bug #122094 - text is not formatted like numbers are.
This contains the condition "cell value > 300" just like the bug #122094 contains "cell value > 0". These are then not applied to text, only numbers in Calc. Frankly, this makes sense. Considering "test" greater than 0 or 300 does not. *** This bug has been marked as a duplicate of bug 122094 ***