Hello!
Sorry, but it is possible hide a spreadsheet
with starbasic in calc?
Thank You
Good Life
Fede
LO: 5.2
SO: 10
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
You can do:
oSheet = thiscomponent.sheets.getByName("Sheet1")
oSheet.IsVisible = false
Regards
PS: MRI use is a good advice
OK thank you
Yes, it is possible!
Install MRI and start with programming by yourself, not only with copy and paste from others.
Ok thank you