Flag values governing the behavior of an argument during conversion
from Excel form to C++ form.
Namespace:
XllPlusAssembly: Psl.XL7.XnReflect.Runtime (in Psl.XL7.XnReflect.Runtime.dll) Version: 7.0.9.1411 (7.0.9.1411)
Syntax
| C# |
|---|
[FlagsAttribute] public enum XlArgumentFlags |
| Visual Basic (Declaration) |
|---|
<FlagsAttribute> _ Public Enumeration XlArgumentFlags |
| Visual C++ |
|---|
[FlagsAttribute] public enum class XlArgumentFlags |
Members
| Member name | Description | |
|---|---|---|
| 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
