XLL+ Class Library (7.0)

Settings.DefaultFillArrayTargets

Array fill 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.

This property controls which cells in an array are treated as missing. If the FillArray property is set to a value other than None, then these cells will be filled with a default value.

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

Flag Description
FillEmptyCells Cells that are empty are considered to be missing.
FillBlankCells Blank cells are considered to be missing. This would include a cell containing ="".
FillZeroCells Numeric cells with zero values are considered to be empty.
FillNonNumericCells Non-numeric cells are considered to be empty.

See Also

Settings Model | Settings Properties | Argument cell defaults