Skip to main content
Version: Streamsheets 2.5

SHOWVALUES

To display values from a query in a boxed table use the SHOWVALUES() function in an event. Select the source and the size of your table, a event should trigger. The table can be scrolled through and closed again.

Syntax

=SHOWVALUES(Datasource, Targetrange)

Arguments

NameDescription
DatasourceA cell with a query (e.g. TIMESCALE.SELECT(), TIMEAGGREGATE())
TargetrangeA range to display the data over.

Return

TRUE.

Hint

This function should not be used in a cell

Examples

FormulaResultComment
=SHOWVALUES(C6,K2:N7)
If this formula is assigned to a shape event, queried data from C6 will be shown in a table covering K2:N7.