Open Office
Some advices

Home page:

User-defined files locations:
Dictionaries: ~/.openoffice.org2/user/wordbook/standard.dic
or (Mac): /Users/ulf/Library/'Application Support'/
Colours: ~/.openoffice.org2/user/config/standard.soc
Configuring: ???

/home/ulf/.rhopenoffice1.1/share är tom (alla subdirectories)
/home/ulf/.rhopenoffice1.1/program/ är tom (alla subdirectories)

How to open the formula (equation) editor window
Click on the black bar at the bottom of the page

How make pdf in landscape
Somtimes Print - print pdf gives slides rotated 90º (and therefore not fitting pages).
It seems that
File - Export as … pdf works better (no special settings needed)
Print hidden slides is an option

New colours
UGreen: 180/255/150
UMagenta: 255/180/255

Change colours: Make a rectangle - Select Area - Here you can change custom colors

Page 28.5 x 21.5 cm, no margin
Grid 6.92/4.91

Keyboard commands

Insert Graphics under Document (Presentation)
Paragraph under Document (Presentation) or Format:Paragraph under Format (Writer)

Edit - changes - record / show / accept; etc.

Transpose table in a spreadsheet
  1. Select the area where the transposed table is intended to be (you can find the size by paste-special - transpose).
  2. In the lower right corner write =transpose() and mark the whole original table
  3. Press shift-control-enter

Use landscape within a portrait document

  1. Create a page style that use landscape page orientation.
    To change the orientation of the current page only, select a page style where the Next Style option is set to "Default" (Organizer tab).
    To change the orientation of the current and subsequent pages, select a page style where the Next Style option is set to the name of the page style (Organizer tab).
  2. Click into the first paragraph where you want to change the page orientation.
  3. Choose Format - Paragraph.
  4. Click theText Flow tab.
  5. Under Breaks, enable Insert. Then enable With Page Style. Select a page style that uses the landscape page orientation.
    To change the orientation of the current page only, select a page style where the Next Style option is set to "Default".
    To change the orientation of the current and subsequent pages, select a page style where the Next Style option is set to the name of the page style.
  6. If you want to change the page orientation later on in the document, repeat these steps for the first paragraph on the page.

To change from superscript to normal text:
Tools -Footnotes - Endnotes: Change Text area to definition (e.d.)


Not on a separate page:

  1. Mark whole document.

  2. Format - Section

  3. Select: Options

  4. Select: Footnotes/Endnotes tab

  5. Check: Endnotes: Collect at end of section

Get rid of the separator line for endnotes

  1. Find the Page style for the endnotes (typically Endnote) from Tools - Footnotes - Endnotes - Styles - Page

  2. Select: Format - Styles - Catalog

  3. Select Page styles

  4. Select the correct style

  5. Select modify

  6. Go to the footnotes tab

  7. Set the length to 0%

How to insert error bars in a scatter plot
First create the plot without error bars.
For each set of points:
Right click on one of the points and select Insert Y Error bars
Select Cell Range and Same values for both
Click on picture for Select Data Range at the end of Positve (+)
Select the cells for error bars in the spread sheet.

Making Lili-style bar diagrams
For first set, use one colour (e.g. violet), Space = 30%, Overlap = 0%.
For the second set, use secondary axis, another colour (e.g. yellow), Space = 150%, Overlap = 0%.
Ensure that the two axes have the same scale, ticks are missing or inside and the numbers are not seen.

How to create numbered formulas:
write fn first in a line and press F3 (Patrik)

How to use cell contents to index other cells

index(f1:f100,g2) gives the element number g2 in the vector f1:f100.

ttest - makes a student t-test whether the averages of two series are different:

TTEST(Data_1; Data_2; Mode; Type)

Data_1 is the dependent array or range of data for the first record.

Data_2 is the dependent array or range of data for the second record.

Mode = 1 calculates the one-tailed test, Mode = 2 the two- tailed test.

Type is the kind of t-test to perform. Type 1 means paired. Type 2 means two samples, equal variance (homoscedastic). Type 3 means two samples, unequal variance (heteroscedastic).

tinv - gives the value of the t-distribution - TINV(Number; degrees_freedom)  Number is the probability associated with the two-tailed t-distribution (i.e. twice the number normally given to the tables).
tdist - Returns the t-distribution


forecast(value;y-data;x-data) -(predict a value by linear regression
rsq returns the square of Pearson correlation coefficient
pearson - Returns the Pearson product moment correlation coefficient r.

PROB(Data; Probability; Start; End) - Returns the probability that values in a range are between two limits. If there is no End value, this function calculates the probability based on the principle that the Data values are equal to the value of Start.



avedev - Returns the average of the absolute deviations of data points from their mean.
Mode - Returns the most common value in a data set.

chiinv - Returns the inverse of the one-tailed probability of the chi-squared distribution

finv- Returns the inverse of the F probability distribution

fdist - Calculates the values of an F distribution.

GAUSS - Returns the standard normal cumulative distribution.
normsinv - Returns the inverse of the normal cumulative distribution

normdist - Returns the density function or the normal cumulative distribution.

standardize(number;mean;stdev) - converts a random variable to a normalized value

confidence(alpha; stdev; size) - returns the (1-alpha) confidence interval for a normal distribution

linest - gives a full linear regression analysis (use function wizard)

frequency bins data: frequency(data;bins) - construct first bins in a set of columns. You seems to need to use the function wizard ((f(x)) to get it right. Cross array.

B returns the probability of a binomial distribution (b(trials, prob, lower_limit, upper_limit)
BINOMDIST - Returns the individual term binomial distribution probability binomdist(#success, trials, probab, 0 = single event; 1 0 cumulative)

Large(a1:a100,3) givest the third largest value in a range.

Add dictionaries

  1. en_UK, en_GB, and sv_SE can be found at Open office web site (and Mozilla). Download these and unzip them.

  2. Put them in OpenOffice0.2/share/dict/ooo

  3. Edit the file dictonary.lst to add these dictionaries.

  4. Restart the program

  5. Go in to Toos/options/Language/Writing aids

  6. Click on Edit; Find the language; and check the boxes.

If you want to add more spell check languages to your open office this is how:

Download more languages either from
Dictionary DownLoad Page
or swedish and english_GB is already on my machine balder in /temp2/kristina

Copy them into you open office directory
unzip them

Edit the file
I think it is quite straight forward how to add the names of your new language files
into this file.

Open openoffice and go in under /tools/options/language settings/language/writing aids.
Click on edit belonging to available language modules and chose a new language.
Mark the boxes and close.

Good Luck!

Problem with strange fonts

Subject: fontlsg
Date: Mon, 28 Feb 2000 17:25:22 +0100
From: Malek Khan <>
CC: jonna, kristina

Emma har stött på vissa problem när man kör StarOffice via nätet.
Fonterna starmath och starbats finns ej på X-servern för SGI och därför
blir utseendet på skärmen fel (framförallt i ekvationseditorn). På
printern finns inga problem. Ett litet hack för att fixa detta följer.
Har många problem kan man installera fonterna "systemwide" - KUL.

Emma gör så här:

På oin.
> mkdir ~/myfonts
> cd /opt/Office51/fonts/75dpi
> cp s* ~/myfonts

På idun
> cd ~/myfonts
> uncompress *.Z
> mkfontdir ~/myfonts
> xset +fp ~/myfonts

Nu har du fått din X-server att använda dig av fonterna i "~/myfonts".
Det är möjligt att du måste köra xset kommandot varje gång du loggar in.
Stör det dig kan du i så fall lägga in det i ditt login script

Happy fonting