Description: Delete item Maximum from drop-down list Minimum and delete item Minimum from drop-down list Maximum in dialogue Conditional Foramtting for variants: All cells - Color Scale (2 Entries) All cells - Color Scale (3 Entries) All cells - Data bar Steps to Reproduce: 1. Open Calc 2. Open dialogue Conditional Formatting and push Add 3. Select variant All cells - Color Scale (2 Entries) 4. Select in left drop-down list item Maximum and in right drop-down list select -> this variant does not work correctly. It is just not logical I offer Delete item Maximum from drop-down list Minimum and delete item Minimum from drop-down list Maximum FYI: in MS Excel there isn't item Maximum in drop-down list Minimum and there isn't item Minimum in drop-down list Maximum Actual Results: we have not logical items in drop-down lists for some variants of conditional formatting Expected Results: we have items in drop-down lists, that do not contradict common sense Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
Hi kompilainenn, This would be clearer, since that is a reverse setting to what is proposed, but does not work this way for now. Colors too can be changed to get the same effect.
Roman Kuznetsov committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/d608b0af3f855e01535f40f3473dbee03d581863%5E%21 tdf#117720 Delete Max from list Min and delete Min from list Max in CF dialog It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thank you, Mike