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: 'NzZlN2Q1MWZjZmI1NzQ0YjRiNTg1MzQyMDczYTA2MzM1MDA5OGRmYTIxMjhlYzc1ZDlhZDM3MmVjYWU1MDljMDJkZDYwYmJlYjBjMmZmZDNhNmI1OTUzODhlZjZjNDRiNzYxNjIyN2ZmMzEzMmIxNTJkZjI3M2JkYjdmY2IwYzMsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTNOakF3TURReU9Td2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0=', }); </script> <p><input type="button" value="Disabled B2" onclick="toggle(this)"></p> </html>