| View previous topic :: View next topic |
| Author |
Message |
Ben Lau Guest
|
Posted: Sat Feb 14, 2004 2:09 am Post subject: UNO's object reference document |
|
|
Hi all,
It may be a stupid question but really thanks for any replies.
I am completely new to the macro/UNO of openoffice(and even to Winword's macro). I want to insert a combo box object in my calc document. I have looked ComboBox_in_a_Sheet_En.sxc but don't know how to use it.
http://ooodocs.sourceforge.net/modules.php?name=Downloads&d_op=getit&lid=97
And then i tried to look inside the source , it is quite short and I am able to read basic language. However , i don't know where can i find the class/object reference document of oSheet/oDoc etc... and result that I really don't understand what is the code going on..
So I want to ask any website contained the list of all UNO's object and their method?
Thanks! |
|
| Back to top |
|
 |
SergeM Super User

Joined: 09 Sep 2003 Posts: 3211 Location: Troyes France
|
|
| Back to top |
|
 |
DannyB Moderator


Joined: 02 Apr 2003 Posts: 3991 Location: Lawrence, Kansas, USA
|
Posted: Sat Feb 14, 2004 7:49 am Post subject: |
|
|
In addition to sergeM's answer, here is how you find how the events are tied to the control.
On the far left side of the document window is a tall vertical toolbar called the Main Toolbar. (If it is not, then make sure View --> Toolbars --> Main Toolbar is checked.)
Right-click in the Main Toolbar. A context menu appears. One of the choices are "Visible Buttons", which leads to a submenu of the possible things that can appear on this toolbar. Make sure that Show Form Functions is checked.
From the Main Toolbar, pick the Show Form Functions icon, and tear off the submenu into a window called "Form Functions".
The Form Functions window has two rows of icons. On the bottom row, sixth button from the left is the "Design Mode On/Off" button. Click it to turn on design mode. (All of the other buttons on the Form Functions should now enable.) Now you can design forms and place form controls on the spreadsheet.
Now, when in design mode, click on the Combo Box. It gets little green handles around it to indicate it is selected. Right-click, context menu appears. Form the context menu pick Right-Click --> Control...
The Properties sheet appears for the control. It has three tabs, General, Data, and Events. On the Events tab, notice that two events are set to call Basic functions.
The "When receiving focus" event calls....
document:Standard.Bas_demo_en.Load_Values_List
The "Text modified" event calls...
document.Standard.Bas_demo_En.Writer_To_Destination_Cell
Here are other links which might help....
How do I get started?
=====================
http://www.oooforum.org/forum/viewtopic.php?t=5421
http://www.oooforum.org/forum/viewtopic.php?t=3687
http://www.oooforum.org/forum/viewtopic.php?t=3590
Basic Programmer's Guide is here....
http://docs.sun.com/db/coll/999.2
StarOffice 7 Basic Programmer's Guide, English
http://docs.sun.com/db/doc/817-1826?q=StarOffice
Available in other languages...
http://api.openoffice.org/TipsAndTricks/external.html
StarOffice 6 Basic Programmer's Guide, English
http://docs.sun.com/db/doc/817-1826-10
StarOffice 6 Product Documentation
http://docs.sun.com/db/coll/999.2
OpenOffice Macro Document by Andrew Pitonyak
http://www.pitonyak.org/AndrewMacro.sxw
Lots of macros here...
http://www.OOoMacros.org
StarBasic FAQ (German only)
http://www.dannenhoefer.de/faqstarbasic.htm
How to navigate the OOo API Docs
================================
http://www.oooforum.org/forum/viewtopic.php?p=13511#13511
http://www.oooforum.org/forum/viewtopic.php?p=15399#15399
http://www.oooforum.org/forum/viewtopic.php?p=15246#15246
http://www.oooforum.org/forum/viewtopic.php?p=11995#11995
http://www.oooforum.org/forum/viewtopic.php?t=3479
http://www.oooforum.org/forum/viewtopic.php?p=16186#16186
http://www.oooforum.org/forum/viewtopic.php?t=4608
http://www.oooforum.org/forum/viewtopic.php?p=13834#13834
http://www.oooforum.org/forum/viewtopic.php?p=15034#15034
http://www.oooforum.org/forum/viewtopic.php?t=3735
http://www.oooforum.org/forum/viewtopic.php?t=3681
XShapes, DrawPage, GenericDrawPage
http://www.oooforum.org/forum/viewtopic.php?t=5328
Developer's Guide
http://api.openoffice.org/DevelopersGuide/DevelopersGuide.html
(Developer's Guide TOC is here)
http://api.openoffice.org/docs/DevelopersGuide/DevelopersGuide.htm
and the online API reference....
http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html
Useful links from Russ...
http://www.oooforum.org/forum/viewtopic.php?p=16374#16374 _________________ Want to make OOo Drawings like the colored flower design to the left? |
|
| Back to top |
|
 |
Ben Lau Guest
|
Posted: Thu Feb 19, 2004 3:31 pm Post subject: |
|
|
| Thanks sergeM and DannyB! I am digesting the links now.. |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|