myliang / xspreadsheet Goto Github PK

在表格里输入内容，然后删除，发现无法全部删掉，用的是demo地址

从demo中看到是支持公式的，但是相对较少，是否有扩展计划或扩展方法，比如增加PMT公式，以及“单变量求解”之类的模拟计算。谢谢。

请问如何在Vue中以组件的方式使用？

This is a good project but it seams to be in early development.
I wish to know when an official release will be available.
Also please consider including a CDN and compiled dist in your build process on every release
Great job man

To get [x,y] from A1 for example, I use expr2xy function and it's working fine with single cell. With x & y, now I can get the cell text.

How do we get cell text from merged cell like A1:A4?

单元格中最后一个字符无法删除

I was wondering were the minified js files are
What about documentation and usage examples?

在表格中如果写if这些条件语句，网页会卡死，有考虑集成：formula.js以及ruleJS.js吗？

从xspreadsheet/src/core/alphabet.ts里代码来看，貌似只能支持到26*27-1列，再多就有问题了,可以试试：

const _alphabet = ['A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z']
function alphabet(index: number): string {
  const [a, b] = [parseInt(index / _alphabet.length + ''), index % _alphabet.length]
  return a > 0 ? `${ a > _alphabet.length ? alphabet(a-1) : _alphabet[a - 1]}${_alphabet[b]}` : _alphabet[b]
}

When i hit the enter key after typing in a cell i don't move to the next cell as expected
In a normal spreadsheet pressing enter should move to cell below

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