To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80488 Issue #|80488 Summary|Dynamic Lists are treating blank cells as having 0s in | them. See the attached files Component|Spreadsheet Version|680m223 Platform|All URL|http://www.adastragames.com/downloads/OpenOffice/Dynam |ic_List_Eval_Glitch_OO-dev-m223-calc.zip OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|configuration Assigned to|spreadsheet Reported by|ken_burnside
------- Additional comments from [EMAIL PROTECTED] Wed Aug 8 21:21:05 +0000 2007 ------- On this spreadsheet, the user selects a range in cell B2; this triggers display of items in cells C2, D2, E2, and F2. The user can then select, in cells C3, D3, E3 and F3, another variable that would (in the full spreadsheet) modify data relevant to the cells above it. The problem I'm having is in the Data > Validity settings in cells C3 through F3 mentioned above. There are three named ranges in the spreadsheet: Ordered_List, Blank, and Action Points. Ordered_List populates the drop-down in B2. Blank should evaluate to an empty cell. Action_Points evaluates to the drop-down list that would populate the cells C3 through F3, if the cell immediately above them was NOT blank. If you examine the files in the URL listing, you will find that cells C, D, E and F on row 3 has Data > Validity activated, as follows: IF(E2="";Blank;Action_Points) So, in plain English - if cell E2 is blank, cell E3 should also be blank. If cell E2 is NOT blank, cell E3 should be populated by the Action_Points drop down. The problem is that that first check is not working, but does in Excel, and I use it a LOT in Excel. The zip file listed in the URL has two copies of the spreadsheet, one for OpenOffice, the other for Excel; this works the way I want it to in Excel, but not in OpenOffice, and I need it to work the same way in both. --------------------------------------------------------------------- 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]
