Star
Back to Examples

Spreadsheet comments

The javascript spreadsheet plugin allows the user to set custom comments for each individual cells. By allowComments in the initialization, the user will be able to add comments in the rigth click contextMenu.



Manage cell comments programmatically

To apply comments via javascript, you can use the methods setComments or getComments, as follow:



Source code

<html>
<script src="https://bossanova.uk/jspreadsheet/v4/jexcel.js"></script>
<link rel="stylesheet" href="https://bossanova.uk/jspreadsheet/v4/jexcel.css" type="text/css" />

<script src="https://jsuites.net/v4/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" />

<div id="spreadsheet"></div>

<script>
var data1 = [
    ['US', 'Cheese', '2019-02-12'],
    ['CA', 'Apples', '2019-03-01'],
    ['CA', 'Carrots', '2018-11-10'],
    ['BR', 'Oranges', '2019-01-12'],
];

mySpreadsheet = jspreadsheet(document.getElementById('spreadsheet'), {
    data:data1,
    columns: [
        {
            type: 'dropdown',
            url:'https://bossanova.uk/jspreadsheet/v4/countries',
            width:200,
        },
        {
            type: 'text',
            width:200,
        },
        {
            type: 'calendar',
            width:200,
        }
     ],
     allowComments:true,
});
</script>

<button type="button" onclick="mySpreadsheet.setComments('A1', 'This is the comments from A1');" style="width:220px;">Set A1 comments</button>
<button type="button" onclick="alert(mySpreadsheet.getComments('A1'));" style="width:220px;">Get A1 comments</button>
<button type="button" onclick="mySpreadsheet.setComments('A1', '');" style="width:220px;">Reset A1 comments</button>

</html>