Flag values governing the behavior of an argument during conversion from Excel form to C++ form.

Namespace:  XllPlus
Assembly:  Psl.XL6.XnReflect.Runtime (in Psl.XL6.XnReflect.Runtime.dll) Version: 6.3.4.831 (6.3.4.0831)

Syntax

C#
[FlagsAttribute]
public enum XlArgumentFlags
Visual Basic (Declaration)
<FlagsAttribute> _
Public Enumeration XlArgumentFlags
Visual C++
[FlagsAttribute]
public enum class XlArgumentFlags

Members

Member nameDescription
None
No flags specified.
Optional
Argument is optional. If omitted, empty or blank, a default value will be supplied. The values of NilToDefault, NonNumericToDefault and BlankToDefault further control the behavior of empty or blank cells respectively.
BlankToDefault
Blank cells are treated as missing
NonNumericToDefault
Convert non-numeric cells to the default value
ZeroToDefault
Convert zero values to the default value
TruncateOnNil
Array is truncated at first empty cell. If FillUsedArea is used, array is truncated at last empty cell, searching backwards.
TruncateOnBlank
Array is truncated at first blank cell. If FillUsedArea is used, array is truncated at last blank cell, searching backwards.
TruncateOnZero
Array is truncated at first zero cell. If FillUsedArea is used, array is truncated at last zero cell, searching backwards.
TruncateOnNonNumeric
Array is truncated at first non-numeric cell. If FillUsedArea is used, array is truncated at last non-numeric cell, searching backwards.
VectorIsRow
Vector argument must be a row
VectorIsColumn
Vector argument must be a column
FillUsedArea
Fill the missing cells in the non-truncated area with the default cell value.
FillAll
Fill all missing cells with the default cell value.
TransposeMatrix
Transpose the rows and columns of the matrix.
FlatMatrixStorage
Store matrix data in a continuous, "flat", form. The default is a vector of pointers to uniform vectors.
RejectNullArray
Fail if an array is empty after truncation.
UpperBoundInner
Ignored
UpperBoundAuto
Ignored
CellEmptyToDefault
If a Fill flag is specified, convert empty cells to the default cell value.
CellBlankToDefault
If a Fill flag is specified, convert blank cells to the default cell value.
CellZeroToDefault
If a Fill flag is specified, convert zero cells to the default cell value.
CellNonNumericToDefault
If a Fill flag is specified, convert non-numeric cells to the default cell value.
IgnoreValidation
Do not filter flag values during validation.
CoreFlagFilter
Flags excluded by this filter will not be passed on to the XLL+ function model. They may be used by the reflector.
ValueListIsExclusive
If true, then any input value that is not in the value list will be rejected at run-time.
ShowValueListInFormulaWizard
If true, then the value list will be displayed in a drop-down list in the Excel Formula Wizard.

See Also