
Spreadsheet comments New
The JSS advance comments provides an easy way for your users to add multiple comments to a cell, that includes information about the user and date.Author
Jspreadsheet Pro Team.License
Available on the premium edition only.Installation
Please choose one of the following optionsUsing CDN
Using NPM
<html> <script src="https://jspreadsheet.com/v9/jspreadsheet.js"></script> <script src="https://jsuites.net/v4/jsuites.js"></script> <link rel="stylesheet" href="https://jspreadsheet.com/v9/jspreadsheet.css" type="text/css" /> <link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" /> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" /> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@jspreadsheet/comments/dist/style.min.css" type="text/css" /> <script src="https://cdn.jsdelivr.net/npm/lemonadejs/dist/lemonade.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/comments/dist/index.min.js"></script> <div id='spreadsheet'></div> <script> // License for Formula Plugin jspreadsheet.license = 'your-license'; // Add-on for Jspreasheet jspreadsheet.setExtensions({ comments }); // Define the information about the user jspreadsheet.comments({ user_id: 1000, name: 'John Lennon', image: 'img/lennon.png' }); // Create the spreadsheets jspreadsheet(document.getElementById('spreadsheet'), { toolbar: true, worksheets: [ { minDimensions: [8,10], comments: { // Advance comments receive an object A3: [ { name: 'George Michael', image: 'img/4.jpg', date: '2022-04-28 12:00:21', comments: 'Please can you try that one?', }, { name: 'Miguel Rodrigues', image: 'img/7359.jpg', date: '2022-05-01 00:00:21', comments: 'Yes. Can you send more details about the calculations?', } ], // Simple comments (notes) F1: 'test', } }, ], }); </script> </html>
// Jspreadsheet Pro import jspreadsheet from 'jspreadsheet'; // Import extension import comments from '@jspreadsheet/comments'; // Add a valid license jspreadsheet.setLicense('your-license'); // Start the JSS plugin jspreadsheet.setExtensions({ comments }); // Define information about the user jspreadsheet.comments({ user_id: 1000, name: 'John Lennon', image: 'img/lennon.png' }); // Create a spreadsheet jspreadsheet(document.getElementById('spreadsheet'), { toolbar: true, worksheets: [ { minDimensions: [8,10], comments: { A3: [ { name: 'George Michael', image: 'img/4.jpg', date: '2022-04-28 12:00:21', comments: 'Please can you try that one?', }, { name: 'Miguel Rodrigues', image: 'img/7359.jpg', date: '2022-05-01 00:00:21', comments: 'Yes. Can you send more details about the calculations?', } ], F1: 'test', } }, ], });