loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC 2007)
Enhancing the Programmability of Spreadsheets with Logic Programming
Coeur d?Al?ne, Idaho
September 23-September 27
ISBN: 0-7695-2987-9
Philip T. Cox, Dalhousie University, Canada
Spreadsheet languages, of which Microsoft Excel is the prototypical example, are arguably the most successful and widely used visual programming languages. The programming facilities provided by spreadsheets, however, are severely limited, forcing users who need more complex computations to resort to convoluted arrangements of arrays of intermediate results, textual languages such as Basic, built-in functions, and various other ad hoc devices that have been added over the years. A consequence of this deficiency is that, despite their usefulness, spreadsheets are among the most error-prone of programming tools.

To address this shortcoming, we propose an enhancement in which sheets can be programmed using logic programming. By replacing lists, the fundamental data structures of logic languages, with arrays, the fundamental structures of spreadsheets, we achieve a natural integration of logic-based and sheet-based computation, providing a concrete visualisation of operations that divide and assemble arrays of cells.

Citation:
Philip T. Cox, "Enhancing the Programmability of Spreadsheets with Logic Programming," vlhcc, pp.87-94, IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC 2007), 2007
Usage of this product signifies your acceptance of the Terms of Use.