Using visual programming to extend the power of spreadsheet

Authors:
Philip T. Cox;Trevor J. Smedley
Affiliations:
Technical University of Nova Scotia, School of Computer Science, Halifax, Nova Scotia, Canada;Technical University of Nova Scotia, School of Computer Science, Halifax, Nova Scotia, Canada
Venue:
AVI '94 Proceedings of the workshop on Advanced visual interfaces
Year:
1994

Citing 4
Cited 2

Object oriented programming: an evolutionary approach

Object oriented programming: an evolutionary approach
An experimental study of people creating spreadsheets

ACM Transactions on Information Systems (TOIS)
Spreadsheet analysis and design

Communications of the ACM
Spreadsheet-based interactive graphics: from prototype to tool

CHI '90 Proceedings of the SIGCHI Conference on Human Factors in Computing Systems

Exception Handling in the Spreadsheet Paradigm

IEEE Transactions on Software Engineering - special section on current trends in exception handling—part II
Expanding the utility of spreadsheets through the integration of visual programming and user interface objects

AVI '96 Proceedings of the workshop on Advanced visual interfaces

Quantified Score

Hi-index	0.00

Visualization

Abstract

We describe a new means for representing computations in spreadsheets based on the visual, object-oriented data-flow language, Prograph, rather than textual arithmetic formulae. This mechanism is illustrated using various examples to show how common spreadsheet operation such as copying and extending formulae is more naturally represented. A formal syntax and semantics is presented. Suggestions are made for how this mechanism may be used to extend the range of applications of spreadsheets from the standard numerical calculations to areas such as symbolic computations and multimedia.