Conference paper Open Access

Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them

Hermans, Felienne


JSON Export

{
  "files": [
    {
      "links": {
        "self": "https://zenodo.org/api/files/8b868210-5bf2-4990-a7d5-5eabdaae15ca/84_CopyPaste_Tracking_Fixing_Spreadsheet.pdf"
      }, 
      "checksum": "md5:d8fc9307375bb095cad88acff1bfe988", 
      "bucket": "8b868210-5bf2-4990-a7d5-5eabdaae15ca", 
      "key": "84_CopyPaste_Tracking_Fixing_Spreadsheet.pdf", 
      "type": "pdf", 
      "size": 137331
    }
  ], 
  "owners": [
    4503
  ], 
  "doi": "10.5281/zenodo.19341", 
  "stats": {
    "version_unique_downloads": 76.0, 
    "unique_views": 90.0, 
    "views": 114.0, 
    "version_views": 114.0, 
    "unique_downloads": 76.0, 
    "version_unique_views": 90.0, 
    "volume": 13733100.0, 
    "version_downloads": 100.0, 
    "downloads": 100.0, 
    "version_volume": 13733100.0
  }, 
  "links": {
    "doi": "https://doi.org/10.5281/zenodo.19341", 
    "latest_html": "https://zenodo.org/record/19341", 
    "bucket": "https://zenodo.org/api/files/8b868210-5bf2-4990-a7d5-5eabdaae15ca", 
    "badge": "https://zenodo.org/badge/doi/10.5281/zenodo.19341.svg", 
    "html": "https://zenodo.org/record/19341", 
    "latest": "https://zenodo.org/api/records/19341"
  }, 
  "created": "2015-07-05T21:07:12+00:00", 
  "updated": "2020-02-10T21:27:35.441515+00:00", 
  "conceptrecid": "610959", 
  "revision": 12, 
  "id": 19341, 
  "metadata": {
    "access_right_category": "success", 
    "part_of": {
      "pages": "104--109", 
      "title": "Proceedings of the First International Conference on Live Coding"
    }, 
    "doi": "10.5281/zenodo.19341", 
    "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": {
      "id": "CC-BY-4.0"
    }, 
    "title": "Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them", 
    "relations": {
      "version": [
        {
          "count": 1, 
          "index": 0, 
          "parent": {
            "pid_type": "recid", 
            "pid_value": "610959"
          }, 
          "is_last": true, 
          "last_child": {
            "pid_type": "recid", 
            "pid_value": "19341"
          }
        }
      ]
    }, 
    "imprint": {
      "publisher": "ICSRiM, University of Leeds", 
      "place": "Leeds, UK", 
      "isbn": "9780853163404"
    }, 
    "communities": [
      {
        "id": "iclc"
      }, 
      {
        "id": "iclc2015"
      }, 
      {
        "id": "livecode"
      }
    ], 
    "keywords": [
      "iclc2015", 
      "live coding"
    ], 
    "publication_date": "2015-07-13", 
    "creators": [
      {
        "affiliation": "van der Storm, Tijs", 
        "name": "Hermans, Felienne"
      }
    ], 
    "meeting": {
      "acronym": "ICLC2015", 
      "url": "http://iclc.livecodenetwork.org/", 
      "dates": "13-15 July 2015", 
      "place": "Leeds, UK", 
      "title": "First International Conference on Live Coding"
    }, 
    "access_right": "open", 
    "resource_type": {
      "subtype": "conferencepaper", 
      "type": "publication", 
      "title": "Conference paper"
    }
  }
}
114
100
views
downloads
All versions This version
Views 114114
Downloads 100100
Data volume 13.7 MB13.7 MB
Unique views 9090
Unique downloads 7676

Share

Cite as