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.
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: It should be formatted the same as in MSO.
User Profile Reset: No
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
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
but I'm not sure that in Excel made right.
IMHO Calc absolutely right work with the condition in this case.
Also reproduced in
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default;
Version 22.214.171.124.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 ***