{
let element = document.getElementById("sheet1")
temp["sheet1"] = {}
element.innerHTML= ""
let mysheet = cdg({...{parentNode: element}, ...{'style': sheet_style}, ...sheet_settings});
mysheet.style.height = '100%';
mysheet.style.width = '100%';
mysheet.addEventListener('datachanged', function (e) {
for (let i in e.data) {
for (let j in e.data[i]) {
let res
try {
res = taylor_js.call(e.data[i][j].slice(1, e.data[i][j].length), temp["sheet1"])
} catch(f) {
res = e.data[i][j]
}
temp["sheet1"][ String.fromCharCode(65+parseInt(j)) +(1+parseInt(i))] = res
}
}
})
mysheet.data = [["Expression","JS Result","EVM Result","","","","","","","","","","","","",""],
["(add 4 5)","=(add 4 5)", "$(add 4 5)"]
,[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]
]
mysheet.addEventListener('afterrendercell', async function (e) {
if (e.cell.value && e.cell.value[0] === "=") {
let res = taylor_js.call(e.cell.value.slice(1,e.cell.value.length), temp["sheet1"])
let loc = e.cell
loc.innerHTML = '<div style="border-top:6px solid #0aa;width:0px;height:0px;border-right:6px solid transparent;top:0px;right:0px" /><div style="font: 16px Roboto Condensed, sans-serif;margin-left:6px;top:-3px;">'
+ res
+ '</div>';
taylor_web3.call(e.cell.value.slice(1,e.cell.value.length), temp["sheet1"]).then(x=>{
console.log("x",x, res, x == res)
loc.innerHTML = '<div style="border-top:6px solid #af0;width:0px;height:0px;border-right:6px solid transparent;top:0px;right:0px" /><div style="font: 16px Roboto Condensed, sans-serif;margin-left:6px;top:-3px;">'
+ res
+ '</div>';
})
}
if (e.cell.value && e.cell.value[0] === "$") {
//let self = e.cell
let res = taylor_js.call(e.cell.value.slice(1,e.cell.value.length), temp["sheet1"]) // taylor_web3.call(e.cell.value.slice(1,e.cell.value.length), temp["sheet1"])
console.log(res)
e.cell.innerHTML = '<div style="border-top:6px solid #af0;width:0px;height:0px;border-right:6px solid transparent;top:0px; right:0px; position:relative;" /><div style="font: 16px Roboto Condensed, sans-serif;margin-left:6px;top:-3px;">'
+ res
+ '</div>';
// taylor_web3.call(e.cell.value.slice(1,e.cell.value.length), temp["sheet1"]).then((x) => {
// self.innerHTML = '<div style="border-top:6px solid #aa0;width:0px;height:0px;border-right:6px solid transparent;top:0px;right:0px" /><div style="font: 16px Roboto Condensed, sans-serif;margin-left:6px;top:-3px;">'
// + x
// + '</div>';
// //self.draw()
//console.log(331133, e.cell.value.slice(1,e.cell.value.length), await taylor_web3.call(e.cell.value.slice(1,e.cell.value.length), temp["sheet1"]))
// })
//console.log(3333)
}
});
mysheet.addEventListener('endedit', function (e) { // datachanged
//console.log(e, e.cell.data)
temp["sheet1"][e.cell.header.title+(e.cell.rowIndex + 1)] = e.value
});
}