OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Help and links

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3329

PostPosted: Tue Dec 26, 2006 3:25 am    Post subject: Help and links Reply with quote

Posts dealing with specific topics at the time of this final edit (GMT 1:35 14.06.07) are linked.

Requests for sources of information about scripting are posted fairly often. This thread is intended as a reference for relevant sources. I have removed all links which are external to oooforum.org and replaced them in the following external thread: [link removed]

Headings:
GENERAL INFORMATION AND AIDS
BOOK AND ARTICLES (see external thread)
APPLICATION PROGRAMMING INTERFACE (API)
UNIVERSAL NETWORK OBJECTS (UNO)
C++
VBA
SOURCE CODE (see external thread)
EXTENSIONS DEVELOPMENT (see external thread)
ACKNOWLEDGEMENTS

If there are additional posts at the time of this final edit, they are linked here :
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

GENERAL INFORMATION AND AIDS

Distribute macro : http://www.oooforum.org/forum/viewtopic.phtml?t=46351
Install macro :
Share on network : http://www.oooforum.org/forum/viewtopic.phtml?t=44084

Danny's Basic macro library: http://www.oooforum.org/forum/viewtopic.phtml?t=18762
Hints for getting started : http://www.oooforum.org/forum/viewtopic.phtml?p=206335#206335
Forum search : http://www.oooforum.org/forum/search.phtml[/list]
Xray: http://www.oooforum.org/forum/viewtopic.phtml?t=50083

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

APPLICATION PROGRAMMING INTERFACE (API)

Using the API ( links from DannyB's post http://www.oooforum.org/forum/viewtopic.phtml?p=21525#21525 )
Analysis of API (example FilterFactory service) : http://www.oooforum.org/forum/viewtopic.php?p=13511#13511
Analysis of API : http://www.oooforum.org/forum/viewtopic.php?p=15399#15399
Compare services and interfaces (example ServiceManager service) :
http://www.oooforum.org/forum/viewtopic.php?p=15246#15246
Creating services, arrays : http://www.oooforum.org/forum/viewtopic.php?t=4608
Document service : http://www.oooforum.org/forum/viewtopic.php?p=11995#11995
Exposition (Basic, Java, Python examples) : http://www.oooforum.org/forum/viewtopic.php?t=3735
Load, store, PropertyValues : http://www.oooforum.org/forum/viewtopic.php?p=13834#13834
LoadComponent, Text Document : http://www.oooforum.org/forum/viewtopic.php?t=3681
Spreadsheet : http://www.oooforum.org/forum/viewtopic.php?p=16186#16186
UnoControl : http://www.oooforum.org/forum/viewtopic.php?p=15034#15034
UnoControlDialog : http://www.oooforum.org/forum/viewtopic.php?t=3479

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

UNIVERSAL NETWORK OBJECTS (UNO)

Macro to extract commands from document: http://www.oooforum.org/forum/viewtopic.phtml?p=194691#194691

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

VBA

Tutorial : http://www.oooforum.org/forum/viewtopic.phtml?t=11854
Cell Font Style - Calc in VB : http://www.oooforum.org/forum/viewtopic.phtml?t=49582
Change Writer Hyperlinks with Visual Basic (VB6) : http://www.oooforum.org/forum/viewtopic.phtml?t=46345
Inserting a row into a calc spreadsheet using visual basic : http://www.oooforum.org/forum/viewtopic.phtml?t=49399
New Openoffice Components for Visual basic : http://www.oooforum.org/forum/viewtopic.phtml?t=40008
Search and replace text in hyperlinks http://www.oooforum.org/forum/viewtopic.phtml?t=46362

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ACKNOWLEDGEMENTS

Credit should be given to those who have supplied the original material.
Links have been provided by SergeM, 9point9
_________________
search forum by month


Last edited by noranthon on Sun Sep 30, 2007 3:38 am; edited 31 times in total
Back to top
View user's profile Send private message Visit poster's website
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3329

PostPosted: Tue Dec 26, 2006 5:56 pm    Post subject: Topic Links Reply with quote

General

Calc add-in function : http://www.oooforum.org/forum/viewtopic.phtml?t=7509
Convert numbers to words :
export to pdf (filter data) : http://www.oooforum.org/forum/viewtopic.phtml?t=54149
Listeners (links collected by SergeM)
Button (which fired an event?) : http://www.oooforum.org/forum/viewtopic.phtml?t=4327
Calc cell : http://www.oooforum.org/forum/viewtopic.phtml?t=6445
Calc cell changes : http://www.oooforum.org/forum/viewtopic.phtml?t=6773
Calc cell identifier : http://www.oooforum.org/forum/viewtopic.phtml?t=7283
Calc cell range - change of data : http://www.oooforum.org/forum/viewtopic.phtml?t=4490
Calc cell value changes - detect : desktop - close of : http://www.oooforum.org/forum/viewtopic.phtml?t=3576
Dialogue - close : http://www.oooforum.org/forum/viewtopic.phtml?t=31010
Event types : http://www.oooforum.org/forum/viewtopic.phtml?p=16086#16086
Globals not visible : http://www.oooforum.org/forum/viewtopic.phtml?t=5786
Key pressed : http://www.oooforum.org/forum/viewtopic.phtml?t=4390
Key pressed (which?) : http://www.oooforum.org/forum/viewtopic.phtml?p=16581#16581
Launching conditional macro : http://www.oooforum.org/forum/viewtopic.phtml?t=6792
Macro recorder and API fail : http://www.oooforum.org/forum/viewtopic.phtml?p=88903#88903
Mouse listener : http://www.oooforum.org/forum/viewtopic.phtml?t=7270
Python:how to add a listener routine : http://www.oooforum.org/forum/viewtopic.phtml?t=7420
Remove Listener : http://www.oooforum.org/forum/viewtopic.phtml?t=6906
Sheet change : http://www.oooforum.org/forum/viewtopic.phtml?t=5135
Shell command on Linux : http://www.oooforum.org/forum/viewtopic.phtml?t=9594

Persistent parameters -
How to store with OO Basic : http://www.oooforum.org/forum/viewtopic.phtml?t=27734
persistent data storage framework : http://www.oooforum.org/forum/viewtopic.phtml?t=34138
Persistent data : http://www.oooforum.org/forum/viewtopic.phtml?t=33823
Storing persistent custom attributes in document : http://www.oooforum.org/forum/viewtopic.phtml?t=17758

Screen refresh / update - avoiding :
(comprehensive discussion) http://www.oooforum.org/forum/viewtopic.phtml?t=49527
[calc] screen updating : http://www.oooforum.org/forum/viewtopic.phtml?t=49078
Preventing screen updating while macro runs : http://www.oooforum.org/forum/viewtopic.phtml?t=36652
An older thread : http://www.oooforum.org/forum/viewtopic.phtml?t=21072
_________________
search forum by month
Back to top
View user's profile Send private message Visit poster's website
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3329

PostPosted: Mon May 07, 2007 6:20 pm    Post subject: Tool-bars Reply with quote

TOOL-BARS

These links are copied from a post by SergeM:

A customized document toolbar with icon, shortcut and layout http://www.oooforum.org/forum/viewtopic.phtml?t=50877
how to create a toolbar with a combobox from java at runtime http://www.oooforum.org/forum/viewtopic.phtml?t=47503
How to copy a "custom_toolbar" from aWriterdoc http://www.oooforum.org/forum/viewtopic.phtml?t=44410
show some toolbars on startup http://www.oooforum.org/forum/viewtopic.phtml?t=44460
Is there a way to add (temporary) toolbar buttons? http://www.oooforum.org/forum/viewtopic.phtml?t=20152
Get the current scrollbar location http://www.oooforum.org/forum/viewtopic.phtml?t=35631
With OOobasic code :
To know if a toolbar is visible (C++, XDispatchHelper) : http://www.oooforum.org/forum/viewtopic.phtml?t=25834
How to change the toolbar name in the View->Toolbars menu http://www.oooforum.org/forum/viewtopic.phtml?t=29596
ScrollBar http://www.oooforum.org/forum/viewtopic.phtml?t=42103
_________________
search forum by month
Back to top
View user's profile Send private message Visit poster's website
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3329

PostPosted: Tue May 15, 2007 7:08 pm    Post subject: Python links Reply with quote

PYTHON

(external links moved to external thread)

Python examples are included in this thread : http://www.oooforum.org/forum/viewtopic.php?t=3735
Development of Calc Function add ons in Python : http://www.oooforum.org/forum/viewtopic.phtml?t=8456
Python container components : http://www.oooforum.org/forum/viewtopic.phtml?t=9115

Python on Windows : http://www.oooforum.org/forum/viewtopic.phtml?t=4818
_________________
search forum by month
Back to top
View user's profile Send private message Visit poster's website
blokkendoos
General User
General User


Joined: 09 Feb 2007
Posts: 15
Location: Westerkwartier, Groningen, Nederland

PostPosted: Thu Sep 27, 2007 2:10 am    Post subject: First link in Post does not seem to exist Reply with quote

Quote:
I have removed all links which are external to oooforum.org and replaced them in the following external thread:
"link removed - mod"


Where has it gone?

tia

pablo k
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3329

PostPosted: Sun Sep 30, 2007 5:02 am    Post subject: Reply with quote

Sorry about that. A page is being cobbled together on a wiki site. I'm not able to do much at present.
_________________
search forum by month
Back to top
View user's profile Send private message Visit poster's website
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3329

PostPosted: Fri Oct 05, 2007 9:24 pm    Post subject: Reply with quote

That site seems to be unavailable for a lengthy period. I've put some raw notes on an oo.o wiki page and will add some others.

If anyone has time to find a better location and move the material, please go ahead. If anyone has the time to format the data correctly, likewise.
_________________
search forum by month
Back to top
View user's profile Send private message Visit poster's website
swingkyd
OOo Advocate
OOo Advocate


Joined: 15 Sep 2004
Posts: 357

PostPosted: Thu Jan 17, 2008 1:03 pm    Post subject: Reply with quote

For those reading the StarOffice8 Programmer's guide, the section titled:
Quote:
storeAsURL Method Options

mentions that to access the FilterName String, one must look in the following file:
Quote:
FilterName (String) – specifies a special filter for the loadComponentFromURL
function. The filter names available are defined in the
\share\config\registry\instance\org\openoffice\office\TypeDetection.xml
file.

So, for me, this file didn't exist, and when I did find something on TypeDetection, it did not list the filters at all. After much searching, the actual file you might want instead of
Quote:
TypeDetection.xml
is files relating to
Quote:
*filters.xcu*

These are found here for me:
Quote:
share\registry\modules\org\openoffice\TypeDetection\Filter\

All the files in this directory give xml headers for the actual filters per program etc.
The API documentation doesn't really point to this description either.
I hope this helps some people.

Thanks to this link from www.nabble.com which pointed me in the right direction.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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