{EDIT} is equivalent to the Edit key, F2. Its main use is in Edit mode, where it lets you edit the contents of the active cell. You can also use it to search for items in a long list.
{EditClear}
Syntax
EditClear
Description
{EditClear} erases the contents and properties of the current cells, deletes selected objects from dialog and chart windows, and deletes selected floating objects. To erase cells while leaving their properties intact, use {ClearContents}.
{EditCopy}
Syntax
EditCopy()
Description
{EditCopy} copies the selected object to the Clipboard.
{EditCut}
Syntax
EditCut}
Description
{EditCut} removes the selected object from the spreadsheet and moves it to the Clipboard.
{EditGoto}
Syntax
EditGoto(Block As String, [Extend_ As _EditGoto_Extend__enum])
{EditGoto} selects and displays Block within spreadsheet sheets, but not the Objects sheet.
You can use {EditGoto?} or {EditGoto!} to display the Go To dialog box. {EditGoto?} lets the user manipulate the dialog box, whereas {EditGoto!} relies on the macro to manipulate it.
Parameters
Block Cells to display and select
Extend? Whether to extend the selection from the current selection to the specified cells; 0 = no, 1 = yes; the default is 0
{EditPaste}
Syntax
EditPaste()
Description
{EditPaste} copies data and its properties from the Clipboard into the notebook.
To paste only values or properties, use {PasteSpecial}. {PasteLink} creates a live DDE link, and {PasteFormat} adds many types of data from other applications (including embedded OLE objects).
{Eval}
Syntax
Eval(Formula As String)
PerfectScript Syntax
Eval (Formula: String)
Description
Evaluates a string as an expression, and returns the result as a string value.
Example
"5 + 5"
Result: "10"
Parameter
Formula The string to evaluate
{EXECAUTO}
Syntax
ExecAuto(AutoExpr1 As String, [AutoExpr])
PerfectScript Syntax
ExecAuto (AutoExpr1:String; {[AutoExpr:String]})
Description
{EXECAUTO} executes one or more methods in another application, but drops any return values.
Example
{EXECAUTO calc.Display()} asks DispCalc to display its current input value.
{EXECAUTO calc.Button(A1), calc.Display()} passes the value in A1 as an input to DispCalc and asks DispCalc to display it.
For more details on using {EXECAUTO} and other OLE automation macro commands, see Using OLE Automation Features.
Parameters
AutoExpr1,2... One or more automation expressions
{ExecMacro}
Syntax
ExecMacro(FileName As String, Macro As String)
PerfectScript Syntax
ExecMacro ([Filename: String;] Macro: String)
Description
Starts Quattro Pro, opens the file, runs the macro, and exits Quattro Pro.
Parameters
Filename [optional] The name of the file that contains the macro you want to run.
Macro The name of the macro you want to run.
{EXPON}
Syntax
EXPON(InBlock As String, OutBlock As String, [Damping As Double], [StdErrs_ As _EXPON_StdErrs__enum])
{EXPON} performs exponential smoothing on a series of values. {EXPON} is equivalent to the Exponential Smoothing analysis tool.
Parameters
InBlock Input cells containing a single column or row with at least four numeric values; the cells must not contain labels
OutBlock Upper-left cell of the output cells
Damping Damping factor used as the exponential smoothing constant; indicates the percentage for error to adjust each prior forecast value; must be │ 0; the default is 0.3
StdErrs Flag indicating whether standard errors are included in the output table: yes (1) or no (0); the default is 0
{ExportGraphic}
Syntax
ExportGraphic(FileName As String, [GrayScale_ As _ExportGraphic_GrayScale__enum], [Compression_ As _ExportGraphic_Compression__enum])
{ExportGraphic} saves selected graphic objects to one of several file types with optional gray-scaling and compression.
You can use {ExportGraphic?} or {ExportGraphic!} to display the Export Graphics File dialog box. {ExportGraphic?} lets the user manipulate the dialog box, whereas {ExportGraphic!} relies on the macro to manipulate it.
Parameters
Filename Name of the graphic file to export
GrayScale? Whether to gray-scale: no (0), yes (1); the default is 0
Compression? Type of .TIF file compression to use: none (0) or PackBits (1); the default is 0
