openoffice

warning: Creating default object from empty value in /data/web/1/000/027/003/273448/htdocs/panticz.de/modules/taxonomy/taxonomy.pages.inc on line 33.

Fix unable to shutdown / reboot / logout when OpenOffice Quickstarter is active

Here is a quick fix for OpenOffice bug reported on Launchpad https://bugs.edge.launchpad.net/ubuntu/+source/openoffice.org/+bug/562027 that prevent Gnome logout if Quickstart is running.

Solution: change DocumentStoreUIEnabled in Recovery.xcu (OpenOffice) or main.xcd (Libreoffice) to false with this command

wget http://dl.panticz.de/libreoffice/scripts/DocumentStoreUIEnabled_false.sh -O - | bash -

#!/bin/bash

if [ -d /usr/lib/libreoffice ]; then
    # libreoffice
    sudo sed -i 's|<prop oor:name="DocumentStoreUIEnabled" oor:type="xs:boolean"><value>true|<prop oor:name="DocumentStoreUIEnabled" oor:type="xs:boolean"><value>false|g' /usr/lib/libreoffice/share/registry/main.xcd
else
    # openoffice
    sudo sed -i '5s|true|false|g' /usr/lib/openoffice/basis*/share/registry/data/org/openoffice/Office/Recovery.xcu
fi

or use Diff to path Recovery.xcu
wget -nv http://dl.dropbox.com/u/4170695/openoffice/Recovery.xcu_DocumentStoreUIEnabled.diff -O - | \
patch -p2 /usr/lib/openoffice/basis3.2/share/registry/data/org/openoffice/Office/Recovery.xcu

Optional: remove user personal Recovery.xcu files
find /home/*/.openoffice.org/ -name Recovery.xcu -exec rm {} \;

Links
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/562027

Enable UNO listener on Windows

wordpad "C:\Programme\OpenOffice.org 3\Basis\share\registry\data\org\openoffice\Setup.xcu"
 
search for <node oor:name="Office"> (by default line 3) and add
<prop oor:name="ooSetupConnectionURL" oor:type="xs:string">
   <value>socket,host=localhost,port=8100;urp;</value>
</prop>

OpenOffice Macros with Basic

Create new Macro
Extras > Makros > Makros verwalten > Makro...
Meine Makros > Standard > Neu
 
 
# open a external application (v1)
Sub Main
	item = ThisComponent.getCurrentSelection.String
 
	If len(item) > 0 then
		rem msgbox "Selection: " & item
 
		item = UCase(item)
		oService = createUnoService("com.sun.star.system.SystemShellExecute")
		oService.execute("/media/programme/starter/scripts/Lager.sh", "item_id=" & item, 0)
	EndIf
End Sub
 
 
 
# open a external application (v2)
Sub Main
selectedRow = ThisComponent.CurrentSelection.getRangeAddress.StartRow
itemId = ThisComp

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_... -P /tmp/

Syndicate content