Examples
Custom formulas
You can create custom JavaScript methods and use in your spreadsheet as the example below.
IMPORTANT: All methods names should be created using capital letters.
Source code
<html> <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 COLORIZE = function(v) { var d = document.createElement('div'); d.style.color = v; d.innerText = v.toUpperCase(); return d; } var data = [ [ 'red', '=COLORIZE(A1)' ], [ 'green', '=COLORIZE(A2)' ], [ 'blue', '=COLORIZE(A3)' ], ]; jspreadsheet(document.getElementById('spreadsheet'), { data:data, columns: [ { type: 'text', width:'300' }, { type: 'text', width:'200' }, ], license: 'MzJkYjdkNDhlZmIzYTRmMzc1MTgxMjQyMzFlMWUyMDgwNmIwZGZjNTBjMzM0OTQ0NzM5ZGE0OTg0OWIwNzQwMmZkY2YwMzhkYTg5ODU5MzBmNDg1MWFkZTExN2IzYzdiM2NlNWEyNmRhMzBjODgwZjhmYjk2MDEyN2Q0Y2E4MGUsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTNOakF3TkRVd05Dd2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0=', }); </script> </html>