OpenOffice.org HowTo:

Formula Command Reference

Formula Command Reference
0.4
First edition: 05 June 2003
First English edition: 05 June 2003

Contents

Table of Contents

Contents	2

Overview	3

Copyright and trademark information	3

Feedback	3

Acknowledgments	3

Modifications and updates	4

Command Reference	5

Commands	5

Unary / Binary Operators	5

Relational Operators	6

Set Operations	7

Functions	8

Operators	9

Attributes	10

Others	12

Brackets	13

Formats	14

Characters	15

Greek	15

Special	15

Overview

OpenOffice.org's burgeoning popularity has increased the need for a comprehensive set of HowTos to aid users.

Copyright and trademark information

© Copyright 2003 Fred Saalbach.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Lesser General Public License, Version 2.1. All trademarks within this guide belong to legitimate owners.

Feedback

Please direct any comments or suggestions about this document to:
dev@documentation.openoffice.org

Acknowledgments

This document was inspired by the de.OpenOffice.org German language Formula How-To.

Layout is in accordance with the OpenOffice.org Style Guide for U.S. Documentation

Modifications and updates

This is the first edition. Place any modifications and updates in this section.

Fred Saalbach 27 Mar 2004

Document Revision	Date	Description of Change
0.1	06/05/03	Initial edition issued for comment
0.2	03/27/04	Added table “Commands, attributes – continued.” showing font colors, and commands switching from serif to sans serif fonts. Fred Saalbach
0.3	03/31/04	Minor corrections to additions to above. Ian Laurenson
0.4	04/04/04	Revised table of contents. Fred Saalbach

Command Reference

Commands

Unary / Binary Operators

Operation	Command	Display
+sign	+1	
-sign	-1	
+/- sign	+-1	
-/+ sign	neg 1	
Boolean not	neg a	
Addition +	a + b	
Multiplication dot	a cdot b	
Multiplication (X)	a times b	
Multiplication (*)	a * b	
Boolean and	a and b	
Subtraction (-)	a - b	
Division (fraction)	a over b	
Division (operand)	a div b	
Division (slash)	a / b	
Boolean or	a or b	
Concatenate	a circ b	

Table 1Commands, unary & binary.Relations

Relational Operators

Operation	Command	Display
Is equal	a = b	
Is not equal	a <> b	
Approximately	a approx 2	
Divides	a divides b	
Does not divide	a ndivides b	
Less than	a < 2	
Greater than	a > 2	
Similar to or equal	a simeq b	
Parallel	a parallel b	
Orthogonal to	a ortho b	
Less than or equal to	a leslant b	
Greater than or equal to	a geslant b	
Similar to	a sim b	
Congruent	a equiv b	
Less than or equal to	a <= b	
Greater than or equal to	a >= b	
Proportional	a prop b	
Toward	a toward b	
Arrow left	a dlarrow b	
Double arrow left and right	a dlrarrow b	
Arrow right	a drarrow b	

Table 2Commands, relations.

Set Operations

Operation	Command	Display
Is in	a in b	
Is not in	a notin b	
Owens	a owns b	
Empty set	emptyset	
Intersection	a intersection b	
Union	a union b	
Difference	a setminus b	
Quotient	a slash b	
Aleph	aleph	
Subset	a subset b	
Subset or equal to	a subseteq b	
Superset	a supset b	
Superset or equal to	a supseteq b	
Not subset	a nsubset b	
Not subset or equal	a nsubseteq b	
Not superset	a nsupset b	
Not Superset or equal	a nsupseteq b	
Natural Numbers Set	setN	
Set of Integers	setZ	
Set of rational numbers	setQ	
Set of real numbers	setR	
Set of complex numbers	setC	

Table 3Commands, set operators.

Functions

Operation	Command	Display
Exponential	func e^{a}	
Natural logarithm	ln(a)	
Exponential function	exp(a)	
Logarithm	log(a)	
Power	a^{b}	
Sine	sin(a)	
Cosine	cos(a)	
Tangent	tan(a)	
Cotangent	cot(a)	
Square root	sqrt{a}	
Arcsine	arcsin(a)	
Arc cosine	arccos(a)	
Arctangent	arctan(a)	
Arc cotangent	arccot(a)	
nth root	nroot{a}{b}	
Hyperbolic sine	sinh(a)	
Hyperbolic cosine	cosh(a)	
Hyperbolic tangent	tanh(a)	
Hyperbolic cotangent	coth(a)	
Absolute value	abs{a}	
Arc hyperbolic sine	arsinh(a)	
Arc hyperbolic cosine	arccosh(a)	
Arc hyperbolic tangent	arctanh(a)	
Arc hyperbolic cotangent	arccoth(a)	
factorial	fact(a)	

Table 4Commands, function.

Operators

All operators can be used with the limit functions (“from” and “to”)

Operation	Command	Display
Limit	Lim(a)	
Sum	sum(a)	
Product	prod(a)	
Coproduct	coprod(a)	
Limits from and to (shown with intigral)	int from {r_0} to {r_t} a	
Intigral	int{a}	
Double intigral	iint{a}	
Tripple Intigral	iiint{a}	
Lower limit shown with summation symbol	sum from{3}b	
Curved intigeral	lint a	
Double curved intigeral	llint a	
Tripple curved intigeral	lllint a	
Upper limit shown with product symbol	prod to{3} r	

Table 5Commands, operators.

Attributes

Operation	Command	Display
Acute accent	acute a	
Grave accent	grave a	
Reverse circumflex	check a	
Breve	breve a	
Circle	circle a	
Vector arrow	vec a	
Tilde	tilde a	
Circumflex	hat a	
Line above	bar a	
Dot	dot a	
Wide vector arrow	widevec abc	
Wide tilde	widetilde abc	
Wide circumflex	widehat abc	
Double dot	ddot	
Line over	overline abc	
Line under	Underline abc	
Line through	overstrike acb	
Ripple dot	dddot a	
Transparent (useful to get a placeholder of a given size)	phantom a	
Bold font	bold a	
Italic font	ital a	
Resize font	size 16 qv	

Table 6Commands, attributes.

Attributes Continued

Operation	Command	Display
Following item in sans serif font	font sans qv	
Following item in serif font	font serif qv	
Following item in fixed font	font fixed qv	
Make color of following text cyan	color cyan qv	
Make color of following text yellow	color yellow qv	
Make color of following text green	color green qv	
Make color of following text blue	color blue qv	
Make color of following text white	color white qv	
Make color of following text red	color red qv	
Make color green returns to default color black	color green X qv	
Brace items to change color of more than one item	color green {X qv}	

Table 7Commands, attributes - continued.

Others

Operation	Command	Display
Infinity	infinity	
Partial	partial	
Nabla	nabla	
There exists	exists	
For all	forall	
H bar	hbar	
Lambda bar	lambdabar	
Real part	re	
Imaginary part	im	
Weierstrss p	wp	
Left arrow	leftarrow	
Right arrow	rightarrow	
Up arrow	uparrow	
Down arrow	downarrow	
Dots at bottom	dotslow	
Dots at middle	dotsaxis	
Dots vertical	dotsvert	
Dots diagonal upward	dotsup	
Dots diagonal downward	dotsdown	

Table 8Commands, others.

Brackets

Operation	Command	Display
Round Brackets	(a)	
Square Brackets	[b]	
Double Square Brackets	ldbracket c rdbracket	
Single line	lline a rline	
Double line	ldline a rdline	
Braces	lbrace w rbrace	
Angle Brackets	langle d rangle	
Operator Brackets	langle a mline b rangle	
Group brackets (used for program control)	{a}	
Round brackets scalable (To make brackets scalable add the word “left before a left bracket and “right” before a right bracket	left ( stack{a # b # z} right )	
Square brackets scalable	left [ b right ]	
Double square brackets scalable	left ldbracket c right rdbracket	
Line scalable	left lline a right rline	
Double line scalable	left ldline d right rdline	
Brace scalable	left lbrace e right rbrace	
Angle bracket scalable	left langle f right rangle	
Operator brackets scalable	left langle g mline h right rangle	
Over brace scalable	{The brace is above} overbrace a	
Under brace scaleable	{the brace is below}underbrace {f}	

Table 9Commands, braces.

Formats

Operation	Command	Display
Left Superscript	a lsup{b}	
Center Superscript	sum(a)a csup{b}	
Right Superscript	a^{b}	
Left subscript	a lsub{b}	
Center subscript	a csub{b}	
Right subscript	a_{b}	
Align character to left	(alignl(a))	
Align character to center	(alignc(a))	
Align character to right	(alignr(a))	
Vertical stack of 2	binom{a}{b}	
Vertical stack, more than 2	stack{a # b # z}	
Matrix stack	matrix{a # b ## c # d}	
Common mathematical arrangement	matrix{a # "="b ## {} # "="c}	
New Line	asldkfjo newline sadkfj	
Small gap (apostrophe)	stuff`stuff	
Large gap (tilde)	stuff~stuff	

Table 10Commands, formats.

Characters

Greek

%ALPHA	%BETA	%CHI	%DELTA	%EPSILON
%ETA	%GAMMA	%IOTA	%KAPPA	%LAMBDA
%MU	%NU	%OMEGA	%OMICRON	%PHI
%PI	%PSI	%RHO	%SIGMA	%THETA
%UPSILON	%XI	%ZETA		
%alpha	%beta	%chi	%delta	%epsilon
%eta	%gamma	%iota	%kappa	%lambda
%mu	%nu	%omega	%omicron	%phi
%pi	%rho	%sigma	%tau	%theta
%upsilon	%varepsilon	%varphi	%varpi	%varrho
%varsigma	%vartheta	%xi	%zeta	

Table 11Characters, Greek.

Special

%and	%angle	%element	%identical	%infinite
%noelement	%notequal	%or	%perthousand	%strictlygreaterthan
%strictlylessthan	%tendto			

Table 12Characters, special.

Unquoted text that isn't a command is considered to be a variable. Variables are, by default, italicized.

There are three custom fonts, sans serif (without kicks), serifs (with kicks), and fixed (non proportional). To change the actual fonts used for custom fonts and the fonts used for variables (unquoted text), numbers and functions, use: Format > Fonts.

Command Reference

OpenOffice.org Formula Command Reference	15

15

Contents

OpenOffice.org Formula Command Reference	xv

Version 1

InsertTheTitleOfYourDocumentHere	15

15	Open Office Formula How-To

Scott Carr

2003-05-29T19:58:18