QS.FUNCTIONS

Spills the names of all worksheet functions registered by this XLL

Category: QuantSupport - System.

QS.FUNCTIONS(transpose: logical or blank) → spilled range
Parameters:
  • transpose (logical or blank) – Optional TRUE transposes the entire spill; omitted or blank defaults to FALSE; table headers move with their fields

Returns:

One-column spill of sorted, distinct registered worksheet names, including aliases; no header row. transpose=TRUE exchanges rows and columns; omitted transpose defaults to FALSE. Empty output returns a blank cell.

Return Type:

spilled range

Errors:

#VALUE! for invalid layout flags; use TRUE/FALSE or leave the argument blank. Invalid transpose/headers flags return #VALUE!; use TRUE/FALSE or leave optional flags blank.

Formula

=QS.FUNCTIONS(transpose)

Calculation

Runs on Excel’s main calculation thread.

Native Declaration

fn qs_functions (transpose : * const xll_rs :: types :: XLOPER12 ,) -> Result < * mut xll_rs :: types :: XLOPER12 , XllError >

Rust source