To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109253 Issue #|109253 Summary|Enhancemant LOOKUP-functions with optional "N/A-string |" Component|Spreadsheet Version|1.0.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|user9591
------- Additional comments from [email protected] Sun Feb 14 13:05:19 +0000 2010 ------- I use the Lookup-functions (also 'Match') a lot and I find it complicating to always check for "N/A" results. The "N/A" result often looks ugly in a spreadsheet. It makes the formula twice as long when you want to prevent the "N/A" in a cell (if(iserror(blablabla). It would be very convenient when an extra parameter could be added to the lookup-functions: an optional string that is shown instead of the "N/A". I often would then use "" (empty string) because I don't want to see anything in a cell when nothing is found. Example: VLOOKUP(SearchCriterion; Array; Index; SortOrder; OptionalStringInsteadOf"N/A") instead of IF(ISERROR(VLOOKUP(SearchCriterion; Array; Index; SortOrder);"Not found";VLOOKUP(SearchCriterion; Array; Index; SortOrder))) Would that be possible in the near future...? I hope so! --------------------------------------------------------------------- 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]
