Planned intervention: On Wednesday April 3rd 05:30 UTC Zenodo will be unavailable for up to 2-10 minutes to perform a storage cluster upgrade.
Published July 13, 2015 | Version v1
Conference paper Open

Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them

  • 1. van der Storm, Tijs

Description

Spreadsheets are the most popular live programming environments, but they are also notoriously fault-prone. One reason for this is that users actively rely on copy-paste to make up for the lack of abstraction mechanisms. Adding abstraction however, introduces indirection and thus cognitive distance. In this paper we propose an alternative: copy-paste tracking. Tracking copies that spreadsheet users make, allows them to directly edit copy-pasted formulas, but instead of changing only a single instance, the changes will be propagated to all formulas copied from the same source. As a result, spreadsheet users will enjoy the benefits of abstraction without its drawback.

Files

84_CopyPaste_Tracking_Fixing_Spreadsheet.pdf

Files (137.3 kB)

Name Size Download all
md5:d8fc9307375bb095cad88acff1bfe988
137.3 kB Preview Download