https://bugs.documentfoundation.org/show_bug.cgi?id=96741
Bug ID: 96741
Summary: EDITING: Data - Validity: mouse-selection(s) should
work in a custom mix with typing
Product: LibreOffice
Version: unspecified
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Keywords: needsDevEval
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
