<?xml version="1.0" encoding="UTF-8"?><xml><records><record><source-app name="Biblio" version="6.x">Drupal-Biblio</source-app><ref-type>47</ref-type><contributors><authors><author><style face="normal" font="default" size="100%">Jácome Cunha</style></author><author><style face="normal" font="default" size="100%">João Alexandre Saraiva</style></author><author><style face="normal" font="default" size="100%">Joost Visser</style></author></authors></contributors><titles><title><style face="normal" font="default" size="100%">Discovery-based edit assistance for spreadsheets</style></title><secondary-title><style face="normal" font="default" size="100%">Proceedings of the Symposium on Visual Languages and Human-Centric Computing - VL/HCC</style></secondary-title><tertiary-title><style face="normal" font="default" size="100%">VLHCC '09</style></tertiary-title></titles><dates><year><style  face="normal" font="default" size="100%">2009</style></year><pub-dates><date><style  face="normal" font="default" size="100%">September</style></date></pub-dates></dates><urls><web-urls><url><style face="normal" font="default" size="100%">http://dx.doi.org/10.1109/VLHCC.2009.5295255</style></url></web-urls><related-urls><url><style face="normal" font="default" size="100%">https://haslab.uminho.pt/sites/default/files/jacome/files/vl-hcc09.pdf</style></url></related-urls></urls><publisher><style face="normal" font="default" size="100%">IEEE Computer Society</style></publisher><pub-location><style face="normal" font="default" size="100%">Oregon, USA</style></pub-location><pages><style face="normal" font="default" size="100%">233–237</style></pages><isbn><style face="normal" font="default" size="100%">978-1-4244-4876-0</style></isbn><language><style face="normal" font="default" size="100%">eng</style></language><abstract><style face="normal" font="default" size="100%">&lt;p&gt;Spreadsheets can be viewed as a highly flexible endusers programming environment which enjoys wide-spread adoption. But spreadsheets lack many of the structured programming concepts of regular programming paradigms. In particular, the lack of data structures in spreadsheets may lead spreadsheet users to cause redundancy, loss, or corruption of data during edit actions. 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.&lt;/p&gt;
</style></abstract></record></records></xml>