ukadakal
The file format docs don't tell you everything about how Excel or Word actually behaves. And a collection of public files will only get you so far. A lot of the weird stuff shows up in proprietary files that customers have been building and modifying for years.
You get a file from one customer, find a case you've never seen, figure out what Office does, implement it, and make sure you haven't broken something else. Then the next customer sends you another one, and so on.
That cycle takes years. Reading and writing DOCX or XLSX is great, but getting close to full compatibility is a much bigger job.
Over the years, we’ve seen many platforms promise to replace spreadsheets for a particular use case or industry. Businesses adopt them and push users away from Excel, but in many cases, those same users eventually find their way back to Excel to do the exact same work.
My concern is that we may end up creating another dual-system maintenance problem, where some people use AI and others continue using Excel for the same business process. Over time, the two versions inevitably diverge, potentially creating more problems than they solve.
Excel is much stickier than most people realize. I think the more interesting opportunity is figuring out how AI and Excel can work together, rather than trying to replace one with the other.
I was playing around with it this morning and tested it on a fairly large Excel model with lots of spillable dynamic arrays used as intermediate calculations. I was able to replace those spill ranges with arrays in cells, and all the formulas referencing those results continued to work nicely. In many cases, enabling it was as simple as adding {} around the existing dynamic array formula. That huge workbook immediately looked much cleaner without all those helper spill ranges taking up space.
I think that's where the immediate value is. It simplifies helper ranges and intermediate calculations, reduces potential #SPILL! issues, and makes complex models easier to build, understand, and maintain.
It could also be interesting when combined with LET and LAMBDA, allowing custom formulas to work with arrays without exposing all their intermediate results across the worksheet.
I think it will become considerably more useful, once it supports features like charts, Power Query, and data validation.
Curious how extensive the formula support is. How many Excel functions do you currently support, and how do you handle more complex formulas and dependencies between cells or dynamic array formulas, etc.?