Affiliation:
1. Université Paris-Saclay, CNRS, Inria, France
Abstract
Spreadsheet programs for interactive surfaces have limited manipulations capabilities and are often frustrating to use. One key reason is that the spreadsheet grid creates a layer that intercepts most user input events, making it difficult to reach the cell values that lie underneath. We conduct an analysis of commercial spreadsheet programs and an elicitation study to understand what users can do and what they would like to do with spreadsheets on interactive surfaces. Informed by these, we design interaction techniques that leverage the precision of the pen to mitigate friction between the different layers. These enable more operations by direct manipulation on and through the grid, targeting not only cells and groups of cells, but values and substrings within and across cells as well. We prototype these interaction techniques and conduct a qualitative study with information workers who perform a variety of spreadsheet operations on their own data.
Publisher
Association for Computing Machinery (ACM)
Subject
Human-Computer Interaction
Reference71 articles.
1. Caroline Appert and Shumin Zhai. 2009. Using strokes as command shortcuts: Cognitive benefits and toolkit support. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI’09). Association for Computing Machinery, New York, NY, USA, 2289–2298. 10.1145/1518701.1519052
2. Untidy Data: The Unreasonable Effectiveness of Tables
3. Ann Blandford. 2013. Semi-structured qualitative studies. In The Encyclopedia of Human-Computer Interaction, 2nd edition, Mads Soegaard and Rikke Friis Dam (Eds.). Interaction Design Foundation.
4. D³ Data-Driven Documents
5. Peter Brandl, Clifton Forlines, Daniel Wigdor, Michael Haller, and Chia Shen. 2008. Combining and measuring the benefits of bimanual pen and direct-touch interaction on horizontal interfaces. In Proceedings of the Working Conference on Advanced Visual Interfaces (AVI’08). Association for Computing Machinery, New York, NY, USA, 154–161. 10.1145/1385569.1385595
Cited by
1 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. Challenges of Music Score Writing and the Potentials of Interactive Surfaces;Proceedings of the CHI Conference on Human Factors in Computing Systems;2024-05-11