Doing Equations, Formulas, Pi, Etc. in OpenOffice Writer and Calc, and Impress

Sooner or later, no matter who you are, you're going to have to talk about pi. Or you're going to need to talk about squaring lambda.  Or you'll need to have a+b+c divided by 2.

How do you do that in OpenOffice?

The first step is to just go to the old reliable Insert menu. Anything out of the realm of plain text, just go to the Insert menu.

Just Using the Special Characters Window

Now, if you just want a Special Character, pi or lambda or something, you can choose Insert > Special Character.

Find the one you want. If you select several you'll see them all displayed at the right side of the window and they'll all be inserted.

Then just click Insert. The character will show up.

It's a pain to scroll through all that again and again so make an AutoText entry for it. See

http://openoffice.blogs.com/openoffice/2006/03/automatic_text_.html

Using the Formulas Features

If you need something more complex, then instead, choose Insert > Object > Formula.

You get an editing window at the bottom, a box for the equation in the document, and a little shortcut window floating off to the side.

Now,  you can use the little shorcut window. Click an item above the line, then click an item below the line and that inserts some placeholder stuff for you in the editing window.

   

But frankly I find it not that helpful since just writing the formulas is reasonably easy once you memorize a few tips.

• Use the Formula Reference Tables online help list to see how to enter formulas. Basically, do it how you think it would work. Use the OpenOffice.org Math Examples online  help list to see examples. These are really good. Just press F1 while you're in the editing window; you can type the titles of these topics into the Find or Index window.

• Use ^ for exponents, as in 3^2  which would be three, squared.
• Use sqrt for square root
• Use % in front of the written version of a symbol, as in %pi

So here are a few formulas. They're pretty easy to figure out. Click each image to see a slightly larger version, if you like.

a + b / $pi

a + b over $pi

(a + b) over $pi

If You Don't Know How to Write Out a Character Like %pi or %rho

Click the Sigma icon at the top to add a special character.

You can just scroll  through and select something from the list, and insert it.

Or you can add something yourself if you don't see what you need.

Optional: Add your own symbol   

To add something you don't see, click Edit.

Find what you want, by scrolling and manipulating all the dropdowns. Then name it, and click Add, not Edit.

The new symbol will show up in the symbol list.

Click in the document to stop editing the formula.

If you want to get back into the formula to change it, double-click the box the formula is in.

Formatting the Formula

All right. You've got a great formula. But it's really small. Or you'd like a different font. You change these by selecting the formula in the editing window and click on the Format menu.

Choosing Fonts gives you this window. You get to choose the font by the type: variables, etc. Click and hold down on the Modify button to change any font.

Select the font in this window, then click OK all the way back out of the windows.

That's About It

Insert > Object > Formula. Type what you want and use the online help and the brief tips I gave you.

Click in the document when you're done, and double-click the equation box to start editing again.

To format, select the text in the editing box and find the Format menu.

To add a symbol you don't know, click the Epsilon icon at the top of the window and select one--or click Edit to create your own.

Doing All This in Impress

I'm using 2.1 in February 2007 and it works just fine.

Click in a bulleted item and choose Insert > Object > Formula.

You can also paste the formula object from Writer to Impress. Don't paste it into a bullet in this case; just paste it into a layout with no bullets.

Double-click to edit, as usual.

Double-click the formula object to get into edit mode. Use the Format menu or make other changes.

---

---

Comments

[Fred Juan DIAZ]

Did you know that in OOoWriter it's possible to write directly your formulas just as in LaTeX, without opening a formula window ?

I discovered that at random some years ago when i accidently let my mouse selectionning an area an I sent Crtl M on it, then I got a formula full of ?? but I discovered that it worked !

1. Create a shortcut Ctrl M in tools customize keyboard insert formula (the second which is under) modify Ok

2. Type your code directly in OooWriter ex : 2 over 3

3. Select your code in the text

4. Press Ctrl M and enjoy !

Friendly

Fred Juan DIAZ
diaz_frederic "at" openoffice.org

[Solveig]

Hi Fred,

Great tip! I have definitely encountered a few LaTeX fans and they will be happy to hear this. Thanks! I'll blog on it directly too.

[Jessena]

I accidently closed the little shortcut window and when i reopen the insert formula function and now it's not appearing anymore...
How can i reopen the little shortcut window?

[Fred Juan Diaz]

Hi
While you're editing a formula, go to View > Selection, the little window with buttons should appear again. Hope it's what you'r looking for.

[Jim Smith]

This is nice, but what would be far more useful to most users would be a way to do a find and replace on manual line breaks. For example, to find all manual line breaks and replace them with two line breaks to make all text double-spaced.

Or, to replace all line breaks with special text, such as xltc, so you could later replace that text with hard or soft line line breaks.

The failure of this function to be in OO, is a major shortcoming. Fortunately, on a Mac, I can do it in the TextEdit application. If it gets much better, we won't need OO anyway.

[nes]

great post!

usefull...

[Bindu Garg]

Hi
I am getting difficulty to handle superscript,subscript and making characters normal again. it is very time consuming,if i do it through mouse.so i want to use shortcuts for this......So plz tell me shortcuts for these.