To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=41183 Issue #:|41183 Summary:|Function calls using 'ranges' do not work with |'function'(INDIRECT(CONCATENATE.......) Component:|Spreadsheet Version:|OOo 1.1.4 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P4 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|domno
------- Additional comments from [EMAIL PROTECTED] Mon Jan 24 01:21:29 -0800 2005 ------- When using a reference variable in a function call to an external file, the function works if a single cell is called, but does not work when a range is used. The issue arises when the external filename is necessarily a reference variable. Example: Cell A1 = "TEST" =SUM(INDIRECT(CONCATENATE("'file:///c:/";A1;".sxc'#$Sheet1.d1"))) will properly return the contents of C:\TEST.SXC, Cell D1. However, =SUM(INDIRECT(CONCATENATE("'file:///c:/";A2;".sxc'#$Sheet1.d1:d3"))) returns ERROR 502. The problem may be with the necessary use of INDIRECT, but the results are the same for other functions such as =MATCH, =LOOKUP, etc. where a 'range' is necessary. However, the fact that it does work with a call to a single cell implies it should work with a 'range', and that the formatting is otherwise correct. Note: The use of the operator "&" instead of CONCATENATE seems to produce the same result. --------------------------------------------------------------------- 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]