How to print hidden and protected sheet

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
kumarkutti
Posts: 5
Joined: Thu Oct 25, 2018 5:18 pm

How to print hidden and protected sheet

Post by kumarkutti »

Hi

Please any one can explain how to print hidden and protected sheet

Any macro code available .

I am created one .ods file and i make one (sheet 2) hidden and protected with password . but in print sheet 2 is not printing .

Want sheet2 print also.

Can any one please help me on this ..


Thanking you ..

Edited to remove All Caps [robleyd, Moderator].
OpenOffice 4.1.5 on Windows 10
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: HOW TO PRINT HIDDEN AND PROTECTED SHEET

Post by robleyd »

This topic may give you some clues; I found it by searching the forum for print hidden sheets
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
FJCC
Moderator
Posts: 9277
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: HOW TO PRINT HIDDEN AND PROTECTED SHEET

Post by FJCC »

I just tested that a hidden and protected sheet will print if a print range is defined on it. To define a print range, go to the menu Format -> Print Ranges and choose either Define or Add.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply