The flags described in the table below manage the conversion and truncation of input arrays.
| Flag | Meaning |
|---|---|
| XLA_TRUNC_NONE | Do not truncate. |
| XLA_TRUNC_ONZERO | Truncate array just before cell if cell contains zero. |
| XLA_TRUNC_ONEMPTY | Truncate array just before cell if cell is empty |
| XLA_TRUNC_ONNONNUMERIC | Truncate array just before cell if cell is not numeric |
| XLA_TRUNC_ONBLANK | Truncate array just before cell if cell is blank |
| XLA_TRUNC_STD | Standard flags: XLA_TRUNC_ONEMPTY |
| XLA_TRUNC_COL_FIRST | In a matrix, truncate the column, rather than the row. |
| XLA_DEFAULT_NONE | Do not use default value. |
| XLA_DEFAULT_ZERO | Use default value if cell contains zero. |
| XLA_DEFAULT_EMPTY | Use default value if cell is empty. |
| XLA_DEFAULT_NONNUMERIC | Use default value if cell is not numeric. |
| XLA_DEFAULT_BLANK | Use default value if cell is blank. |
| XLA_DEFAULT_STD | Standard flags: 0 |
| XLA_FLAG_TRANSPOSE | Transpose rows and columns. |
| XLA_FLAG_ARRAYONLY | Reject single cells. |
| XLA_FLAG_REJECT_NULL_ARRAY | Reject empty arrays (i.e. those with zero rows or columns. |
| XLA_FLAG_CONVERT_BOOLEAN | Convert Boolean values to strings or numbers as required |
| XLA_FLAG_CONVERT_NUMERIC | Convert numbers to strings as required |
| XLA_FLAG_CONVERT_ERROR | Convert errors values to strings or numbers as required |
| XLA_BOUND_UBOUND_INNER | Treat upper bound values as size - 1 (following Visual Basic conventions) |
| XLA_BOUND_UBOUND_OUTER | Treat upper bound values as size (following C/C++ conventions) |
| XLA_BOUND_UBOUND_AUTO | If 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:
| Function | Purpose |
|---|---|
| COper::ReadVector | Reads a vector from an array into a vector of numbers or strings |
| COper::ReadMatrix | Reads an array argument into a two-dimensional matrix of numbers or strings |
| COper::ColToVector | Reads a column from an array into a vector of numbers or strings |
| COper::RowToVector | Reads a row from an array into a vector of numbers or strings |
| COper::ToMatrix | Reads an array argument into a two-dimensional matrix of numbers or strings |
| CXlArray::ReadVector | Reads a vector from an array into a vector of numbers or strings |
| CXlArray::ReadMatrix | Reads 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.