DocumentCode :
1803077
Title :
Enhancing the Programmability of Spreadsheets with Logic Programming
Author :
Cox, Philip T.
Author_Institution :
Dalhousie Univ., Halifax
fYear :
2007
fDate :
23-27 Sept. 2007
Firstpage :
87
Lastpage :
94
Abstract :
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.
Keywords :
logic programming; spreadsheet programs; visual programming; Microsoft Excel; logic languages; logic programming; logic-based computation; sheet-based computation; spreadsheet languages; spreadsheet programmability; visual programming languages; Computer languages; Concrete; Data structures; Data visualization; Functional programming; Logic arrays; Logic programming; Programmable logic arrays; Prototypes; Spreadsheet programs;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Visual Languages and Human-Centric Computing, 2007. VL/HCC 2007. IEEE Symposium on
Conference_Location :
Coeur d´Alene, ID
Print_ISBN :
978-0-7695-2987-5
Type :
conf
DOI :
10.1109/VLHCC.2007.49
Filename :
4351332
Link To Document :
بازگشت