XLL+ Class Library

vector<T> and matrix<T> Flags

The flags described in the table below manage the conversion and truncation of input arrays.

FlagMeaning
XLA_TRUNC_NONEDo not truncate.
XLA_TRUNC_ONZEROTruncate array just before cell if cell contains zero.
XLA_TRUNC_ONEMPTYTruncate array just before cell if cell is empty
XLA_TRUNC_ONNONNUMERICTruncate array just before cell if cell is not numeric
XLA_TRUNC_ONBLANKTruncate array just before cell if cell is blank
XLA_TRUNC_STDStandard flags: XLA_TRUNC_ONEMPTY
XLA_TRUNC_COL_FIRSTIn a matrix, truncate the column, rather than the row.
XLA_DEFAULT_NONEDo not use default value.
XLA_DEFAULT_ZEROUse default value if cell contains zero.
XLA_DEFAULT_EMPTYUse default value if cell is empty.
XLA_DEFAULT_NONNUMERICUse default value if cell is not numeric.
XLA_DEFAULT_BLANKUse default value if cell is blank.
XLA_DEFAULT_STDStandard flags: 0
XLA_FLAG_TRANSPOSETranspose rows and columns.
XLA_FLAG_ARRAYONLYReject single cells.
XLA_FLAG_REJECT_NULL_ARRAYReject empty arrays (i.e. those with zero rows or columns.
XLA_FLAG_CONVERT_BOOLEANConvert Boolean values to strings or numbers as required
XLA_FLAG_CONVERT_NUMERICConvert numbers to strings as required
XLA_FLAG_CONVERT_ERRORConvert errors values to strings or numbers as required
XLA_BOUND_UBOUND_INNERTreat upper bound values as size - 1 (following Visual Basic conventions)
XLA_BOUND_UBOUND_OUTERTreat upper bound values as size (following C/C++ conventions)
XLA_BOUND_UBOUND_AUTOIf lower bound is non-zero, then treat upper bound values as size - 1 (following Visual Basic conventions). If lower bound is zero, then treat upper bound values as size (following C/C++ conventions)

These flags are used in the following functions:

FunctionPurpose
COper::ReadVectorReads a vector from an array into a vector of numbers or strings
COper::ReadMatrixReads an array argument into a two-dimensional matrix of numbers or strings
COper::ColToVectorReads a column from an array into a vector of numbers or strings
COper::RowToVectorReads a row from an array into a vector of numbers or strings
COper::ToMatrixReads an array argument into a two-dimensional matrix of numbers or strings
CXlArray::ReadVectorReads a vector from an array into a vector of numbers or strings
CXlArray::ReadMatrixReads an array argument into a two-dimensional matrix of numbers or strings

See Bounded input arrays for more information on the use of upper bounds.

See Also

Bounded input arrays