Showing posts with label Protected Cells. Show all posts
Showing posts with label Protected Cells. Show all posts

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.

Zero income tax on Capital Gain on sale of house property

We signed agreement to sale our flat in Delhi on 31st March 2025 and started house hunting in Bhopal online immediately on sites like 99acre...