Align numbers to the right.
How to automatically align number to the right using JSS spreadsheets
by Spreadsheet Online
HTML
<script src="https://jspreadsheet.com/v8/jspreadsheet.js"></script>
<script src="https://jsuites.net/v4/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" />
<div id="spreadsheet"></div>
JavaScript
jspreadsheet.setLicense('MGNjZTBmZGRhZDViZWI0MTMzZmU4MWE4MDJlYzM2NmJkYzI3MmZlZGVkMTc4YjE1NmZlNDc2MTg1ZGNkZjZmODQ0YTU5ZDVmZGI4Y2FhMjA0NzM2NDYwOTJlN2U3Yzc5MTQ4M2NlNTQ3NWY4MjQxYzc3OTIzNTFkNGFkOTkyMDQsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UY3hOekU1TmpRd01Dd2laRzl0WVdsdUlqcGJJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0luZGxZaUlzSW14dlkyRnNhRzl6ZENKZExDSndiR0Z1SWpvaU16UWlMQ0p6WTI5d1pTSTZXeUoyTnlJc0luWTRJaXdpZGpraUxDSjJNVEFpTENKbWIzSnRjeUlzSW1admNtMTFiR0VpTENKeVpXNWtaWElpTENKd1lYSnpaWElpTENKcGJYQnZjblJsY2lJc0luWmhiR2xrWVhScGIyNXpJaXdpWTI5dGJXVnVkSE1pTENKelpXRnlZMmdpTENKamFHRnlkSE1pTENKd2NtbHVkQ0lzSW1KaGNpSXNJbU5zYjNWa0lpd2lZbUZ5SWl3aWNISnBiblFpTENKdFlYTnJJaXdpYzJobFpYUnpJaXdpYzJWeWRtVnlJaXdpYVc1MGNtRnphR1ZsZEhNaVhYMD0=');
jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
minDimensions: [8,8],
}],
onchange: function(worksheet, cell, x, y, value) {
if (cell) {
if (jSuites.isNumeric(value)) {
cell.classList.add('jss_number');
} else {
cell.classList.remove('jss_number');
}
}
}
});