Operation Manual

2) Select the markup language.
3) Go to Insert > Object on the menu bar and select Formula, or click on the Formula icon
on the Standard toolbar to create a formula from the selected markup language.
Note
If the Formula icon is not displayed on the Standard toolbar, then right-click in an
empty area on the toolbar, select Visible Buttons from the context menu, then select
Formula from the available options.
Formulas in Calc, Draw, and Impress
In Calc, Draw, and Impress, formulas are inserted as OLE objects without any background (area
fill) or borders. See the Math Guide for more information.
Each formula object is inserted into a spreadsheet, drawing, or slide as follows:
• In Calc, formulas are inserted into a selected cell in a spreadsheet with no style assigned to
the formula object.
• In Draw and Impress, formulas are inserted into a central position on a drawing or slide
and, by default, are assigned the drawing object style Object with no fill and no line. For
more information on how to modify or assign drawing object styles, see the Draw Guide or
the Impress Guide.
Anchoring formulas
Calc
A formula object can be anchored into a spreadsheet as To Page (default setting), or as To Cell.
To change the anchoring type of formulas in a Calc spreadsheet:
1) Select the formula object in the spreadsheet.
2) Right-click on the formula and select Anchor > To Page or To Cell from the context menu
3) Alternatively, go to Format > Anchor on the menu bar and select To Page or To Cell.
Draw and Impress
When a formula is inserted into a drawing or slide, it is inserted as a floating OLE object and is not
anchored to any particular position in a drawing or slide.
Formula object properties
Formula objects in Calc, Draw, and Impress can be modified just like any other object that has
been placed in a spreadsheet, drawing, or presentation, with the exception of formula object size
and changing the format of any text within a formula. For more information on how to change
object properties, see the Calc Guide, Draw Guide, and Impress Guide. For more information on
formula object size and formatting formula text, see the Math Guide.
The following points will help you select which dialog to use if you want to change the properties of
formula objects.
• For formula backgrounds, use the various options in the pages of the Area dialog.
• For formula borders, use the various options in the Line dialog. Note that formula borders
are separate from cell borders in a Calc spreadsheet.
288 | Getting Started with LibreOffice 5.0