fmtgrid

This is another Grid control. This is quite big, but it also provides a lot of features. All of the neccessary ones as defined by the contest, but many more as well. There's the cut'n'paste functions (Cut, Copy, Paste), there's the Undo/Redo functions (Undo, Redo), cells may contain formulas (SUM, MAX, MIN, ABS, etc), formulas may contain any operator (+, -, *, /, \, MOD, etc), operations may be done on numeric values as well as cell references (A1, B2, C3, etc), formulas may contain multi-parameter functions (SUM, MAX, MIN) as well as single-parameter functions (ABS, SIN, TAN, etc), multi-parameter functions may operate on a range of cells (A1:B20, C5:D10). The cells are updated automatically in real-time, if you ie edit A1 to be of the same value as B2 (enter "=B2" into the cell), and then update cell B2 to a new value, cell A1 is automatically updated to the new value as well.
I have probably left out some features, try it out to see for yourself.

DOWNLOAD


INCLUDED FILES

• GRID.TXT
  Documentation for the grid control. Note this is the very first revision, it's short and may not explain as well as I would hope to. Be ware, it is written by a programmer. Feature releases might be better though.
• GRIDPROGRAM.BAS
  An example program showing off some of the features. When you start the program, it loads the grid with a couple of values, and you may load a new grid with any of the included .GRD files.
• CALENDARPROGRAM.BAS
  The grid control may be used to create a simple calendar control, in which you may select a day. You specify the year and month, the calendar will show a 5x7 grid and fill out the grid with the days available in the specified year/month.
• TEST1.GRD
  Example file showing some uses for the SUM function. This is the same as the contents you get when you start up the GRIDPROGRAM.BAS file.
• TEST2.GRD
  Example file showing off the grid's ability to find cyclic references, ie setting cell A1 equal "=A1" should product an error, or setting cell A1 to be eaul B1, and cell B1 to equal A1 -> same result. There's a lot of situations where these problems may arise, and I think they should all be covered.
• TEST3.GRD
  Example file showing a simple purchase list for a new computer. You may change the VAT for different parts, and it will automatically calculate the part's price as well as total price for you.

SCREENSHOT