Service interruption on Monday 11 July from 12:30 to 13:00: all the sites of the CCSD (HAL, Epiciences, SciencesConf, AureHAL) will be inaccessible (network hardware connection).
Skip to Main content Skip to Navigation
Conference papers

Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them

Abstract : 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 drawbacks.
Document type :
Conference papers
Complete list of metadata
Contributor : Tijs Van Der Storm Connect in order to contact the contributor
Submitted on : Monday, June 14, 2021 - 9:40:28 AM
Last modification on : Wednesday, February 2, 2022 - 3:52:32 PM
Long-term archiving on: : Thursday, September 16, 2021 - 8:21:13 AM


Files produced by the author(s)


  • HAL Id : hal-01261473, version 1



Felienne Hermans, Tijs van Der Storm. Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them. ICLC 2015 - The first International Conference on Live Coding, Jul 2015, Leeds, United Kingdom. ⟨hal-01261473⟩



Record views


Files downloads