SheetXL - v1.0.2
    Preparing search index...

    Options for DeferredCall.resolve.

    interface ResolveOptions {
        keepBlanks?: boolean;
    }
    Index
    keepBlanks?: boolean

    Whether the blanks of an array result stay blank when it spills. Omitted, they read as 0, as any spilled array's blanks do.

    For data whose empty fields mean "nothing here", such as an imported file. The result keeps them while a formula passes it on as it is (IF(c, result, …)). A function that answers element by element builds a new array, whose blanks read as 0 (IFERROR(result, …), result & "").

    false