Lets you specify the range of cells to be updated from the query output.
Parameter
Range The range of cells
{WhatIf}
Syntax
{WhatIf.Option}
PerfectScript Syntax
WhatIf_Block (Block:String)
WhatIf_Input_Cell_1 (Cell:String)
WhatIf_Input_Cell_2 (Cell:String)
WhatIf_One_Way ()
WhatIf_Reset ()
WhatIf_Two_Way ()
Description
{WhatIf} builds one- or two-variable "what-if" tables that display a range of results for different conditions.
If you are creating a one-variable table, use these command equivalents: {WhatIf.Input_Cell_1}, {WhatIf.Block}, {WhatIf.One_Way}. For two-variable tables, use {WhatIf.Input_Cell_2} after indicating the first input cell; use {WhatIf.Two_Way} instead of {WhatIf.One_Way}.
You can use {WhatIf?} or {WhatIf!} to display the What-If dialog box. {WhatIf?} lets you manipulate the dialog box, whereas {WhatIf!} relies on the macro to manipulate it.
Example
The following macro defines A4..H18 as the "what-if" cells, B1 as Input Cell 1, B2 as Input Cell 2, and builds a two-variable table.
{Whatif.Block A:A4..A:H18}
{Whatif.Input_cell_1 A:B1}
{Whatif.Input_cell_2 A:B2}
{Whatif.Two_Way}
Options
{WhatIf.Block Block} Specifies the cells where you want to write the data table.
{WhatIf.Input_Cell_1 Cell} Specifies the first (or only) cell referenced by the what-if formula.
{WhatIf.Input_Cell_2 Cell} Specifies the second cell referenced by a two-variable what-if formula.
{WhatIf.One_Way} Builds the table.
{WhatIf.Reset} Clears all settings.
{WhatIf.Two_Way} Builds the table.
{WhatIfExpert}
Description
{WhatIfExpert} displays the first What-If Expert dialog box. The macro has no arguments
{WindowArrIcon}
Syntax
WindowArrIcon()
Description
{WindowArrIcon} lines up minimized windows on the Quattro Pro desktop or icons on the Objects sheet.
{WindowCascade}
Syntax
WindowCascade()
Description
{WindowCascade} rearranges all open windows on the Quattro Pro desktop.
{WindowClose}
Syntax
WindowClose()
Description
{WindowClose} is equivalent to Close in a Control menu, which closes the active window (if the active window is not saved, a prompt appears to confirm the operation).
{WindowHide}
Syntax
WindowHide()
Description
{WindowHide} conceals the active notebook window.
{WindowMaximize}
Syntax
WindowMaximize
Description
{WindowMaximize} is equivalent to Maximize in a Control menu, which enlarges the active window so it fills the screen.
{WindowMinimize}
Syntax
WindowMinimize()
Description
{WindowMinimize} is equivalent to Minimize in a Control menu, which shrinks the active window to an icon on the Quattro Pro desktop.
{WindowMove} is equivalent to Move in a Control menu, which lets you move the active window. UpperLeftX and UpperLeftY are the new coordinates of the upper-left corner of the window.
Parameters
UpperLeftX Distance between the left side of the Quattro Pro window and the left side of the active window, in pixels
UpperLeftY Distance between the bottom of the input line and the top of the active window, in pixels
{WindowNewView}
Syntax
WindowNewView()
Description
{WindowNewView} displays a duplicate copy of the active notebook in a new window.
{WindowNext}
Syntax
WindowNext()
Description
{WindowNext} is equivalent to choosing Next in a Control menu. It makes the next window active.
{WindowPanes}
Syntax
WindowPanes(Mode As _WindowPanes_Mode_enum, Synch_ As _WindowPanes_Synch__enum, [Width As Double], [Height As Double])
{WindowPanes} splits a notebook window into two horizontal or vertical panes; use Clear to restore a single pane.
Width and Height indicate the ratio relationship between the panes.
You can use {WindowPanes?} or {WindowPanes!} to display the Split Window dialog box. {WindowPanes?} lets you manipulate the dialog box, whereas {WindowPanes!} relies on the macro to manipulate it.
Example
{WindowPanes Vertical,0,2,1} splits the notebook window into two vertical panes, not synchronized. The first pane is twice as wide as the second.
Parameters
Synch? Whether the panes are synchronized: yes (1) or no (0)
Width Width of the left pane or height of the upper pane (optional)
Height Width of the right pane or height of the lower pane (optional)
{WindowQPW}
Syntax
{WindowQPW.Option}
PerfectScript Syntax
WindowQPW_Maximize ()
WindowQPW_Minimize ()
WindowQPW_Restore ()
Description
{WindowQPW} is the command equivalent for the Maximize, Minimize, and Restore commands on the Quattro Pro Control menu.
¿ {WindowQPW.Maximize} enlarges the Quattro Pro window so it fills the screen.
¿ {WindowQPW.Minimize} shrinks the Quattro Pro window to an icon.
¿ {WindowQPW.Restore} restores the Quattro Pro window to its original size.
Options
{WindowQPW.Maximize} Maximizes the Quattro Pro application window.
{WindowQPW.Minimize} Minimizes the Quattro Pro application window.
{WindowQPW.Restore} Restores the Quattro Pro application window to its previous size.
{WindowRestore}
Syntax
WIndowRestore()
Description
{WindowRestore} is equivalent to Restore on the Control menu. It restores minimized windows to their original size.
{WindowShow}
Syntax
WindowShow(Name As String)
PerfectScript Syntax
WindowShow (Name:String)
Description
{WindowShow} shows hidden window Name and makes it active.
You can use {WindowShow?} or {WindowShow!} to display the Show Window dialog box. {WindowShow?} lets you manipulate the dialog box, whereas {WindowShow!} relies on the macro to manipulate it.
Parameters
Name Name of the hidden window to show
{WindowSize}
Syntax
WindowSize(x As Double, y As Double)
PerfectScript Syntax
WindowSize (X:Numeric; Y:Numeric)
Description
{WindowSize} is equivalent to Size in the Control menu. It sizes the active window to the specified width and height.
Parameters
X New window width, in pixels
Y New window height, in pixels
{WINDOWSOFF}
Syntax
WindowsOff()
Description
{WINDOWSOFF} disables normal screen updating during macro execution when Quattro Pro's Macro Suppress-Redraw property is set to None. It can significantly speed up execution for most macros because it saves Quattro Pro the time normally needed to redraw the screen each time a cell changes. Quattro Pro cancels it once the macro stops executing, so you are not "locked out" of the screen. To cancel its effect within the same macro, use {WINDOWSON}.
Use {WINDOWSOFF} with {PANELOFF} to completely disable normal screen updating.
After a {WINDOWSOFF} command, avoid pointing to cells in response to an Edit command. The selector may be in a different cell than the "frozen" display indicates. If you must point to cells, precede it with a {WINDOWSON} command.
Example
The following macro uses {WINDOWSOFF} and {WINDOWSON} to turn off screen updating while Quattro Pro sorts a list of vendors with the cell name vendor_name, thereby speeding up the sort operation.
sort_blk vendor_name
key_nm vendor_name
\W {QGOTO}sort_message~
{WINDOWSOFF}
{_sort vendor_name}
{WINDOWSON}
_sort {DEFINE sort_blk}
{Sort.Block @@(sort_blk)}
{BlockCopy sort_blk,key_nm}
{Sort.Key_1 @@(key_nm)}
{Sort.Order_1 "Ascending"}
{Sort.Go}
sort_message SORT IS IN PROGRESS
vendor_name General Cement Co.
Alveoli Mfg., Inc.
Sandab Development
Consolidated Dust
{WINDOWSON}
Syntax
WindowsOn()
Description
{WINDOWSON} reenables normal screen updating during macro execution, canceling the effects of a previous {WINDOWSOFF}. However, the screen will not be updated until {CALC} is encountered or the macro ends. If {WINDOWSON} is called when screen updating is already in effect, the command is ignored.
See {WINDOWSOFF}for an example using {WINDOWSON}.
{WindowTile}
Syntax
WindowsTile()
Description
{WindowTile} displays all open windows without overlapping them.
{WindowTitles} locks specific rows and/or columns of a spreadsheet sheet as titles on screen. When you scroll, the titles remain fixed on screen while the rows below (or columns to the right) scroll as usual. "Horizontal" locks rows above the active cell, "Vertical" locks columns to the left of the active cell, and "Both" locks both rows and columns. Use "Clear" to unlock the titles.
You can use {WindowTitles?} or {WindowTitles!} to display the Locked Titles dialog box. {WindowTitles?} lets you manipulate the dialog box, whereas {WindowTitles!} relies on the macro to manipulate it.
You can use {WindowTitles.Title} with @COMMAND, @PROPERTY, and @CURVALUE.
Example
Use @COMMAND{"WindowTitles.Title"} to determine whether locked titles are in use and to display their type (Horizontal, Vertical, Both, or Clear). You can also use this command in macros to check for locked titles.
Filename The name of the document you want to route
{Workflow.WorkflowManager}
Syntax
Workflow_WorkflowManager()
PerfectScript Syntax
Workflow_WorkflowManager ()
Description
{WorkSpace}
Syntax
{WorkSpace.Option}
PerfectScript Syntax
Workspace_Restore (Filename:String)
Workspace_Save (Filename:String)
Description
{Workspace.Save} saves all open notebooks as a group with the specified Filename (Quattro Pro's default file extension for workspaces is .WBS). {Workspace.Restore} opens the specified file.
Options
{Workspace.Restore Filename} Overlays any existing windows with the windows stored in the workspace file, then retrieves the appropriate file for each.
{Workspace.Save Filename} Saves the position and size of all notebook windows and the names of the files contained in each window.
