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

[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

46277 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

1691 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

4888 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

2411 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

6004 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

5880 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

2013 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

2601 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

2944 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

2666 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

26326 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

5533 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

5373 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

2222 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

4593 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

4819 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

2471 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

9910 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

2438 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

2615 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

3261 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

4520 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

7474 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

3920 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

9075 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

2210 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

38374 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

3776 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

4410 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

2419 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

2497 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

3161 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

2469 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

2488 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

2202 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

8241 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

4460 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

2142 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

2517 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

24274 Views

Last post by Hagar Delest
Sat Jul 30, 2016 11:07 am
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

3372 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

8736 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

2455 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

39921 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

2800 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

20736 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

16928 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

14195 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

15435 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

40236 Views

Last post by Villeroy
Tue Feb 17, 2015 12:23 am

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