Quick Links

If you’re working in a LibreOffice Writer document, and need to do some simple calculations, instead of opening the Windows Calculator, you can perform the calculations directly in Writer.

We’ll show you how to calculate simple equations in LibreOffice Writer using the Formula bar and the Calculate function. You can also use pre-defined functions in your equations, such as mean (average), square root, and power.

Performing Simple Calculations

The Formula bar in LibreOffice Writer allows you to perform simple calculations while working in a text document. To enter an equation to calculate, first place the cursor where you want to insert the result in your document. Then, press F2 to access the Formula bar. Type an equals sign (=) and the equation you want to calculate with no spaces. Press Enter.

01_entering_equation_on_formula_bar

The result of your calculation is inserted at the cursor and the Formula bar is hidden again. The result is highlighted in gray because it is a field.

02_answer_inserted

Calculating Complex Formulas Using Predefined Functions

The Formula bar includes predefined functions you can use in your calculations. For example, to calculate the mean, or average, of a set of numbers, press F2 to access the Formula bar and then click the “fx” button on the bar. Then, select Statistical Functions > Mean from the popup menu.

03_selecting_mean

The function name is inserted into the Formula bar with a space after it. Note that the cursor might not be in the Formula bar after inserting the function. If not, click in the empty space to the right of the function name on the Formula bar to put the cursor at the end of the equation so far. Then, enter the numbers for which you want to calculate the mean, separated by vertical bars. and press Enter.

04_entering_mean_function

The result of your function calculation is inserted at the cursor and the Formula bar is hidden again. Again, the result is highlighted in gray because it is a field.

05_mean_result

The online help for LibreOffice Writer provides help on how to enter the values for each type of function available on the Formula bar.

Viewing the Formula

As we’ve said, when you calculate an equation using the Formula bar, the result that displays is a field, showing the field value by default. You can easily view the equation in the field by switching to viewing field names. To do this, press Ctrl+F9, or select View > Field Names. This is handy if you’ve calculated an equation using the Formula bar in your document in the past and don’t remember what the equation was.

05a_showing_field_name

To switch back to viewing the result, press Ctrl+F9 again, or select View > Field Names again.

Changing the Formula

Once you’ve calculated an equation or function using one of the methods described above, you can change it and get a different result. As we mentioned, the answer is inserted into your document as a field, and you can edit this field. To do so, simply double-click on the result highlighted in gray.

05b_double_clicking_on_result

The Edit Fields dialog box displays. The Type of field is Insert Formula and the formula itself is in the Formula box. You can edit the formula in the Formula box and then click “OK” when you’re done making changes.

05c_changing_formula

The result is updated to reflect the changes.

05d_changed_result

Calculating a Formula Already Existing in Your Document

If you already have an existing equation in your LibreOffice Writer document, you can easily calculate the equation and insert the result without using the Formula bar. Select the equation you want to calculate.

06_selected_equation

Select Tools > Calculate, or press Ctrl+Plus sign (+).

07_selecting_tools_calculate

Put the cursor where you want to insert the answer and press Ctrl+V to paste the result.

08_answer_inserted_for_existing_equation

When calculating existing equations using this last method, the result is not a field and is not linked to the equation. If you change the equation, you must select and calculate it again and paste the result again.