You need also to install at least one "transformer" (currently there is only a Calc Transformer). The transformer is also an extension and is the component that actually makes the Dispatch-to-API translation of the macro code.
After the installation, you do not need to know anything else: reboot openoffice and just use the macro recorder as usual.
If you want to switch back to the "classic" macro recorder you have only to remove or disable both extensions from the extension manager dialog.

scripts

Disable possibility to adjust toolbars | lookup (Dmitri Popov) | lookup with GUI (also D.P.) | make link (D.P.?) | multi save (D.P.?)

source code

hacker
Koders
source download
source search (better idea than downloading)

vba

Excel VBA to OpenOffice Basic Converter
Programming OpenOffice.org with Visual Basic
VBA/StarBasic
Wiki page

too many notes

Decided just to dump the lot (well, almost the lot) here without trying to organise them much. One day I'll get a Round Tuit.

edit sections

language settings

more (IIRC) from Villeroy

There are 3 lang-settings at Tools>Options>LangSettings>Languages
Which one do you want to change and most important: why?
The first one ("User interface") influences menues, help files,
tool-tips and alike.
The second one ("Locale") influences the how your input is interpreted
(12/30/2000 vs 30/12/2000).
The third one ("Default for documents") influences the appearance
(output) of data. Basically it sets the language of the default styles.
This can be set up for each new document, an individual document, per
paragraph (writer:paragraph styles) or even for a text-portion
(writer:character styles). Same with cell styles in Calc.

This way you can stick with your local input method while the document
(or parts of it) shows regional typographic and numeric distictions.

rounding

(and around we go)
For most people that do not have a degree in numerical analysis or similar numeric studies, 1.5 is expected to round up.

In Calc, however, you can use the functions ROUND, ROUNDDOWN, or ROUNDUP.

FLOOR and CEILING provide more control then ROUNDUP or ROUNDDOWN.

INT claims to round down to the nearest integer.

Other supported methods are EVEN and ODD. MROUND is rarely used in cases such as this, but it is available.

To always truncate, you can use TRUNC

Your requests makes me believe that you want to round as follows:

Round towards zero, which is different than round down, if the fractional portion is less than or equal to 0.5, and round away from zero otherwise.

You can always do something similar to the following:
Code:
=IF(ABS(B7)-TRUNC(ABS(B7))<=0.5; ROUNDDOWN(B7); ROUNDUP(B7))

the regex mess

http://www.oooforum.org/forum/viewtopic.phtml?p=209713#209713
remove leading 'the'

http://www.oooforum.org/forum/viewtopic.phtml?t=43032
http://www.oooforum.org/forum/viewtopic.phtml?t=44199

Use Standard-Filter with regex-option.
The criterion for "starts with foo" is: ^foo.*
The criterion for "ends with foo" is: .*foo$
The criterion for "contains foo" is: .*foo.*
Regex-criteria can be used with operators equal (=) and and unequal(<>)
Short regex-howto:
- Use .* instead of *
- Use . instead of ?
- ^ means start
- $ means end
- if you search for a literal * escape it with \*
- same with any kind of braces and any of ^$.*?\&
- in doubt escape anything but <, > and alphanumerics, since \<, \>, \n, \t and \C have a special meaning in regexes.
- avoid named character-classes as they are described in help (eg. [:digit:])
Support of named classes is buggy and will change in future.
http://www.openoffice.org/issues/show_bug.cgi?id=64368

Regular expression quick reference

. (period) - matches any single character except a newline.

(asterisk) - matches zero or more instances of the preceding character.

(plus) - matches one or more instances of the preceding character.
? (question mark) - matches zero or one (but not more) instances of the preceding character.
\{n\} (backslash-braces) - matches exactly n repetitions of the preceding character.
[ … ] (brackets) - delimit a set of possible characters.
^ (caret) - matches the beginning-of-line character.
$ (period) - matches the end-of-line character.

Call Edit>Find/replace (Ctrl+F)
Options: "Current Selection" and "Regular Expressions"
Find: .+ [dot and plus]
Replace: &
Button "Replace All"
This should re-enter all numeric text as numbers.

Call Menu:Edit>Find…
Option "Regular Expression"
Find: ^=.+
Replace: &
Button "Replace All"
This replaces all formulas with themselves, just like retyping each formula.

=SEARCH("[a-c]";"abc123")
Cell A1 will now display "1" as you'd expect.

=SEARCH("[^a-c]";"abc123")
I would expect cell A1 to now display "4" as that's where the first
character that isn't one of a,b, or c is located.

apostrophe
sSymbol = "^." .* The second is official
sReplace = "&"
Try =COUNTIF(A1:L37;".*INCHINNAN.*"). The ".*" says any number of or zero leading or trailing characters
If you put the regular expression .* in the Search for box, the search will find 0 or more of any character in the cell. The regular expression & in the Replace with box will replace the found character with itself. In the process the format of the cell is refreshed (be sure to change the cell format before performing the search).
You can use two regular expressions: "^ *" and " *$" (leaving off the quotes of course and there is a "space" in front of each asterisk) and leave the Replace as window empty. The first expression trims off leading spaces and the second expression trims off trailing spaces. FOR TRAILING, search " +$"

Search for "^.* " (there is a space as the last character), replace with nothing and check the Regular Expressions box. This expression will find any and all characters at the beginning of a paragraph up to and including the space.

Short regex-howto:
- Use .* instead of *
- Use . instead of ?
- ^ means start
- $ means end
- if you search for a literal * escape it with \*
- same with any kind of braces and any of ^$.*?\&
- in doubt escape anything but <, > and alphanumerics, since \<, \>, \n, \t and \C have a special meaning in regexes.
- avoid named character-classes as they are described in help (eg. [:digit:])
Support of named classes is buggy and will change in future.
http://www.openoffice.org/issues/show_bug.cgi?id=64368

my thread on spaces: http://www.oooforum.org/forum/viewtopic.phtml?t=37992

Replace regex \x0000 with " " does not work with null-chars, nor does REPLACE(A1;CHAR(0);" ").
Copy a null-char from the formula
Paste into the search-box and replace with " ".

There seems to be something wrong with my copy of OOo.
I get 0 from the code formula.
=DATEVALUE(SUBSTITUTE(A1;CHAR(160);" ")) does not work (no substitution)
but
Find Regex: \xA0
Replace: " "
replaces the "wrong spaces" [hex(160) = A0] and converts strings to dates on the fly.

Found my way for replacing all kinds of spaces with a "real space" (ascii 32):
Find Regex: [:space:]+
find any kind of space, optionally followed by more spaces
Replace with: single space
The implementation of named character-classes is broken and will change in OOo3: http://www.openoffice.org/issues/show_bug.cgi?id=64368
Currently [:space:] won't match whereas [:space:]? matches a single space, which is contrary to the meaning of "?" (zero or one occurance of preceeding item).

I've never used Bork, but looking at amo the description says it uses regular expressions. If this is the case, "*" will not match the text as you describe. In regular expressions, "*" is used to match zero or more of the previously specified character. So, "A*" would match "" or "A" or "AAA", etc. Since "." is used to match any character, you want ".*" instead.

Also, the backslash "\" has special meanings in regular expressions. Be careful when you use it. For example, "\." will make it actually match a period (".") since period normally matches any character.

That's a non-breaking space. Try ^[\xA0 \t]+.

=COUNTIF(C1:C6;"^.[34].$") replacing the range as needed. This expresion says any three digit expression with 3 or 4 as the middle character. The ^ and $ are what are called anchors. These make sure that your match is pinned to the start and end of the string.

On Thu, 2005-12-29 at 18:30 -0600, Knight, Jon wrote:

In Writer, I'd like to Search & Replace all occurrences of data enclosed in parentheses. I'm able to do so in MS Word by using "$*$" as a regular expression, without the double-quotes of course. I have read the regular expression section in the OO help, but nothing I try is successful. I thought that "$[:print:]$" would work, but it doesn't.

Try: "$.*$"

The * means zero or more occurrences of the preceding "thing", so in your case you were searching for zero or more open brackets immediately followed by a close bracket. (It was finding the close brackets - right?).

The . means any character, so .* means any group of characters.

But remember that it is "greedy" so that if there is more than one
bracketed expression in a paragraph it will find from the start of the
first bracketed expression to the end of the last. To get around this
problem try: "$[^(]*$"

This searches for an open bracket, anything that isn't an open bracket followed by a close bracket.

Thanks, Ian

If you use "^.*; " in a regular expression, you could find a whole line full of characters at the start. If you want to limit the search to only three characters (any) at the start of the line followed by semi-colon and space, you need to use "^.{3}; " and don't forget to check the regular expressions box.

the scripting

Activating another Calc file:
http://www.oooforum.org/forum/viewtopic.phtml?t=29806
Active cell
http://www.oooforum.org/forum/viewtopic.phtml?p=220683#220683
Auto Generate Save As Filename :
http://www.oooforum.org/forum/viewtopic.phtml?t=54184

automatic recalculation and lock :
bCalc = oDoc.isAutomaticCalculationEnabled
myDoc.lockControllers
myDoc.addActionLock
oDoc.enableAutomaticCalculation(False)
….
myDoc.removeActionLock
myDoc.unlockControllers
oDoc.enableAutomaticCalculation(bCalc)
enableAutomaticCalculation ( bEnabled as boolean )

csv : How to open a csv from command line (using a prepared filter) and copy all data into a prepared template:
http://www.oooforum.org/forum/viewtopic.phtml?t=54584&start=15

Format characters : http://www.oooforum.org/forum/viewtopic.phtml?p=223632#223632

Forms, buttons:
http://www.oooforum.org/forum/viewtopic.phtml?t=10431
Frame:
http://www.oooforum.org/forum/viewtopic.phtml?t=5057
Function:
http://www.oooforum.org/forum/viewtopic.phtml?p182671#182671
Function Access:
http://www.oooforum.org/forum/viewtopic.phtml?t=12828
Hyperlink:
http://www.oooforum.org/forum/viewtopic.phtml?t=46362
idl reference:
http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html

import csv into sheet : http://www.oooforum.org/forum/viewtopic.phtml?p=61004#61004

insert at position : http://www.oooforum.org/forum/viewtopic.phtml?p=90225#90225

insert date/time : http://www.oooforum.org/forum/viewtopic.phtml?t=56033
Villeroy's comments:
http://www.oooforum.org/forum/viewtopic.phtml?p=220736#220736

List files in spreadsheet :
http://www.oooforum.org/forum/viewtopic.phtml?p=225989#225989

remove leading apostrophe :
http://www.oooforum.org/forum/viewtopic.phtml?p=227797#227797

Flags defines which data will be copied:
A - all
or
S - string
V - value
D - date, time
F - formulas
N - notes
T - formats
Any of them can be skiped, you can copy only values without formulas…

Sub CopyRangeToAnotherDocument
oDesktop = createUnoService("com.sun.star.frame.Desktop")
oDocument = ThisComponent
oRange1 = oDocument.Sheets.getByIndex(0).getCellRangeByPosition
(0,0,2,3)

sPath = "file:/C:/intranet/NarPapiroti/" ' Windows
' sPath = "/home/" & sUser & "/NarPapiroti/" ' Unix, Linux
sTargetUrl = convertToUrl(sPath & "Test.sdc")
oTargetDoc = oDesktop.loadComponentFromURL(sTargetUrl,"_default",0,
Array())
oRange2 = oTargetDoc.Sheets.getByIndex(0).getCellRangeByPosition
(2,0,4,3)

oDataArray = oRange1.getDataArray
oRange2.setDataArray(oDataArray)
End Sub
Both source and target ranges must have equal dimensions.

Sub LaunchOutsideFile()

oSvc = createUnoService
("com.sun.star.system.SystemShellExecute")

Rem File:
' oSvc.execute(ConvertToUrl("C:\sample.txt"), "", 0)
Rem Folder:
' oSvc.execute(ConvertToUrl("C:\Program Files\OpenOffice.org1.1.0"), "", 0)
Rem Web address:
' oSvc.execute("http://www.openoffice.org/", "", 0)
Rem Email:
' oSvc.execute("mailto:anonymous@ftp.com", "", 0)

End Sub

Sub exporterFormeParExt(oForm as Object)
Dim maForme As Object, serv As Object, filtre As String
Dim params(2) As New com.sun.star.beans.PropertyValue
Dim optionsfiltre(1) As New com.sun.star.beans.PropertyValue
optionsfiltre(0).Name = "PixelWidth"
optionsfiltre(0).Value = 2000
optionsfiltre(1).Name = "PixelHeight"
optionsfiltre(1).Value = 2000
serv = CreateUnoService("com.sun.star.drawing.
GraphicExportFilter")
serv.setSourceDocument(oForm)
params(0).Name = "URL"
params(0).Value = convertToURL("/home/didier/tmp4/
export1.bmp")
params(1).Name = "FilterName"
params(1).Value = "bmp"
params(2).Name = "FilterData"
params(2).Value = optionsfiltre()
serv.filter(params())
End Sub

the software

512 Formula overflow
Compiler: the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512. Interpreter: the total number of matrices that the formula creates exceeds 150. This includes basic functions that receive too large an array as a parameter (max. 0xFFFE, for example, 65534 bytes).

http://www.openoffice.org/servlets/ReadMsg?list=dev&msgNo=18970
Yup, X11 fonts are disabled by default (for >=OOo 2.2). See issue
http://www.openoffice.org/issues/show_bug.cgi?id=62039
for details of this change. To reenable native X11 you can do
export SAL_ENABLE_NATIVE_XFONTS=1
before starting soffice.

Forum abbrevs
http://www.8daysaweek.co.uk/forums/viewtopic.php?t=11

alternative row formatting[solved] :
http://www.oooforum.org/forum/viewtopic.phtml?t=55584

automatic update :
http://www.oooforum.org/forum/viewtopic.phtml?t=55406

Base :
Consultants: http://bizdev.openoffice.org/consultants.html
Support directory: http://support.openoffice.org/
Getting Started with Base chapter: http://www.oooforum.org/forum/viewtopic.phtml?t=51516
Beginners - Example Database - Base Tutorial: http://www.oooforum.org/forum/viewtopic.phtml?t=25060
Read this if you cannot insert/delete/update records: http://www.oooforum.org/forum/viewtopic.phtml?t=10374
OOo Base beginner tutorial: http://www.oooforum.org/forum/viewtopic.phtml?t=28312
Base website: http://dba.openoffice.org/
Documentation: http://documentation.openoffice.org./
Base mailing list: http://wiki.services.openoffice.org/wiki/Base_Mailing_List

Bittorrent:
http://distribution.openoffice.org/p2p/
Bottom of list:
http://www.oooforum.org/forum/viewtopic.phtml?p=130414#130414
cell mover:
http://www.ooomacros.org/user.php#146632
common:

Convert to number:
http://www.oooforum.org/forum/viewtopic.phtml?p=121791#121791
http://qa.openoffice.org/issues/show_bug.cgi?id=62596

copy and paste with dispatcher :
http://www.oooforum.org/forum/viewtopic.phtml?p=104422#104422
Copy down:
http://www.oooforum.org/forum/viewtopic.phtml?t=3619

corrupt file:
hol.sten's links:
http://www.oooforum.org/forum/viewtopic.phtml?t=24208
http://www.oooforum.org/forum/viewtopic.phtml?t=23146
http://www.oooforum.org/forum/viewtopic.phtml?t=20840

macro to repair (windoze):
http://www.oooforum.org/forum/viewtopic.phtml?t=45473
other links:
http://www.oooforum.org/forum/viewtopic.phtml?t=33263
http://www.oooforum.org/forum/viewtopic.phtml?t=33210
http://www.oooforum.org/forum/viewtopic.phtml?t=24208
http://www.oooforum.org/forum/viewtopic.phtml?t=30992
http://www.oooforum.org/forum/viewtopic.phtml?t=31277
script to recover:
http://www.oooforum.org/forum/viewtopic.phtml?t=34891
One user: Thanks for the effort! Here's how I did it:

1. renamed the defective file extension to .zip
2. extracted content of the .zip file
3. opened content.xml with Dreamweaver, selected in the view menu to show errored lines (shows the bad text with yellow background) and removed them.
4. did the same with style.xml
5. updated the .zip file and renamed it back to .ods
Some styling was removed but the file worked and all the data was in it! Cheers!

crash recovery :
http://www.oooforum.org/forum/viewtopic.phtml?t=44960
http://www.oooforum.org/forum/viewtopic.phtml?t=55151

csv to Base : http://www.oooforum.org/forum/viewtopic.phtml?p=176645#176645

` Data pilot:
http://www.oooforum.org/forum/viewtopic.phtml?t=36884
Database functions :
http://www.oooforum.org/forum/viewtopic.phtml?p=203448#203448
Default format:
http://www.oooforum.org/forum/viewtopic.phtml?t=27273
http://www.oooforum.org/forum/viewtopic.phtml?p=218014#218014 and next

Debian type systems :
http://trustworthy.net/blog/category/kubuntu/
http://www.reallylinux.com/docs/oo2install.shtml
http://www.openoffice.org/servlets/ReadMsg?listName=users&msgNo=136547
http://www.oooforum.org/forum/viewtopic.phtml?p=194370#194370 (Hagar) ***
http://www.oooforum.org/forum/viewtopic.phtml?p=184259#184259 (Hagar)

Default template :
http://www.oooforum.org/forum/viewtopic.phtml?t=37132
Dictionaries:
http://www.oooforum.org/forum/viewtopic.phtml?t=50862 (spellcheck tut)
http://lingucomponent.openoffice.org/download_dictionary.html
http://www.ooomacros.org/user.php#114694
http://sourceforge.net/project/showfiles.php?group_id=87718&package_id=114694
Distros:
http://www.oooforum.org/forum/viewtopic.phtml?t=35407
dock window:
http://www.oooforum.org/forum/viewtopic.phtml?t=37567
documentation
http://documentation.openoffice.org./
http://www.oooforum.org/links.phtml
http://www.kaaredyret.dk/openoffice.html
Download Managers:
http://download.openoffice.org/
download wget :
http://www.oooforum.org/forum/viewtopic.phtml?p=213187#213187

edit spreadsheet share :
http://qa.openoffice.org/issues/show_bug.cgi?id=8811

English language thing
http://www.oooforum.org/forum/viewtopic.phtml?p=178029
Enterprise Management
http://www.oooforum.org/forum/viewtopic.phtml?p=139540
FAQs :
http://wiki.services.openoffice.org/wiki/Category:User_FAQ
filing bug report - filing issue :
http://www.oooforum.org/forum/viewtopic.phtml?t=47619
Firefox add-on :
https://addons.mozilla.org/firefox/4102/
http://wiki.services.openoffice.org/wiki/Firefox_OpenOffice.org_extension

force negative value - use trailing minus :
http://www.oooforum.org/forum/viewtopic.phtml?p=226233#226233

forking main binary : http://www.oooforum.org/forum/viewtopic.phtml?t=57039

formula to number: http://www.oooforum.org/forum/viewtopic.phtml?p=222552#222552

forum hosting requirements :
http://www.oooforum.org/forum/viewtopic.phtml?p=187666#187666
function translator :
http://www.oooforum.org/forum/viewtopic.phtml?t=23270
Further instructions:
http://download.openoffice.org/2.0.2/instructions.html
Google docs: https://docs.google.com/
Google spreadsheets: http://spreadsheets.google.com/
Headers:
http://www.oooforum.org/forum/viewtopic.phtml?t=40157
Hide options:
http://www.oooforum.org/forum/viewtopic.phtml?t=32564

Hyperlink style: http://www.oooforum.org/forum/viewtopic.phtml?t=44143

import csv to Base:
http://www.oooforum.org/forum/viewtopic.phtml?p=176645#176645
import Base to spreadsheet :
http://www.oooforum.org/forum/viewtopic.phtml?p=206533#206533
increment month :
http://www.oooforum.org/forum/viewtopic.phtml?p=214687#214687
and previous (mine)
install extensions for all users :
http://www.openoffice.org/servlets/ReadMsg?list=users&msgNo=143511

To install an extension for all users one has to log in as admin and
start the extension manager outside of OOo by running "unopkg gui". If
the place of the extension is known installing can also be done without
the graphical extension manager by calling

"unopkg add —shared $EXTENSIONPATH".

Install w/o rpms:
http://www.oooforum.org/forum/viewtopic.phtml?t=26173
integration :
http://www.oooforum.org/forum/viewtopic.phtml?t=44021
internet calling - phone home :
Spyware in OO 2.1?
http://www.oooforum.org/forum/viewtopic.phtml?t=51983
Auto Update is killing my Web Proxy Server
http://www.oooforum.org/forum/viewtopic.phtml?t=55398

iso md5sum : http://www.oooforum.org/forum/viewtopic.phtml?p=223928#223928
issues:
open in Calc http://www.openoffice.org/issues/show_bug.cgi?id=23078

jre solutions :
OOo crashing when Calc cell deleted : http://www.oooforum.org/forum/viewtopic.phtml?p=204692#204692

OOo files wrongly identified as java files :
http://www.oooforum.org/forum/viewtopic.phtml?p=227727#227727
http://www.clasohm.com/blog/archive/2006/12/
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6510610

some other problem
http://www.oooforum.org/forum/viewtopic.phtml?p=224465#224465

language of spreadsheet :
http://www.oooforum.org/forum/viewtopic.phtml?p=204132#204132

large file:
http://www.openoffice.org/issues/show_bug.cgi?id=68960
http://qa.openoffice.org/issues/show_bug.cgi?id=69448

last item in list / column :
http://www.oooforum.org/forum/viewtopic.phtml?p=130414#130414
http://www.oooforum.org/forum/viewtopic.phtml?p=218815#218815
http://www.oooforum.org/forum/viewtopic.phtml?p=159695#159695
http://www.oooforum.org/forum/viewtopic.phtml?t=39863

Launch with different languages : http://www.oooforum.org/forum/viewtopic.phtml?t=54526

line break
http://www.oooforum.org/forum/viewtopic.phtml?t=32392

http://www.oooforum.org/forum/posting.phtml?mode=quote&p=178404
Thanks, acknak. Inserting a space here (CHAR(32)) would enable you to take advantage of David's method, automatic text wrap.

Inserting a linebreak (CHAR(10)) has no effect because Calc does not recognise it. If you insert a line break in a cell using Ctrl+Enter, Calc reads it as char(32), i.e. as a space.

So: A1:
testingline [linebreak]
break
B1: =CODE(MID(A1;12;1)) —>32

Linux quick starter :
http://www.oooforum.org/forum/viewtopic.phtml?t=55524

location of settings folder : bootstrap.ini
http://www.oooforum.org/forum/viewtopic.phtml?p=208950#208950
http://www.oooforum.org/forum/viewtopic.phtml?p=201901#201901

locales - application and format :
http://www.oooforum.org/forum/viewtopic.phtml?p=227512#227512

Long time
http://www.oooforum.org/forum/viewtopic.phtml?t=39649
http://www.oooforum.org/forum/viewtopic.phtml?t=43606
http://www.openoffice.org/issues/show_bug.cgi?id=69448

mac x11
http://porting.openoffice.org/mac/news/news2006.html#20061105

Mandriva2007
http://www.oooforum.org/forum/viewtopic.phtml?p=196481#196481
http://www.oooforum.org/forum/viewtopic.phtml?t=46056
for 2.2 : http://www.oooforum.org/forum/viewtopic.phtml?t=55211

md5sum:
http://download.openoffice.org/2.2.0/md5sums.html

memory issues :
Calc http://www.oooforum.org/forum/viewtopic.phtml?p=209144#209144
… undo http://www.oooforum.org/forum/viewtopic.phtml?p=213140#213140
management : http://www.oooforum.org/forum/viewtopic.phtml?p=224827#224827

merge files:
TerryE (win) http://www.oooforum.org/forum/viewtopic.phtml?p=211941#211941

Missing Help:
http://www.8daysaweek.co.uk/forums/viewtopic.php?t=311
http://www.openoffice.org/issues/show_bug.cgi?id=59499
http://www.oooforum.org/forum/viewtopic.phtml?t=28931
http://www.oooforum.org/forum/viewtopic.phtml?t=29628
http://www.oooforum.org/forum/viewtopic.phtml?p=122883
http://web.mit.edu/ooffice_v2.0.1/distrib/i386_rhel4/openoffice.org2.0/help/en/

month increment:
http://www.oooforum.org/forum/viewtopic.phtml?p=214687#214687 and previous
http://www.oooforum.org/forum/viewtopic.phtml?p=218109#218109

move user folder :
http://www.oooforum.org/forum/viewtopic.phtml?p=208950#208950

msi : The Windows Installer Cleanup Utility :
http://support.microsoft.com/default.aspx?scid=kb;en-us;290301
http://www.oooforum.org/forum/viewtopic.phtml?t=29662
http://download.microsoft.com/download/e/9/d/e9d80355-7ab4-45b8-80e8-983a48d5e1bd/msicuu2.exe - download link

http://www.oooforum.org/forum/viewtopic.phtml?p=207851#207851

Multilingual:
http://oooauthors.org/en/members/tutorials/multilingualooo/
http://oooauthors.org/en/members/tutorials/multilingualooo/pdf-format/

Multiply cells:
http://www.oooforum.org/forum/posting.phtml?mode=quote&p=175469

nameserver - slow
http://www.oooforum.org/forum/viewtopic.phtml?t=42204

network : http://www.oooforum.org/forum/viewtopic.phtml?t=47172

no start after crash :
http://www.oooforum.org/forum/viewtopic.phtml?p=222121#222121
from command line: rm /tmp/OSL_PIPE_*_SingleOfficeIPC_*

ooextras:
http://ooextras.sourceforge.net/

offset : http://www.oooforum.org/forum/viewtopic.phtml?p=120437#120437

open .csv : http://user-faq.openoffice.org/faq/ar01s06.html#id2874578

opentype fonts:
The issue of OpenType fonts seems to be a system rather than software issue:
http://qa.openoffice.org/issues/show_bug.cgi?id=16032

and can be fixed at that level:
http://www.linuxquestions.org/questions/showthread.php?&t=200530
http://www.oooforum.org/forum/viewtopic.phtml?t=24511#96046

password cracker :
http://www.ooomacros.org/user.php#173080
http://www.oooforum.org/forum/viewtopic.phtml?t=23014
perl:
http://www.oooforum.org/forum/viewtopic.phtml?p=187367#187367
pdftohtml
http://pdftohtml.sourceforge.net/
permit second user to use desktop - xauth :
http://www.oooforum.org/forum/viewtopic.phtml?p=212457#212457

persistent recovery:
The particular files involved are mentioned here:
http://www.oooforum.org/forum/viewtopic.phtml?p=156335#156335

Rename the following files to something like xxx.yyy.bad:
~/.openoffice.org2/user/registry/cache/org.openoffice.Office.Recovery.dat
~/.openoffice.org2/user/registry/data/org/openoffice/Office/Recovery.xcu

and delete / move the contents of the following folder: ~/.openoffice.org2/user/backup
On Linux, you may have to remove also ~/.recently-used :
http://www.oooforum.org/forum/viewtopic.phtml?p=209718#209718

Prefix :

rpm -ivh —prefix /home/openoffice.org2.1.0 `ls *.rpm|grep -v kde`

rpm -Uvh —prefix /usr/local/openoffice.org2.0 *rpm
rpm -Uvh —prefix /usr/local/openoffice.org2.1_sdk *rpm

privacy :
http://www.oooforum.org/forum/viewtopic.phtml?t=57864

release notes :
http://wiki.services.openoffice.org/wiki/Product_Release

Quickstart:
http://www.oooforum.org/forum/viewtopic.phtml?t=30269
http://www.oooforum.org/forum/viewtopic.phtml?p=138104#138104
Quoots - open your documents and fill in template
details (written in OOBasic):
http://quoots.sourceforge.net/
recent files list:
http://www.oooforum.org/forum/viewtopic.phtml?t=40670
http://qa.openoffice.org/issues/show_bug.cgi?id=37201
recovery flaw :
http://www.oooforum.org/forum/viewtopic.phtml?t=44960
refresh datasource:
http://www.oooforum.org/forum/viewtopic.phtml?t=43635

registration screen persistent register again & :
http://www.oooforum.org/forum/viewtopic.phtml?p=106545#106545
http://qa.openoffice.org/issues/show_bug.cgi?id=64615
http://www.oooforum.org/forum/viewtopic.phtml?p=178260#178260

regex in OOo regular expressions :
http://www.oooforum.org/forum/viewtopic.phtml?t=39715
http://www.oooforum.org/forum/viewtopic.phtml?t=50802
for the real thing :
http://www.regular-expressions.info/

row limits:
http://qa.openoffice.org/issues/show_bug.cgi?id=30215
Can't save options [SOLVED] (Issue filed) : http://www.oooforum.org/forum/viewtopic.phtml?t=53047
Setup Guide:
http://documentation.openoffice.org/setup_guide2/

stock prices : Get Stock Prices in a Spreadsheet : http://www.oooforum.org/forum/viewtopic.phtml?t=16741

Solver:
http://kohei.us/ooo/solver/

Spell check and Language configuration :
http://www.oooforum.org/forum/viewtopic.phtml?t=50862

splash:
Either
delete ÐÐÐ¾/program/intro.bmp or
edit ÐÐÐ¾/program/soffice.ini (Linux - sofficerc), adding Logo=0
start from script:
http://www.oooforum.org/forum/viewtopic.phtml?t=37773
http://www.oooforum.org/forum/viewtopic.phtml?t=37837

style function:
http://www.oooforum.org/forum/viewtopic.phtml?p=185804#185804
Styles:
http://documentation.openoffice.org/manuals/oooauthors2/0113GS-WorkingWithStyles.pdf
system requirements
http://www.openoffice.org/dev_docs/source/sys_reqs.html

Troubleshooting
http://documentation.openoffice.org/HOW_TO/misc/Troubleshooting_guide.html

ui-language
http://www.oooforum.org/forum/viewtopic.phtml?t=43458

Unicode
http://www.unicode.org/charts/

uploading: http://www.oooforum.org/forum/viewtopic.phtml?t=56528

User Guide :
http://documentation.openoffice.org./manuals/OOo2.x/user_guide2_draft.pdf
vlookup:
http://www.openoffice.org/issues/show_bug.cgi?id=69545
voice - Dragon Naturally Speaking
http://www.oooforum.org/forum/viewtopic.phtml?t=45970
http://ui.openoffice.org/accessibility/

WinDohs path:
c:\documents and settings\username\Application Data\ OpenOffice.org2
Under Win 98 - C:\Windows\Application Data\OpenOffice.org2
Under Vista: C:\Users\[name]\AppData\Roaming\OpenOffice.org2

Xml editing:
http://www.oooforum.org/forum/viewtopic.phtml?t=39699

http://www.oooforum.org/forum/viewtopic.phtml?t=32654
you can use array formulas in this type of problem …
the following entered as an array formula will return the last non blank value in the range b33:b36
=OFFSET(B33;MAX(NOT(ISBLANK(B33:B36))*(ROW(B33:B36)-ROW(B33)));0)

IsBlank() returns an array of true/false
ROW(B33:B36)-ROW(B33) is an array of offset values from B33

Installation on Other UNIX systems
If you have a UNIX distribution that does not have an up-to-date rpm or you are unsure that your system is current and rpm installation is failing, then try the following:
….
b) Get and use rpm2cpio to convert the rpm files to cpio archives and then employ cpio to install the software. There is a perl version of rpm2cpio at http://www.iagora.com/~espel/rpm2cpio that should be portable. However, if it fails, try precompiled
rpm-package (including rpm2cpio) from ftp://ftp.rpm.org/pub/rpm/dist/rpm-4.1.x/rpm-4.1.i386.tar.gz or get the sources from
ftp://ftp.rpm.org/pub/rpm/dist/rpm-4.1.x/rpm-4.1.tar.gz
c) Install any language packs needed for OpenOffice.org.

ex: I want a function to add 5+4+3+2+1=15

im looking for something like =?func?(5) and the cell will display 15

With a top value [5 here] in A1, you'd have =A1*(A1+1)/2
If you want any arithmetic series summed, you'd show the step [difference between terms] in one cell, and need to know, for example, the first value, and the number of values to be added.

top of page
foot of side-bar

Kingfisher's corner

containing tasty morsels

blogs

bookmarks

forums

news

on this site

wiki help

bugs

memory

qa

security

calc

related

database

codes

compatibility

complementary

dictionaries

language packs

sound in Linux

documentation

private sources

download and install

escape

hacking

for networks

open document standards

organisation

departments

support and information

* Kingfisher's pages

scripting

api

books

C++

openoffice.org

scripting and tools

Python specific

extensions