Spreadsheets on Interactive Surfaces: Breaking through the Grid with the Pen - Laboratoire Interdisciplinaire des Sciences du Numérique Access content directly
Journal Articles ACM Transactions on Computer-Human Interaction Year : 2024

Spreadsheets on Interactive Surfaces: Breaking through the Grid with the Pen

Caroline Appert
Emmanuel Pietriga

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.
Fichier principal
Vignette du fichier
spreadsheets_on_interactive_surfaces_HAL.pdf (8.15 Mo) Télécharger le fichier
spreadsheets_on_interactive_surfaces.mp4 (75.22 Mo) Télécharger le fichier
Origin : Files produced by the author(s)
licence : Copyright

Dates and versions

hal-04272550 , version 1 (06-11-2023)

Licence

Copyright

Identifiers

Cite

Vincent Cavez, Caroline Appert, Emmanuel Pietriga. Spreadsheets on Interactive Surfaces: Breaking through the Grid with the Pen. ACM Transactions on Computer-Human Interaction, 2024, 31 (2), pp.16:1-16:33. ⟨10.1145/3630097⟩. ⟨hal-04272550⟩
98 View
34 Download

Altmetric

Share

Gmail Facebook X LinkedIn More