Red Hat Bugzilla – Bug 228305
getCellByName in calc says "missing module" errors
Last modified: 2007-11-30 17:11:57 EST
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
Steps to Reproduce:
1.In a spreadsheet macro named "example" tied to a button, put the following code:
dim doc as object
dim sheet as object
dim cell as object
cell=sheet.getCellByPosition(0,0) ' this works
cell=sheet.getCellByName("A1") ' this doesn't
2.Hit the button to execute the macro code
3.Note the error :
BASIC runtime error.
Property or method not found.
Developers guide shows both getCellByPosition and getCellByName calls, therefore I expect both calls to function.
Yeah, but getCellByName is only for tables inside writer I believe, not for the