OpenOffice Calc, the spreadsheet program offered for free by openoffice.org, lets you perform calculations on the data you enter into the spreadsheet.
Apache OpenOffice Calc Tutorial – Len Function | Apache OpenOffice 4 Calc
You can use OpenOffice Calc formulas for simple arithmetic tasks, such as addition and subtraction, as well as for more complex calculations, such as salary deductions or averaging a student's test scores.
In addition, if you change the data, Calc automatically recalculates the answer without you having to reenter the formula.
The following step-by-step example shows how to create and use a basic formula in OpenOffice Calc.