To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102570
User regina changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Summary|Extends the valtidation of|Extends the validation of
| values |values
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sun Jun 7 19:09:14
+0000 2009 -------
Ok, cells with validity can be easier copied than form controls and need not be
aligned to cells. But I'm still not sure whether I could make it clear to you,
how to work with list boxes. List boxes do exact what you want: Select a value
from a list, which is given by a cell range, and return the index of the entry
in the list for further calculation.
Do not expect, that such a feature will be implemented soon. Therefore another
tip. You can calculate the index from the validation list by using the MATCH
function. You can hide this calculated value, if you put the calculation next to
the cell with the validity and then merge the cells.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
