Home

openoffice

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

Sat, 10/02/2010 - 10:40 — panticz

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://www.panticz.de/sites/default/files/scripts/set.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/basis*/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

Tue, 04/28/2009 - 15:53 — panticz 
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

Wed, 09/10/2008 - 11:15 — panticz 
Create new Macro
Extras > Makros > Makros verwalten > Makro...
Meine Makros > Standard > Neu
 
# open a external application
Sub Main
selectedRow = ThisComponent.CurrentSelection.getRangeAddress.StartRow
itemId = ThisComponent.CurrentController.ActiveSheet.getCellByPosition(0, selectedRow).getString()
 
oSysExecuteService = createUnoService("com.sun.star.system.SystemShellExecute")
oSysExecuteService.execute("/media/programme/starter/scripts/Lager.sh", "item_id=" & itemId, 0)
 
rem MsgBox itemId, 0
rem ThisComponent.CurrentSelection.getString()
End Sub
 
 
 
 
# print file name in

OpenOffice

Wed, 04/30/2008 - 15:54 — panticz

Configure default paper size
echo "a4" > /etc/papersize

sudo apt-get install -y patch

enable uno listener
#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/
sudo patch -p2 /usr/lib/openoffice/share/config/javasettingsunopkginstall.xml < /tmp/javasettingsunopkginstall.xml_.diff
# on OpenOffice 3.1

Do you like this page? Then support it. Please click the AD below and visit the sponsor. Thank you!


Syndicate content