Examples
Multiple worksheet formulas
The usage of formulas across multiple worksheets is possible using a similar excel syntax.
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://jsuites.net/v4/jsuites.css" type="text/css" /> <link rel="stylesheet" href="https://jspreadsheet.com/v7/jspreadsheet.css" type="text/css" /> <div id="spreadsheet"></div> <script> var data1 = [ ['Cheese', 10, 6.00, "=B1*C1"], ['Apples', 5, 4.00, "=B2*C2"], ['Carrots', 5, 1.00, "=B3*C3"], ['Oranges', 6, 2.00, "=B4*C4"], ]; var data2 = [ ['20%', "=SHEET1!D1"], ['20%', "=SHEET1!D2"], ['20%', "=SHEET1!D3"], ['20%', "=SHEET1!D4"], ]; jspreadsheet(document.getElementById('spreadsheet'), [ { data: data1, minDimensions: [5,5], defaultColWidth: '100px', license: 'NTVlZmU5ZDY2OWRjNzExYzIwZDY5NjE3NjBkZWJiNTJiZWM5NWY3NWFhMTNhYmI1OTIwMzUwMWQzYjRkZGMwMWFmMGYwNjk3MjAzMGY1MWM3ZjA5YjU3ZGE2NTdiMWRmMzNjNTk0Njg0Zjg0OWU1Y2U1ZjU1YzU3N2NmZDhmNjUsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTNOVGs1T1RRMk55d2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0=' }, { data: data2, minDimensions: [5,5], defaultColWidth: '100px', license: 'NTVlZmU5ZDY2OWRjNzExYzIwZDY5NjE3NjBkZWJiNTJiZWM5NWY3NWFhMTNhYmI1OTIwMzUwMWQzYjRkZGMwMWFmMGYwNjk3MjAzMGY1MWM3ZjA5YjU3ZGE2NTdiMWRmMzNjNTk0Njg0Zjg0OWU1Y2U1ZjU1YzU3N2NmZDhmNjUsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTNOVGs1T1RRMk55d2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0=' }, ]); </script> </html>