Bug 117720

Summary:	Delete item Maximum from drop-down list Minimum and delete item Minimum from drop-down list Maximum in dialogue Conditional Formatting
Product:	LibreOffice	Reporter:	Roman Kuznetsov <79045_79045>
Component:	Calc	Assignee:	Roman Kuznetsov <79045_79045>
Status:	RESOLVED FIXED
Severity:	minor	CC:	jalojo, xiscofauli
Priority:	medium	Keywords:	needsDevAdvice
Version:	6.1.0.0.alpha1+
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=117719
Whiteboard:	target:6.3.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	87351, 116222

Description Roman Kuznetsov 2018-05-21 08:59:05 UTC

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

Comment 1 Jacques Guilleron 2018-05-21 13:47:57 UTC

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.

Comment 2 Commit Notification 2018-11-26 17:39:00 UTC

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.

Comment 3 Roman Kuznetsov 2018-11-26 19:12:33 UTC

Thank you, Mike