next up previous contents index
Next: D Glossary Up: C NExS Error Messages Previous: C.1.3 Formula Evaluation Errors

C.2 Summary of Error Messages

 

# of histogram bins not specified; using 10

The number of bins, or buckets, has not been specified for the histogram, so NExS is using the default of 10. To change this, set the number of tick marks for the X axis.

allocating negative-dimensional matrix

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

annotation lacks (x,y) position

An attempt has been made to annotate a graph without giving the coordinates at which to place the annotation.

argument is negative

@SQRT has been passed a negative argument. NExS does not work with complex numbers, so @SQRT takes only positive arguments.

argument must be an integer

@FACT has been passed a non-integer argument.

argument not a cell or range

@@ has been passed an argument that is neither a cell nor a range.

argument out of range

An argument to a function is not within the correct range for the function and its other arguments.

arguments must be numeric

The function requires numeric arguments, which may be literal numbers, formulas which return numeric values, or references to cells containing numeric values.

arguments must be positive

The arguments in this function must be all positive values.

bad continuation record

The XS3 file has been corrupted. A line ending in ``´has not been followed by a line beginning with a space or a tab.

bad sheet or graph index
A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

bars with the same X coordinate

All values specified in the X Range for a bar graph must be unique.

beginning line with subscript command

Line begins with subscript start character, '_'. The subscript is ignored, if possible, with the text that would have been in a subscript set as normal text.

can not access file

Insufficient permission to open file. The causes for this are system-dependent.

can not parse condition string

NExS has encountered a malformed conditional expression.

cannot allocate color

NExS was not able to allocate a color from the X server. This can be caused by having other applications active which allocate too many colors of their own without creating a new colormap. It may also be caused by specifying a color name in the user's X resource file(s) which is not a legal color in the color database for the X server.

cannot find help topic

The requested topic was not found in the nexs-help.txt file.

cannot get font

NExS was not able to allocate a font from the X server. This is usually caused by the font being unavailable to the server. This is likely to happen when the server is an older release of X which does not come with as many fonts as later releases of X, or when a font has been specified incorrectly in the user's X resource file(s). It may also be caused by a low-memory condition which causes the X server to be unable to store the font, although this is less likely to happen in most circumstances.

cannot open help file

The help file does not exist or could not be read. The default directory to the NExS help file (nexs-help.txt) is /usr/local/lib/nexs/. If installed elsewhere, the alternate path must be specified inside the NExS application defaults file. Also, make sure that the help file is readable, and that there are no faulty resources pointing to the help file in any X resource files on your system.

cannot read file

The file does not exist or the user has insufficient permissions to read the file.

can't read license file

The NExS license file (normally /usr/local/lib/NExs/NExS-license.txt) does not exist or the user has insufficient permissions to read the file.

cannot find interpolation

@INTERP2D or @INTERP3D is unsuccessful in finding interpolated values.

cannot write file

The user has insufficient permissions to write the file or an out of disk space condition has occurred.

cash flow series must be a range

@NPV and @MIRR require that their cash flow series must be a range, which must represent a single column or row.

cash flow series must be single column or row

@NPV and @MIRR require that their cash flow series must be a range, which must represent a single column or row.

cell is protected

User has attempted to edit a protected cell.

Cell limit exceeded

You have exceeded the number of cells that your NExS license allows. The cell limit for your license, if any, will be displayed in the license dialog box each time NExS starts up.

cell operand contains error condition

A cell which is referenced from the cell in which the error occurs contains an error condition.

cell reference out of range

A cell reference has been made which is outside the range A1..FAN32767

coefficient matrix has linearly dependent columns

The existence of a unique solution to a linear least squares (@LLS) problem, Ax=b, requires that the columns of A are linearly independent.

column offset out of range

The third argument to the @VLOOKUP function specifies an offset that is less than 0 or is greater than the width of the range specified in the second argument.

compass window is too small

A window is too small to draw in. This is probably because the user resized the window so that it became less than 16 pixels wide or deep. Alternately, this may be the fault of the window manager not honoring the size NExS requested for the new window.

constraint check not supported with ``As Needed''

Constraint checking is not supported when the recalculation is set to ``As Needed''.

contains an error indicator

A cell in one or more of the data ranges for a graph contains an error condition. The error condition must must be resolved before NExS can plot the graph.

could not find real root

@IRR could not find a real root. This suggests that the data given to @IRR is probably wrong.

could not open external file

@XVALUE could not access the external file referenced.

count less than zero

User has passed a negative argument to a function which requires a count, for example, with @LEFT, it is impossible to take the -2 leftmost characters of a string.

data set size must be >= 3

@LINFIT and @LINCOEF require a data set of size 3 or larger.

data set size must be >= polynomial degree + 2

@PLS, @POLYFIT, and @POLYCOEF require that the data set size be greater than or equal to the polynomial degree + 2.

dataset index out of range

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

date series must be single column or row

@XIRR and @XNPV require the argument D (date series) to be a single column or single row.

decimal places out of range

@STRING only takes a decimal place argument between 0 and 15.

degrees of freedom must be > 0

@F and @T require degrees of freedom greater than zero, as ``degrees of freedom'' is mathematically undefined for zero or less.

delete operation would erase all cells

Delete row(s) or delete column(s) operation would delete all the data on the sheet. If you intend to delete all the data, use File|New instead.

dimension must be power of 2

@FFT and @INVFFT require matrices whose dimensions are powers of two. The somewhat slower functions @DFT and @INVDFT, respectively, are equivalent functions which do not share this requirement.

divide by zero

An attempt has been made to divide by zero. Note that NExS considers cells which are empty or contain text strings to have the value zero in the context of a numerical calculation.

does not accept arguments

Several NExS functions, including @PI, @TRUE, @FALSE, @RAND, and @GRAND, do not accept any arguments.

domain is -1 < x < 1

@ATANH only takes arguments between -1 and 1, exclusive.

domain is -1 <= x <= 1

@ACOS and @ASIN only take arguments between -1 and 1, inclusive.

domain is 0 <= x <= 170

@FACT only takes arguments between 0 and 170, inclusive. (Most platforms)

domain is 0 <= x <= 33

@FACT only takes arguments between 0 and 33, inclusive. (VAX platforms)

domain is x > 0

@LN, @LOG2, @LOG, @GAMMA, and @LNGAMMA only take arguments greater than zero.

domain is x >= 1

@ACOSH only takes arguments greater than or equal to 1.

``End Period'' must be >= 1

@CUMIPMT and @CUMPRINC require the argument E (end period) to be greater than or equal to 1.

``End Period'' must be >= ``Start Period''

@CUMIPMT, @CUMPRINC and @VDB require the argument E (end period) to be greater than or equal to S (start period).

end-of-file occurred while reading XS3 file

Indicates a truncated (or possibly otherwise corrupted) XS3 file.

ending line with a
\
The \ is an escape sequence introducer, which should be followed by another character for interpretation, but the string ended prematurely.

ending line with a superscript command

When displaying text in the context of graphics, a ^ is a superscript introducer. Like y^2 means ``y squared.'' This message occurs when a ^ occurs at the end of the string.

ending line with subscript command

When displaying text in the context of graphics, an `_' is a subscript introducer. Like y_2 means ``y subscript 2.'' This message occurs when an `_' occurs at the end of the string.

error decoding option field

Your XS3 file contains an invalid record.

error decoding record

Your XS3 file contains an invalid record.

error in regular expression

An error occurred while parsing the regular expression used in a search or extract operation, or while executing @REGEX or @MATCH.

error occurred while reading XS3 file

Some error occurred while reading which was not an end of file. This might include an out-of-space condition, a loss of network connectivity, or some other system-dependent error.

error occurred while writing XS3 file

An error occurred while writing. This might include an out-of-space condition, a loss of network connectivity, or some other system-dependent error.

expected the right hand side of a range here

The outer range reference is missing.

expected to find [something] here

There was a parsing error. The cursor will be placed in the edit window in edit mode. Read the documentation for the function and correct the error.

expecting a function

There is something wrong with the formula you have entered on the edit line. The parser was expecting to find a function name at the point indicated by the cursor position.

expecting an operand

There is something wrong with the formula you have entered on the edit line. The parser was expecting to find a function name at the point indicated by the cursor position.

expecting an operator

There is something wrong with the formula you have entered on the edit line. The parser was expecting to find a function name at the point indicated by the cursor position.

extraneous operands

There is something wrong with the formula you have entered on the edit line. The parser was expecting to find a function name at the point indicated by the cursor position.

F must be >= 0

The third argument to @F must be greater than or equal to 0.

file is not valid [XS3|XLS|XS|WK1|WKS] format

NExS was expecting to open a file in the specified format, and the file was not valid. This may happen if the file has been corrupted, or if, for example, the user attempts to access a WK1 file as an XS3 file.

first argument must be numeric

@NPV and @CHOOSE require that their first argument be numeric.

floating exception

A floating-point arithmetic hardware exception occurred during the computation of the function or expression. This means that the calculations resulted in a number out of the range that the computer hardware is able to represent.

format error reading file

There has been an error reading an XS (NExS version 2.x) spreadsheet file. The file is probably corrupt.

found number where string should be

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message and contact NExS technical support.

found something unexpected here

NExS has found something it doesn't understand in an expression.

``Fraction'' must be >= 1

@DOLLARDE and @DOLLARFR require the argument F (fraction) to be greater than and equal to 1.

freeing data pointed to by NULL

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message and contact NExS technical support.

freeing negative-dimensional matrix

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message and contact NExS technical support.

``Frequency'' must be 1, 2 or 4

The argument Frequency (number of coupon payment per year) in financial functions is limited to one of the following choices: 1, 2 or 4

function not installed

This error occurs when NExS encounters an ``@'' followed by a function name which it does not recognize as one of its built-in functions, or one that has been installed by a connection program.

function stack overflow

This error occurs when functions are nested too deeply. NExS supports nesting of functions up to 50 levels deep.

graph index out of range

A graph index greater than 100 has been found while reading an XS3 file. This probably indicates a corrupted data file.

graph window is too small

The graph window has been rescaled to the point where NExS could not draw anything inside. This occurs when a window has a 16x16 pixel area or smaller inside the window.

hex number greater than 32 bits

NExS cannot convert a hex string to a number if the hex string is longer than 8 characters, which translates to 32 bits in the internal binary representation.

histogram data max and min are the same

The max and min are the same for the histogram. NExS will default to a bin size of 1.0, which is probably not what you want. Fix the max and min.

IEEE Floating Exception (Infinity or NaN)

This error means that the formula caused a computation to occur which could not be calculated properly by the computer's IEEE standard floating point hardware. Most likely, this means that the computation would produce an intermediate or final result outside the range +/-1.8e308.

illegal cell address specification

An illegal cell address has been entered in a dialog box.

illegal cell identifier in record

A cell record in the xs3 file specifies a cell address which is outside the range A1..FAN32767.

illegal cell or range reference

It happens when a copy or move operation results in a cell or range reference that is outside the range A1..FAN32767.

illegal column width

User tried to set an illegal column width.

illegal combination of source/destination range

The destination range is not compatible with the source range. For example, in a copy operation:

If the source is: The destination may be:
a single cell any range, including a single cell
a row, or portion of a row a single column, or portion of a column
a column, or portion of a column a single row, or portion of a row
a 2-D range a single cell

illegal operand of ``operator''`

This error occurs when one or both of the operands of the specified ``operator'' are not valid. Most likely, a range name was used as an operand in an arithmetic expression.

illegal range specification

A range specification entered in an NExS dialog box is invalid.

illegal range specifier in View record

You have a corrupted data file.

illegal record type specifier

You have a corrupted data file.

illegal row height

User tried to set an illegal row height.

improper argument type

One or more arguments to the function are incompatible with the type of arguments required by the functions.

improper coefficient type

In the polynomial evaluation function (@POLY), one or more of the polynomial coefficients are non-numeric.

improper dimensions

Several NExS matrix functions and embedded tools have certain requirements on the dimensions of their matrix arguments. Check the reference manual if you are uncertain about those requirements.

incompatible matrix dimensions

In matrix multiplication (@MMUL), the number of columns in the first matrix must equal the number of rows in the second matrix.

incompatible range dimensions

The NExS dot product functions (@DOT) requires vectors of equal size. It will also compute the sum-of-products of any two ranges with equal dimensions.

index column contains empty cell

The first column in the lookup table referenced by @VLOOKUP must not contain empty cells.

index out of range

In @FIND, the third argument may not be larger than the length of the second argument. In @MID, the second argument may not be larger than the length of the first argument.

index row contains empty cell

The first row in the lookup table referenced by @HLOOKUP must not contain empty cells.

insert operation would erase all cells

If you selected a column and then did Edit/Insert/Row, this error would occur. Same with selecting a row.

integer parameter out of range

An integer parameter greater than 4294967296 or less than -2147483649 has been entered.

interest rate should be > 0

@EFFECT and @NOMINAL require that argument R (interest rate) to be greater than 0.

interest schedule must be a single column or row

The argument R (array of interest rates) in @FVSCHEDULE must be a single column or row.

internal error freeing node

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

internal error--unconsumed operands

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

invalid XS3 file access mode

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

invalid cell reference

User has tried to access a cell with a row which is negative, zero, or greater than 32767, or with a column which is negative or greater than FAN, or 4095.

invalid character in formula

The NExS spreadsheet has probably been corrupted.

invalid date

NExS could not understand the date format. Date values must be in the range 1-73,050, representing the dates January 1, 1900, to December 31, 2099, respectively. This error can also occur when the year, month, and day values passed to @DATE do not represent an actual date within this range (February 31, 1950, or January 1, 2589, for example).

invalid day count basis

The day count basis in financial functions should be one of the following choices: 0 (30/360), 1 (actual/actual), 2 (actual/360) or 3 (actual/365)

invalid range name

User tried to either reference or delete a named range that does not exist.

invalid range reference

User has tried to make a range reference that references cells beyond the range of the spreadsheet; that is, a row which is negative, zero, or greater than 32767, or a column which is negative or greater than FAN, or 4095.

invalid table

The table of reference points in @INTERP2D or @INTERP3D contains non-numeric values or blank cells.

invalid time

NExS cannot parse a time which the user has provided. Time values are fractional values from 0 to 1, representing fractions of a 24-hour period. When interpreting a number as a date/time value, NExS interprets the integer portion of the number as the date and the fractional portion as the time on that date. A negative value is invalid. Also, the @TIME function must have arguments in the range of 0-23 hours, 0-59 minutes, and 0-59 seconds. Any other values are invalid.

iterative calculation not supported with ``As Needed''

To avoid infinite looping, iterative (self-referential) calculations are not supported when the recalculation method is ``As Needed''. To use iterative calculations, the user must choose manual recalculation.

label and slice data ranges have different sizes

The ``X Data'' and ``Y Data'' ranges (meaning label and slice, respectively) in the ``Data Sets...'' option dialog box are of different sizes. There needs to be exactly one label for each slice on a pie graph.

label missing [closing|opening] quote

This error indicates a corrupt data file. Check your data carefully, as it is likely to be corrupt.

less than 2 arguments

@POLY requires 2 or more arguments.

``Life'' and ``Period'' must be integers

@DDB requires that ``Life'' and ``Period'', arguments 3 and 4, respectively, be integers.

``Life'' must be > 0

@SLN and @SYD require that ``Life'' is greater than 0.

lookup failed to produce a match

@HLOOKUP or @VLOOKUP failed to produce a match. This should only happen with an alphabetic lookup.

``Lower limit'' must be >=0

The argument L (lower limit) should be greater than or equal to 0 in @ERF and @ERFC.

magnitude too large

@NUMTOHEX requires an argument between 2147483646 and -2147483647, inclusive.

making null list

A bug has been triggered in NExS. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

matrix is singular

It is mathematically impossible to invert a singular matrix.

matrix must be square

It is impossible to invert, take the eigenvalue of, or take the determinant of a non-square matrix.

``Match Type'' must be 0 for string match

The argument T (type of match) must be 0 if argument V (value to be matched) is text in @MATCH.

matrix must be symmetric

@EIGEN requires a symmetric matrix.

mismatched {}'s

When using subscripts and superscripts in graph text, there must be an ending `}' for every beginning `{'.

misplaced newline

It is not legal to have a newline within a superscript or subscript in graph text.

misplaced }

To include a `}' in regular graph text, use `\}'. Subscripts and Superscripts cannot be empty. `^}' and `_}' are illegal character sequences.

missing X record in XS3 import file or paste buffer

The xs3 file has been corrupted, or pasting has failed.

modula divide by zero

Mod 0 is an undefined operation.

must be -15 to +15 places

@ROUND cannot round to greater than 15 places on either side of the decimal point.

must have ``Cost'' >= ``Salvage'' >= 0

@DDB, @SLN, @SYD, @DB, and @VDB require that the ``Cost'' argument be greater than or equal to the ``Salvage'' argument, which must be greater than or equal to 0.

must have issue < first coupon < maturity

The values of argument I (issue date), FC (first coupon date) and M (maturity date) must satisfy the following condition: I < FC < M

must have issue < last coupon < maturity

The values of argument I (issue date), LC (last coupon date) and M (maturity date) must satisfy the following condition: I < LC < M

must have ``Life'' >= ``Period'' >= 1

@DDB, @DB, and @VDB all require that the ``Life'' argument be greater than or equal to the ``Period'' argument, which must be greater than or equal to 1.

must have N > 0, K > 0 and N < K

The arguments N (number of objects to choose from) and K (Number of objects to be chosen) in @PERMUT must follow the following condition: N>0, K>0 and N<K.

need at least 2 cash flow values

A single data point does not a cash flow series make; it takes two to trend. Computing the internal rate of return (@IRR) is undefined for only one value.

negative data in pie chart

There is no way to show negative data in a pie chart, unlike, say, a line graph or histograph.

no PostScript description for marker

A bug has been triggered in NExS. Please save a copy of your current spreadsheet and contact NExS technical support.

no duplicate number found

The @MODE can not find the most frequently occurring number because all numbers appears only once in the argument list.

no file specified at end of path name

The filename that was given was a directory, not a file.

no match was found

@MATCH is unsuccessful in finding a match.

no title areas specified

User has tried to create view titles with the upper-left cell selected.

non hex digits in string

@HEXTONUM requires that its argument be a string containing only hex digits, 0-9 and a-f.

non-existent object

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

non-numeric operand

An expression of some sort has a non-numeric operand where a numeric operand is required, making the result of the expression undefined.

non-numeric value in ...

Doing arithmetic on alphabetic entities is undefined.

non-string in annotation field

Graph annotations must be strings.

normalizing zero-length vector

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

not allowed with protection enabled

Most edit operations are not allowed when cell protection is enabled.

not enough arguments to function

User has entered too few arguments to the function.

nothing to find

There is nothing to find in an empty sheet.

NULL graphics pixmap

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

``Number'' is not in the reference list

The number to be ranked is not in the reference list in @RANK.

number is too [large|small]

The number is at or beyond the limit of the ability of the computer to express, and is treated as if it were slightly within the limit.

number of compounding periods should be >=1

@EFFECT and @NOMINAL require that argument C (number of compounding periods) to be greater than or equal to 1.

odd character in numeric string

A bug in NExS or your system libraries has been triggered. Please save the sheet you are working on and contact AIS technical support.

one argument must be non-zero

@ATAN2 requires that one of it's arguments be non-zero.

operand contains error condition

Some cell referenced by the operand is in an error condition, or contains a reference to a cell which is in an error condition, etc.

operand equal to 0

@HMEAN does not take arguments whose value is 0.

operand larger than 32 bits

Integers in NExS cannot take more than 32 bits to express. This restricts integers to the range 2147483647 to -2147483648, or 4294967295 to zero, depending on whether the operand is only positive or can be negative.

operand less than or equal to 0

@GMEAN does not take arguments which are 0 or negative.

operand out of range

@CHAR only takes integers between 1 and 255

operands of ``&'' must be same type

The ``&'' operator serves a dual purpose: if its operands are numeric, then it performs a bitwise AND operation; if its operands are text strings, then it concatenates the two strings. If the operands are neither both numeric nor both strings, this error occurs.

operands of ``..'' must be cell reference

The .. operator can only join two cell references to create a range. It cannot join integers to make a range of integers, or do anything else.

operator not available in Lotus Mode

Some NExS operators are not available in Lotus spreadsheets, and therefore are incompatible with Lotus Mode.

option value illegal or out of bounds

This is a corrupted file. The ``options'' in an xs3 record are the entities between the colons, separated by vertical bars. Each option consists of a name-value pair.

out of memory

The operating system has run out of memory to give NExS. You may close other applications, add physical memory, add swap space, or use smaller or less complex spreadsheets to remedy this problem in the future. However, this error forces NExS to terminate the current session.

password protection feature not supported

The file you have attemped to open is a password-protected WK1 or XLS file. NExS does not currently support the password encryption feature of these formats.

``Payment'' and ``FV'' must have the same sign

@TERM requires that Payment and Future Value have the same sign.

Payment`` must be non-zero

@TERM requires that Payment be non-zero.

``Period'' must be >= 0

@SYD requires that Period be greater than or equal to 0.

``Period'' must be an integer > 0

@FV, @PMT, @PV, and @RATE require that Period be an integer greater than 0.

polynomial degree must be between 1 and 10

@PLS, @POLYFIT, and @POLYCOEF require that the polynomial degree by between 1 and 10.

pooled sample size less than 3

@TTEST2EV requires a pooled sample size greater than 2 to be mathematically defined.

population less than 1

@CVAR, @CSTD, @SSE, @VAR, and @STD require a population greater than or equal to 1.

``PV'' and ``FV'' must be non-zero

@CTERM and @RATE require that Present and Future Values be non-zero by definition.

``PV'' and ``FV'' must have the same sign

@CTERM and @RATE require that Present and Future Values have the same sign.

range should not be a block

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

range should not be a column

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

range should not be a row

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

ranges must be same dimensions

@PTTEST and @CORR require that both their arguments be ranges of equal dimensions, since they work with pairs of values, one value from each range.

``Rate'' must be greater than -1

@CTERM, @FV, @PMT, @PV, @TERM, @NPV, @XNPV, and @XIRR require that their Rate argument be greater than -1.

``Rate'' must be non-zero

@CTERM requires that its Rate argument be non-zero.

rate found is less than -1

@IRR has found a rate less than -1 after iterating the maximum number of times.

record contains too many options

Your spreadsheet file has probably been corrupted.

record line too long

Your spreadsheet file has probably been corrupted.

record value illegal or out of bounds

Your spreadsheet file has probably been corrupted.

recursion too deep

This error will occur if NExS encounters ``a condition string within a condition string.'' For example, it happens with a conditional statistical formula whose condition string calls another conditional statistical function which in turn contains its own condition string.

remote function error

An external function, one installed via the NExS connections API, has returned an error.

removing NULL

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and contact NExS technical support.

requested unknown type of graph

Either a bug has been triggered in NExS, or possibly a corrupted file has been loaded. Please save a copy of your current spreadsheet and contact NExS technical support.

result of expression is a range

Some NExS functions, such as @CELLREF and @RANGEREF, return cell references or range references as a result. Cell and range references can not be the final result of a formula.

resultant string too long

A string generated by a formula is too long (greater than 512 characters).

row offset out of range

The third argument to the @HLOOKUP function specifies an offset that is less than 0 or is greater than the depth of the range specified in the second argument.

sample missing from pair

The two input ranges to the paired t-test (@PTTEST) and Pearson product-moment correlation (@CORR) functions contain paired values. If a value appears at a given position in the first range, then there must also be a value in the corresponding position of the second range.

sample size less than 2

@CVARS, @CSTDS, @VARS, @STDS, @TTEST, @PTTEST, @TTEST2UV, and @FTEST require a sample size greater than 1.

searching NULL list

searching list with a NULL function.

selector out of range

The first argument to @CHOOSE must be 0 or more and be less than or equal to the number of the rest of the arguments - 1.

settlement date should be < maturity date

Settlement date should be earlier than maturity date in financial functions.

settlement date should be >= issue date

Settlement date should not be earlier than the issue date.

showing NULL list

showing list with a NULL function

Sorry, your NExS license file is invalid

Your NExS license file, which is normally /usr/local/lib/NExS/NExS-license.txt, can not be decoded correctly.

Sorry, your NExS license has expired

Your NExS license file contains an expiration date which has passed. (If your NExS license has an expiration date, it will be displayed in the license dialog box each time NExS starts up.)

specified file is not a valid XS3 file

The file is either badly corrupted, missing parts (probably the beginning), or really is not an XS3 file.

``Start Period'' must be >= 1

@CUMIPMT and @CUMPRINC require the argument S (start peroid) to be greater than or equal to 1.

starting date should be at beginning of ``Dates''

The number in argument D (dates) should not precede the starting date in @XIRR and @XNPV.

strange (X,Y,Z) point in surface data

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and contact NExS technical support.

substring longer than string

@FIND cannot find an instance of the pattern string within a shorter target string, since it is impossible to embed a string in a string shorter than itself.

substring not found

@FIND could not find an instance of the pattern string in the target string.

sum of piechart data exceeds graphics INFINITY

The sum of the pie chart data being graphed exceeds 1.0e38.

sum of piechart data is zero

The sum of the pie chart data being graphed is zero. Since percentages are determined by dividing by the sum, and division by zero is undefined, this does not work.

target is not a valid numeric value

The target value specified for a goal seek is not a valid number.

titles already locked

User has attempted to lock titles when they are already locked.

titles not locked

User has attempted to unlock titles when they are already unlocked.

token buffer overflow

This error can only occur when a formula is entered which is more complex than NExS can accept. NExS can accept up to 200 operators, numbers, function calls, and text strings in a single formula, which is more than any human can reasonably deal with.

too few arguments

The function requires more arguments.

too few contour levels were requested

Fewer than 3 levels were requested in ``No. Ticks'' when drawing a contour graph.

too few points in plane

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

too few points in spline

A point on a spline is not within the legal X-range of the spline. This error can occur if the user tries to draw a spline through only a single point.

too few tick marks specified

At least 2 tick marks must be specified, one for the beginning, and the other for the end, of the axis.

too many arguments to function

User has provided too many arguments to the function. No function can take more than 100 arguments.

too many arguments

@NOT only takes one argument, unlike the rest of the digital logic functions. @ROW and @COL take 1 argument, @ANNOTATE takes 3-5 arguments.

too many graph editors

Only 20 graph editors can be activated at once.

too many graph viewers

Only 20 graph viewers can be activated at once.

too many simultaneous views

Only 10 views are allowed simultaneously.

Treasury Bill should not be outstanding more than 1 year

The period between the settlement date and maturity date of a Treasury bill should not exceed one year.

unable to open XS3 file

The operating system did not allow nexs to open the XS3 file in question.

unable to open file

The operating system did not allow nexs to open the file in question.

unable to parse extract filter

Happens when you are doing an Extract operation and you specify an invalid boolean expression; e.g., #==/5.

unable to parse search condition

Happens when you are doing a numeric search and you specify an invalid boolean expression; e.g., #==/5

undefined symbolic name

This error occurs when NExS encounters a symbolic range or cell reference which has not been defined. To use a symbolic name to refer to a cell or range, you must first define it using the ``Named Range...'' dialog box under the ``Edit'' menu.

unexpected question mark

NExS supports C-language compatible condition expressions, which use the operator pair ``?'' and ``:''. If one of these operators appears without the other, an error occurs.

unknown format

The format argument to the @FORMAT function must be a string containing one of the NExS cell format names appearing in the ``Cell Format'' menu in the ``Cell Format...'' Dialog box on the ``Format'' menu.

unknown object command

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

unknown type of graph data

A bug has been triggered in nexs. Please save a copy of your current spreadsheet and make a note of the action which caused this message, and contact NExS technical support.

unrecognized option in record

NExS file has probably been corrupted.

unrecognized record subtype

NExS file has probably been corrupted.

unrecognized record type

NExS file has probably been corrupted.

unresolved name in expression

A name which is not a valid function or named range has been used in the expression.

unspecified or invalid

A bug has been triggered in NExS. Please save a copy of your spreadsheet and the idraw file you created when this error appeared and contact NExS technical support.

unsupported .xs file option

While reading an .xs file, NExS encountered an object which is unrecognized. This probably indicates a corrupt .xs file.

``Upper limit'' must be >=0

The argument U (Upper limit) should be greater than or equal to 0 in @ERF.

``v'' option only allowed in formula records

Either your XS3 file is corrupt, or you are trying to read a file in another format as an XS3 file.

``values'' and ``dates'' series must have the same dimension

@XIRR and @XNPV require the argument V (cash flow series) and the argument D (date series) to have the same dimension.

``Values'' must have at least one inflow and one outflow

@MIRR requires the value range contains at least one income (positive value) or one payment (negative value)

Version 2 writes are unsupported

Writing to an old .xs file is not supported under version 3.

wks/wk1 file error

Your WKS or WK1 file is corrupt or NExS could not understand it.

would alter protected cells

This could happen with a copy, move, clear, extract or other operation that would overwrite or erase protected cells.

wrong number of arguments

The number of arguments passed to the function is incorrect. Check the reference manual to determine the correct number of arguments that the function expects.

X and Y data ranges have different sizes

Since all the X's and Y's come in pairs, the X and Y data ranges must be the same size.

X, Y, and Z data ranges have different sizes

Since all the X's, Y's, and Z's come in tuples, the X, Y, and Z data ranges must be the same size.

[X|Y|Z] axis maximum set too low

The specified axis has a maximum value which is too low. Raise the maximum using the ``X-'', ``Y-'', or ``Z Axis...'' dialog box on the Options menu of the graph editor.

[X|Y|Z] axis minimum set too high

The specified axis has a minimum set too high. Lower the minimum using the ``X-'', ``Y-'', or ``Z Axis...'' dialog box on the Options menu of the graph editor.

zero or negative coordinate in logarithmic plot

Logarithmic plots cannot plot negative or zero values.


next up previous contents index
Next: D Glossary Up: C NExS Error Messages Previous: C.1.3 Formula Evaluation Errors

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