Conference paper Open Access

Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them

Hermans, Felienne

JSON-LD ( Export

  "description": "<p>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.</p>", 
  "license": "", 
  "creator": [
      "affiliation": "van der Storm, Tijs", 
      "@type": "Person", 
      "name": "Hermans, Felienne"
  "headline": "Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them", 
  "image": "", 
  "datePublished": "2015-07-13", 
  "url": "", 
  "@type": "ScholarlyArticle", 
  "keywords": [
    "live coding"
  "@context": "", 
  "identifier": "", 
  "@id": "", 
  "workFeatured": {
    "url": "", 
    "alternateName": "ICLC2015", 
    "location": "Leeds, UK", 
    "@type": "Event", 
    "name": "First International Conference on Live Coding"
  "name": "Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them"
All versions This version
Views 114114
Downloads 100100
Data volume 13.7 MB13.7 MB
Unique views 9090
Unique downloads 7676


Cite as