This extension allows you to hide or show the grid lines on a sheet of a Calc file with multiple sheets, without affecting the other sheets, just by clicking a button, just the way Excel does.
You do NOT need to write anything inside the macro. All you need to do is to click the button and the active sheet grid lines will be hidden or shown. Even if you go to another sheet, every time you go back to the sheet you changed, it will be in the way you left it. By the way, you can change how many sheets you want.
After the installation, it will create a new library called “GrdiLinesLib” inside the “My Macros” container and it will add a new menu in “Tools\Add-ons” and a new toolbar that can be viewed by “View\Toolbars”.
Don't forget to restart the OpenOffice after the installation.
The extension installation package was tested in OpenOffice 3.2 and 3.3 and works nice. Any way, if you have a problem to install in your OpenOffice by the extension manager, then after download the extension, unzip the installation file named “GridLines_v1.1.oxt” and follow the instructions inside the “Read_me.txt” file to get installation alternatives.