{NAME} is equivalent to the Choices key, F3, which displays a list of cell names in the current notebook, if cell names exist in the notebook. (If there are no named cells, the list of cell names won't appear.)
Use {NAME} with {GOTO}.
Example
{GOTO}{NAME}
{NamedStyle}
Syntax
{NamedStyle.Option}
PerfectScript Syntax
NamedStyle_Alignment(Settings As String)
NamedStyle_Define(StyleName As String, Align_ As _NamedStyle_Define_Align__enum, NumericFormat_ As _NamedStyle_Define_NumericFormat__enum, Protection_ As _NamedStyle_Define_Protection__enum, Lines_ As _NamedStyle_Define_Lines__enum, Shading_ As _NamedStyle_Define_Shading__enum, Font_ As _NamedStyle_Define_Font__enum, TextColor_ As _NamedStyle_Define_TextColor__enum)
NamedStyle_Delete(StyleName As String)
NamedStyle_Font(Settings As String)
NamedStyle_Line_Drawing(Settings As String)
NamedStyle_Numeric_Format(Settings As String)
NamedStyle_Protection(Settings As String)
NamedStyle_Shading(Settings As String)
NamedStyle_Text_Color(ColorID As Integer)
Description
{NamedStyle} lets you create styles in the active notebook.
These command equivalents do not take effect until the command {NamedStyle.Define} is used to create (or modify) a style. The arguments Align? through TextColor? each specify one property to include in the style; use 1 to include the property, 0 to exclude the property.
{NamedStyle.Font} sets the new typeface and size of text in the cell. Bold, Italic, Underline and Strikeout can be "Yes" to include that type feature or "No" to omit it.
{NamedStyle.Shading} sets the shading of the cell; ForegroundColor and BackgroundColor are numbers from 0 to 15; each specifies a color on the notebook palette to use; Pattern is a string ("Blend1" through "Blend7").
You can use {NamedStyle?} or {NamedStyle!} to display the Styles dialog box. {NamedStyle?} lets you manipulate the dialog box, whereas {NamedStyle!} relies on the macro to manipulate it.
Example
This macro creates a new style named RedNote, which makes the active cells red, and sets a new font.
{Navigate} is equivalent to the navigation tools available on the Data Manipulation Toolbar. {Navigate.SelectTable} is equivalent to the SpeedSelect button on the Data Manipulation Toolbar, which expands selection from a cell or cells within a table to the entire table. {Navigate.Zoom2Fit} is equivalent to the Zoom To Fit button. {Navigate.GoTo} performs the same actions as the Top Left Of Table, Top Right Of Table, Bottom Left Of Table, and Bottom Right Of Table buttons. {Navigate.Jump} jumps to the next table or to the selected boundary of the current table.
Example
The following macro selects cell C6 in the table below, then selects the entire table that C6 belongs to, and zooms to fit the table on the page.
{SelectBlock A:C6}
{Navigate.SelectTable}
{Navigate.Zoom2Fit}
A B C D
1 Sales Expenses Profits
2 Jan 1580 700 880
3 Feb 2474 545 1929
4 Mar 2570 656 1914
5 Apr 2876 454 2422
6 May 3223 489 2734
7 Jun 2987 470 2517
8 Jul 3178 500 2678
Options
{Navigate.SelectTable} Expands selection to the table boundaries
{Navigate.Zoom2Fit} Zooms so that a table fits into the visible part of the screen
{Navigate.GoTo Up | Left | Right | Down | TopLeft | TopRight | BottomLeft | BottomRight , <Extend?(0|1)>} Go to the sides or corners of a table. When the optional Extend? argument is 1, cell selection is extended.
{Navigate.Jump Up | Left | Right | Down} Jump to the next table in a given direction, or jump to the current table boundary if in the middle of a table.
{NEXTPANE}
Syntax
NextPane()
PerfectScript Syntax
NextPane ()
Description
{NEXTPANE} switches between the panes of a notebook window previously split. The optional argument CellAtPointer? specifies whether the active cell in the pane will be at the location of the selector (1) or its previous position (0). This command is equivalent to the Pane key, F6.
Parameters
CellAtPointer? Specifies which cell should be active when the pane switches (0 or 1, optional)
{NEXTTOPWIN}
Syntax
NextTopWin()
PerfectScript Syntax
NextTopWin ()
Description
{NEXTTOPWIN} is equivalent to the Next Window key, Ctrl+F6. It makes the next window active and moves the selector to it.
Parameters
Number Number of times to repeat the operation (optional)
{NEXTWIN}
Syntax
NextWin()
PerfectScript Syntax
NextWin ()
Description
{NEXTWIN} is equivalent to Shift+F6. It makes the bottom window active and moves the selector to it. This macro is included for compatibility with Corel Quattro Pro for DOS.
Parameters
Number Number of times to repeat the operation (optional)
{Notebook_Display}
Syntax
Notebook_Display(Settings As String)
PerfectScript Syntax
Notebook_Display_Objects(Mode As String)
Notebook_Display_Show_HorizontalScroller(Show_ As _Notebook_Display_Show_HorizontalScroller_Show__enum)
Notebook_Display_Show_HorizontalScroller(Show_ As _Notebook_Display_Show_HorizontalScroller_Show__enum)
Notebook_Display_Show_Tabs(Show_ As _Notebook_Display_Show_Tabs_Show__enum)Notebook_Display_Show_Tabs(Show_ As _Notebook_Display_Show_Tabs_Show__enum)
Notebook_Display_Show_VerticalScroller(Show_ As _Notebook_Display_Show_VerticalScroller_Show__enum)
Description
{Notebook.Display} is equivalent to options of the notebook property Display.
Example
This macro command hides the vertical and horizontal scroll bars of the active notebook, reveals the sheet tabs, and shows all objects.
{Notebook.Display "No,No,Yes,Show All"}
Options
{Notebook.Display "VertScroll, HorizScroll, Tabs, Objects"} Sets display characteristics for the active notebook
{Notebook.Display.Objects Show All|Show Outline|Hide} Specifies which parts of the notebook to display
{Notebook.Display.Show_HorizontalScroller Yes|No} Displays or hides the horizontal scroll bar
{Notebook.Display.Show_Tabs Yes|No} Displays or hides the sheet tabs
{Notebook.Display.Show_VerticalScroller Yes|No} Displays or hides the vertical scroll bar
{Notebook_Group_Mode}
Syntax
Notebook_Group_Mode(Mode As String)
PerfectScript Syntax
Notebook_Group_Mode (Mode:String)
Description
{Notebook.Group_Mode} activates or deactivates group mode.
{Notebook.Macro_Library}
Syntax
Notebook_Macro_Library(Enable_ As _Notebook_Macro_Library_Enable__enum)
{Notebook.Macro_Library } is equivalent to options of the notebook property Macro Library. To make the active notebook a macro library, use Yes.
{Notebook_Password}
Syntax
Notebook_Password(Password As String)
PerfectScript Syntax
Notebook_Password (Password:String)
Notebook_Password_Level (Level:String)
Description
{Notebook.Password} sets the password of the active notebook. The next save operation encrypts the file on disk.
Tips
¿ Before specifying a password, set the password level using {Notebook.Password_Level}.
{Notebook_Password_Level}
Syntax
Notebook_Password_Level(Settings_ As String)
PerfectScript Syntax
Notebook_Password_Level (Level:String)
Description
{Notebook.Password_Level} sets the password level of the active notebook. If you specify a password level of Low, Medium, or High, you must also specify a password using {Notebook.Password}.
{Notebook_Recalc_Settings}
Syntax
Notebook_Recalc_Settings(Settings As String)
PerfectScript Syntax
Notebook_Recalc_Settings (Settings:String)
Description
{Notebook.Recalc_Settings} is equivalent to options of the notebook property Recalc Settings. This command equivalent sets the recalculation options of the active notebook. Mode options are "Automatic," "Background," and "Manual." Order can be "Column-wise," "Row-wise," or "Natural." Iterations specifies the number of times formulas are recalculated before calculation is considered complete (relevant only if Order is changed, or if you use circular references).
To highlight the source of error for each cell containing NA or ERR in the active notebook, set the optional argument AuditErrors? to 1.
{Notebook_Summary}
Syntax
{Notebook.Summary.Option}
PerfectScript Syntax
Notebook_Summary (Settings:String)
Notebook_Summary_Author (Author:String)
Notebook_Summary_Comments (Comments:String)
Notebook_Summary_Keywords (Keywords:String)
Notebook_Summary_Subject (Subject:String)
Notebook_Summary_Title (Title:String)
Description
{Notebook.Summary} displays summary information about the current notebook.
You can use the following options with @COMMAND to get information about the notebook.
Notebook.Statistics.Created
Notebook.Statistics.Directory
Notebook.Statistics.FileName
Notebook.Statistics.Last_Saved
Notebook.Statistics.Last_Saved_By
Notebook.Statistics.Revision_Number
Example
@COMMAND("Notebook.Statistics.Created")
Options
{Notebook.Summary.Title Title } Specifies a title for the notebook
{Notebook.Summary.Subject Subject} Specifies a subject for the notebook
{Notebook.Summary.Author Author} Specifies an author for the notebook
{Notebook.Summary.Keywords Keywords} Specifies keywords for the notebook
{Notebook.Summary.Comments Comments} Specifies comments for the notebook
{Notebook_System}
Syntax
Notebook_System(Enable_ As _Notebook_System_Enable__enum)
PerfectScript Syntax
Notebook_System (Enable?:Enumeration {Yes!; No!})
Description
{Notebook.System Yes|No} makes the active notebook a system notebook.
{Notebook_Zoom_Factor}
Syntax
Notebook_Zoom_Factor(Factor As Integer)
PerfectScript Syntax
Notebook_Zoom_Factor (Factor:Numeric)
Description
{Notebook.Zoom_Factor} is equivalent to options of the notebook property Zoom Factor, which sets the zoom factor of the active notebook (from 10% to 400%). This setting is for display only and does not affect printed output.
{NUMOFF} and {NUMON}
Syntax
NumOff()
Description
{NUMOFF} and {NUMON} are equivalent to Num Lock off and Num Lock on, respectively.
