https://bugs.documentfoundation.org/show_bug.cgi?id=113535
--- Comment #5 from [email protected] ---
(In reply to Wolfgang Jäger from comment #3)
> The 'Source' entered using 'Cell Range' mode needs to ba a cell range
> actually containing the accepted values or an expression returning a
> respective reference or array. A1 does neither contain the two entries. As
> soon as ther is entered one of the accepted values, the validity dropdown of
> A2 will offer this single entry.
My thought as I created this ticket was probably that the source A1 as cell
range would access the validity list from the cell A1 to fetch the values that
would then be listed in the dropdown field of A2. This would be useful if
multiple cells would use the same selection of entries for their dropdown field
as the first cell could act as a master cell containing the raw validity list
while other cells would use the master cell's validity list as reference
instead of using their own same values for storage/performance reasons.
I could workaround that by writing all valid entries in cell(s) and use them as
reference - but this is an ugly solution.
But maybe LibreOffice supports what I actually want to try to achieve and I
just did not encounter this feature yet. If not what I'm actually looking for
could be described as 'Supporting "Allow: Validity list" in the menubar -> Data
-> Validity... -> Criteria' which takes as "Source" a cell pointing in any way
to a validity list.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
