Bug 96743 - UI: Data - Validity: Make available "Insert => Names => Insert", or add completion of available names while typing
Summary: UI: Data - Validity: Make available "Insert => Names => Insert", or add compl...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval
Depends on:
Blocks: Cell-Validity
  Show dependency tree / graph
 
Reported: 2015-12-27 20:42 UTC by burnuser2
Modified: 2017-07-06 11:59 UTC (History)
1 user (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:42:26 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!

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:
Make available "Insert => Names => Insert" in Validity
Comment 1 Cor Nouws 2015-12-27 22:05:19 UTC 
Thanks for the issue. Set to new!
Comment 2 burnuser2 2017-01-08 10:16:49 UTC 
Bug is still present. No changes in bug behavior.
Testsystem:
LO 5.2.3.3 on Windows Vista