Controls how empty cells in an array are handled.
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:
| Value | Description |
|---|---|
| None | Empty cells are discarded (if array truncation settings allow it) or rejected. |
| FillUsedArea | All empty cells within the used area are filled with the default value. The used area is defined as being the smallest rectangular area which includes all populated cells and also the origin (0, 0). |
| FillAll | All empty cells are filled with the default value. |
Cells are classed as empty according to the flags of the CellUseDefault property.