next up previous contents index
Next: YEAR Up: A Function Reference Previous: XOR

XVALUE

 

Syntax: @XVALUE(P, C)

P = a string containing the pathname, enclosed in quotations, of another spreadsheet.
C = a valid cell reference or #

@XVALUE returns the value of cell C in sheet saved as a file with pathname P. When the cell reference C is the same as the cell containing the @XVALUE function, use the hash mark (#) as the second argument. Cell names are currently not supported for the second argument.

If sheet P is currently loaded into another instance of NExS, and you change a value, you must first save sheet P then recalculate the sheet containing the @XVALUE function to retrieve the new value entered into sheet P.

Examples:

@XVALUE(``controls.xs3'', A1) returns the value of cell A1 from the sheet saved as the file controls.xs3 in the directory from which NExS was launched when the @XVALUE function is stored in a cell other than A1.

@XVALUE(``controls.xs3'', #) returns the value of cell A1 from the sheet saved as the file controls.xs3 in the directory from which NExS was launched when the @XVALUE function is stored in cell A1.


next up previous contents index
Next: YEAR Up: A Function Reference Previous: XOR

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999