Investigate Excel TABLE() array formula support via Office.js API
Takeaway: I went in assuming there might be some Office.js trick to trigger TABLE(), but the honest answer was no — it's genuinely UI-only.
3 sessions on excel with a coding agent: the agent failed at least once in 1, and 2 finished without a human stepping in.
Takeaway: I went in assuming there might be some Office.js trick to trigger TABLE(), but the honest answer was no — it's genuinely UI-only.
Takeaway: Next time I'd start by telling it to actually load the running page with agent-browser instead of trusting typecheck/build passing as proof the UI worked — that's what actually surfaced the real state and let it self-verify.
Takeaway: Next time I'd start the prompt by pointing straight at format-cells.ts and the multi-range support so the agent doesn't have to rediscover it through grep.