2.16.5 Output Notations

In most of X-Function dialogs, there is a Output variable, which is used to specify the output Origin Object. Besides the default setting <new> which means create a new Origin objects for output, you also can specify the desirable object in the text box to output the results to an existed object or new a object with specified name.

To specify a Origin Object, you should follow the syntax of range notation:

For Worksheet data, the whole notation is:
[WorkBookName]SheetNameOrIndex!ColumnNameOrIndex[CellIndex]
For matrix data, the whole notation is
[MatrixBookName]MatrixSheetNameOrIndex!MatrixObject
For graph data, the whole notation is
[GraphWindowName]LayerNameOrIndex!DataPlot

1 Output to Workbook
- 1.1 Output Worksheet
- 1.2 Output Range
2 Output Matrix
3 Output Graph

Output to Workbook

Output Worksheet

If the results are default output to worksheet, you can specify a worksheet to output using the following syntax:

[WorkBookName]SheetNameOrIndex!

For example, you can enter [Stackcol]Stackcol1! in the Output Worksheet box of wstackcol dialog to output the results to [Stackcol]Stackcol1. You also can type [<new>]<new> to output the result to a new worksheet of new workbook.

Optionally, you can specify use of a workbook template using the syntax ...

[WorkBookName]SheetNameOrIndex!<new template:=TemplateName>!

... where TemplateName>! is a custom OTW or OTWU file.

Output Range

If the results are default output to the columns of a worksheet, you can specify columns to output using the following syntax:

[WorkBookName]SheetNameOrIndex!ColumnNameOrIndex

If you want to output the results to the columns of source worksheet, only ColumnNameOrIndex need to be specified.

For example, you can enter [Conv]Conv1!(A,B) in the Output box of conv dialog to output the results to col(A) and col(B) of worksheet [Conv]Conv1. You also can type [<new>]<new>!(1,2) to output the result to a new worksheet of new workbook. To output the results to source worksheet, only enter (<new>,<new>), then the results will be output to the adjacent columns of source data range.

Output Matrix

If the results are default output to matrix sheet, you can specify the matrix sheet to output using the following syntax:

[MatrixBookName]MatrixSheetNameOrIndex!

For example, you can enter [Mshrink]Mshrink1! in the Output Matrix box of mshrink dialog to output the results to [Mshrink]Mshrink1. You also can type [<new>]<new> to output the results to a new matrix sheet in a new matrix.