Controls which cells cause the converter to truncate the array at that point.
This property controls how empty cells in an array input are treated. whether the argument is optional, and when it should be treated as missing, in which case the DefaultValueText is used. It must contain one of the following values:
TruncateArray 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. |