[sc-issues] [Issue 114418] value returned by ADDRESS () not valid as INDEX() value
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114418 User er changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from e...@openoffice.org Thu Sep 9 13:47:12 + 2010 --- Despite that ADDRESS(COLUMN();ROW()) would always address its own cell, the result of ADDRESS() is a text string, not a reference. INDEX() expects a reference, not text, hence the Err504. If you wanted to use some ADDRESS() result with INDEX() you'd have to convert it to a reference first using INDIRECT(), for example INDEX(INDIRECT(ADDRESS(...;...));...) - 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
[sc-issues] [Issue 114418] value returned by ADDRESS () not valid as INDEX() value
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114418 User er changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from e...@openoffice.org Thu Sep 9 13:47:28 + 2010 --- Closing. - 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
[sc-issues] [Issue 114418] value returned by ADDRESS () not valid as INDEX() value
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114418 Issue #|114418 Summary|value returned by ADDRESS() not valid as INDEX() value Component|Spreadsheet Version|OOO320m12 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|editing Assigned to|spreadsheet Reported by|urlordofelves --- Additional comments from urlordofel...@openoffice.org Wed Sep 8 22:51:32 + 2010 --- i entered in cell B1 the following: =ADDRESS(COLUMN(),ROW()) (for a simple column, row value swapping. returns desired absolute value: $A$2) i enter into D1 the following: =INDEX(ADDRESS(COLUMN(),ROW())) and get error 504. if i however enter into E1 the following: =INDEX($A$2) which is the return value of the ADDRESS function, i get the correct value return for that cell. ($A$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: 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
[sc-issues] [Issue 114418] value returned by ADDRESS () not valid as INDEX() value
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114418 --- Additional comments from to...@openoffice.org Thu Sep 9 01:55:38 + 2010 --- urlordofelves: The formula in D1, INDEX(ADDRESS(COLUMN();ROW())), is referencing itself. The 'Address' portion of this formula is returning 4,1 or cell D1. This makes the 'reference' range for the 'Index' function, the cell that contains the 'Index' function. TomW - 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