Apache OpenOffice Community Forum - Code Snippets

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 forum is not for asking questions about writing your own macros.

Forum

Topics

Posts

Last post

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

Total redirects: 28427
Macro Repository
Collection of macros or both developers and end users
Total redirects: 30662

Total redirects: 30662

New Topic

157 topics

Announcements

Replies

Views

Last post

Apache OpenOffice 4.1.12 released

Last post by robleyd « Thu May 05, 2022 2:15 am
Posted in Announcements

by robleyd » Thu May 05, 2022 2:15 am » in Announcements

0 Replies

1846 Views

Last post by robleyd
Thu May 05, 2022 2:15 am

Topics

Replies

Views

Last post

Delphi: Dual unit to use Excel or OOo Calc transparently

Last post by DavEar « Thu May 05, 2022 10:30 am
Replies: 21
by SergioHC » Tue Feb 07, 2012 2:19 pm

21 Replies

43530 Views

Last post by DavEar
Thu May 05, 2022 10:30 am
StarBasic Sort Algorithms

Last post by MrProgrammer « Sat Apr 23, 2022 6:37 pm

by MrProgrammer » Sat Apr 23, 2022 6:37 pm

0 Replies

646 Views

Last post by MrProgrammer
Sat Apr 23, 2022 6:37 pm
Proof of concept: Generate QR code in Calc

Last post by MrProgrammer « Sat Jan 15, 2022 5:21 am

by MrProgrammer » Sat Jan 15, 2022 5:21 am

0 Replies

1712 Views

Last post by MrProgrammer
Sat Jan 15, 2022 5:21 am
Remove duplicate rows in a texttable

Last post by JeJe « Mon Nov 22, 2021 2:08 pm
Replies: 2
by JeJe » Sat Nov 20, 2021 2:40 am

2 Replies

2883 Views

Last post by JeJe
Mon Nov 22, 2021 2:08 pm
detach / reAttach the template

Last post by Lupp « Fri Nov 12, 2021 2:27 pm

by Lupp » Fri Nov 12, 2021 2:27 pm

0 Replies

1341 Views

Last post by Lupp
Fri Nov 12, 2021 2:27 pm
Calc: Handling of Outline Groups

Last post by Lupp « Wed Oct 20, 2021 2:11 pm

by Lupp » Wed Oct 20, 2021 2:11 pm

0 Replies

2429 Views

Last post by Lupp
Wed Oct 20, 2021 2:11 pm
Document with list of Folder sizes in Windows only

Last post by JeJe « Sun Sep 26, 2021 3:41 pm

by JeJe » Sun Sep 26, 2021 3:41 pm

0 Replies

2197 Views

Last post by JeJe
Sun Sep 26, 2021 3:41 pm
Writer Titlebar

Last post by JeJe « Sun Sep 05, 2021 1:56 am

by JeJe » Sun Sep 05, 2021 1:56 am

0 Replies

2222 Views

Last post by JeJe
Sun Sep 05, 2021 1:56 am
Extended file information (full path) in TitleBar

Last post by karolus « Wed Sep 01, 2021 11:14 am
Replies: 5
by Lupp » Fri Aug 27, 2021 10:06 pm

5 Replies

2571 Views

Last post by karolus
Wed Sep 01, 2021 11:14 am
Calc User Sort/Fill Lists

Last post by eeigor « Thu Jun 24, 2021 5:52 pm

by eeigor » Thu Jun 24, 2021 5:52 pm

0 Replies

2617 Views

Last post by eeigor
Thu Jun 24, 2021 5:52 pm
How to get UTC DateTime in a spreadsheet or in Basic

Last post by karolus « Sun Apr 11, 2021 7:56 am
Replies: 20
by Lupp » Mon Mar 29, 2021 4:09 pm

20 Replies

22625 Views

Last post by karolus
Sun Apr 11, 2021 7:56 am
Writer - insert tabs with the keyboard

Last post by JeJe « Mon Mar 29, 2021 3:28 pm

by JeJe » Mon Mar 29, 2021 3:28 pm

0 Replies

1810 Views

Last post by JeJe
Mon Mar 29, 2021 3:28 pm
[BASIC] Resizable dialog

Last post by JeJe « Sat Mar 13, 2021 5:21 pm
Replies: 19
by roland65 » Mon Mar 19, 2018 10:48 am

19 Replies

13400 Views

Last post by JeJe
Sat Mar 13, 2021 5:21 pm
AWT Dialog-clone

Last post by JeJe « Sat Mar 13, 2021 5:16 pm

by JeJe » Sat Mar 13, 2021 5:16 pm

0 Replies

1940 Views

Last post by JeJe
Sat Mar 13, 2021 5:16 pm
OOBasic timer without a do loop

Last post by JeJe « Tue Mar 09, 2021 1:47 pm
Replies: 5
by JeJe » Mon Mar 08, 2021 4:03 pm

5 Replies

2625 Views

Last post by JeJe
Tue Mar 09, 2021 1:47 pm
Moving Columns or Rows in Writer Texttable

Last post by JeJe « Fri Feb 26, 2021 9:43 pm

by JeJe » Fri Feb 26, 2021 9:43 pm

0 Replies

1615 Views

Last post by JeJe
Fri Feb 26, 2021 9:43 pm
Window Manager for Writer

Last post by AndresSolar « Sat Feb 13, 2021 8:11 pm
Replies: 2
by JeJe » Sun Aug 16, 2020 6:14 pm

2 Replies

2593 Views

Last post by AndresSolar
Sat Feb 13, 2021 8:11 pm
Box Drawing Characters

Last post by JeJe « Fri Jan 29, 2021 10:46 pm
Replies: 3
by JeJe » Sun Nov 29, 2020 12:24 am

3 Replies

2582 Views

Last post by JeJe
Fri Jan 29, 2021 10:46 pm
Convert text in Writer to text drawing object

Last post by JeJe « Tue Jan 19, 2021 1:18 am

by JeJe » Tue Jan 19, 2021 1:18 am

0 Replies

1725 Views

Last post by JeJe
Tue Jan 19, 2021 1:18 am
Scroll a specific cell to the top-left corner of the sheet

Last post by Lupp « Mon Jan 04, 2021 4:31 pm
Replies: 2
by Lupp » Sun Jan 03, 2021 11:37 pm

2 Replies

2098 Views

Last post by Lupp
Mon Jan 04, 2021 4:31 pm
Unicode Character entry in Writer

Last post by JeJe « Thu Nov 26, 2020 2:28 pm

by JeJe » Thu Nov 26, 2020 2:28 pm

0 Replies

1598 Views

Last post by JeJe
Thu Nov 26, 2020 2:28 pm
BASIC Long color to HTML hex color with alpha

Last post by rickberon « Wed Oct 21, 2020 8:13 am
Replies: 5
by Evgeniy » Sat Jan 11, 2020 4:21 pm

5 Replies

4376 Views

Last post by rickberon
Wed Oct 21, 2020 8:13 am
Determine csv import filter options

Last post by ms777 « Sat Oct 17, 2020 6:51 pm

by ms777 » Sat Oct 17, 2020 6:51 pm

0 Replies

1636 Views

Last post by ms777
Sat Oct 17, 2020 6:51 pm
OO Writer WordCount (excluding non-dictionary words)

Last post by JeJe « Wed Sep 16, 2020 12:34 am
Replies: 5
by JeJe » Sat Sep 12, 2020 4:33 pm

5 Replies

3571 Views

Last post by JeJe
Wed Sep 16, 2020 12:34 am
Writer Footnotes/Endnotes in separate windows

Last post by JeJe « Tue Sep 08, 2020 12:09 am

by JeJe » Tue Sep 08, 2020 12:09 am

0 Replies

32151 Views

Last post by JeJe
Tue Sep 08, 2020 12:09 am
Main Window Outliner for Writer

Last post by JeJe « Wed Aug 05, 2020 6:24 pm

by JeJe » Wed Aug 05, 2020 6:24 pm

0 Replies

2148 Views

Last post by JeJe
Wed Aug 05, 2020 6:24 pm
OpenOffice BASIC: Create an independent copy of an array.

Last post by Lupp « Thu Jul 16, 2020 1:35 pm
Replies: 7
by Lupp » Thu May 17, 2018 10:07 pm

7 Replies

8485 Views

Last post by Lupp
Thu Jul 16, 2020 1:35 pm
OOBasic Dialog Resizing button

Last post by JeJe « Thu Jun 11, 2020 10:20 pm

by JeJe » Thu Jun 11, 2020 10:20 pm

0 Replies

2207 Views

Last post by JeJe
Thu Jun 11, 2020 10:20 pm
Creating a simple extension

Last post by JeJe « Thu Jun 04, 2020 12:45 am

by JeJe » Thu Jun 04, 2020 12:45 am

0 Replies

2064 Views

Last post by JeJe
Thu Jun 04, 2020 12:45 am
FreeHSQLDB v.0.3

Last post by Villeroy « Fri May 22, 2020 12:39 pm
Replies: 1
by Villeroy » Sat Jun 06, 2015 5:43 pm

1 Replies

23307 Views

Last post by Villeroy
Fri May 22, 2020 12:39 pm
Convert ASCII text files by deleting extra paragraph breaks

Last post by John_Ha « Thu May 07, 2020 3:14 pm
Replies: 13
by JohnV » Wed Jan 05, 2011 6:48 pm

13 Replies

22341 Views

Last post by John_Ha
Thu May 07, 2020 3:14 pm
Scroll to Writer Page

Last post by JeJe « Thu Apr 09, 2020 9:18 pm

by JeJe » Thu Apr 09, 2020 9:18 pm

0 Replies

2672 Views

Last post by JeJe
Thu Apr 09, 2020 9:18 pm
[Calc] More than 3 conditional formats

Last post by Villeroy « Sun Mar 29, 2020 9:39 am
Replies: 21
by Villeroy » Fri May 23, 2008 12:38 am

21 Replies

67954 Views

Last post by Villeroy
Sun Mar 29, 2020 9:39 am
Number or string representation of a Writer TextRange

Last post by JeJe « Fri Mar 20, 2020 6:27 pm
Replies: 5
by JeJe » Tue Mar 03, 2020 11:00 pm

5 Replies

3611 Views

Last post by JeJe
Fri Mar 20, 2020 6:27 pm
Alternative script organizer for Python macro

Last post by hubert lambert « Wed Feb 19, 2020 11:27 am
Replies: 27
by hanya » Sun Jul 22, 2012 7:27 pm

27 Replies

76752 Views

Last post by hubert lambert
Wed Feb 19, 2020 11:27 am
[Base, Python] Tiny Macro Refreshing Forms, List/Combo Boxes

Last post by Villeroy « Sun Feb 02, 2020 9:08 pm
Replies: 1
by Villeroy » Sat May 20, 2017 3:10 pm

1 Replies

5648 Views

Last post by Villeroy
Sun Feb 02, 2020 9:08 pm
Colored square icon for toolbar or menu item

Last post by JeJe « Sun Jan 19, 2020 9:02 pm
Replies: 6
by JeJe » Wed Jan 15, 2020 12:40 pm

6 Replies

4857 Views

Last post by JeJe
Sun Jan 19, 2020 9:02 pm
Each one HTML exporter support image cropping (clip)

Last post by Evgeniy « Sun Jan 19, 2020 12:17 pm

by Evgeniy » Sun Jan 19, 2020 12:17 pm

0 Replies

1736 Views

Last post by Evgeniy
Sun Jan 19, 2020 12:17 pm
OpenOffice BASIC API viewer

Last post by Zizi64 « Sun Jan 19, 2020 11:23 am
Replies: 5
by Evgeniy » Sat Jan 18, 2020 1:03 pm

5 Replies

2955 Views

Last post by Zizi64
Sun Jan 19, 2020 11:23 am
Writer Full Screen popup Menubar clone

Last post by JeJe « Sat Jan 18, 2020 11:21 pm

by JeJe » Sat Jan 18, 2020 11:21 pm

0 Replies

1641 Views

Last post by JeJe
Sat Jan 18, 2020 11:21 pm
Menubar button with popup menu or dropdown in OOBasic

Last post by JeJe « Wed Jan 15, 2020 12:47 am
Replies: 2
by JeJe » Tue Jan 14, 2020 2:49 am

2 Replies

2308 Views

Last post by JeJe
Wed Jan 15, 2020 12:47 am
Run macro other than the first in OpenOffice

Last post by musikai « Sat Dec 21, 2019 1:50 pm
Replies: 4
by JeJe » Fri Dec 20, 2019 5:15 pm

4 Replies

2916 Views

Last post by musikai
Sat Dec 21, 2019 1:50 pm
Alternative Document Properties Extension

Last post by JeJe « Mon Dec 02, 2019 3:58 pm

by JeJe » Mon Dec 02, 2019 3:58 pm

0 Replies

2107 Views

Last post by JeJe
Mon Dec 02, 2019 3:58 pm
Draw: create custom pagenumbers

Last post by musikai « Thu Sep 19, 2019 1:21 pm

by musikai » Thu Sep 19, 2019 1:21 pm

0 Replies

2151 Views

Last post by musikai
Thu Sep 19, 2019 1:21 pm
Colorpicker, RGB, RGBtoCMYK , CMYKtoRGB

Last post by musikai « Mon Sep 09, 2019 8:29 pm

by musikai » Mon Sep 09, 2019 8:29 pm

0 Replies

1992 Views

Last post by musikai
Mon Sep 09, 2019 8:29 pm
PDF-List (Calc),Hyperlinks,pdftk,read-write metadata, merge

Last post by musikai « Thu Sep 05, 2019 9:40 pm
Replies: 2
by musikai » Thu Sep 05, 2019 6:39 pm

2 Replies

2395 Views

Last post by musikai
Thu Sep 05, 2019 9:40 pm
Extract content.xml into same folder and open in default app

Last post by John_Ha « Wed Aug 21, 2019 2:12 pm
Replies: 8
by musikai » Tue Aug 20, 2019 12:34 pm

8 Replies

4200 Views

Last post by John_Ha
Wed Aug 21, 2019 2:12 pm
Copy and paste a text string TO or FROM the clipboard.

Last post by DavidHMcCracken « Fri Aug 16, 2019 6:56 pm
Replies: 1
by Sébastien C » Sun May 13, 2018 5:52 pm

1 Replies

5407 Views

Last post by DavidHMcCracken
Fri Aug 16, 2019 6:56 pm
Database procedures and callable Statements

Last post by aay « Tue Aug 13, 2019 1:54 pm
Replies: 1
by rudolfo » Fri May 20, 2011 2:09 am

1 Replies

13358 Views

Last post by aay
Tue Aug 13, 2019 1:54 pm
[Python] Array Sort add-in function.

Last post by mikekaganski « Mon Jul 29, 2019 3:53 am
Replies: 17
by Charlie Young » Sun Oct 21, 2012 8:16 pm

17 Replies

26656 Views

Last post by mikekaganski
Mon Jul 29, 2019 3:53 am

New Topic

157 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