Most frequently asked questions and answers
Jspreadsheet converts a string to a number.
What is the best way to create odd/even rows in an online spreadsheets?
How do I transform multiple HTML static tables to dynamic Jspreadsheet tables?
How do I disable paste over a JSS spreadsheet?
How can I intercept and change a pasted string over a JSS spreadsheet?
How do I overwrite a type of a cell over a column type?
How do I disabled the JavaScript contextmenu in my spreadsheet?
How do I change the default download filename?
How do I add an external action without losing the spreadsheet focus?
How do I keep the selection in the spreadsheet when clicking on an element outside the sheet?
How do I automatic align numbers to the right using JSS spreadsheet?
This is because autoCasting is set as default. It tries to improve the calculations by converting a string to a number. Solution: set autoCasting: false as a property in the column definitions.
... columns: [{ type:'text', autoCasting: false }]
Solution: Add the following CSS code to your project.
.jss 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'), { worksheets: [{ minDimensions: [6,6], }], onbeforepaste: function(instance, data, x, y) { return false; } });
jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [{ minDimensions: [6,6], }], onbeforepaste: function(instance, data, x, y) { data = data.replace(',', '.', data); return data; } });
jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [{ columns: [ { type: 'text' }, { type: 'text' }, ], cells: { B2: { type:'number', mask:'$ #,##0.00', decimal:'.' }, B3: { type:'percent' }, } } });NOTE: Only available from Jspreadsheet Pro v7.
jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [{ columns: [ { type: 'text' }, { type: 'text' }, ], cells: { B2: { type:'number', mask:'$ #,##0.00', decimal:'.' }, B3: { type:'percent' }, } }, contextMenu: function() { return false; } });
jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [{ minDimensions: [6,6], }], csvFileName: 'yourname' });
Working example:
https://jsfiddle.net/spreadsheet/v5tbxg01/Add a class to the external element: jss_object
Working example:
https://jsfiddle.net/spreadsheet/Lfxm6qw1/