This is a very simple entry. It meets the base requirements of the contest.
LBSpreadsheetJLT
Programmed by Janet Terra
Liberty BASIC Spreadsheet Contest
October 29, 2006
Known Limitations (and there are many)
Cells will not update properly if the cells are navigated by any method other than pressing ENTER. For example, the tab key and the mouse navigation will leave incomplete results / displays.
The error parsing is sufficient for legal entries, but will probably not be sufficient to handle unexpected user errors.
The program was only tested on the XP display. The textboxes may not line up properly on other displays. The GetSystemMetrics API call would be helpful, but this program doesn't use it.
The LB native commands DecHex$ and HexDec will cause the program to hang or crash. Don't try them. These commands will need further parsing algorithms.
This spreadsheet program is probably very buggy and is not meant to be used for any serious applications. It is only meant to be a fun example of creative coding / parsing using LB's native math functions. Please DO NOT attempt to run your payroll with this program!
Janet Terra
The zipped file contains
LBSpreadsheetJLT.bas
4 images for bmp buttons
3 demo files for loading
LBSSJLTNotes.txt with the limitations listed above
LBSpreadsheetJLT
Programmed by Janet Terra
Liberty BASIC Spreadsheet Contest
October 29, 2006
Known Limitations (and there are many)
Cells will not update properly if the cells are navigated by any method other than pressing ENTER. For example, the tab key and the mouse navigation will leave incomplete results / displays.
The error parsing is sufficient for legal entries, but will probably not be sufficient to handle unexpected user errors.
The program was only tested on the XP display. The textboxes may not line up properly on other displays. The GetSystemMetrics API call would be helpful, but this program doesn't use it.
The LB native commands DecHex$ and HexDec will cause the program to hang or crash. Don't try them. These commands will need further parsing algorithms.
This spreadsheet program is probably very buggy and is not meant to be used for any serious applications. It is only meant to be a fun example of creative coding / parsing using LB's native math functions. Please DO NOT attempt to run your payroll with this program!
Janet Terra
The zipped file contains
Screenshot