Title
Gridlets: Reusing Spreadsheet Grids
Abstract
Spreadsheets allow end users to blend calculations with arbitrary layout and formatting. However, when it comes to reusing groups of formulae along with layout and formatting, spreadsheets provide only limited support. Most users rely on copy and paste, which is easy to learn and use, but maintaining several copies can be tedious and error-prone. We present the concept of Gridlets, an abstraction over calculation and presentation applicable in common use case scenarios. Using the Cognitive Dimensions of Notations framework, we compare Gridlets to copy/paste and sheet-defined functions. We find that Gridlets are consistent with the spreadsheet paradigm, enable users to take advantage of secondary notation, and make common edit operations less viscous and less error-prone.
Year
DOI
Venue
2020
10.1145/3334480.3382806
CHI '20: CHI Conference on Human Factors in Computing Systems Honolulu HI USA April, 2020
Keywords
DocType
ISBN
Spreadsheets, Abstraction, End-User Programming
Conference
978-1-4503-6819-3
Citations 
PageRank 
References 
0
0.34
0
Authors
4
Name
Order
Citations
PageRank
Nima Joharizadeh101.01
advait sarkar227.83
Andrew Gordon33713268.70
Jack Williams402.03