xspreadsheet icon indicating copy to clipboard operation
xspreadsheet copied to clipboard

Files not opening properly or opening with console error if aggregate formula is present

Open ghost opened this issue 2 years ago • 0 comments

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);

ghost avatar Jan 31 '23 08:01 ghost