Search papers, labs, and topics across Lattice.
This paper introduces a benchmark and framework for evaluating next action predictions in spreadsheet applications, addressing the lack of predictive code completion tools in this domain. The authors manually curated a dataset of 52 sequences comprising 12,000 actions to simulate user interactions, overcoming challenges related to the absence of edit histories and the complexity of spreadsheet actions. The proposed online evaluation method allows for real-time prediction and adjustment of future actions, revealing insights into the performance of various predictive models, including zero-shot and fine-tuned approaches.
Predictive models for spreadsheets can be rigorously evaluated, revealing critical insights into user behavior and action prediction accuracy.
Predictive code completion greatly accelerates how quickly developers work. In spreadsheets, despite being much more common, such auto-completion features are virtually non-existent. To address this gap, we introduce a benchmark for systems that observe a sequence of user actions in a spreadsheet and predict future actions. Two challenges are (1) the absence of edit histories in public spreadsheet corpora and (2) the complex space of spreadsheet actions (spatial, temporal, composite). To address (1), we manually curate 52 sequences of 12K actions that recreate spreadsheets from public corpora, seeded by parametrized heuristics and LLM refinement. To address (2), we propose an online evaluation that expects a prediction after each user action, accepts or rejects that prediction, updates the future actions upon acceptance, and repeats this until the target spreadsheet is obtained. We use multiple baseline predictors (including zero-shot LLMs, fine-tuned SLMs, and classical models) and analyze different properties that our benchmark teaches us, including but not limited to: properties of saved actions and false positives, efficiency, effect of user profiles, effect of triggers, and effect of context.
