https://bugs.documentfoundation.org/show_bug.cgi?id=143610
Kira Tubo <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED CC| |[email protected] --- Comment #5 from Kira Tubo <[email protected]> --- @Colin, I think this is happening because you have "Percentile" selected as the mid-range color. If "Percentile" is set to 50, this would take the MEDIAN number within column I, as defined here: https://help.libreoffice.org/latest/en-US/text/scalc/01/05120400.html?&DbPAR=CALC&System=WIN#colorscale The numbers you have within column I has a bunch of 0's, so currently the median value for the mid-range color is 0. So no matter what what you set as the Min, it the colors won't change. If you want to see the colors change to the way that you described in Comment 3, try changing the mid-range to "Percent" instead. I don't think this is a bug, so I'm going to close this ticket as NOTABUG. However, feel free to reopen the ticket and change the status back to UNCONFIRMED and explain the issue further. I tested this with latest stable build, 7.6.2.1, so you might want to update if you are still having problems. Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
