Apache OpenOffice Community Forum - Code Snippets - (View forum)

Code Snippets

Forum rules
For sharing working examples of macros / scripts. These can be in any script language supported by OpenOffice.org [Basic, Python, Netbean] or as source code files in Java or C# even - but requires the actual source code listing. This section is not for asking questions about writing your own macros.

Forum

Topics

Posts

Last post

Extension Repository
OpenOffice.org official extension repository
Total redirects: 919485

Total redirects: 919485
Macro Repository
Collection of macros or both developers and end users
Total redirects: 1805824

Total redirects: 1805824

New Topic

196 topics

Announcements

Replies

Views

Last post

Apache OpenOffice 4.1.15 released

Last post by robleyd « Sat Dec 23, 2023 3:55 am
Posted in Announcements

by robleyd » Sat Dec 23, 2023 3:55 am » in Announcements

0 Replies

317186 Views

Last post by robleyd
Sat Dec 23, 2023 3:55 am

Topics

Replies

Views

Last post

[Calc, Python] Print selected sheets and ranges

Last post by RichieRH « Thu Feb 12, 2015 12:44 pm
Replies: 2
by Villeroy » Tue Jun 04, 2013 7:13 pm

2 Replies

8006 Views

Last post by RichieRH
Thu Feb 12, 2015 12:44 pm
[Basic, Python] Reporting all number format locales

Last post by Villeroy « Sun Nov 30, 2014 2:45 pm

by Villeroy » Sun Nov 30, 2014 2:45 pm

0 Replies

3132 Views

Last post by Villeroy
Sun Nov 30, 2014 2:45 pm
Base. Do calculation before updating table

Last post by macnab « Wed Oct 22, 2014 5:41 am

by macnab » Wed Oct 22, 2014 5:41 am

0 Replies

2417 Views

Last post by macnab
Wed Oct 22, 2014 5:41 am
[Python] Sort CellRange across rows/coumns.

Last post by Charlie Young « Tue Oct 21, 2014 5:00 pm
Replies: 1
by Charlie Young » Tue Oct 21, 2014 9:27 am

1 Replies

3771 Views

Last post by Charlie Young
Tue Oct 21, 2014 5:00 pm
Export Base report as pdf file - Report Runner.oxt

Last post by jaycee6828 « Sun Jun 01, 2014 3:58 pm
Replies: 7
by DrewJensen » Mon Mar 31, 2008 6:51 am

7 Replies

14550 Views

Last post by jaycee6828
Sun Jun 01, 2014 3:58 pm
UserFields class via python dictionary api

Last post by Induane « Tue May 27, 2014 9:01 pm

by Induane » Tue May 27, 2014 9:01 pm

0 Replies

3056 Views

Last post by Induane
Tue May 27, 2014 9:01 pm
Get/Set color properties easily in Python

Last post by Induane « Thu Apr 24, 2014 10:54 pm

by Induane » Thu Apr 24, 2014 10:54 pm

0 Replies

5862 Views

Last post by Induane
Thu Apr 24, 2014 10:54 pm
Convert Text to SRT subtitle format

Last post by Robert Tucker « Thu Mar 20, 2014 5:05 pm

by Robert Tucker » Thu Mar 20, 2014 5:05 pm

0 Replies

6982 Views

Last post by Robert Tucker
Thu Mar 20, 2014 5:05 pm
Resize array formula

Last post by Villeroy « Sun Feb 09, 2014 12:41 pm
Replies: 2
by Villeroy » Sun Feb 09, 2014 12:26 am

2 Replies

7692 Views

Last post by Villeroy
Sun Feb 09, 2014 12:41 pm
[Python,Calc] Group_Concat for the spreadsheet

Last post by Villeroy « Wed Feb 06, 2013 9:31 pm

by Villeroy » Wed Feb 06, 2013 9:31 pm

0 Replies

4606 Views

Last post by Villeroy
Wed Feb 06, 2013 9:31 pm
[Python] Shape Drawing Add-In Function

Last post by Charlie Young « Thu Nov 29, 2012 6:21 am

by Charlie Young » Thu Nov 29, 2012 6:21 am

0 Replies

5586 Views

Last post by Charlie Young
Thu Nov 29, 2012 6:21 am
[BASIC] Advanced printing macro's

Last post by zenlord « Fri Oct 19, 2012 12:19 pm
Replies: 4
by zenlord » Tue Oct 09, 2012 5:48 pm

4 Replies

17730 Views

Last post by zenlord
Fri Oct 19, 2012 12:19 pm
Remove unused custom styles

Last post by Hagar Delest « Sat Jul 14, 2012 9:19 pm
Replies: 3
by Hagar Delest » Sun Jul 17, 2011 12:24 am

3 Replies

14699 Views

Last post by Hagar Delest
Sat Jul 14, 2012 9:19 pm
[Calc And Excel VBA] Large X-Y Table Interpolation Macro

Last post by siouxerbrewer « Thu May 03, 2012 4:18 am
Replies: 3
by geyerej » Sun Nov 07, 2010 2:36 pm

3 Replies

33331 Views

Last post by siouxerbrewer
Thu May 03, 2012 4:18 am
[Base] Call MRI on forms or form controls from form document

Last post by Arineckaig « Fri Mar 23, 2012 1:06 pm
Replies: 3
by Arineckaig » Wed Mar 02, 2011 2:13 pm

3 Replies

11258 Views

Last post by Arineckaig
Fri Mar 23, 2012 1:06 pm
Sort buttons on spreadsheet

Last post by Villeroy « Sat Mar 03, 2012 3:09 pm
Replies: 4
by Villeroy » Sun Dec 30, 2007 7:15 pm

4 Replies

20859 Views

Last post by Villeroy
Sat Mar 03, 2012 3:09 pm
Java code to print spreadsheet rows to the console

Last post by Yu0JbXks « Sun Dec 11, 2011 4:04 am

by Yu0JbXks » Sun Dec 11, 2011 4:04 am

0 Replies

8528 Views

Last post by Yu0JbXks
Sun Dec 11, 2011 4:04 am
[Writer] Extract embedded picture on disk

Last post by Bidouille « Wed Aug 03, 2011 3:31 pm

by Bidouille » Wed Aug 03, 2011 3:31 pm

0 Replies

3333 Views

Last post by Bidouille
Wed Aug 03, 2011 3:31 pm
[Writer] Save with file name from fields

Last post by JohnV « Thu Jul 07, 2011 4:52 pm
Replies: 1
by gopalakrishnanms » Thu Jul 07, 2011 1:58 pm

1 Replies

683 Views

Last post by JohnV
Thu Jul 07, 2011 4:52 pm
Delete all hyperlinks - Writer

Last post by JohnV « Thu Apr 28, 2011 9:37 pm

by JohnV » Thu Apr 28, 2011 9:37 pm

0 Replies

10537 Views

Last post by JohnV
Thu Apr 28, 2011 9:37 pm
AutoCorrect import macro? 2008 version

Last post by Tommy « Sat Mar 19, 2011 8:27 pm
Replies: 17
by rmdemi » Mon Jun 30, 2008 10:39 pm

17 Replies

31878 Views

Last post by Tommy
Sat Mar 19, 2011 8:27 pm
Data pilot ImportDescriptor availlable since OOo 3.3

Last post by mbrouillet « Wed Dec 08, 2010 1:08 am
Replies: 1
by Villeroy » Tue Nov 30, 2010 1:13 am

1 Replies

4506 Views

Last post by mbrouillet
Wed Dec 08, 2010 1:08 am
Function to return Calc Document containing a Spreadsheet

Last post by Villeroy « Tue Nov 09, 2010 3:29 pm
Replies: 1
by gurfle » Mon Aug 16, 2010 1:22 am

1 Replies

4886 Views

Last post by Villeroy
Tue Nov 09, 2010 3:29 pm
unoconv: Convert between any doc format supported by OOo

Last post by dag « Thu Jul 29, 2010 2:12 pm
Replies: 4
by AndrewZ » Mon Feb 11, 2008 1:19 am

4 Replies

20312 Views

Last post by dag
Thu Jul 29, 2010 2:12 pm
[Basic] Log output to the consol or a file from Basic

Last post by B Marcelly « Sat Jul 17, 2010 3:19 pm
Replies: 1
by hanya » Sat Jul 17, 2010 12:03 pm

1 Replies

12112 Views

Last post by B Marcelly
Sat Jul 17, 2010 3:19 pm
Populate list box with records from database

Last post by batonac « Mon Jun 14, 2010 7:43 pm
Replies: 1
by Lazy-legs » Fri Mar 14, 2008 7:45 pm

1 Replies

10283 Views

Last post by batonac
Mon Jun 14, 2010 7:43 pm
Wrapper for a code-beautifier

Last post by Heertsch « Fri Apr 02, 2010 6:34 pm

by Heertsch » Fri Apr 02, 2010 6:34 pm

0 Replies

4363 Views

Last post by Heertsch
Fri Apr 02, 2010 6:34 pm
[Calc, Basic] Formatted form controls to sheet cells

Last post by Villeroy « Sun Dec 06, 2009 8:58 pm
Replies: 7
by Villeroy » Thu May 14, 2009 12:09 pm

7 Replies

24314 Views

Last post by Villeroy
Sun Dec 06, 2009 8:58 pm
[Writer] Save with first line as file name.

Last post by JohnV « Mon Nov 30, 2009 9:06 pm
Replies: 5
by JohnV » Tue Jun 23, 2009 4:48 pm

5 Replies

30112 Views

Last post by JohnV
Mon Nov 30, 2009 9:06 pm
[Calc, Basic] Introspective cell functions

Last post by Villeroy « Tue Oct 27, 2009 7:23 pm
Replies: 2
by Villeroy » Mon Feb 18, 2008 9:53 pm

2 Replies

91135 Views

Last post by Villeroy
Tue Oct 27, 2009 7:23 pm
Import filter for Treepad light 3.0 files into OOo Writer

Last post by pk72 « Sun Sep 13, 2009 12:16 pm

by pk72 » Sun Sep 13, 2009 12:16 pm

0 Replies

4942 Views

Last post by pk72
Sun Sep 13, 2009 12:16 pm
[Writer] Macro to update indexes, merge revisions, save doc

Last post by oobuffett « Thu Jul 16, 2009 11:46 am
Replies: 1
by stefano77 » Wed Aug 27, 2008 6:10 pm

1 Replies

8650 Views

Last post by oobuffett
Thu Jul 16, 2009 11:46 am
[Calc] Event-Listeners & Handlers

Last post by Villeroy « Tue Jun 09, 2009 9:06 am
Replies: 2
by onidarbe » Fri Sep 26, 2008 2:00 am

2 Replies

22546 Views

Last post by Villeroy
Tue Jun 09, 2009 9:06 am
[Calc,Python,Basic,Base] Several ways to time stamps

Last post by Villeroy « Sat Mar 28, 2009 6:14 pm
Replies: 2
by Villeroy » Wed Nov 26, 2008 8:39 pm

2 Replies

32400 Views

Last post by Villeroy
Sat Mar 28, 2009 6:14 pm
[Writer] Work-around for a Two lines heading

Last post by Hagar Delest « Mon Mar 23, 2009 11:20 pm
Replies: 11
by foxcole » Wed Dec 05, 2007 1:54 pm

11 Replies

20496 Views

Last post by Hagar Delest
Mon Mar 23, 2009 11:20 pm
[Calc] Get Macro-Editor open fast with 1 button

Last post by onidarbe « Sun Feb 08, 2009 3:31 pm
Replies: 5
by onidarbe » Thu Sep 18, 2008 9:07 pm

5 Replies

9873 Views

Last post by onidarbe
Sun Feb 08, 2009 3:31 pm
[Calc] Statusbar, displaying text at the bottom

Last post by opensanta « Sat Dec 27, 2008 1:35 pm
Replies: 1
by onidarbe » Thu Sep 25, 2008 4:13 pm

1 Replies

8670 Views

Last post by opensanta
Sat Dec 27, 2008 1:35 pm
[Writer] Work-around for an in-line heading

Last post by Hagar Delest « Sun Nov 30, 2008 4:16 pm
Replies: 5
by Hagar Delest » Mon May 26, 2008 11:44 am

5 Replies

11244 Views

Last post by Hagar Delest
Sun Nov 30, 2008 4:16 pm
Calc-EVENT trouble, still 1 problem, how start them again?

Last post by onidarbe « Wed Sep 17, 2008 1:36 am

by onidarbe » Wed Sep 17, 2008 1:36 am

0 Replies

3716 Views

Last post by onidarbe
Wed Sep 17, 2008 1:36 am
Maximize document window - MS Windows only

Last post by morry « Wed Aug 06, 2008 3:27 pm
Replies: 1
by DrewJensen » Sun Feb 03, 2008 6:04 pm

1 Replies

8953 Views

Last post by morry
Wed Aug 06, 2008 3:27 pm
Cleanup recent files

Last post by hanya « Tue Jun 24, 2008 4:55 pm
Replies: 1
by hanya » Mon Jun 23, 2008 7:12 pm

1 Replies

6052 Views

Last post by hanya
Tue Jun 24, 2008 4:55 pm
[Python] Context sensitive recent files list

Last post by hanya « Tue Jun 24, 2008 4:55 pm
Replies: 1
by hanya » Mon Jun 23, 2008 6:50 pm

1 Replies

5238 Views

Last post by hanya
Tue Jun 24, 2008 4:55 pm
Generate own UNO services with OO Basic

Last post by ms777 « Mon May 26, 2008 10:31 pm
Replies: 1
by ms777 » Sat Apr 05, 2008 4:22 pm

1 Replies

9778 Views

Last post by ms777
Mon May 26, 2008 10:31 pm
Delete custom styles

Last post by esperantisto « Fri Feb 22, 2008 3:50 pm
Replies: 1
by JohnV » Wed Feb 06, 2008 4:49 pm

1 Replies

9765 Views

Last post by esperantisto
Fri Feb 22, 2008 3:50 pm
Using COM to integrate Powerpoint and Impress

Last post by TerryE « Mon Feb 11, 2008 11:05 am
Replies: 1
by TerryE » Mon Feb 11, 2008 12:25 am

1 Replies

8432 Views

Last post by TerryE
Mon Feb 11, 2008 11:05 am
[Calc] Import by parameters in cells.

Last post by TerryE « Mon Jan 14, 2008 10:31 pm
Replies: 1
by Villeroy » Mon Jan 14, 2008 11:51 am

1 Replies

11709 Views

Last post by TerryE
Mon Jan 14, 2008 10:31 pm

New Topic

196 topics

Return to Board Index

Forum permissions

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 post attachments in this forum