From Bugzilla Helper: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7 Description of problem: Developers guide claims that getCellByName exists and provides examples. I can get getCellByPosition to work inside a spreadsheet document, but any attempt to use getCellByName fails on a missing module error. Its like that call is unknown. I checked this on the latest FC6, and also on an older FC4 and it doesn't work on either box. Therefore, is the version supplied incomplete for both FC6 & FC4? Do I need to install something to get this functionality or is this a legit bug? Version-Release number of selected component (if applicable): 2.0.4-5.3 & 2.0.4-5.5.3 and sdk-2.1.0-6 How reproducible: Always Steps to Reproduce: 1.In a spreadsheet macro named "example" tied to a button, put the following code: sub example dim doc as object dim sheet as object dim cell as object doc=ThisComponent sheet=doc.Sheets.getByName("Sheet1") cell=sheet.getCellByPosition(0,0) ' this works cell=sheet.getCellByName("A1") ' this doesn't end sub 2.Hit the button to execute the macro code 3.Note the error : Actual Results: Dialog box: BASIC runtime error. Property or method not found. Expected Results: Developers guide shows both getCellByPosition and getCellByName calls, therefore I expect both calls to function. Additional info:
Yeah, but getCellByName is only for tables inside writer I believe, not for the spreadsheets http://www.openoffice.org/servlets/ReadMsg?list=dev&msgNo=14061 http://www.openoffice.org/servlets/ReadMsg?list=users&msgNo=31712