Most common questions and answers
What is the best way to create odd/even rows on a Jspreadsheet spreadsheet and tables?
How to transform multiple HTML static tables in dynamic Jspreadsheet tables?
How to disable paste over a Jspreadsheet spreadsheet?
How to intercept and change a pasted string over a Jspreadsheet table?
How to overwrite a type of a cell over a column type?
How to disabled the javascript contextmenu of my spreadsheet?
How to change the default download filename?
Solution: Adding the following CSS code on your project.
.jspreadsheet tbody tr:nth-child(even) { background-color: #EEE9F1 !important; }
var tables = document.querySelectorAll('table'); for (var i = 0; i < tables.length; i++) { Jspreadsheet(tables[i]); }
jspreadsheet(document.getElementById('spreadsheet'), { onbeforepaste: function(instance, data, x, y) { return false; } });
jspreadsheet(document.getElementById('spreadsheet'), { onbeforepaste: function(instance, data, x, y) { data = data.replace(',', '.', data); return data; } });
jspreadsheet(document.getElementById('spreadsheet'), { columns: [ { type: 'text' }, { type: 'text' }, ], cells: { B2: { type:'number', mask:'$ #,##.00', decimal:'.' }, B3: { type:'percent' }, } });NOTE: Only available from Jspreadsheet Pro v5.
jspreadsheet(document.getElementById('spreadsheet'), { columns: [ { type: 'text' }, { type: 'text' }, ], contextMenu: function() { return false; } });
jspreadsheet(document.getElementById('spreadsheet'), { csvFileName: 'yourname' });