[Kubuntu] Updating OpenOffice.org 3.2.1

I have installed OOo 3.2.0 but there are a number of issues that seems to persist on Kubuntu 10.04 (LTS). For example;

1. When I create a macro to delete selected cells, it does not work. (Solved on 3.2.1)
2. Impress printout of handouts, I do not get the page foot numbers. All pages display as number 1.

[Upgraded OOo has not fixed the bugs I am facing]
Backup all of the extensions you have for OpenOffice.org 3.2.0, if you intend to use it in the future. Now, the steps to upgrade to OOo 3.2.1

Method 1:

1. Download OOo 3.2.1 from
   ftp://mirror.upm.edu.my/openoffice/stable/3.2.1/OOo_3.2.1_Linux_x86_install-deb_en-US.tar.gz
2. Open a terminal line and extract the tar.gz file
   tar -xzvf OOo_3.2.1_Linux_x86_install-deb_en-US.tar.gz
   
3. Remove existing OOo 3.2.0
   sudo apt-get remove openoffice*.*
4. Enter the extracted directory and install the .deb files
   cd OOO320_m18_native_packed-1_en-US.9502/DEBS
   sudo dpkg -i *.deb
   sudo dpkg -i desktop-integration/

Method 2:

1. In the software sources, enable the "software Sources"
2. Update packages and install OpenOffice.org-3.2.1
   

Reset user desktop for CentOS

On CentOS, after installing the Oracle OpenOffice.org (OOo), everything works fine. Since by default the PCs have auto update enabled, the users tend to update and this causes the CentOS version of OOo to corrupt the installed OOo.

One way to avoid this is to disable the auto update. Since it is a lab environment, I can easily delete and replace user1 account to remove previous configurations in OOo for user1.

Step 1. Create the 2 simple scripts to disable the auto update and reset the desktop for user1.

goreset.sh
#/bin/bash
echo "Resetting pc:"
chkconfig yum-updatesd off
tmpwatch 0 /tmp
echo "Creating user user1"
userdel -r user1
useradd -m user1
passwd oscc
echo "User created, going to reboot"
reboot

startscript.sh
#!/bin/bash
LOGFILE="./coombreset.log"
echo "Enter server name:"
read SERVER
if [ -e $SERVER ]
then
exit
fi
scp prepare-cooomb-test.sh root@"$SERVER":~
ssh root@"$SERVER" ./goreset.sh
echo $SERVER >> $LOGFILE

Step 2. execute (run) the script named startscript.sh

-end-

Install Windows on Linux

To get MS Windows programs installed on Linux (Ubuntu this case), install Wine and other related files.

Step 1: Open a terminal. Or through the Kpackagekit, install packages below.

Step 2: Install packages by the command below;
sudo apt-get install libmpg123-0 libwbclient0 samba-common smbclient ttf-symbol-replacement winbind wine wine1.2 wine1.2-gecko pptview

MS PPTX and DOCX files can be viewed with OpenOffice.org 3, or the viewers from MS Office (I am yet to try these 2).

1. PowerPoint
2. Word

Disable Nautilus on KDE automount

After installing KDE on Ubuntu 10.04, there were some challenges. One of it is that the USB disk when plugged in, opens (mount) automatically and launches the Gnomes Nautilus. This is not a real problem but when you are used to KDE's environment, the preferred File browser is either Konqueror or Dolphin. In this case, I choose Dolphin.

The most likely cause is that Gnome's GVFS is running and opens the disk automatically. Doing a "ps aux" you will find the following processes running;

/usr/lib/gvfs/gvfsd-trash --spawner :1.39 /org/gtk/gvfs/exec_spaw/0 /usr/lib/gvfs/gvfs-gdu-volume-monitor /usr/lib/gvfs/gvfsd-burn --spawner :1.39 /org/gtk/gvfs/exec_spaw/1 /usr/lib/gvfs/gvfs-afc-volume-monitor /usr/lib/gvfs/gvfs-gphoto2-volume-monitor /usr/lib/gvfs/gvfsd-metadata /usr/lib/gvfs/gvfsd



What is GVFS?
GVFS replaces Gnome's virtual file system (VFS). Programmes built with the library GIO or Gnome I/O will be invoke automatically and managed by the gvfsd service.

The gvfs-fuse module is used only when the application is not built with the GIO library. With GVFS, Nautilus takes over the automount/autorun responsibilities from gnome-volume-manager. A good read on GVFS is in this 2006 article.



Stopping processes
If I stop (kill) the gvfsd and gvfs-gdu-volume-monitor, Nautilus does not get open anymore. But instead of killing this process, I will approach this by assuming that gvfs reads from Gnome Desktop Manager configuration files.

Step 1:
Open a terminal (e.g. konsole) and type
gconf-editor

Step 2:
In the left window of Gconf-editor, choose /apps/nautilus/preferences and remove check mark for
1) media_automount
2) media_automount_open

Step 3:
Close the Gconf-editor and log out. After you log back in, no more Nautilus.