| W. A. C. A. J. de Hoon, L. M. W. J. Rutten, and M. C. J. D. van Eekelen. Implementing a functional spreadsheet in Clean. Journal of Functional Programming, 5(3):383--414, 1995. |
....interface on top of a full fledged programming language. Pure functional languages are prime candidates, since they are side effect free. We have made such an interface, tentatively named Haxcel , for Haskell. The idea to have functional languages as formula languages in spreadsheets is not new [7, 8, 10], but to our knowledge this has not been done for Haskell before (although a Haskell based interface has been outlined in [7] We think Haskell is an interesting candidate for this, both as a strong language in general, and since it is relatively easy to define domain specific sublanguages within ....
....or definitions that just happen to share the same rows or columns, see Fig. 1. In such a situation, a very tedious re editing of the spreadsheet can be necessary. Fig. 1. Interference between tables when inserting a row for Charlie in the first table. Another, related problem, observed also in [6, 8], occurs when spreadsheet definitions are copied between cells. Very often, the copying is done to implement a similar computation on, say, a different row of a table than the original one. A convenient treatment of coordinates in the definition is then to let them move , so they have the same ....
[Article contains additional citation context not shown here]
W. A. C. A. J. de Hoon, L. M. W. J. Rutten, and M. C. J. D. van Eekelen. Implementing a functional spreadsheet in Clean. Journal of Functional Programming, 5(3):383--414, 1995.
....Reasoning about Units Like other members of the applicative family, spreadsheet languages are declarative languages, and hence computations are specified by providing arguments to operations. It is not impossible for a spreadsheet language to support higherorder functions (for example, see [8]) but since higher order functions are not commonly associated with spreadsheets, for the purposes of this paper we will consider only first order functions. The restriction to first order functions makes rich type systems feasible, such as by including use of dependent types. Taking advantage of ....
....that a simple (sub)set lattice model for units is not adequate. Not all of a spreadsheet s legal units are actually used as units. For example, in Figure 1, Tota l is a value and thus also a unit, but it is not used as a unit for another value. Likewise, the well formed unit Fruit[Apple[8]] is not used in the spreadsheet. 5 A Spreadsheet Unit System We have defined what spreadsheets and units are; next we have to describe how units are inferred for cells in a spreadsheet. We need to consider three kinds of judgments: first, we have judgments of the form (a, e) u that associate ....
W. de Hoon, Rutten L., and M. van Eekelen. Implementing a Functional Spreadsheet in CLEAN. Journal of Functional Programming, 5(3):383--414, 1995.
....the differences between existing programming environments, so they can be objectively compared and conclusions drawn about the suitability of these environments for any given task. Spreadsheets and the Declarative Paradigm Although some work has been carried out on functional spreadsheets [11, 12, 16, 30], and on alternative uses for spreadsheets (that is, using spreadsheets for functions other than numerical computation) 30, 9] exactly what constitutes a spreadsheet, at its most basic level, has been less investigated. Isakowitz and Schocken [23] argue that the present state of the art in ....
....formulas on most commercial spreadsheets [32, 35, 4] normally adhere to this paradigm, if one considers the formula to be the function, the cells referred to by the formula as the function s arguments and 33 the value displayed in the cell occupied by the formula as the function s result. De Hoon [12] has shown that a spreadsheet can indeed be built from a purely functional perspective, and describes his implementation of a general spreadsheet using the functional programming language Clean [11] 3.3 An Abstract View of a Spreadsheet The main aim of this dissertation is to extend the ....
W. de Hoon, L. Rutten, and M. van Eekelen. Implementing a functional spreadsheet in clean. Journal of Functional Programming, 5(3):383--414, July 1995.
....(e.g. Wray and Fairbairn 1989] There is also an obvious difference between spreadsheet languages and other functional languages: unlike spreadsheet languages, most functional languages support higher order functions. It is not impossible for a spreadsheet language to do so (e.g. see [de Hoon et al. 1995]) but since this is not commonly associated with spreadsheets, for the purposes of this paper we will regard only first order functions as a characteristic of the paradigm. Another difference between spreadsheet languages and other functional languages is the presence of continuous evaluation in ....
W. de Hoon, L. Rutten, M. van Eekelen, "Implementing a Functional Spreadsheet in CLEAN," Journal of Functional Programming 5(3), July 1995, 383-414.
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC