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.
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.
fqvarfort
Oct 31, 2006
I have probably left out some features, try it out to see for yourself.
DOWNLOAD
INCLUDED FILES
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.
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.
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.
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.
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.
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