Showing posts with label office. Show all posts
Showing posts with label office. Show all posts

Change LibreOffice progress bar color

Newest LibreOffice splash screen shows a orange-redish colour bar instead of a green one like it was some versions ago. I guess they changed it to integrate better with Unity default colours. But I'm using Linux Mint, so I liked the green one more. The other day, I just stumbled about the /etc/libreoffice/sofficerc configuration file, which defines some variables for the startup and there it is, the ProgressBarColor parameter.

Install instructions

The following instructions change the color from the shell command line, but you could also just edit the file with your favourite text editor (with root permissions).
# Put the color value into a variable
pbcolor=160,195,124

sudo sed -r -i.bak "s/(ProgressBarColor=)[0-9]{1,3},[0-9]{1,3},[0-9]{1,3}/\1${pbcolor}/" /etc/libreoffice/sofficerc

# Check that everything went fine (otherwise you can restore the backup file).
cat /etc/libreoffice/sofficerc
You can find the right colors for example with the Gimp image editor.

Install LibreOffice 3.5

The current version of LibreOffice which ships with Ubuntu Oneiric is 3.4.4.
Lately, I was getting very angry about this version, because it gave me constant trouble:
  • it looses somehow control about its lock-files, therefore I wasn't able to save my open files any longer, neither with the old nor with a new name
  • graphics in calc files suddenly jumped to another sheet when opening the files
I loved LibreOffice so far, but this behaviour really pi.... me of.
So the other day, I read about the new release 3.5, its new features and so I decided to update it by hand.

Below, you can find the update script that I programmed for that task.

After using it for some time, here I list the most interesting stuff about the new version.
  1. No problem with the lock-files any longer.
  2. Graphics stay in their sheets.
  3. Conditional formatting now lets you define more then three conditions, this was really necessary, I use that feature a lot. I'm just missing an easy way for reordering.
  4. Bigger text box for writing formulas.
  5. The import of Microsoft Visio files.
  6. The print preview of all pages.
  7. and lots more

Install instructions

Just save the following lines as InstallLibreOffice.sh and execute it with the -h parameter to see the usage text. You can also download it from here directly.
#! /bin/bash

#
## LibreOffice installation from Debian Packages from website
## @author Sven Rieke
# 

language=en-US
version="3.5.0"

function Usage() {
    cat <<EOF
Usage: ${0##*/} [-h] [-v] [-l lang-id] [p lang-id] [-d version-id] [-u]

  Options:
    -h             Show this help.
    -v             Be verbose about processing steps.
    -l lang-id     Set language for main installer and documentation (default = ${language})
    -p lang-id     Set language for interface translation (not installed by default)
    -d version-id  Specify another package version (default = ${version})
    -u             Start with a clean user-profile
 
EOF
}

function AndOut() {
    popd
    exit
}

trap AndOut ERR

########################################################################
# Interpretation and validation of command line parameters and options #
########################################################################

while getopts :hvl:d:u OPT; do
    case $OPT in
 h|+h) Usage ; exit 0     ;;
 v|+v) VERBOSE=true       ;;
 l|+l) language="$OPTARG" ;;
 p|+p) langpack="$OPTARG" ;;
 d|+d) version="$OPTARG"  ;;
 u|+u) NEWUSER=true       ;;
 *)    Usage
       exit 2
    esac
done

sudo -v

mkdir -p /tmp/LibO.3.5
pushd /tmp/LibO.3.5

#### Download from http://www.libreoffice.org/download/?type=deb-x86
[[ -v VERBOSE ]] && echo "---[ Installing LibreOffice ${version}-${language} ]" >&2
[[ -v VERBOSE ]] && echo "*** Downloading packages ***" >&2

for i in install helppack ; do
    package="LibO_3.5.0_Linux_x86_${i}-deb_${language}.tar.gz"

    if [ ! -f $package ]; then
 [[ -v VERBOSE ]] && echo "*** Downloading new package $package ***" >&2
 wget http://download.documentfoundation.org/libreoffice/stable/${version}/deb/x86/$package
    fi
done

if [ -v langpack ]; then
    package="LibO_3.5.0_Linux_x86_langpack-deb_${language}.tar.gz"
    if [ ! -f $package ]; then
 [[ -v VERBOSE ]] && echo "*** Downloading new package $package ***" >&2
 wget http://download.documentfoundation.org/libreoffice/stable/${version}/deb/x86/$package
    fi
fi

[[ -v VERBOSE ]] && echo "*** Decompressing downloaded archives ***" >&2
for t in LibO_3.5.0_*.tar.gz ; do tar xzf $t ; done

[[ -v VERBOSE ]] && echo "*** Removing old LibreOffice installation ***" >&2
sudo apt-get remove libreoffice-core

for d in $(find -maxdepth 1 -mindepth 1 -type d) ; do
    [[ -v VERBOSE ]] && echo "*** Install packages from $d ***" >&2    
    pushd $d/DEBS
    sudo dpkg -i *.deb

    if [ -d desktop-integration ]; then
 [[ -v VERBOSE ]] && echo "*** Install desktop integration ***" >&2
        cd desktop-integration
        sudo dpkg -i *.deb
        cd ..
    fi
    
    popd
done

if [ -v NEWUSER ]; then
    [[ -v VERBOSE ]] && echo "*** Remove old user profile ***" >&2
    mv ~/.config/libreoffice/3/user ~/.config/libreoffice/3/user_old
    [[ -v VERBOSE ]] && echo "*** Old one can be found in ~/.config/libreoffice/3/user_old ***" >&2
fi

AndOut

From repository

There also exists a repository which gets updated from time to time with the latest versions.
sudo add-apt-repository ppa:libreoffice/ppa
sudo apt-get update
sudo apt-get upgrade

Troubleshooting

In two installations I had trouble with my old user profile. LibreOffice claimed about templates already installed. Therefore, I added the -u switch to my install script which moves the whole user profile to a backup location, so LibreOffice will start with a new profile. Just copy your old templates to the new profile and reapply all your settings again.

Creating large Documents using OpenOffice.org Writer

One of OpenOffice.org's strengths is its ability to handle large word processing documents. In this recently released guide of 48 pages, you'll learn how to create and manage large documents.

Topics include:

  • Developing table of contents, indexes, appendices
  • Working with templates, cross-references
  • Handling graphics, tables, charts
  • Using OOo powerful style guides to manage page styles, paragraph styles, and character styles
  • And a lot more helpful tips and tricks

Download this guide now (without passing through the registration form).

Problems with Lightning on Ubuntu Jaunty


After putting on my fresh Ubuntu Jaunty installation, my favourite Email client Thunderbird, the Lightning extension (version 0.9), didn't worked at all.
I tried everything, reinstalling Thunderbird several times, disabling all other extensions, nothing.
Lightning painted some icons, but that was everything.
Some incompatibility. I installed SunBird 0.9, and it works fine. Earlier Lightning versions seemed to work also, so what is the matter?

Solution


Finally, I found the solution in some forum, you need to have libstdc++ version 5 on your system (Jaunty comes with version 6 by default). And it has to be there, when Lightning extension 0.9 is installed, so if you already have it in your Thunderbird setup, uninstall it first, then put libstc++5 on your system, and reinstall the Lightning extension.
sudo aptitude install libstdc++5
# or if you don't want to install more stuff:
ln -s /usr/lib/libstdc++.so.6 /usr/lib/libstdc++.so.5

MS Project 2003 on Ubuntu

As I already mentioned about Gantt Charting, on Windows commonly used is MS Office Project. Not always you can avoid its use, especially if anyone else in your company uses it and you'll be asked to prepare a Gantt chart for them.

So what can you do if you don't want to abandon your great Ubuntu desktop?

The solution is to run in under the hood of Crossover (will only work with MS Project 2003 Pro).
But I ran into some trouble, so I'll explain the solution here.

It is still recommendable to use any of the
open source applications which I mention here!


Install instructions

  1. Install Crossover of course. Do it with your normal user account, the recommended way.
  2. Install MS Project 2003 Pro from Crossover's internal installer, inside a win2000 bottle.
    • After being installed you can already run Project, but it will complain all the time that you have to add gbui://mainpage.htm to your trusted sites inside of Internet Explorer.
  3. So we have no other choice as to install IExplorer always.
    • Make sure you select the same win2000 bottle as the one of Project, otherwise your settings will not been seen by Project.
    • Crossover will tell you that it is a bad idea and that it will most likely fail, but nevertheless go on and ignore the warning at the end.


Configuration


Now we have to add the mentioned page to your trusted sites list.
  1. Launch Crossovers Configuration application.
  2. Manage Bottles tab.
  3. Select the win2000 bottle and push Configure.
  4. Enter the Control Panel tab.
  5. Push the icon for Internet Options.
  6. Go to Security --- Trusted sites -- Sites... and enter gbui://mainpage.htm
    • You'll have to disable Require server verification first.
That's it, leave and apply the settings and from now on, MS Project 2003 will work like a charm.

Click here for full resolution


Open Source language checker


LanguageTool is a rule-based language checker that will find errors for which a rule is defined in its XML configuration files or Java code.

You can think of LanguageTool as a tool to detect errors that a simple spell checker cannot detect, e.g. mixing up there/their, no/now etc. It can also detect some grammar mistakes. It does not include spell checking

It has been integrated in OpenOffice's latest 3.0 release, but can be used under 2.x also.

Install instructions in OpenOffice 3.x


Double click LanguageTool-0.9.4.oxt to install it. If that doesn't work, call Tools -> Extension Manager -> Add... to install it.
Close OpenOffice.org and re-start it.

For OpenOffice 2.x use LanguageTool-0.9.2.oxt instead.

MS Office Fonts in OpenOffice Linux

Sometimes you open a MS Office Word document and you discover that some of the fonts don't look equal on your screen, and even worse, look very different on print-outs.

What happens?

MS Office users heavenly use some MS Office specific fonts (like Comic Sans, Webdings), which aren't installed by default on your fresh Ubuntu system. So OpenOffice tries to simulate these with similar fonts, the same applies to the printer driver.

Okay, you could go and setup a font replacement table in OpenOffice, but there's a much quicker way of solving the problem.

Installation of MS Core Fonts


Just install the msttcorefonts package from Synaptic, from the Applications menu or the command line:
sudo aptitude install msttcorefonts

View Office documents

There's OpenOffice so why should I bother to install the Microsoft Office Suite?
  1. Some MS Office documents aren't displayed right with OpenOffice. There are few ones, but it still happens.
  2. Documents with Macros often aren't handled.
  3. You just don't want to start OpenOffice to see a PowerPoint that a friend has send you via email, because it isn't immediately.
Okay, these are some reasons, but I still don't want to install this huge Suite or I'm using Linux so this is no choice.

You don't have to.
There exist free tools from Microsoft which can display Word, Excel and Powerpoint documents, without having installed the Office Suite.
Moreover, they work perfectly with Wine on Linux.

They are simple Viewers, you can't edit the documents, but printing works as well.

You can find them here: