* Andrew Douglas Pitonyak <[EMAIL PROTECTED]> [280605, 20:33]:
> Ennio-Sr wrote:
>
> >Hi all,
> >
> >After grouping seven different spreadsheets in a single
> >'multiplesheets' document I'm at a loss, now, being no longer able to
> >use the common library macros: for them to work as they did before
> >I should be able to make the macro 'know' which sheet it's acting on,
> >so that it can choose the appropriate parameters.
> >
> >Perusing into the docs I discovered the 'getActiveSheet()' _thing_ (in
> >com.sun.star.sheet) but could not find any example of its use I could
> >understand or, at least, make work ... ;-(
> >
> >As I would like to test it now (and not after having fully understood
> >how the whole 'API affair' works, which may well take some very long
> >time) could some of you suggest some good example?
> >
> >Regards,
> > Ennio.
> >
> >
> If I remember correctly, you own a copy of my book.
> Look at page 249, 260, and 261 for examples.
> Look at Table 52 on Page 372 for a description.
>
> Now, for a test of your understanding of how things are setup, read the
> first paragraph on page 190. Also, read the fifth paragraph on the same
> page. The real meat of what you want to know, however, starts in Chapter
> 12. Just start reading. It is again explained in paragraph three.
>
> After you understand the usage of the controller, it becomes obvious why
> you ask the current controller for the view cursor, the active sheet, etc.
>
Hi Andrew,
thanks for your answer; unluckily I don't have a copy of your book and
there is no quick way to get it, at least where I live ;-(. I searched
bookshops and Universities libraries to no avail; OTOH starting a
regular study of macros does not fit in my current plans, so I gave up.
I did find some examples around, but there is still something which I
cannot grasp, i.e. whether the *getActiveSheet()* would return the
spreadsheet name or its cardinal number. Running this macro:
>Sub getsheet
> oDoc=ThisComponent
> oSheet=oDoc.CurrentController.getActiveSheet()
>End sub
doesn't throw any error, neither seems to yeald any result: adding:
> MsgBox oSheet
will produce a box with an 'OK' in it and soon after a *Basic Runtime
Error: incorrect property value* warning.
In case I'm too far from a solution, never mind: I'll return to my seven
separate spreadsheets and stop bothering myself and the ML with things
beyond my present capacity to understand :-)
Thanks again,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
