To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104102 Issue #|104102 Summary|increased flexibility of ADDRESS function Component|Spreadsheet Version|OOO310m11 Platform|Other URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|risch
------- Additional comments from ri...@openoffice.org Sat Aug 8 09:57:56 +0000 2009 ------- Currently, ADDRESS(row; column; mode; sheet) accepts the following arguments row: number, specifying the row; works also, if number is entered as string column: number (not a letter) specifying the column mode: (an optional number) determines whether the cell address is absolute or relative sheet: (optional) text string specifying the sheet I suggest that ADDRESS performs a type evaluation of the arguments column and sheet: -if column is a string, ADDRESS should try to interpret it as a column name, calculating automatically the corresponding index -if sheet is entered as a number, ADDRESS should try to interpret it as a sheet index, calculating automatically the corresponding sheet name --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
