xspreadsheet
xspreadsheet copied to clipboard
Files not opening properly or opening with console error if aggregate formula is present
If a file contains aggregate formula then x-spreadsheet is unable to handle it properly.
var data = new Uint8Array(responseFromServer); var arr = new Array(); for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]); var bstr = arr.join(""); var workbook = XLSX.read(bstr, {type:"binary"}); const xdata = stox(workbook); x_spreadsheet(document.getElementById("x-spreadsheet-demo"), op).loadData(xdata);