Bug 228305 - getCellByName in calc says "missing module" errors
getCellByName in calc says "missing module" errors
Status: CLOSED NOTABUG
Product: Fedora
Classification: Fedora
Component: openoffice.org (Show other bugs)
6
i386 Linux
medium Severity medium
: ---
: ---
Assigned To: Caolan McNamara
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2007-02-12 11:19 EST by Bill Gradwohl
Modified: 2007-11-30 17:11 EST (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2007-02-13 03:43:46 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Bill Gradwohl 2007-02-12 11:19:44 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 

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:
Comment 1 Caolan McNamara 2007-02-13 03:43:46 EST
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

Note You need to log in before you can comment on or make changes to this bug.