LibreOffice 4.1 Solver example

While going through my accounting I found some discrepancies. So I needed to go through a long list of numbers and check whether they have been included in the totals I was checking.
Of course I would like not having to spend hours doing this, so I decided to find out how I could do this using LibreOffice Calc an save myself a lot of time. The time spent making the calculation is now about 1 second. (The time spent figuring this out... Let's just say hours....)

LibreOffice 4.1 password protected document

Another release of LibreOfice have been announced and I was quick to download

and install version 4.1. I must admit I have been a big fan of LibreOffice from their first release, but there are still a few bugs that I find annoying. Unfortunately I found a new bug in v.4.1, or at least I thought so...

Free E-books

Just a quick tip for everyone who likes to learn more.
At BookBoon.com you'll find a few good pdf-books free to download.


As always there is a small cath; there are a few adverts in these books.

Encrypted storage

In case you have documents and files you don't want anyone to be able to see there is always the possibility to use truecrypt. Truecrypt will let you use a file or partition as an encrypted storage. It is easy to use and not at all hard to understand. It also supports Linux, Windows and Mac so you can use it on whatever platform you wish.

Truecrypt is no longer safe.
Check their website before using it.

You can even encrypt part of an USB-pendrive and include the files for running the truecrypt program on the USB-drive. This way you will be able to use you USB-device on other computers without needing to install the package on the computer you are working on. (But you will need admin privileges.)

To download TrueCrypt head over to their web-site. Go to the download page and download the package for your platform. After downloading the Linux gzipped tarball you simply extract it and run the truecrypt installation-file.

Step 1:
Run truecrypt to open the GUI for the program and create a new encrypted volume. Using a file is as it can be. Click on Create Volume, select the folder to put the file in, and give it a filename. Follow the instructions to set the encryption, password and any other option.

Step 2:
In the TrueCrypt main window select the slot you want to put your encrypted volume in, click on Select File and navigate to the file you created in the previous step. Click on Mount and type your password for the encrypted filesystem when prompted.

Step 3:
Add files or folders to your encrypted filesystem as you do to any filesystem.

That's all there is to it.
Easy and well functioning way of keeping some documents private.
To use a portable USB-drive check the documentation on TrueCrypt web-site.

Linux Tutorials

Linux has become the preferred OS for me and my company. Not only for the fact that it is free, but also because of the possibilities it gives us.

For a small company as ours Linux is the perfect solution. It provides us with a stable and secure platform for our servers running mail, webserver, fileserver, printserver, automated backups and a lot more.

Of course we need to know a thing or two about installing it and setting up the various components . And I am always looking for more information on how to configure and setup different parts of Linux and other Open Source Software.

Recently I found out that linux.org had redesigned their site and of course I had to take a look at it.