Miscellaneous spreadsheet functions
|
•
|
|
Attribute — Each cell has a number of attributes, including its address, contents, type, protection status, format, etc. These spreadsheet functions return the attributes of a specified cell. If cells are specified, they use the top left cell in the cells.
|
|
•
|
|
Cell and Table — These spreadsheet functions generally return simple information from a cell or cells.
|
|
•
|
|
Status — Return the current setting for commands, properties, and other elements.
|
|
•
|
|
Table Lookup — These spreadsheet functions are used to search for a value in cells that has been specified as a data table.
|
Cell Attribute spreadsheet functions |  |
The attribute spreadsheet functions return the requested attribute of a cell (or of the upper left cell in specified cells).
|
•
|
|
@CELL Returns the requested attribute of the upper left cell in specified cells.
|
|
•
|
|
@CELLINDEX Returns the requested attribute of the cell at the intersection of a specified column and row in cells.
|
|
•
|
|
@CELLPOINTER Returns the requested attribute of the active (currently selected) cell.
|
Miscellaneous Cell and Table spreadsheet functions | |
|
•
|
|
@@ Returns the contents of a specified cell.
|
|
•
|
|
@ADDRESS Returns, as text, a cell reference for which you specify row and column numbers.
|
|
•
|
|
@ARRAY Returns the result of an expression (a formula or @function) using array syntax.
|
|
•
|
|
@BLOCKNAME Returns the name of specified cells.
|
|
•
|
|
@BLOCKNAME2 Returns the cell name created in a specified notebook for specified cells.
|
|
•
|
|
@BLOCKNAMES Returns a two-column table showing the cell names that intersect with specified cells.
|
|
•
|
|
@BLOCKNAMES2 Returns a two-column table showing the cell names created in a specified notebook that intersect with specified cells.
|
|
•
|
|
@CHOOSE Returns the element from a specified list in the specified position.
|
|
•
|
|
@COLS Returns the number of columns in specified cells.
|
|
•
|
|
@COLUMN Returns the column number(s) for a cell or cells.
|
|
•
|
|
@COUNTBLANK Counts blank cells in specified cells.
|
|
•
|
|
@DDELINK Creates a “live” data link from another Windows application that supports DDE (Dynamic Data Exchange).
|
|
•
|
|
@ERR Always returns ERR (the error indicator).
|
|
•
|
|
@FIRSTBLANKPAGE Returns the sheet letters for the first unnamed blank sheet in a notebook that is not part of a group.
|
|
•
|
|
@FIRSTINGROUP Returns the sheet letters for the first sheet in the specified group.
|
|
•
|
|
@GETGROUP Returns the name of the group that contains the sheet for specified cells, or the name of the group in the specified cells that contains a specified sheet name.
|
|
•
|
|
@GETREGISTRYKEY Returns the contents of the specified key in the Windows Registry.
|
|
•
|
|
@INDEXTOLETTER Returns a one- or two-character string for the index number of a sheet or column.
|
|
•
|
|
@ISLEGALPAGENAME Returns 1 if the specified sheet name is valid (whether it exists or not); otherwise, returns 0.
|
|
•
|
|
@LASTBLANKPAGE Returns the sheet letters for the last unnamed blank sheet in a notebook that is not part of a group.
|
|
•
|
|
@LASTCELLVALUE Returns the contents of the last cell that is not blank in the specified cells.
|
|
•
|
|
@LASTINGROUP Returns the sheet letters for the last sheet in the specified group.
|
|
•
|
|
@LETTERTOINDEX Returns the index number for column letters or sheet letters.
|
|
•
|
|
@LLDEC Converts latitude and longitude coordinates to decimals.
|
|
•
|
|
@NA Always returns NA (not available).
|
|
•
|
|
@PAGEINDEX Returns the index number for a notebook sheet with a specified name.
|
|
•
|
|
@PAGEINDEX2 Returns the index number for a notebook sheet with a specified name in a specified notebook.
|
|
•
|
|
@PAGENAME Returns the name of a notebook sheet with a specified index number.
|
|
•
|
|
@PAGENAME2 Returns the name of a notebook sheet with a specified index number in a specified notebook.
|
|
•
|
|
@PAGENAMES Returns a two-column table showing the sheet letters and corresponding sheet names for the active notebook.
|
|
•
|
|
@PAGENAMES2 Returns a two-column table showing the sheet letters and corresponding sheet names for a specified notebook.
|
|
•
|
|
@ROW Returns the row number(s) for a cell or cells.
|
|
•
|
|
@ROWS Returns the number of rows in specified cells.
|
|
•
|
|
@SHEETS Returns the number of sheets in specified cells.
|
|
•
|
|
@TYPE Returns a code indicating the type (for example, number or formula) of a specified value.
|
Status spreadsheet functions | |
|
•
|
|
@COMMAND Returns current settings for the specified command equivalent.
|
|
•
|
|
@CURVALUE Returns the current value of a specified menu command setting.
|
|
•
|
|
@MEMAVAIL Returns the number of bytes of available memory.
|
|
•
|
|
@MEMEMSAVAIL Under DOS, returns t
he number of bytes of available expanded memory; under Windows, returns NA (included for compatibility with Quattro Pro for DOS). |
|
•
|
|
@PROPERTY Returns current property settings for the specified object and property.
|
|
•
|
|
@VERSION Returns the version number of Quattro Pro.
|
Table Lookup spreadsheet functions | |
|
•
|
|
@FIELD Returns the nth substring in a delimited list of strings.
|
|
•
|
|
@HLOOKUP Searches for a specified value in the first row of specified cells. Returns the value a specified number of rows from the first.
|
|
•
|
|
@INDEX Returns the value at the intersection of a specified column and row in specified cells.
|
|
•
|
|
@LOOKUP Looks up values in a specified row or column.
|
|
•
|
|
@MATCH Returns the position of the cell whose contents match specified cell contents within cells.
|
|
•
|
|
@MAXLOOKUP Returns the address of the cell containing the largest value in specified cells or list of cells.
|
|
•
|
|
@MINLOOKUP Returns the address of the cell containing the smallest value in specified cells or list of cells.
|
|
•
|
|
@OFFSET returns a reference that is offset from another reference by a specified number of rows and columns; dimensions of the offset can also be specified.
|
|
•
|
|
@TABLELINK Establishes a link to an external database table and displays the table in a Quattro Pro notebook.
|
|
•
|
|
@VHLOOKUP Searches for a specified value in the first row of specified cells. Returns the value from a specified number of rows from the first
|
|
•
|
|
@VLOOKUP Searches for a specified value in the first column of specified cells. Returns the value from a specified number of columns from the first.
|
|
•
|
|
@XINDEX Returns the contents of a cell located at the intersection of a specified column, row, and (optionally) notebook sheet.
|