| 摘要 |
A spreadsheet program providing the combination of spreadsheet and database tools, and enabling users to develop an application environment that can use all resources in the spreadsheet storage area. The spreadsheet program comprises three storage areas: a spreadsheet data structure; a set of database files in a storage area, and a video display system. The spreadsheet data structure is divided into two sets of cells that can be operated through three different environments. The first environment contains the tools of a spreadsheet environment, and the first set of cells can be operated through the first environment. This is most appropriate for scratchpad uses. The second environment contains the tools of a spreadsheet environment and contains a special command that can define commands for the third environment. This is appropriate to develop formulas for an application, and the application's environment of operation. The second environment also contains the tools necessary to define special environments for the integrated operation of spreadsheet and database tools. Said integrated operation coordinates dynamic screen video operations of the information in the spreadsheet and database storage areas. The second set of cells (for the development and use of an application) can be operated through the second or third environments. Several environments for the integrated operation of spreadsheet and database tools can exist in this invention. The software enables users to develop and use full database applications such as integrated accounting packages, within spreadsheet environments.
|
