Friday, February 22, 2013

How to install Gnumeric 1.12.0 on Ubuntu from Debian Sid.

I have become fan of Gnumeric.

Earlier I was unable to open one .xlsx file (which I use to get daily as MIS) in Libre Office 3.5.4 but I could open it in Gnumeric. In fact I had submitted a bug for Libre Office on Launchpad.

As soon I knew about release of Libre Office 4.0 I installed it as indicated in this post. The file opens quickly in this version of Libre Office.

Afterwards I found that Excel file locked i.e. main sheet protected by password but I could open the lock in Gnumeric as indicated in this post.

As a fan of Gnumeric I decided to install the latest version and downloaded gnumeric_1.12.0-1_i386.deb from Debian Sid.

When I clicked on the .deb file Software Centre complained of following dependencies one by one:

I downloaded all the above packages from Debin Sid. Before installing Gnumeric 1.12, I had to remove installed gnumeric-common and gnumeric packages.

At last Software Centre complained broken cache but installed gnumeric on second attempt.

Tuesday, February 19, 2013

How to edit protected Excel Sheet using Gnuneric.

I am getting an MIS Report every day in Microsoft Excel. Although there is no need to change the contents of the file I clicked out of curiosity on one of the cells and found that I could not read the formula. When I right clicked on Sheet Tab I found the sheet protected with a password.

Since I use Libreoffice I searched about how to crack the password and found a couple of lengthy solutions.

I also keep Gnumeric on my machine. I opened the file in Gnumeric, right clicked on Sheet Tab, selected Manage Sheets and clicked on Lock icon. I was surprised to find that the lock opened without any password. After saving I could edit that file in Libreoffice.

I suppose this is possible in Gnumeric on Windows as well.

Gnumeric is a fantastic software.

Monday, February 18, 2013

Ubuntu 12.04.2 has new Linux Kernel.

Ubuntu 12.04.2 has been shipped with Linux Kernel 3.5.0-23. I have downloaded the iso for Ubuntu 12.04.2 and running it now from USB disk.
Typing uname -a in the terminal gives:
Linux ubuntu 3.5.0-23-generic #35~precise1-Ubuntu SMP Fri Jan 25 17:15:33 UTC 2013 i686 i686 i386 GNU/Linux

I am having some issues on my Laptop running updated Ubuntu 12.04 like it hangs but pressing ctrl+alt+f1 opens a terminal in which I can reboot. Sometimes the Keyboard too does not work and I long press the power key.

I didn't find any issue running the Laptop on USB disk, therefore, I upgraded the kernel on installed Ubuntu 12.04. The command is:
sudo apt-get install linux-generic-lts-quantal xserver-xorg-lts-quantal

This also upgraded Xorg.

I am happy on Linux Kernel 3.5 and removed Linux Kernel 3.2 completely with headers.

You can read all about Kernel/LTS Enablement  stack on this page.

Friday, February 08, 2013

Install Libreoffice 4.0 on Ubuntu 12.04.

LibreOffice 4.0 was released on 7th Feb 2013.

Update: As on 4th March PPA for Libreoffice 4.0 is available. You can add the PPA by following command:
sudo add-apt-repository ppa:libreoffice/libreoffice-4-0
sudo apt-get update

Although I use LTS versions of Ubuntu, I upgrade the packages to latest by using relevant PPAs, however, I continued with Libreoofice 3.5 the version on Ubuntu 12.04.

Today I read about release of LibreOffice 4.0 and I decided to install since it may take sometime before PPA for Libreoffice 4.0 arrives for Ubuntu 12.04.

I downloaded the debs from

Libreoffice 4.0 can be installed without removing the default Libreoffice 3.5 on Ubuntu 12.04 as per procedure on this page, however I removed the installed version of Libreoffice:
sudo apt-get purge libreoffice*

After opening the terminal in the directory containing the DEBS I installed Libreoffice 4.0
sudo dpkg -i *.deb
cd desktop-integration
sudo dpkg -i *.deb

After installing you can click on Dash and search for "libreoffice" and open Writer. After it is open you can lock the icon on the launcher. Similarly you can open Calc from Dash and lock the icon on the launcher.

On Kubuntu 12.04 or any other distribution you can run the following command to start Libreoffice 4.0

It is working fine but Menu integration with Unity Desktop is not working and it is not working in Ubuntu 13.04 either.

You can chose Firefox Themes in Libreoofice 4.0. I have installed Underwater Dolphins Theme:

Saturday, February 02, 2013

How to combine multiple .flv files into one

Sometimes you download .flv files in parts e.g. Presentation_Part1.flv Presentation_Part2.flv but you would like to see the whole presentation using one file. After searching I found this thread on Ubuntuforums.

The forum post suggests to convert the .flv files to .mp4 files by using the following command:
$ for f in *.flv; do ffmpeg -i "$f" -vcodec copy -acodec copy "${f%.flv}.mp4"; done

By using the above command the 1.flv, 2.flv, 3.flv get converted to 1.mp4, 2.mp4, 3.mp4 etc.

The *.mp4 files get combined into test.mp4 by using following command:
$ MP4Box -add 1.mp4 -cat 2.mp4 -cat 3.mp4 -cat test.mp4