|
| This Article | ||
| ||
| Share | ||
| Bibliographic References | ||
| Add to: | ||
 Digg  Furl  Spurl  Blink  Simpy  Google  Del.icio.us  Y!MyWeb | ||
| Search | ||
| ||
2009 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
Discovery-based edit assistance for spreadsheets
Corvallis, OR, USA
September 20-September 24
ISBN: 978-1-4244-4876-0
| ASCII Text | x | ||
| Jacome Cunha, Joao Saraiva, Joost Visser, "Discovery-based edit assistance for spreadsheets," Visual Languages and Human-Centric Computing, IEEE Symposium on, pp. 233-237, 2009 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC), 2009. | |||
| BibTex | x | ||
| @article{ 10.1109/VLHCC.2009.5295255, author = {Jacome Cunha and Joao Saraiva and Joost Visser}, title = {Discovery-based edit assistance for spreadsheets}, journal ={Visual Languages and Human-Centric Computing, IEEE Symposium on}, volume = {0}, year = {2009}, isbn = {978-1-4244-4876-0}, pages = {233-237}, doi = {http://doi.ieeecomputersociety.org/10.1109/VLHCC.2009.5295255}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, } | |||
| RefWorks Procite/RefMan/Endnote | x | ||
| TY - CONF JO - Visual Languages and Human-Centric Computing, IEEE Symposium on TI - Discovery-based edit assistance for spreadsheets SN - 978-1-4244-4876-0 SP233 EP237 A1 - Jacome Cunha, A1 - Joao Saraiva, A1 - Joost Visser, PY - 2009 VL - 0 JA - Visual Languages and Human-Centric Computing, IEEE Symposium on ER - | |||
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.
Citation:
Jacome Cunha, Joao Saraiva, Joost Visser, "Discovery-based edit assistance for spreadsheets," vlhcc, pp.233-237, 2009 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC), 2009
Usage of this product signifies your acceptance of the Terms of Use.