How To Calculate a File With Open Office
Open Office is a free, open source productivity office suite comparable to Microsoft Office. Open Office contains a word processor (Writer), spreadsheet (Calc), database (Base), graphics (Draw) and presentation (Impress) applications. The applications are integrated and include familiar functions as those in the MS Office programs such as document properties. Additional functions were also added such as inserting a calculating table or mini-spreadsheet in a Writer document.
Other People Are Reading
Instructions
-
Document Statistics
-
1
Select "Properties" under "File" in the top menu bar of your open document. The "General" tab will provide an overview of the file size and format.
-
2
Click the "Statistics" tab and then click the "Update" button to review the unique document information such as word count, number of paragraphs and number of characters. Click the "OK" button to exit the Properties dialog box.
-
-
3
Click "Print Layout" under "View" in the top menu bar. Look at the bottom of the screen in the status bar for total number of pages in the document.
Calculation Within a Table
-
4
Insert a table and type information in each cell. To insert a calculation (like those used in a spreadsheet), click the desired cell and press the "F2" key.
-
5
Type the formula function in the field, such as "=sum" or "=". Activate the available function menu by clicking "f(x)" to the right of the formula field and selecting your desired formula function.
-
6
Select cells containing the values to be calculated; if applicable, type additional calculation information for your formula. For example, to calculate the average of two cells: "=sum<A1:A2>/2". Click the green check mark to save your formula.
-
1
Tips & Warnings
Formulas in Writer tables are not automatically updated (as they are in spreadsheet applications such as Calc) so deleted and inserted columns and rows may affect calculations.
