Add excel capabilities to the data table

[tnrich]

Here's where we're at with this so far:

Screen.Recording.2024-01-26.at.4.17.40.PM.mov

• support formula entry

• make it so Copy Column/Table when allowFormulas=true does not include the headers by default..?

• make sure right clicking clears the existing selection in a datatable

• performance: many columns/rows shouldn't slow down the whole table too much

• typing "=" should cause editing to be started in a cell

• fix bug where double clicking a cell with another cell already open causes the clicked cell to quickly open for editing and then reclose

• clicking the row number should select the whole row

• support cell referencing and auto updating on edit

• make sure more than A-Z rows work (aka AA, AB etc..)

• prevent equivalent formula from updating the undo/redo stack

• allow working with a range of cells/columns A:A or A1:A5 5:5

• make sure row addition/deletion updates cell references

• support dollar sign excel capability ($C$1 fixes the column and row to C1 so that drag down does not go on to C2, C3 etc.)

• make sure column drag updates formulas correctly

• support copy/paste of formulas within table

• allow copy and paste of formula/values into/out of excel

• write tests for various use cases

• (stretch goal) support column reorder

• (stretch goal) support adding/inserting columns

• (stretch goal) add dropdown helper for entering formula, aka start typing SU and get SUM auto completed

• (stretch goal) cell highlighting when entering formulas in cells

• fix mispositioning of "Add 10 Rows" button when there are a LOT of rows:

[tgreen7]

recompute chain not working

Screen.Recording.2024-02-23.at.9.50.45.AM.mov