Bug 96718 - EDITING: Data - Validity: make available cell ranges by mouse-selection in ALL conditions of Validity
Summary: EDITING: Data - Validity: make available cell ranges by mouse-selection in AL...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86 (IA32) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
 
Reported: 2015-12-25 10:03 UTC by burnuser
Modified: 2019-10-22 15:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description burnuser 2015-12-25 10:03:20 UTC
Working with a formula in Calc: Data => Validity is a very powerful option. (Especially a matrix-formula for a custom cell-range. Very good!)
But entering could be a pain.

A formula could be used in each condition (Whole number, Decimal, ...), but the used cell ranges must be typed!
Mouse-selection as in a regular formula (or in Excel: Validity => all conditions) does only work in condition "Cell range".
And in "Cell range" it does not work with a mix of typing and mouse-selection.
Using mouse-selection overwrites everything typed before.
(In Excel you can mix it as you like.)

With only one cell range in the formula the problem could be resolved by mouse-selection first and building the formula around the taken cell range.
But with 2 or more needed cell ranges in the formula ...

Using names and "Insert => Names => Insert" does not help, because LibreOffice does not allow this function while "Data => Validity" dialog is open.
(In Excel it is possible.)

So please:
1.) Make available cell ranges by Mouse-selection in ALL conditions of Validity
2.) The mouse-selection(s) should work in a custom mix with typing (as in a regular formula)
3.) Make available "Insert => Names => Insert" in Validity
Comment 1 Buovjaga 2015-12-27 17:17:38 UTC
Ok, I'm changing this to be about 1).

You should create separate reports for 2) and 3) and then comment here the numbers and I will confirm them.

Adding needsDevEval keyword, so devs can evaluate this for an easy hack.
Comment 2 burnuser 2015-12-27 20:43:08 UTC
2.) The mouse-selection(s) should work in a custom mix with typing (as in a regular formula) new in:
https://bugs.documentfoundation.org/show_bug.cgi?id=96741

3.) Make available "Insert => Names => Insert" in Validity new in:
https://bugs.documentfoundation.org/show_bug.cgi?id=96743
Comment 3 burnuser 2017-01-08 10:13:16 UTC
Bug is still present. No changes in bug behavior.
Testsystem:
LO 5.2.3.3 on Windows Vista