Spreadsheets on Interactive Surfaces: Breaking through the Grid with the Pen - Interacting with Large Data
Article Dans Une Revue ACM Transactions on Computer-Human Interaction Année : 2024

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

Caroline Appert
Emmanuel Pietriga

Résumé

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
Origine Fichiers produits par l'(les) auteur(s)
licence
Copyright (Tous droits réservés)

Dates et versions

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

Licence

Copyright (Tous droits réservés)

Identifiants

Citer

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⟩
221 Consultations
103 Téléchargements

Altmetric

Partager

More