To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56534 Issue #:|56534 Summary:|queryPrecedents (XFormulaQuery) on Calc-cells don't |recognize cross-table-references Component:|api Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|sw Reported by:|leguff
------- Additional comments from [EMAIL PROTECTED] Mon Oct 24 04:11:05 -0700 2005 ------- try the following: - create a new spreadsheet document and name the first table "table1" and the second "table" - enter a value into table1.D24 - enter formula "=table1.D24" into table2.C6 - now get the precedents cells of table2.C6 via API and you'll find some unexpected values: Sub PrintFormulaPrecedents spreadSheetDocument = ThisComponent sheet1 = spreadSheetDocument.getSheets().getByIndex(0) sheet2 = spreadSheetDocument.getSheets().getByIndex(1) ' "table2.C2" formulaCell = sheet2.getCellByPosition(2, 5) ' get the precedents of this cell (Aspect: XFormulaQuery) ranges = formulaCell.queryPrecedents(true) ' prints: table2.C6; table2.D24 (should be table1.D24 only) print ranges.getRangeAddressesAsString() e = ranges.getCells().createEnumeration() while e.hasMoreElements() cell = e.nextElement() ' prints: table2.5.2 (should be table1.23.3) print "Precedents " & cell.SpreadSheet.Name _ & "." & cell.RangeAddress.StartRow _ & "." & cell.RangeAddress.StartColumn wend End Sub --------------------------------------------------------------------- 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]