Write a Blog >>
Mon 11 Oct 2021 14:10 - 14:20 - Helping Programmers Build Chair(s): Michael Coblenz

We explore the idea of adding bidirectionality to spreadsheet formulas, so that editing the output can directly affect the input. We introduce portals: a portal is a value paired with its where-provenance, that is, one or more links to its origin. When a portal is the result of a formula in a cell, that cell inherits the capability to edit the locations described by the provenance of the portal. The simplicity of portals makes them amenable to implementation in an existing spreadsheet system. We analyze the provided functions list of large spreadsheet system and find that many frequently used functions work with portals for free.

Mon 11 Oct

Displayed time zone: Central Time (US & Canada) change

14:10 - 14:50
Helping Programmers BuildResearch Papers / Journal-First Presentations
Chair(s): Michael Coblenz University of Maryland at College Park
Where-provenance for Bidirectional Editing in SpreadsheetsFull paper
Research Papers
Jack Williams Microsoft Research, Cambridge, Andrew D. Gordon Microsoft Research and University of Edinburgh
Applications of model-driven engineering in cyber-physical systems: A systematic mapping studyJournal-first
Journal-First Presentations
Mustafa Abshir Mohamed Independent Researcher, Moharram Challenger University of Antwerp, Geylani Kardas Ege University
Guided Optimization for Image Processing PipelinesShort paper
Research Papers
Yuka Ikarashi MIT CSAIL, Jonathan Ragan-Kelley Massachusetts Institute of Technology, Tsukasa Fukusato The University of Tokyo, Jun Kato National Institute of Advanced Industrial Science and Technology (AIST), Takeo Igarashi The University of Tokyo
A Toolkit for Building More Adaptable User Interfaces for Vision-impaired UsersShort paper
Research Papers
Calvin Luy Monash University, Jeremy Law Monash University, Lily Ho Monash University, Richard Matheson Monash University, Tracey Cai Monash University, Anuradha Madugalla Monash University, Australia, John Grundy Monash University