On Tuesday 17 April 2007, + Bill Gradwohl wrote:
> [ MODERATED ] ***********************
> I hope this is the correct list to ask.
>
> I've seen several subroutine examples that all contain the same sequence
> of opening executable statements when working with a spreadsheet, as
> does the following example:
>
> sub dumpSheets
>
> Dim doc as object
> Dim Sheets As Object
> Dim SheetNames
> Dim I As Integer
>
> ' Executable statements follow:
> doc=StarDesktop.CurrentComponent
> Sheets = doc.Sheets
>
> SheetNames = Sheets.getElementNames
> For I=LBound(SheetNames) To UBound(SheetNames)
> MsgBox SheetNames(I)
> Next I
> end sub
>
>
> When doc is initialized, what object exactly is it associated with?
> Is it a com.sun.star. (document or container or sheet or ...) what?
>
> For the life of me, I can't find the thing called "Sheets" as in
> doc.Sheets, anywhere in the API, so I can't understand how the
> initialization of Sheets = doc.Sheets works. How am I supposed to know
> that something called "Sheets" exists? Where is this documented in the
> API?
>
> I've spent hours trying to go thru the API at
> http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html
> and can't seem to get my brain around how to find something as
> rudimentary as the doc.Sheets item.
>
> Any help would be appreciated.
Hi Bill,
Maybe you should ask on [EMAIL PROTECTED] and ask to be CC:ed as you may
not see all replies unless you subscribe to that list by sending an email to
[EMAIL PROTECTED] and reply to the confirmation request email.
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
