Monday, January 26, 2015

LibreOffice - Referencing cells

At times I need to summarize values from another sheet in Libre Office, and get an output that will group some values together. In my example I have a small table that could contain from 10 to 1000 rows. The table I want is to be grouped by date, and I want to know how much I have spent on a specific day.

Friday, March 7, 2014

Cleaning out linux-image-x.x.xx-xx-* files

I was suddenly denied access to my in-house web-server with a message telling me the disk is full. After a quick check with df -h I could confirm the root partition used 100%.
First I started to look for "user -files" I could remove, but found out there wasn't all that many of them. Most of the usage was in the folders /lib, /usr and /var. A quick question to my friend google took me in the direction that there could be some linux-image files no longer used that were spending my disk.
Some more searching gave me the following solution to removing these unused kernel files:

Wednesday, January 29, 2014

Personal emails - Mail Merge add-on

 About a year ago I added some info about this little add-on for thunderbird calle Merge Email. I then described how-to use the address-book to make merged emails. Since I am a bit of a fan of this add-on I'll describe using it with a csv-file.

Thursday, January 23, 2014

Making or burning ISO images

I was given a burned CD from a friend and decided to make an ISO image of that particular CD. Currently I'm using Ubuntu 12.10 and decided to use the Linux-command: dd

But to my surprise; IT WOULDN'T WORK!!! I have always used that command to make an ISO image, so now I had to figure out why this is not working, and how I could make it work.

Monday, January 20, 2014

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....)

Thursday, January 16, 2014

Formatting phone numbers in LibreOffice

Every now and then I need to setup a list containing phone numbers in Libre Office Calc. When the phone numbers are listed I need to have them formatted in 3+2+3 digits. (Or else I'm unable to separate the digits when I am going to make the call.)

Here's the trick how to do this:
In the phone number column I'll select the entire column or the cells I need the formatting on.
Right click the selected area and click Format Cells
In the Numbers tab, I insert the following as Format Code:
###" "##" "###

Make sure to add the space between the " and ".

Correctly inserted phone numbers should now look like: 123 45 789
(A lot better for my ageing eyes.)