Scheduled System Maintenance:
On Monday, April 27th, IEEE Xplore will undergo scheduled maintenance from 1:00 PM - 3:00 PM ET (17:00 - 19:00 UTC). No interruption in service is anticipated.
By Topic

Enhancing the Programmability of Spreadsheets with Logic Programming

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

1 Author(s)
Cox, P.T. ; Dalhousie Univ., Halifax

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.

Published in:

Visual Languages and Human-Centric Computing, 2007. VL/HCC 2007. IEEE Symposium on

Date of Conference:

23-27 Sept. 2007