Bug 96741 - EDITING: Data - Validity: mouse-selection(s) should work in a custom mix with typing
Summary: EDITING: Data - Validity: mouse-selection(s) should work in a custom mix with...
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 tree / graph
 
Reported: 2015-12-27 20:34 UTC by burnuser2
Modified: 2017-12-11 15:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description burnuser2 2015-12-27 20:34:08 UTC 
As stated in https://bugs.documentfoundation.org/show_bug.cgi?id=96718

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 ...

So please:
The mouse-selection(s) should work in a custom mix with typing (as in a regular formula)
Comment 1 Cor Nouws 2015-12-27 22:08:31 UTC 
Question: are you saying that it is/should be possible to add non continuous ranges as reference for the validity?
Comment 2 m_a_riosv 2015-12-27 22:21:50 UTC 
if I'm not mistaken there is no place where it works.
Comment 3 burnuser2 2015-12-27 23:24:51 UTC 
If you enter in a regular cell a formula you can type elements of the formula an add cell ranges with mouse selection (and typing again, and selecting again, and ...), all mixed up.
Including a matrix formula.
Which can be used also (with typing the ranges) in Validity: Cell range:
IF(B1:B10="a";C1:C10;"") ... list with values in C where value in B="a"
Instead of "a" you can also use a cell reference (D1) which can hold the selection of a (first) list. On which the contents of the second list then depends!
or
IF((A1:A10>4)*((B1:B10="a")+(B1:B10=D$1));C1:C10)
or a special formula for a number range Maximum value:
MAX(A1:A10;C1:C10;E1:E10)
or an other (even much more complex) formula in a prospective new custom validity
https://bugs.documentfoundation.org/show_bug.cgi?id=96698
Comment 4 Cor Nouws 2015-12-27 23:39:58 UTC 
Thanks - makes sense.
Comment 5 burnuser2 2017-01-08 10:15:08 UTC 
Bug is still present. No changes in bug behavior.
Testsystem:
LO 5.2.3.3 on Windows Vista
Comment 6 m_a_riosv 2017-12-11 15:34:25 UTC Comment hidden (obsolete)