Mike,
What an embarrassing situation:
- first, we are very close to the final release: the new features are developed, the opened beta is closed, the new documentation and lessons are ready. But the version is not available yet because we have not the Upgrade in the LiveCode store at this very moment.
- second, I kept aside the spreadsheet behavior we discussed here (opening a cell in one click and navigate through cells with the keyboard) because I have thought this was very specific and like I described in one of the post: this is like to try flying with a car. This is possible, but for flying a plane is more adapted. What about rGrid for example?
https://livecode.com/products/thirdpart ... rid-1-5-0/
Even if we might do the following list with DGH (if I'm including the last two points in the final 2.5 release)
- you could have columns named with letter (this is easiest to have them existing in the datagrid than created on the fly like in Excel)
- you could create a first column with the number of the lines
- you could have basic formulae (operation on columns only)
- you could format numbers
- you could edit a cell in one click
- you could navigate through cells with keyboard
You will never have an active cell, no formulae bar, rows are only existing if they are created at some point by anticipation, etc.
So using a datagrid in the hope to turn it in an Excel spreadsheet is not a good idea, in my opinion. For sure, you could have some result depending of your needs but you will never get Excel.
Now to be back to your need: if you want to have something looking like an "insurance form" you have probably not the need to have the datagrid looking exaclty like Excel or I don't see what is the "insurance form" you are trying to implement.
You will probably have the need for editing cells in one click, formulae for subtotals and totals, so some columns with formulae and a grand total line you could have outside of the datagrid. What over?
In this case a datagrid is a possibility and DGH could help you. Especially if I'm including the scripts I have kept for maybe a futur release. Let me know and I will see what I can do.