To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=80160
Issue #|80160
Summary|Logical statements (IF, AND, OR, NOT) do not work when
| defining Data > Validity criterion.
Component|Spreadsheet
Version|OOo 2.2.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|ENHANCEMENT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|ken_burnside
------- Additional comments from [EMAIL PROTECTED] Sun Jul 29 23:01:50 +0000
2007 -------
The original formula in Excel is:
=IF(D14="",List_1,List_2)
Which means that if cell D14 is empty, use the named range List_1 to
populate this drop down list, else use the named range List_2.
(A further test in D14 ensures that if it would come up as a 0, the
cell is set to empty; that part works just fine in Calc as near as I
can tell.)
I can make this work in Data > Validation in Excel.
I cannot make its cognate work in Data > Validity in Calc, where it
gets translated to:
IF('Ship Builder'.D14="";List_1;List_2)
---------------------------------------------------------------------
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]
