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

Find & Replace working on cell contents in Calc

Last post by Lupp « Sun Jun 23, 2019 5:28 pm
Replies: 1
by Lupp » Sun Jun 23, 2019 2:19 pm

1 Replies

4543 Views

Last post by Lupp
Sun Jun 23, 2019 5:28 pm
Merge multiple CSV with same Header

Last post by Villeroy « Fri Apr 26, 2019 5:01 pm
Replies: 3
by musikai » Sun Dec 10, 2017 10:11 pm

3 Replies

11202 Views

Last post by Villeroy
Fri Apr 26, 2019 5:01 pm
Scroller for Writer

Last post by JeJe « Mon Apr 08, 2019 1:42 pm

by JeJe » Mon Apr 08, 2019 1:42 pm

0 Replies

3338 Views

Last post by JeJe
Mon Apr 08, 2019 1:42 pm
Assign a shortcut for a macro

Last post by JeJe « Wed Mar 27, 2019 1:14 pm

by JeJe » Wed Mar 27, 2019 1:14 pm

0 Replies

3014 Views

Last post by JeJe
Wed Mar 27, 2019 1:14 pm
Print properties of TypeDetection and FilterFactory

Last post by Villeroy « Sun Feb 24, 2019 8:53 pm

by Villeroy » Sun Feb 24, 2019 8:53 pm

0 Replies

4921 Views

Last post by Villeroy
Sun Feb 24, 2019 8:53 pm
[Calc] Selection of multiple linear items.

Last post by Sébastien C « Sun Feb 24, 2019 3:18 pm

by Sébastien C » Sun Feb 24, 2019 3:18 pm

0 Replies

3979 Views

Last post by Sébastien C
Sun Feb 24, 2019 3:18 pm
Filters: Export to Non-Office, Import/Export Alien Formats

Last post by Sébastien C « Sat Feb 23, 2019 11:11 pm
Replies: 4
by Lupp » Wed Feb 20, 2019 4:13 pm

4 Replies

4015 Views

Last post by Sébastien C
Sat Feb 23, 2019 11:11 pm
Use the dispatcher for other modules than Calc or Writer.

Last post by Sébastien C « Mon Feb 18, 2019 3:05 am

by Sébastien C » Mon Feb 18, 2019 3:05 am

0 Replies

2984 Views

Last post by Sébastien C
Mon Feb 18, 2019 3:05 am
Unlimited Sort Columns & Custom Sort Order Using Basic

Last post by alsOO « Sun Feb 17, 2019 2:38 am
Replies: 2
by alsOO » Mon Oct 03, 2011 1:33 am

2 Replies

12250 Views

Last post by alsOO
Sun Feb 17, 2019 2:38 am
Create CSV from Formdata of PDFs in a folder (using PDFtk)

Last post by musikai « Sat Feb 16, 2019 12:31 pm
Replies: 2
by musikai » Thu Dec 14, 2017 1:33 am

2 Replies

6097 Views

Last post by musikai
Sat Feb 16, 2019 12:31 pm
[BASIC] Object-Oriented Programming

Last post by JeJe « Thu Feb 14, 2019 1:34 am
Replies: 33
by JPL » Sat Dec 15, 2012 1:19 pm
1

2
33 Replies

51879 Views

Last post by JeJe
Thu Feb 14, 2019 1:34 am
Select Whole Writer Document

Last post by JeJe « Sun Feb 03, 2019 9:49 pm

by JeJe » Sun Feb 03, 2019 9:49 pm

0 Replies

1956 Views

Last post by JeJe
Sun Feb 03, 2019 9:49 pm
[Calc] Know the last nonempty cell of a row or a column.

Last post by Villeroy « Fri Jan 18, 2019 7:39 pm
Replies: 1
by Sébastien C » Sun Jan 06, 2019 11:43 pm

1 Replies

5393 Views

Last post by Villeroy
Fri Jan 18, 2019 7:39 pm
OOBasic Picker Dialogs

Last post by JeJe « Tue Dec 18, 2018 11:21 pm

by JeJe » Tue Dec 18, 2018 11:21 pm

0 Replies

2682 Views

Last post by JeJe
Tue Dec 18, 2018 11:21 pm
Save /back up Basic Libraries with macro, rename Libraries

Last post by JeJe « Tue Dec 04, 2018 1:16 am
Replies: 6
by JeJe » Mon Nov 12, 2018 12:31 am

6 Replies

6831 Views

Last post by JeJe
Tue Dec 04, 2018 1:16 am
Base, Calc, Python: INSERT, UPDATE, DELETE from spreadsheet

Last post by Villeroy « Tue Oct 23, 2018 1:41 pm
Replies: 2
by Villeroy » Fri Oct 19, 2018 7:04 pm

2 Replies

6504 Views

Last post by Villeroy
Tue Oct 23, 2018 1:41 pm
[Basic] Enum.erations or Constant groups

Last post by LibreOfficiant « Wed Oct 17, 2018 6:35 pm

by LibreOfficiant » Wed Oct 17, 2018 6:35 pm

0 Replies

2272 Views

Last post by LibreOfficiant
Wed Oct 17, 2018 6:35 pm
Convert DateTime fields to ordinary text portions

Last post by JeJe « Wed Oct 10, 2018 1:33 pm
Replies: 1
by Lupp » Wed Oct 10, 2018 12:51 pm

1 Replies

3042 Views

Last post by JeJe
Wed Oct 10, 2018 1:33 pm
OOBasic Popup menu Class

Last post by JeJe « Wed Sep 12, 2018 1:09 pm

by JeJe » Wed Sep 12, 2018 1:09 pm

0 Replies

3232 Views

Last post by JeJe
Wed Sep 12, 2018 1:09 pm
Calc: Copy one Cell to each cell in a CellRange

Last post by Lupp « Thu Sep 06, 2018 12:58 am

by Lupp » Thu Sep 06, 2018 12:58 am

0 Replies

3045 Views

Last post by Lupp
Thu Sep 06, 2018 12:58 am
[Basic] Save a document and create a timestamped copy

Last post by Lupp « Sun Aug 12, 2018 1:21 pm
Replies: 6
by squenson » Sun Oct 11, 2009 6:32 pm

6 Replies

27395 Views

Last post by Lupp
Sun Aug 12, 2018 1:21 pm
[Calc] Check boxes and radio buttons in UTF8.

Last post by Sébastien C « Fri Jun 01, 2018 12:17 am

by Sébastien C » Fri Jun 01, 2018 12:17 am

0 Replies

6026 Views

Last post by Sébastien C
Fri Jun 01, 2018 12:17 am
Merge sheets of one spreadsheet document

Last post by Villeroy « Thu Apr 05, 2018 4:23 pm

by Villeroy » Thu Apr 05, 2018 4:23 pm

0 Replies

5837 Views

Last post by Villeroy
Thu Apr 05, 2018 4:23 pm
OOBasic Dialog Label Scrollbar Class

Last post by JeJe « Fri Mar 30, 2018 6:36 pm

by JeJe » Fri Mar 30, 2018 6:36 pm

0 Replies

2481 Views

Last post by JeJe
Fri Mar 30, 2018 6:36 pm
[Draw] Center an image on the page.

Last post by Zizi64 « Sun Mar 11, 2018 10:36 am
Replies: 1
by Sébastien C » Wed Mar 07, 2018 3:42 pm

1 Replies

4947 Views

Last post by Zizi64
Sun Mar 11, 2018 10:36 am
[Calc, Basic] Copy visible cells

Last post by Villeroy « Wed Feb 14, 2018 4:03 pm

by Villeroy » Wed Feb 14, 2018 4:03 pm

0 Replies

5170 Views

Last post by Villeroy
Wed Feb 14, 2018 4:03 pm
Faster sorted list of OO font names

Last post by JeJe « Mon Feb 05, 2018 12:49 am
Replies: 1
by JeJe » Sun Feb 04, 2018 1:05 am

1 Replies

2863 Views

Last post by JeJe
Mon Feb 05, 2018 12:49 am
[Calc, Python] Send Mail

Last post by balmerhevi « Wed Jan 17, 2018 8:40 am
Replies: 4
by Villeroy » Sat Sep 09, 2017 5:32 pm

4 Replies

10626 Views

Last post by balmerhevi
Wed Jan 17, 2018 8:40 am
Calc: Replace "\n" with linebreaks

Last post by musikai « Mon Dec 18, 2017 11:52 pm

by musikai » Mon Dec 18, 2017 11:52 pm

0 Replies

2818 Views

Last post by musikai
Mon Dec 18, 2017 11:52 pm
Convert Folder of Formdata.txt (created with PDFtk) to .xfdf

Last post by musikai « Thu Dec 14, 2017 12:28 am

by musikai » Thu Dec 14, 2017 12:28 am

0 Replies

2895 Views

Last post by musikai
Thu Dec 14, 2017 12:28 am
Extract form data of Folder of PDFs (using PDFtk)

Last post by musikai « Thu Dec 14, 2017 12:20 am

by musikai » Thu Dec 14, 2017 12:20 am

0 Replies

3625 Views

Last post by musikai
Thu Dec 14, 2017 12:20 am
XFDF to CSV-Converter

Last post by musikai « Sat Dec 09, 2017 11:12 pm

by musikai » Sat Dec 09, 2017 11:12 pm

0 Replies

4925 Views

Last post by musikai
Sat Dec 09, 2017 11:12 pm
[Calc BASIC]Function to convert attributes and links to html

Last post by Lupp « Mon Nov 20, 2017 4:36 pm
Replies: 1
by Lupp » Sun Sep 18, 2016 12:13 am

1 Replies

7873 Views

Last post by Lupp
Mon Nov 20, 2017 4:36 pm
Rearrange Arrrays: Flip Functions (for reverse search e.g.)

Last post by Zizi64 « Sun Oct 01, 2017 1:29 pm
Replies: 2
by Lupp » Wed Sep 27, 2017 10:16 pm

2 Replies

4354 Views

Last post by Zizi64
Sun Oct 01, 2017 1:29 pm
OOBasic Date Picker dialog

Last post by DatFrame « Thu Aug 10, 2017 1:25 am
Replies: 7
by JeJe » Fri Nov 25, 2016 2:17 am

7 Replies

9818 Views

Last post by DatFrame
Thu Aug 10, 2017 1:25 am
Generate UNO documentation for Dash

Last post by sasa « Sun Jul 02, 2017 10:47 pm

by sasa » Sun Jul 02, 2017 10:47 pm

0 Replies

2470 Views

Last post by sasa
Sun Jul 02, 2017 10:47 pm
Base Copy Field or Clone Record - Example

Last post by Arineckaig « Sun Apr 23, 2017 8:01 pm
Replies: 15
by Arineckaig » Thu May 26, 2016 5:18 pm

15 Replies

41522 Views

Last post by Arineckaig
Sun Apr 23, 2017 8:01 pm
OOBasic Complex text/labelling for dialogs (updated 25/2/17)

Last post by JeJe « Sun Mar 12, 2017 4:41 am
Replies: 2
by JeJe » Fri Feb 24, 2017 1:37 am

2 Replies

4105 Views

Last post by JeJe
Sun Mar 12, 2017 4:41 am
[Calc][Writer] Batch search and replace.

Last post by Sébastien C « Sat Mar 11, 2017 11:00 pm

by Sébastien C » Sat Mar 11, 2017 11:00 pm

0 Replies

4754 Views

Last post by Sébastien C
Sat Mar 11, 2017 11:00 pm
OOBasic dialog gradient borders, lines, frames

Last post by JeJe « Sat Feb 18, 2017 12:17 am

by JeJe » Sat Feb 18, 2017 12:17 am

0 Replies

2673 Views

Last post by JeJe
Sat Feb 18, 2017 12:17 am
[Python]: Project template for macros or custom scripts

Last post by sasa « Wed Feb 08, 2017 1:17 am

by sasa » Wed Feb 08, 2017 1:17 am

0 Replies

2841 Views

Last post by sasa
Wed Feb 08, 2017 1:17 am
[Calc, Base, Basic] Logging DDE to sheet or database

Last post by Villeroy « Sun Feb 05, 2017 8:49 am

by Villeroy » Sun Feb 05, 2017 8:49 am

0 Replies

3471 Views

Last post by Villeroy
Sun Feb 05, 2017 8:49 am
[Calc] References of multiple choices.

Last post by Sébastien C « Wed Jan 11, 2017 12:39 am

by Sébastien C » Wed Jan 11, 2017 12:39 am

0 Replies

2726 Views

Last post by Sébastien C
Wed Jan 11, 2017 12:39 am
[Base] Store location and opened time in a Base table

Last post by misitu « Wed Nov 23, 2016 5:00 am

by misitu » Wed Nov 23, 2016 5:00 am

0 Replies

2900 Views

Last post by misitu
Wed Nov 23, 2016 5:00 am
OOBasic Move/Size controls on Dialog with mouse at Runtime

Last post by JeJe « Mon Nov 21, 2016 12:27 am

by JeJe » Mon Nov 21, 2016 12:27 am

0 Replies

2466 Views

Last post by JeJe
Mon Nov 21, 2016 12:27 am
[Python] Macro to extract and reconnect embedded HSQLDB

Last post by Villeroy « Tue Nov 15, 2016 2:47 pm

by Villeroy » Tue Nov 15, 2016 2:47 pm

0 Replies

8938 Views

Last post by Villeroy
Tue Nov 15, 2016 2:47 pm
[Calc][XML] Tree structures from merged cells.

Last post by Sébastien C « Sun Nov 13, 2016 9:45 pm
Replies: 1
by Sébastien C » Sun Nov 13, 2016 9:43 pm

1 Replies

4907 Views

Last post by Sébastien C
Sun Nov 13, 2016 9:45 pm
OOBasic window sizing widget

Last post by JeJe « Sun Nov 13, 2016 2:49 am

by JeJe » Sun Nov 13, 2016 2:49 am

0 Replies

2400 Views

Last post by JeJe
Sun Nov 13, 2016 2:49 am
Very simple OOBasic Color Picker (updated)

Last post by JeJe « Mon Oct 17, 2016 7:46 pm

by JeJe » Mon Oct 17, 2016 7:46 pm

0 Replies

2799 Views

Last post by JeJe
Mon Oct 17, 2016 7:46 pm
Text Twirler

Last post by Hagar Delest « Sat Jul 30, 2016 11:07 am
Replies: 20
by Villeroy » Sun Apr 06, 2008 2:45 am

20 Replies

26264 Views

Last post by Hagar Delest
Sat Jul 30, 2016 11:07 am

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