I am loading csv file data into editor. I select the row→copy the row→add new row above→trying to paste row then I am getting error like:
handsontable.min.js:56 Uncaught TypeError: Cannot read properties of undefined (reading ‘sanitize’)
my code:
<div id="editor"></div>
<script>
var fileContent = <?= json_encode($contentString) ?>;
var fileName = "<?= htmlspecialchars($fileName) ?>";
let editor = '';
const HEARTBEAT_INTERVAL = 10 * 60 * 1000; //1000=1 second;
let hot;
function initSpreadsheet() {
// Parse CSV → array
const parsed = Papa.parse(fileContent, {
skipEmptyLines: false
});
hot = new Handsontable(document.getElementById('editor'), {
data: parsed.data,
rowHeaders: true,
colHeaders: true,
renderAllRows: true,
colWidths: 120,
selectionMode:'multiple',
licenseKey: 'non-commercial-and-evaluation',
contextMenu: true,
manualColumnResize: true,
manualRowResize: true,
copyPaste: true,
// stretchH: 'all',
height: 'calc(100vh - 40px)',
afterChange: function(changes, source) {
if (source === 'loadData') return;
markDirty();
},
afterCreateRow: function() {
markDirty();
},
afterRemoveRow: function() {
markDirty();
},
afterCreateCol: function() {
markDirty();
},
afterRemoveCol: function() {
markDirty();
},
});
}