spreadsheets

QueryConnector

Allows you to attach a query to a spreadsheet OpenOffice Calc, saving the connection information on the spreadsheet itself for future data updates. It does not requires OpenOffice Base or registering a file *.odb to connect the query. This extension is thinked for those people that need frequently to extract many data from different databases using complicated queries and for those ones that cannot (or don't want) register *.odb files inside the OpenOffice installation.

Supported languages: english, italian.

Clear spaces cells

[En] Clear spaces in the cells containts strings. If the cell containt only spaces, the cell will be empty.
[Es] Limpia de espacios en las celdas que contienen cadenas. Si la celda solo contiene espacios, la deja vacía.

Validator

Validator is an OpenOffice.org Calc extension that validates cells based on selected rules.

More information: http://wiki.services.openoffice.org/wiki/Validator_Extension

WatchWindow

With Watch Window Extension, you can add a Watch Window, which keeps the value of the monitored cell on the screen, no matter where the change is made.

WatchWindow is an OpenOffice.org Calc extension.

More information: http://wiki.services.openoffice.org/wiki/WatchWindow_Extension

3-Period Balance Sheet Template for Open Office Calc

The Balance Sheet Template for Open Office is an Open Office template (Calc) for practitioners who wish to perform their own valuation and analysis but don't wish to invest the significant time necessary to create the financial statements.

It is designed to accommodate three periods of data, which can be entered from a firm's 10-K or 10-Q report (10-K and 10-Q reports are publicly available reports detailing a company's financial position). The spreadsheet comes pre-configured to accept the most popular asset and liability categories, and is easily expandable by anyone with a basic knowledge of Open Office Calc.

A common-size balance sheet is automatically calculated based on the input from the 10-K and 10-Q reports. (Common-size balance sheets are used to show the percentage of total assets and liabilities represented by each item in the balance sheet.)

Date and number fields may be re-formatted by the user (using Open Office Calc's built-in formatting capabilities) to accommodate non-US conventions.

The Balance Sheet Template for Open Office is an excellent tool to use as a basis for business valuation.

This Open Office template was developed by a CFA charterholder.

Thousands Separator

Add the missing thousands separator button to OpenOffice.org Calc toolbar.

One of the UI element that is missing in Calc compare to Excel 2003 is the thousands separator button on the toolbar. The button will format the numbers in the currently selected cell(s) using a predefined (accounting) format. Though Calc users can do the same using the menu Format > Cell but the converted Excel users usually miss the convenience and ask for the feature.

Gantt Chart

The Vertex42™ Gantt Chart template lets you easily create a project timeline. It uses conditional formatting to create the gantt chart based on the dates entered in the spreadsheet.

CalcEasyToolbar

This extention is strong recommended for all calc users, it allow remove/insert column easier eventhough selected range is merged.
It work on new openoffice.org calc. Tested version included 2.3.1 and 3.0.
Features:

1. Insert new toolbar which allow user add/remove columns or rows.
2. Allow user to perform mass vertical or horizontal merge easily for range of cell.

Savings Calculator

The Vertex42™ Savings Calculator is a simple spreadsheet that helps you estimate your future savings based on your initial investment, expected annual interest rate, and optional periodic deposits.

Amortization Schedule

The Vertex42™ Amortization Schedule spreadsheet creates a payment schedule for a fixed-rate loan, with optional extra payments.