METHOD FOR HANDLING A DATA TABLE IN AN ELECTRONIC SHEET APPLICATION, METHOD FOR RECEIVING ONE OR MORE DATABASE FUNCTIONS TO APPLY TO A COMPUTER-LEGAL STORAGE DATA SET

摘要

"designing spreadsheet functions for working with data tables". The present invention provides various database formulas that can handle large sets of data. Each database formula is customizable and repeatable without user intervention. Thus, users can enter numerous options that may encompass the user's desire for data output in certain forms or formats, select an input data set, and consistently receive an output data set. In some embodiments, the user may refer to the dataset semantically instead of specifying a range of cells to use in the database formula. Referring to data semantically allows database formulas to adjust to changes in the range of cells that new data may occupy.