XLL+ Class Library (7.0)

Settings.DefaultTruncateArrayFlags

Array truncation flags applied by default to array arguments

Remarks

When an argument is edited so that it becomes a vector or matrix, the truncation flags selected in this property will automatically be applied to it.

DefaultTruncateArrayFlags may include any, all or none of the following flags:

Flag Description
TruncateOnEmpty 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.
TruncateOnNonNumeric Array is truncated at first non-numeric cell. If FillUsedArea is used, array is truncated at last non-numeric cell, searching backwards.
TruncateOnZero Array is truncated at first cell containing the numeric value zero. If FillUsedArea is used, array is truncated at last zero cell, searching backwards.

See Also

Settings Model | Settings Properties | Argument truncation flags