Examples
Readonly cells
It is possible to set a column or single specific cell as readonly.
Source code
<script src="https://jspreadsheet.com/v7/jspreadsheet.js"></script> <script src="https://jsuites.net/v4/jsuites.js"></script> <link rel="stylesheet" href="https://jspreadsheet.com/v7/jspreadsheet.css" type="text/css" /> <link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" /> <div id="spreadsheet"></div> <script> var toggle = function(b) { if (table.isReadOnly('B2')) { table.setReadOnly('B2', false); b.value = 'Disable B2'; } else { table.setReadOnly('B2', true); b.value = 'Enable B2'; } } var data = [ ['Mazda', 2001, 2000, 1], ['Pegeout', 2010, 5000, 1], ['Honda Fit', 2009, 3000, 1], ['Honda CRV', 2010, 6000, 0], ]; var table = jspreadsheet(document.getElementById('spreadsheet'), { data: data, columns: [ { type: 'text', title:'Description', width:'200px', readOnly:true, }, { type: 'text', title:'Year', width:'200px' }, { type: 'text', title:'Price', width:'100px', mask:'#.##', }, { type: 'checkbox', title:'Automatic', width:'100px' }, ], updateTable: function(el, cell, x, y, source, value, label) { if (x == 2 && y == 2) { cell.classList.add('readonly'); } }, license: 'NDc4ZDc3NWJiNjIzNzU4MTVmNjA4MjdlYjk1MjlmZDZiYzk4MWM3ZmM2OTdiZDczOWQ2MGRkZjdhNTc4ODExNmMyMDZkZDIwNzExYzJmM2EwOTBiYWUxM2M0NGY1YzNiZmVmZTY1OGY5OWI2ZDg2NDMyNjgwOTFhZGQ2MzVlYmEsZXlKdVlXMWxJam9pY0dGMWJDNW9iMlJsYkNJc0ltUmhkR1VpT2pFMk5EY3pPRGc0TURBc0ltUnZiV0ZwYmlJNld5SnFjMmhsYkd3dWJtVjBJaXdpWTI5a1pYTmhibVJpYjNndVkyOXRJaXdpYW5Od2NtVmhaSE5vWldWMExtTnZiU0lzSW1OellpNWhjSEFpTENKalpIQnVMbWx2SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXlJbjA9', }); </script> <p><input type="button" value="Disabled B2" onclick="toggle(this)"></p> </html>