SpreadJS 14
Formula Reference / Formula Overview / Functions in a Formula / Database Functions
In This Topic
    Database Functions
    In This Topic

    Database functions apply a mathematical or statistical operation to a subset of values in a range of cells treated as a database. The database table can be thought of as a two-dimensional array organized into rows and columns. Or it can be thought of as a one-dimensional array of records where each record is a structure that has one or more fields. In the context of database tables, the terms "row" and "record" mean the same thing and the terms "column" and "field" mean the same thing. Database refers to a range of cells where the first row in the range represents field labels. The remaining rows in the range represent records. The columns in the range represent fields.