Description: add labels Minimum and Maximum to drop-down lists in dialogue Conditional Formatting, for variant All cell - Color Scale (2 entries) All cell - Color Scale (3 entries) All cell - Data bar Steps to Reproduce: 1. Open Calc 2. Open dialogue Conditional Formatting 3. Select variant Any cell - Color Scale (2 entries) (or Color Scale (3 entries) or Data bar) 4. Look at two drop-down lists to left and to right. It are types of Minimum and Maximum values 5. But user don't know this, because there aren't any labels by those lists I offer add labels to user know, that select from drop-down lists. Actual Results: drop-down lists for selecting Min and Max values don't have any labels Expected Results: drop-down lists for selecting Min and Max values have labels Minimum and Maximum 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
Created attachment 142222 [details] Screenshot with problem and offering
You get what you want with "top n elements = 1" and bottom respectively given that the other patch is implemented. We should not overload the lengthy menu, so my take is WFN.
(In reply to Heiko Tietze from comment #2) > You get what you want with "top n elements = 1" and bottom respectively > given that the other patch is implemented. We should not overload the > lengthy menu, so my take is WFN. I am sorry: IIUC, OP doesn't suggest adding something to the drop-down menu: his proposal is to add labels next to drop-downs that would say something like (referring to the screenshot he provided): "Min: [Automatic ][V] Max: [Automatic][V]"
Created attachment 142231 [details] Right mockup for this bug
(In reply to Heiko Tietze from comment #2) > You get what you want with "top n elements = 1" and bottom respectively > given that the other patch is implemented. We should not overload the > lengthy menu, so my take is WFN. Heiko, it was my mistake. I made screenshot with not correct my comments =( I attached new mockup with correct view
Created attachment 142232 [details] Mockup for All cells - Color scale (3 entries)
Created attachment 142233 [details] Labels in MS Excel
Okay, got it. But minimum/maximum is misleading since min/max are an option in the dropdown like percentile, value... How about "Lower/Upper threshold"?
(In reply to Heiko Tietze from comment #8) > Okay, got it. But minimum/maximum is misleading since min/max are an option > in the dropdown like percentile, value... How about "Lower/Upper threshold"? may be we'll follow Excel in this case?
(In reply to kompilainenn from comment #9) > may be we'll follow Excel in this case? Sure, we can do. But we would have to rename "Min" and "Max" because "Minimum = Min" sounds weird. MSO calls it "Lowest value". The alternative was to label the option not as "Minimum" but "Lower threshold" (or boundary) and keep "Min". Both work, the MSO approach sounds more professional.
(In reply to Heiko Tietze from comment #10) > (In reply to kompilainenn from comment #9) > > may be we'll follow Excel in this case? > > Sure, we can do. But we would have to rename "Min" and "Max" because > "Minimum = Min" sounds weird. MSO calls it "Lowest value". > The alternative was to label the option not as "Minimum" but "Lower > threshold" (or boundary) and keep "Min". Both work, the MSO approach sounds > more professional. Heiko, i think that we don't understand each other. My bug about add LABEL above drop-down list, as NAME for this list. You say about change item INSIDE drop-down list.
Roman Kuznetsov committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/b907fe59a819aaba75518dc1534eb71d9e378b74%5E%21 tdf#117719: add Minimum and Maximum labels to color bar CF It will be available in 6.2.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.
Fixed. Verified on Version: 6.2.0.0.alpha1+ Build ID: 7eb71f84db2f2d9a6e79a42d25bb676cf1018a90 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-11-12_17:12:50 Locale: ro-RO (ro_RO.UTF-8); UI-Language: en-US Calc: threaded