LibreOffice

User Java config file in Libreoffice 4.3

/home/${USER}/.config/libreoffice/4/user/config/javasettings_Linux_X86_64.xml

Configure default paper size

echo "a4" > /etc/papersize

enable uno listener

sudo apt-get install -y patch
#wget http://www.panticz.de/sites/default/files/Setup.xcu_.diff -P /tmp/
#patch -p2 /usr/lib/openoffice/share/registry/data/org/openoffice/Setup.xcu < /tmp/Setup.xcu_.diff

add path to java

wget http://www.panticz.de/sites/default/files/javasettingsunopkginstall.xml_.diff -P /tmp/
sudo patch -p2 /usr/lib/openoffice/share/config/javasettingsunopkginstall.xml < /tmp/javasettingsunopkginstall.xml_.diff
# on OpenOffice 3.1
sudo patch -p2 /usr/lib/openoffice/basis3.1/share/config/javasettingsunopkginstall.xml < /tmp/javasettingsunopkginstall.xml_.diff

configure database source

wget http://www.panticz.de/sites/default/files/DataAccess.xcu_.diff -P /tmp/
patch -p2 /usr/lib/openoffice/share/registry/data/org/openoffice/Office/DataAccess.xcu < /tmp/DataAccess.xcu_.diff
# on OpenOffice 3.1
patch -p2 /usr/lib/openoffice/basis3.1/share/registry/data/org/openoffice/Office/DataAccess.xcu < /tmp/DataAccess.xcu_.diff
 
v2
mv ~/.openoffice.org/3/user/registry/data/org/openoffice/Office/DataAccess.xcu ~/.openoffice.org/3/user/registry/data/org/openoffice/Office/DataAccess.xcu.org
wget http://www.panticz.de/sites/default/files/DataAccess.xcu -O ~/.openoffice.org/3/user/registry/data/org/openoffice/Office/DataAccess.xcu

check files java files

sudo apt-get install ure
/usr/lib/ure/share/java/juh.jar
/usr/lib/ure/share/java/jurt.jar
/usr/lib/ure/share/java/ridl.jar
 
sudo apt-get install ure
/usr/lib/ure/share/java/unoloader.jar
 
sudo apt-get install libreoffice-java-common
/usr/lib/libreoffice/program/classes/unoil.jar
 
sudo apt-get install libreoffice-officebean
/usr/lib/libreoffice/program/classes/officebean.jar

Run listener

ooffice "-accept=socket,host=localhost,port=8100;urp" -quickstart -nologo -nodefault

Check uno

/usr/lib/libreoffice/program/soffice.bin "--accept=socket,host=127.0.0.1,port=8100;urp;" --headless --nodefault --nolockcheck --nologo --norestore
 
unoconv --server localhost --stdout --port 8100 -f pdf FILE_IN.odt > FILE_OUT.pdf

Fix jetpipe

ln -s /usr/lib/libreoffice/program/libjpipe.so your_project/lib/

HowTo
Tabelle jede 2. Zeile farbig
1. Schalte mit F11 die Formatvorlagen ein.
2. Erstelle eine neu Zellvorlage mit Deiner gewünschten Farbe.
3. Markiere den gewünschten Bereich für die Einfärbung der Zeilen.
4. Wähle: Menü - Format - Bedingte Formatierung, gib für die „Bedingung 1“ an: „Formel ist“ in das freie Feld daneben kopiere diese Formel: REST(ZEILE();2)<>0
Wähle unter „Zellvorlage“ Deine neue Vorlage mit der gewünschten Farbe aus.

install spell check

apt-get install myspell-de-de openoffice.org-thesaurus-de openoffice.org2-l10n-de openoffice.org2-thesaurus-de openoffice.org-hyphenation-de

fix line repetition bug (Wiederholungszeile)
http://de.openoffice.info/viewtopic.php?f=2&t=27194

libreoffice

~/.libreoffice/3/user/config/javasettings_Linux_x86.xml

# dep
install packages OpenOffice

# sudo apt-get install -y openoffice.org-java-common openoffice.org-officebean openoffice.org-base patch

Links
http://extensions.services.openoffice.org/project/TeamDrive
http://wiki.openkm.com/index.php/Third-party_software_integration:_OpenOffice.org
http://www.gnuaccounting.de - LibreOffice automatisation / accounting and bookkeeping application