2007/12/7, Christian Cottignies <[EMAIL PROTECTED]>:
>
> I used to develop macros in Lotus 123 and Excel environments, now I am
> switching to OpenOffice, but I don't really find the good information in the
> API Programmer's guide neither Developper's guide to develop Basic
> macros/scripts in OpenOffice Spreadsheet documents. Samples given in The
> programmer's guide does not work....The corresponding object variables or
> methods are not recognized...for example getFormula for Xcell services or
> Document.Sheets.getByName("sheet1"). I tried to use the "Macro record"
> facility to have recorded examples of macro including my actions performed
> in the sheets, but these macros contain statements and use services/methods
> that are not at all described in the two API Guides. for example I could not
> find any explanation on "com.sun.star.frame.DispatchHelper" and its
> available methods.as .."xxx.executeDispatch(document,
> ".uno:JumpToNextCell", "", 0, Array())"
> Can someone help me by some documentations or hints or some OpenOffice
> Basic macros prints.
>
> Christian Cottignies, GSM: 06 81448878Hello, Andrew Pitonyak is one of the macro gurus at OpenOffice.org. See http://www.pitonyak.org/oo.php See his macro document http://www.pitonyak.org/database/AndrewBase.odt The macros pages of OOo are at: http://www.ooomacros.org/ HTH -- Guy using dutch OOo 2.3 m221 on a iMac Intel DualCore Tiger and brazilian OOo 2.3 RC 3 on a G4 PPC Powerbook Tiger -- please reply only to [email protected] -- Dodoes can't afford to have headaches
