I have written an application to create a spreadsheet. I unprotect certain cells, and then protect the entire sheet
Thissheet.protect("")
The only parameter is password. Since I don’t want a password, I give it a blank string, since the parameter is not optional.
This all works. The question is what is the parameter that unchecks the “Select protected cells” option? The IDE shows this option checked. I want to be able to do it through LibreOffice Basic.
It is nothing majour. I could go into the IDE and manually unprotect/protect all the sheets and while protecting the sheets, uncheck “Select protected cells”. I would, however prefer to do it in code.
Any help would be appreciated.
While here I would like to make a comment about LibreOffice. Specifically about developing code. At times I have found it very frustrating to try to find parameters and methods. I have had a lot of help in this forum. One thing that amazes me is the speed that the code executes. The application creates, and formats 13 sheets, and adds 2 charts on each sheet. This takes less than 12 seconds. This is a rewrite of an EXCEL spreadsheet. With disabling screen updating the VBA version still took over a minute.
John