These types are differentiated only by their shape.
There are 4 basic "subclasses" of Grid: Table, Row, Column, and Cell. Note that grids do not contain formulas, we use separate visual operators instead. Grids usually contain numbers, but you can also add labels which hold strings.
Grids are basically collections of cells. The two most important of these classes are Grids and Operators.įigure 4. Each of these classes of object can come in many different shapes and sizes (you might even call them subclasses), and some samples are shown in Figure 4.
There are 4 major classes of objects in Spreadsheet 2000: Grids, Operators, Charts, and Notes. The idea of treating data as objects, is one of the things that makes Spreadsheet 2000 so powerful. I hesitate to say that Spreadsheet 2000 is object oriented, because that term carries so much intellectual baggage, but objects do play a big role in our language. I can, however, tell you what Spreadsheet 2000 is: Spreadsheet 2000 is an object-based, data flow, visual programming language. It probably isn't, but it helps the marketing people to call it one. Is Spreadsheet 2000 really a spreadsheet? I get asked that question a lot, and I'm not sure I know the answer. Lastly, we hope that Spreadsheet 2000 makes problem solving more fun.įigure 3. We feel that this will lead to more accurate results, as well as a shallower learning curve. We use visible operators instead of text-based formulas to perform the work. Spreadsheet 2000 calculations are easy to understand because you can see what you're doing. The same calculation done with Spreadsheet 2000. Figure 2 shows a simple calculation done with Spreadsheet 2000 as it would appear on your screen.įigure 2. Spreadsheet 2000 is the program we built. We set out to design a Macintosh-like user interface to fix this and other problems with the traditional spreadsheet metaphor. Cell A4 looks like data, but it is actually a formula. In fact, a single cell often contains a text-based formula hidden underneath the answer produced by the formula, as shown in Figure 1.įigure 1. One of the fundamental problems with spreadsheets is that your formulas, labels, and data are all mixed together. It just isn't a good one! Anyone who has ever built a non-trivial spreadsheet knows how hard it is to do without causing unseen errors. the new wayĪ spreadsheet is a type of programming language. We used Prograph CPX, another VPL to write Spreadsheet 2000, and as you can imagine, this led to some interesting experiences.
In this article I will give an overview of the VPL we created and also talk briefly about our experiences implementing it. In January 1997 we released version 2.0 of the product and changed the name to Spreadsheet 2000. 1.0 was first released in May 1996, and was very well received. The product which resulted was called Let's Keep It Simple Spreadsheet (or L.K.I.S.S. We locked ourselves in a conference room with a white board for two days, and designed a visual programming language (VPL) for solving the same type of problems typically solved with a spreadsheet. We decided we would write a spreadsheet - but not just any spreadsheet.
Limitations in megaseg dj 6 demo mac#
We wanted to build an app that would appeal to a wide range of users and would fill a real need in the Mac community.
Limitations in megaseg dj 6 demo software#
0 kommentar(er)
