publications:
- title: "Discovery-based edit assistance for spreadsheets"
  author:
  - name: "Jácome Cunha"
    link: "http://di.uminho.pt/"
  - name: "João Saraiva"
    link: "https://researchr.org/alias/jo%C3%A3%C2%A3o-saraiva"
  - name: "Joost Visser"
    link: "http://www.di.uminho.pt/~joost.visser/"
  year: "2009"
  doi: "http://doi.ieeecomputersociety.org/10.1109/VLHCC.2009.5295255"
  abstract: "In this paper, we demonstrate how implicit structural properties of spreadsheet data can be exploited to offer edit assistance to spreadsheet users. Our approach is based on the discovery of functional dependencies among data items which allow automatic reconstruction of a relational database schema. From this schema, new formulas and visual objects are embedded into the spreadsheet to offer features for auto-completion, guarded deletion, and controlled insertion. Schema discovery and spreadsheet enhancement are carried out automatically in the background and do not disturb normal user experience."
  links:
    doi: "http://doi.ieeecomputersociety.org/10.1109/VLHCC.2009.5295255"
  tags:
  - "relational data base"
  - "rule-based"
  - "discovery"
  - "relational database"
  - "XML"
  - "XML Schema"
  - "data-flow"
  - "spreadsheets"
  - "database"
  - "Meta-Environment"
  - "systematic-approach"
  - "meta-objects"
  researchr: "https://researchr.org/publication/CunhaSV09-0"
  cites: 0
  citedby: 0
  pages: "233-237"
  booktitle: "IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2009, Corvallis, OR, USA, 20-24 September 2009, Proceedings"
  publisher: "IEEE"
  isbn: "978-1-4244-4876-0"
  kind: "inproceedings"
  key: "CunhaSV09-0"