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:
libgsf-1-114_1.14.25-2_i386
libgsf-1-common_1.14.25-2_all
libgoffice-0.10-10-common_0.10.0-1_all
libgoffice-0.10-10_0.10.0-1_i386
gnumeric-common_1.12.0-1_all

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.

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.