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
You can do:
oSheet = thiscomponent.sheets.getByName("Sheet1")
oSheet.IsVisible = false
Regards
PS: MRI use is a good advice :)
Yes, it is possible!
Install MRI and start with programming by yourself, not only with copy and paste from others.
Asked: 2017-02-28 23:07:23 +0100
Seen: 73 times
Last updated: Mar 01 '17
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
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
@pierre-yves samyn: Yeah I figured he'd mean that, and I said he got the answer for it.