How to hide a spreadsheet

Hello!

Sorry, but it is possible hide a spreadsheet
with starbasic in calc?

Thank You

Good Life

Fede

LO: 5.2
SO: 10

Hi

You would have a response corresponding to your need if you specify them: do you want to hide a spreadsheet when it is opened, or hide an already opened spreadsheet? Do you want to hide the spreadsheet or one of its sheets?

Regards

Sorry, It was not clear;
I would like to hide one or more sheets

Thank you, Pierre

AFAIK, ‘spreadsheet’ is the whole file, while ‘sheet’ is a tab, or officially known as sheet, in the file. That’s the distinction. Hiding the file in true sense is impossible without changing the name and file extension, and if someone wants to find a spreadsheet he can use systems like the magic detection on NIX through file. Hiding a sheet in the file is another story to which you got an answer, but I’m pretty sure it can be found out even without seeing the code used to hide it.

Hi @rautamiekka

This is not to hide the document in the file system. It is possible and common to open a spreadsheet (or other document) hidden by macro. See
API

Regards

@PYS: Yeah I figured he’d mean that, and I said he got the answer for it.

You can do:

oSheet = thiscomponent.sheets.getByName("Sheet1")
oSheet.IsVisible = false

Regards

PS: MRI use is a good advice :slight_smile:

OK thank you :slight_smile:

Yes, it is possible!

Install MRI and start with programming by yourself, not only with copy and paste from others.

Ok thank you :slight_smile: