Used to transform the results of a FormQueryPlugin query into a format which SpreadSheetPlugin can operate on. %QUERYTOCALC accepts all the same parameters as %TABLEFORMAT (except name), and also the following parameters:
Parameter Description
query Required, gives the name of the query to show
start Optional, first row to display
limit Optional, number of rows to display, or all
For example,
The query must be formatted as a table. This variable produces no output, but must precede any calculation on the resultant query.

Topic revision: r1 - 17 Nov 2009, CrawfordCurrie - This page was cached on 12 Jan 2018 - 22:35.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License