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)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsDevEval
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
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:
Regression By:


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.
LO on Windows Vista