Hi,
I want updated json on add character in cell, currently i am getting only first character of cell in update json, For getting whole updated json i have to change or focus on another cell. So, It is possible to get updated json on change of any single character in cell.

Here i attach screen shot of tables with enter data "at" and in json only get single character "a" .

Please help me to resolve this.

How to load existing excel date or json data

1. Select a cell
2. Type a
3. Press enter
4. Type b

Cell will be bb.

Edit: I am using Firefox 64.0

Breaks easily, to reproduce bug: Put =B1 in A1 and =A1 in B1.

It's neat and fast. I do think that you should consider implementing a few more common excel shortcuts, to make it really seamless to an advanced excel user. For instance:

• CTRL ARROWS: to move on the grid to the next populated cell

• F2: edit the first cell of the selected range

• CTR ENTER: applies the content of the first cell of the selected range to the whole range (after you pressed F2 to edit it)

• when edit mode, pressing down arrow should leave edit mode and move to the cell below

• CTR *: select area

• SHIFT SPACE / CTR SPACE: to select a row / column

XSS refers to Cross Site Scripting.

比如选择框，下拉框，图片上传框等？可以进行数据交互吗？

This is a suggestion of improvement of the UX.
Right-click is not working on the headers but is already working on the cells, offering, among other things, to delete row or column.

Ideally a right-click on the column/row header should offer the possibility to delete the right-clicked row/column.

您好，我是java后端开发，不太了解前端的语言体系，我看您的项目好像是nodejs之类的语言吗？当前我有个javaWeb项目是springboot的，我那个项目目前不是前后端分离，不知道如何才能把你这个插件功能集成进到我的项目里面，我项目的前端比较老还在用jsp，对怎么集成进jsp里面比较疑惑

I've tried to multiply a cell by "2.5" (=A1 * 2.5) and it doesn't work, although it works with integer factors. I've also tried "2,5" instead of "2.5" and the result was the same.

This is a suggestion of improvement of the UX.
We can see Bold, Italic, Strikethrough options but not underline in the demo.
Is underline already implemented but not shown in the demo?

Trying this on StackBlitz.

当文字的长度超过了单元的宽度，点击文本对齐的居中，或者居右，会出现文字溢出到左边单元格的情况，这个怎么解决？

Create i18n feature for future translations.

It should be "A web-based JavaScript spreadsheet". Appears twice in the front page.

I hope you have used inbuilt converter from js to xlsx format.

I am getting a feeling of using Google sheets without too much waiting for loading or login required.

Its like a necessary condition of Download button.

Del key should delete contents of selected cell(s). This is standard functionality in every other spreadsheet and would be great if it functioned the same here.

change:
alphabet.js 文件的第38行，改为 return [parseInt(y, 10) - 1, indexAt(x)];
可以解决问题

划线的逻辑有问题，最后一行和最后一列的线画不出来

您好，我看到您这个excel表格是用canvas标签画的，我有个疑惑，为什么我F12看控制台，发现好多table标签，但是没有一个table标签里面存储我写的数据，并且我Ctrl+F搜索我填的数据，发现在控制台里面找不到，不知道您是把数据存在哪？请问我要怎样把excel上面的数据全部提交到后台去呢

I was wondering what the row limit was?

Is this build using react?

copy table from excel and paste

Hello!

First of all, loving the project-- this looks awesome.

Next, the issue I noticed. Not sure if this is by design or not, but I thought I'd share that I found it a little weird. The scroll event seems to leave the canvas and so as the spreadsheet scrolls the whole thing moves up and down.

I imagine this could be fixed by disabling scroll in the container element(s). CSS is probably enough. Pointing it out not only because it's present in the example, but also because it's worth thinking if this should be the default behaviour or not.

Below is a screen recording of what I mean-- notice how as the cells scrolls the whole interface bounces around (as things do by default on macOS).

FYI, I'm using Chrome 71.0.3578.98 on macOS 10.14.2 (18C54).

Even clicking repeatedly on a single cell did not result in the keyboard popping up and being able to modify content.

Tedted on chrome on Android, might apply to other mobile browsers and platforms as well

Right now the spreadsheet seems blurry on Macbook retina screens that have 2x resolution. Could you enable support for these?

Not able to delete cell

Hello Myliang,
It is possible to display spreadsheet preview without selected any single cell.

Sometimes leading zeros are needed in order to better represent some unit of measure, e.g.:

In fact this is an issue with the "cell pulling" feature, as you can notice that it does not consider what type of data is inserted, since the cells with dates are having the year incremented instead of the day. But if we go step-by-step, fixing the leading zeros would be a good start to improve the "cell pulling" feature.

The speed of the rendering is amazing compared especially to e.g. google sheets. I just informally timed both and gsheets was rendered and editable in 4 seconds whereas this took 0.2 seconds.
However nearly every native UI interaction seems kinda broken. Even entering a value on Firefox doesn't work well. The first letter typed is entered into the cell but then every subsequent letter triggers firefox's fine-in-page (which also doesn't work as others have pointed out). Similarly copy/paste doesn't work, and the context menu (right-click) closes immediately. Maybe it works better in Chrome.

I wonder if there's a case to be made for a hybrid rendering/ui approach here. Rendering could be handled by canvas but native elements swapped in when actual text-editing is invoked?

Cool little demo in any case. I liked some of the simple but effective spreadsheet evaluation code.

by ryanianian

What would you recommend to get the all the data of the spreadsheet as one object without a change event?

I see two methods in the Spreadsheet class: loadData and change.
Could we use a new method "getData" or there's already a way to do that?

Migration to typescript would make it future proof !

Tooltips go into a flicker loop when you hover over the tooltip arrow ( the triangle hanging off of the tooltip box )

Hello,

First of all, thank you for sharing this project which looks very nice.
Is it planned to include a build directly in the repository?

In Windows, ctrl works as the fn key, but in macOS, command works as the fn key in general.

There are some awesome libraries out there could make this easy:
ccampbell/mousetrap: https://github.com/ccampbell/mousetrap
madrobby/keymaster: https://github.com/madrobby/keymaster

Put =A1 in B1, =B1 in A1, demo breaks

hello. great work. is there an option to load just the grid, without the toolbar? it looks lighter than other grid components like Handsontable. thanks!

TAB and ENTER already works as expected.

However the opposite directions do not seem to be implemented:
SHIFT+TAB: move one cell to the left of the current selection
SHIFT+ENTER: move one cell to the top of the current selection

To Reproduce:

1. Load Demo
2. Double click A1
   

Tooltips have serif font while rest of the application has sans-serif. Sent a PR #26 to change this

Dropdowns should close when you click a second time on the dropdown toggle

1. Write 7 into cell A6.
2. Write 3 into cell B6.
3. Write =A6+B6 into cell C6

Cell C6 returns "37" instead of 10.

Suggested solution in cell.js, line 135:

if (srcStack[i] === '+') {
  const top = stack.pop();
  const bottom = stack.pop();
  // Add if numeric. Concatenate otherwise.
  if (!isNaN(top) && !isNaN(bottom)) {
    stack.push(Number(top) + Number(bottom));
  } else {
    stack.push(bottom + top);
  }
}

I'll work up a PR.

I`m sorry, i mean when i set the freeze is 'C4', but the codes draw from the third row and fourth col
that hope draw from the fourth row and third col

This is amazing and fast. I'm complaining about it actually being easily broken only because I really wished this worked well, so I could build on it. It crashed for me on literally the very first thing I tried. I opened up the demo page, typed in 4 numbers in a column (in positions a5,a6,a7,a8), then typed "=sum(a5:a8)" in position a9, hit enter, and the demo crashed (with canvas all messed up). There's a traceback in the console log that starts "Uncaught TypeError: Cannot read property 'render' of undefined at cell.js:146". I'm using Chrome 71. I refreshed and tried the same test and it crashed again.