To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=23098
User kpalagin changed the following: What |Old value |New value ================================================================================ CC|'' |'kpalagin' -------------------------------------------------------------------------------- Status|CLOSED |UNCONFIRMED -------------------------------------------------------------------------------- Resolution|DUPLICATE | -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Tue Feb 6 09:42:51 +0000 2007 ------- I will allow myself to reopen the issue for two reasons: 1. User does not always want Lookup functions to search full column/row. 2. Issue 20495 seems to very far away from resolution and seems to be non- trivial undertaking. On the other hand, this issue (23098) looks like trivial enough - just slightly modify how Function Wizard generates the formula (adding '$' to the cell references). After all, it seems naturall for Lookup function to work on the same array (defining range is impractical in many cases because files areregenearted every time). Please consider this enhancement. Thanks a lot. --------------------------------------------------------------------- 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]