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: 1280633

Total redirects: 1280633
Macro Repository
Collection of macros or both developers and end users
Total redirects: 2239613

Total redirects: 2239613

New Topic

206 topics

Announcements

Replies

Views

Last post

Apache OpenOffice 4.1.16 Released

Last post by robleyd « Thu Nov 13, 2025 3:27 am
Posted in Announcements
Replies: 1
by LastUnicorn » Tue Nov 11, 2025 12:36 pm » in Announcements

1 Replies

205238 Views

Last post by robleyd
Thu Nov 13, 2025 3:27 am

Topics

Replies

Views

Last post

Macro code similar to MS Access

Last post by acknak « Mon Jul 11, 2016 8:43 pm
Replies: 2
by longi » Sun Jul 10, 2016 10:10 pm

2 Replies

3724 Views

Last post by acknak
Mon Jul 11, 2016 8:43 pm
[Calc] Coundown Timer

Last post by VBWizard « Mon May 16, 2016 10:24 pm
Replies: 2
by VBWizard » Sat May 14, 2016 5:20 pm

2 Replies

9195 Views

Last post by VBWizard
Mon May 16, 2016 10:24 pm
Alternative Listbox Updated 15 April 16

Last post by JeJe « Mon Apr 11, 2016 12:48 am

by JeJe » Mon Apr 11, 2016 12:48 am

0 Replies

2706 Views

Last post by JeJe
Mon Apr 11, 2016 12:48 am
Find & Replace Sample of multiple operations.

Last post by jjjjjjj7 « Sat Mar 19, 2016 12:40 am
Replies: 15
by JohnV » Thu Feb 07, 2008 6:52 pm

15 Replies

42046 Views

Last post by jjjjjjj7
Sat Mar 19, 2016 12:40 am
Base Macros to Modify Menubars

Last post by Ratslinger « Mon Feb 15, 2016 5:36 am

by Ratslinger » Mon Feb 15, 2016 5:36 am

0 Replies

3065 Views

Last post by Ratslinger
Mon Feb 15, 2016 5:36 am
Merge sheets of spreadsheet documents

Last post by guidox « Sun Nov 08, 2015 4:36 pm
Replies: 5
by Villeroy » Sat May 09, 2015 11:05 pm

5 Replies

22428 Views

Last post by guidox
Sun Nov 08, 2015 4:36 pm
[Calc] Get ActiveCell (with changing column or row)

Last post by RichieRH « Sun Oct 25, 2015 5:02 am
Replies: 6
by onidarbe » Thu Sep 25, 2008 4:25 pm

6 Replies

17435 Views

Last post by RichieRH
Sun Oct 25, 2015 5:02 am
[Basic] Copy full content from one document to another

Last post by Villeroy « Sun Sep 06, 2015 10:28 pm
Replies: 6
by espinosa_cz » Sun Aug 23, 2015 7:41 pm

6 Replies

14878 Views

Last post by Villeroy
Sun Sep 06, 2015 10:28 pm
Create fancy custom toolbars with OOo Basic

Last post by taipeihugo « Wed Aug 12, 2015 11:23 am
Replies: 4
by ms777 » Sat Apr 05, 2008 4:48 pm

4 Replies

15961 Views

Last post by taipeihugo
Wed Aug 12, 2015 11:23 am
DIRECTORY LIST - files or folders to Calc

Last post by Villeroy « Tue Feb 17, 2015 12:23 am
Replies: 20
by JohnV » Mon May 23, 2011 4:39 pm

20 Replies

42028 Views

Last post by Villeroy
Tue Feb 17, 2015 12:23 am
[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

8406 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

3400 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

2600 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

4070 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

15282 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

3298 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

6139 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

7421 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

8118 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

4872 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

6018 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

18262 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

15288 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

33994 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

11749 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

21342 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

8783 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

3553 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

954 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

10816 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

33569 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

4770 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

5145 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

20717 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

12449 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

10591 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

5046 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

24919 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

30921 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

93429 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

5209 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

8923 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

23351 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

33005 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

21690 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

10178 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

8992 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

11796 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

4012 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

9229 Views

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

New Topic

206 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