Problem
Research questions and friction points this paper is trying to address.
Spreadsheet
Reference Semantics
User Expectations
Bugs
Kale: A Transformation-Safe Spreadsheet System
🤖 AI Summary
本文提出Kale系统，通过限制可表达的引用类型来解决电子表格中因结构变化导致的引用错误问题。
📝 Abstract
Spreadsheet formulas can refer to rectangular ranges of arbitrary size. When a user changes the structure of a referenced table, the spreadsheet system updates the references to refer to a new range. Unfortunately, this new range may differ from the user's expectations, introducing bugs in spreadsheets. We describe a user study showing that standard reference semantics are error-prone, resulting in significant risk to users. We introduce Kale, a prototype system that eliminates the risk of inserting these kinds of bugs by restricting the kinds of references that can be expressed. We show that Kale can be used effectively by users to complete tasks that are error-prone in traditional spreadsheet systems. Finally, we describe a corpus study that evaluates the extent to which the reference restrictions in Kale might have implications on users.
Innovation
Methods, ideas, or system contributions that make the work stand out.
Transformation-Safe
Reference Semantics
Spreadsheet System
🔎 Similar Papers
No similar papers found.
