The best extensions can be acquired from the Extensions Store. You can reach it using the URL below. However, for OpenOffice application can install a dictionary, a PDF import tool, a spell checker, and optionally a clip-art gallery theme or a barcode generator.
Extensions Store: http://extensions.openoffice.org/
Access the page, then select the Most Popular to see what are the mostly used extensions for OpenOffice application.