https://bugs.documentfoundation.org/show_bug.cgi?id=115891
Bug ID: 115891
Summary: FORMATTING: Calc Conditional Formatting Not
Functioning Properly
Product: LibreOffice
Version: 6.0.1.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Conditional formatting applied to a range of cells only works properly on a
handful of those cells and misrepresents the status of others.
Steps to Reproduce:
1.Create spreadsheet with an array of random values. Values should be
'Scientific' in nature. IE: 4.7e-6
2.Place a threshold value in a separate cell. IE: 3.1415e-3
3.Setup Conditional Formatting : Cell Value Is, greater than, (threshold cell
location), enter some obvious style.
4.Click OK
Actual Results:
In the example spreadsheet:
Cells B14,B15 and B16 are handled correctly.
Cell B17 is incorrectly showing that the value is over the threshold.
Similarly, cells C15 and C17 are incorrectly indicated, but C16 is correct.
Etc.
Expected Results:
Expected to have values that were "greater than" cell B5 value to be
highlighted, cells below or equal to the value should be displayed normally.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
See Expected Results
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:58.0) Gecko/20100101
Firefox/58.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
