The idea about this extension comes after to discuss this issue in the forum community ( ).īy the way, credits for the volunteer “Charlie Young” by the idea about to use a listener checking for the active sheet.
#Openoffice calc help print gridlines install
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 or 1.2” and follow the instructions inside the “Read_me.txt” file to get installation alternatives.
The extension installation package was tested in OpenOffice 3.2 and 3.3 and works nice. Don't forget to restart the OpenOffice after the installation. It's necessary to run the listener that intercepts the active sheet.Īfter 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”. You will need to reset the grid lines view in two cases:ġ) When you re-open the Calc file, after close it andīut, anyway, in both cases you reset it just by clicking the same button. By the way, you can change how many sheets you want.
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. Click the File tab, and then click Print. On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.
Select the worksheet or worksheets that you want to print. All you need to do is to click the button and the active sheet grid lines will be hidden or shown. This article describes how you can make the gridlines appear in your printed worksheets. You do NOT need to write anything inside the macro. 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 and LibreOffice do.
0 kommentar(er)
