I found a few knowledge base tips regarding the use of JavaScript to
manipulate SpreadJS (the backbone of View Pro)
https://kb.4d.com/assetid=78395 for example.
I also found the following on the SpreadJS website.
var spread =
GC.Spread.Sheets.findControl(document.getElementById('ss'));
var sheet = spread.getActiveSheet();
sheet.options.protectionOptions = {
allowSelectLockedCells: true,
allowSelectUnlockedCells: true,
allowSort: false
};
var option = sheet.options.protectionOptions;
console.log(JSON.stringify(option, null, 2));
I'm going to see if I can figure out how to set this from within 4D.
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
