{OBJECTSPAGEGOTO} displays the Objects sheet of the active notebook. When the Objects sheet is active, you can use {SELECTOBJECT} to select icons, and other object commands to manipulate them.
You can use {SELECTBLOCK} to move from the Objects sheet to a spreadsheet sheet.
Linked {OLE.DoVerb}, {OLE.Change_Link}, {OLE.Update}, {OLE.Convert}, {OLE.Change_To_Picture}, {OLE.DisplayAsIcon}, and {OLE.ActivateAs}
Example
This macro selects an OLE object named Embedded1, lets you edit the data (in the OLE server), then converts the object into a picture (disabling the OLE link).
{SELECTFLOAT Embedded1}
{OLE.DoVerb Edit}
{OLE.Change_To_Picture}
Options
{OLE.ActivateAs ObjectType} Opens the object using a different but compatible application
{OLE.AutomaticResize 0|1} Automatically resizes the object after you edit it
{OLE.AutomaticUpdate 0|1} Turns automatic updating on or off
{OLE.Change_Link FileName} Switches links from one file to another
{OLE.Change_To_Picture} Clicks to convert the embedded picture to a differenty type
{OLE.Convert ObjectType} Converts the embedded information to a different type
{OLE.DisplayAsIcon 0|1} Displays the embedded object as an icon
{OLE.DoVerb Action} Plays, edits, or opens the object
{OLE.OpenEdit} Opens the original application to edit the object
Normally, if an error occurs during macro execution, the macro ends and you see an error message. {ONERROR} tells Quattro Pro to branch to a different location (BranchLocation) if an error is encountered and to store the error message in MessageLocation for future reference. Quattro Pro stores the location of the error in ErrorLocation. MessageLocation and ErrorLocation are optional. If MessageLocation is omitted, no error message will be displayed or stored.
Only one {ONERROR} command can be in effect at a time, so each time it is called, the most recent {ONERROR} replaces the previous one. If an error occurs, the {ONERROR} state is "used up" and must be redeclared. It is best to declare {ONERROR} at the very beginning of your macro, or at least before any procedure is likely to result in an error.
In general, {ONERROR} will not capture macro programming errors, such as an incorrect sequence of commands, or an attempt to call a nonexisting subroutine. Nor will it detect syntax errors within a macro itself, such as an error resulting from the incorrect use of a macro keyword.
Typical errors that {ONERROR} detects include
¿ disk errors, such as a disk drive door left open, a full disk, or failure to find a file of a given name
¿ attempts to copy to a protected cell when a notebook's protection property is enabled
¿ attempts to insert a row that would push a nonblank cell off the bottom of the notebook
Example
The following macro uses {ONERROR} by first deliberately causing an error (trying to insert a row that would push text off the bottom of the notebook), then beeping when that error occurs.
\G {ONERROR _on_err,err_msg,err_loc}
{EditGoto A8192}
{PUTCELL "This is the end"}
{UP}
{BlockInsert.Rows C(0)R(0), "Entire"}
_on_err {BEEP 5}
err_msg
err_loc
Parameters
BranchLocation First cell of the macro to run in case of an error
MessageLocation Cell in which to store any error message (optional)
ErrorLocation Cell in which to store the address of the cell containing the macro error (optional)
ServiceName A string indicating the type of online service to use.
Arguments A string indicating the command line to pass to the service.
{OPEN}
Syntax
{OPEN Filename,AccessMode}
Description
{OPEN} establishes a connection to Filename so you can use other file-access macro commands ({READ}, {WRITE}, and so on) on it. There are five different access modes:
R (Read-Only) Allows only reading from this file, ensuring no changes are made to it. {WRITE} and {WRITELN} cannot be used with a file opened as read-only.
M (Modify) Opens an existing file for modification. All reading and writing commands can be used with a file opened for modification. You can also use this access mode to open a stream to a communications port (for example, "COM1") or a printer port (for example, "LPT1").
W (Write) Opens a new file with the name given in {OPEN}. If a file already exists with that name, the existing file is erased. All reading and writing commands can be used with a file opened for writing.
A (Append) Opens an existing file for modification. Allows writing to the selected file only, and positions the file pointer at the end of the file.
L (Locate) Opens and closes a file to locate it.
Filename's full name and access path must be given, and the entire name must be in quotes. For instance, to open and modify the file DATA.TXT in the subdirectory called FILES on drive C, use the command {OPEN "C:\FILES\DATA.TXT",M}. If any part of the access path or file name is left out, the file might not be found.
Although {OPEN} can provide access to any type of file (including .WB3 spreadsheet files), Quattro Pro's file-access macro commands are designed to work only with plain text files. Using these commands with any other file type is not recommended and can result in corruption of that file. Make a backup copy of your file before using {OPEN} on it.
Once {OPEN} runs successfully, Quattro Pro skips to the next row of the macro and continues executing instructions there. {OPEN Filename,R}, {OPEN Filename,M}, and {OPEN Filename,A} fail if the file is not found. {OPEN Filename,W} fails if the supplied access path or file name is invalid. If {OPEN} fails, Quattro Pro continues executing commands in the same cell as the {OPEN} command. (See the third macro below for an example.) You can use {ONERROR} to trap some errors that occur in {OPEN}.
Example
The following example opens the file named MYDATA.TXT for reading. If the file does not exist in the default data directory, the command fails.
{OPEN "MYDATA.TXT",R}
The next example creates a file MYDATA.TXT on drive A for writing. If there is already a file on drive A with that name, it is erased. This command will fail only if there is no disk in drive A.
{OPEN "A:MYDATA.TXT",W}
The last example demonstrates how to do error trapping in an {OPEN} macro. When you press Ctrl+H, Quattro Pro attempts to open the file C:\MYDIR\DATA.TXT. If that succeeds, the macro stops, since there are no more commands in the row below. If {OPEN} fails (meaning the file does not exist), the adjacent {BRANCH} runs. The subroutine _try_again then attempts to create the file. If that succeeds, the macro restarts, since {OPEN} should succeed now that the file has been created. If _try_again fails, probably an invalid directory path was given. Therefore, the adjacent {BRANCH} goes to _bad_dir, which displays a relevant error message with pertinent instructions.
{Optimizer} performs goal-seeking calculations and solves sets of linear and nonlinear equations and inequalities.
Constraint# refers to a constraint's order in the constraint list. Constant may be a value or a cell containing a value. The Value for Target_Value may also be a value or a cell. Use {Optimizer.Solve} after the other commands to calculate the solution.
To save an Optimizer model, use {Optimizer.Model_Cell Cell} {Optimizer.Save_Model}. To load a model, use {Optimizer.Model_Cell Cell}{Optimizer.Load_Model}
You can use {Optimizer?} or {Optimizer!} to display the Optimizer dialog box. {Optimizer?} lets the user manipulate the dialog box, whereas {Optimizer!} relies on the macro to manipulate it.
Example
The following macro sets up an Optimizer problem designed to maximize the formula in D6 by varying cells B8..B10. Seven constraints limit the solution. All options have been changed from their default settings. T2 and G13 are the upper-left cells of the report selections.
{Optimizer.Solution_cell A:D6}
{Optimizer.Solution_goal Max}
{Optimizer.Variable_cells A:B8..A:B10}
{Optimizer.Add 1,"A:D8..A:D8",<=,"1000"}
{Optimizer.Add 2,"A:B8..A:B8",>=,"100"}
{Optimizer.Add 3,"A:B9..A:B9",>=,"100"}
{Optimizer.Add 4,"A:B10..A:B10",>=,"100"}
{Optimizer.Add 5,"A:D8..A:D8",>=,"500"}
{Optimizer.Add 6,"A:D9..A:D9",<=,"900"}
{Optimizer.Add 7,"A:D10..A:D10",<=,"110000"}
{Optimizer.Max_Time 50}
{Optimizer.Max_Iters 300}
{Optimizer.Precision 5E-05}
{Optimizer.Linear 1}
{Optimizer.Show_Iters 1}
{Optimizer.Estimates Quadratic}
{Optimizer.Derivatives Central}
{Optimizer.Search Conjugate}
{Optimizer.Detail_Reporting A:T2..A:T2}
{Optimizer.Answer_Reporting A:G13..A:G13}
{Optimizer.Solve}
Options
{Optimizer.Add Constraint#, Cell, <=|>=|=|Integer, Constant} Adds a new constraint
{Optimizer.Answer_Reporting Cell} Specifies the cells for the Answer Report
{Optimizer.Auto-scale 0|1} Automatically scales variables to achieve a target value
{Optimizer.Change Constraint#, Cell, <=|>=|=|Integer, Constant} Edits the selected constraint
{Optimizer.Delete Constraint#} Removes the selected constraint
{Optimizer.Derivatives Central|Forward} Selects differencing for estimates of partial derivatives
{Optimizer.Detail_Reporting Cell} Specifies the cells for the Detail Report
{Optimizer.Estimates Quadratic|Tangent} Specifies the approach used to obtain initial estimates of the basic variables in each iteration
{Optimizer.Linear 0|1} Uses a linear method to solve the problem
{Optimizer.Load_Model} Loads cells of Optimizer settings
{Optimizer.Max_Iters Value} Sets the maximum number of iterations or trails
{Optimizer.Max_Time Value} Indicates how long Optimizer can spend looking for the best solution
{Optimizer.Model_Cell Cell} Saves cells of Optimizer settings for later use
{Optimizer.Precision Value} Controls the accuracy of the solution
{Optimizer.Reset} Clears Optimizer settings
{Optimizer.Save_Model} Saves cells of Optimizer settings for future use
{Optimizer.Search Conjugate|Newton} Selects a method for computing the search direction
{Optimizer.Show_Iters 0|1} Pauses between iterations so you can check the progress of the search
{Optimizer.Solution_Cell SolutionCell} Specifies the cell whose value you want Optimizer to measure
{Optimizer.Solution_Goal Max|Min|None|Target Value} Specifies maximum, minimum, and target values
{Optimizer.Solve} Finds a solution to the defined problem
{Optimizer.Target_Value Value} Specifies the value to be reached by the formula in the Solution Cell
{Optimizer.Tolerance Value} Indicates the maximum percentage a solution can differ from a theoretical optimum integer solution
{Optimizer.Variable_Cells Cell(s)} Specifies the cells the Optimizer can adjust to reach an optimal solution
{Order}
Syntax
{Order.Option}
PerfectScript Syntax
Order_Backward ()
Order_Forward ()
Order_ToBack ()
Order_ToFront ()
Description
{Order} reorders overlapping objects in a chart or dialog window. Each command affects selected objects in the active window.
Options
{Order.Backward} Sends the selected object back one layer
{Order.Forward} Sends the selected object forward one layer
{Order.ToBack} Sends the selected object to the back layer
{Order.ToFront} Sends the selected object to the front layer
{Outline} defines, creates, manipulates, and groups outlines.
Options
{Outline.AutoOutline} Creates an outline automatically on the current pane/page
{Outline.Group} Groups rows or columns. If the cells are not an entire row or column, whichever one contains the most elements (rows or columns) will be grouped
{Outline.Ungroup} Ungroups rows or columns. If the cells are not an entire row or column, whichever one contains the most elements (rows or columns) will be ungrouped. If the cells do not span the ENTIRE group, only those rows/columns that are inside the cells will be ungrouped
{Outline.UngroupAll} Destroys all groups on the current pane/page
{Outline.Expand} Expands a collapsed group of rows or columns. If the cells are not an entire row or column and are inside a group, whichever one contains the most elements (rows or columns) and is inside a current group, will be expanded
{Outline.Collapse} Collapses an expanded group of rows or columns. If the cells are not an entire row or column and are inside a group, whichever one contains the most elements (rows or columns) and is inside a current group will be collapsed
{Outline.Hide 0|1} Either hides or shows the outline in the current pane/page
{Outline.Summary Above|Below, Left|Right} Sets whether the summary will be above or below for row-based groups, and left or right for column-based groups
{Outline.ToLevel Rows|Columns, Level} Collapses or expands a group or rows or columns at a specific level
