SmartWare Online Help

What's NewHelp CommandsHelp About-HelpRelated TopicsSearch StringHelp ContentsHelp IndexHelp On-ErrorHelp TutorialRemember CommandsRemember StartCommandsKeysBothRemember FinishRemember ToolsRemember Tools CompileDebugNo-DebugRemember Tools EditThe SPL Editor/Debugger WindowFile FinishFile CloseEdit UndoEdit CutEdit Do-CopyEdit PasteEdit Select-AllEdit FindEdit Find FirstEdit Find NextEdit ReplaceEdit Jump-ToEdit Last-PositionEdit GotoSPL-Debug ExecuteSPL-Debug FinishSPL-Debug BreakSPL-Debug StepSPL-Debug Step IntoSPL-Debug Step OverSPL-Debug Step End-FunctionSPL-Debug Toggle-BreakpointSPL-Debug Next-Statement-SetSPL-Debug Call-StackRemember Tools PrintRemember Tools DeleteRemember Tools TraceRemember Tools Input-ScreenInput-Screen DefineLoadUndefineRemember ExecuteIn-MemoryFrom-FileRemember LoadRemember UnloadRemember Make-ApplicationRemember Run-ApplicationTools CommandsTools CalculatorFormula ModeAlgebraic ModeArithmetic OperatorsUsing PercentPrecisionMemory StorageMath FormatUsing ResultsExiting The CalculatorTools DirectoryTools Directory DisplayTools Directory MakeCurrent DirectoryTools Directory New-DirectorySearching for a FileTools Directory RemoveTools FileUsing the File PrompterSearching for Specific FilesDisplaying Directories Within a File ListMarking FilesTools File CopyTools File EraseTools File MoveTools File RenameTools File PrintTools MacrosMacros ClearTools Macros LoadTools Macros RememberSuspending Remember ModeTools Macros SaveTools Macros ViewMacros EditAdvanced Macro TermsMacros FinishTools New-FontTools New-Font NormalTools New-Font SidewaysTools OSTools PreferencesTools Preferences ModuleTools Preferences GlobalTools Preferences HardwareTools Preferences PulldownsTools Preferences Terminate PulldownsTools Preferences Font-MapTools Text-EditorCreating/Editing Text FilesUser-DirectoryTools ResourceTools Resource CommandsTools Resource ExtractTools Resource ModifyTools Resource ViewTools Edit-PrinterGeneral DescriptionPaper PathPaper SizeFontsProportional Space TablesCharacter Generation TablesMovement and Graphics CommandsFont SequencesPrinter ResolutionColor SequencesQuit CommandsOptions for Quit include the following:QuitMain-MenuCommunicationsDatabaseSpreadsheetWordprocessorOn pulldown menus, the FileOn pulldown menus, OpenOn pulldown menus, ExitCommunicationsDatabaseSpreadsheetWord ProcessorIf you encounter a protection violation, an error screen is generated and the following choices appear:Select Quit to DOSSelect Resume ANGOSSDatabase Command ReferenceShould You Use the User's Guide?Important Database ConceptsDatabase Terms DefinedData-file TypeFieldsRecordsViewsTypes of ViewsViewing Multiple FilesLinking Data-FilesTablesField ReferencesControl ReferencesSorting RecordsOverview - Creating a DatabaseStep 1 - Create a ViewStep 2 - Create a Data-FileStep 3 - Create Fields for the Data-FileCreating a TableSQL GrammarUsing Database CommandsData CommandsData options listData BrowseAll, Fields, and OffSelect Data Browse Fields to select only certain fields for displaySelect Data Browse Off to turn off Browse Mode for the current windowData Cross-TabCross-Tab KeywordsCross-Tabulation OverviewCross-Tab CreateConstruct Cross-TabInsertDeleteEditOptions Window DefinitionsOnce you select the Options keyword, another menu of options appears:If you select Row-Automatic or Column-Automatic, select Define to create or change the definition, or select Undefine to remove the definitionThe Auto Row OptionTo remove the current auto row field, select Options Row-Automatic UndefineThe Auto Column/Auto Summary OptionTo remove the current auto column field and summary definition, select Options Column-Automatic UndefineColumn TitleSummariesValid summary definition types and their meanings are listed in Table 9-1RejectsQuitCross-Tab ExecuteSelect Smart if you want to create a file that can be read into another VisualSmartWare moduleCross-Tab ModifyCross-Tab RemoveDeleteThe two options of Delete are Record and Table-RecordEnterUse Update to change data in an existing recordTo enter the data for a record, just type information into the appropriate fieldsPress Enter (or F10 if you have entered multi-line data) to move the cursor to the next fieldAll previously entered records are savedData FindSelect from the search field from the available fieldsComparison OptionsEqualGreater-ThanLess-ThanPartialSearch Type OptionsBinary SearchData GotoGoto OptionsGoto PageGoto RecordGoto TableGoto ViewGoto WindowData QueryQuery OptionsQuery CreateConstruct QuerySelect NewThe Query EditorQuery By ExampleFull Formula ExpressionsQuery ExecuteIndexData-FileStatistical Summary DataQuery Action ResultsQuery ModifyQuery NowQuery RemoveQuery SQLQuery SQL OptionsQuery SQL CreateConstruct SQL QueryThe SQL Editor appearsThe SQL EditorQuery SQL ExecuteQuery ModifyQuery SQL NowQuery SQL RemoveThe SQL Query Editor WindowSQLSQL ResultsSQL Verify-SQLSQL Property-SheetData RelateData Relate OptionsRelate CreateConstruct RelateThe Relate Definition MenuRelate ExamplesRelate ExecuteRelate ModifyRelate RemoveData SendSend OptionsData Send AllSend All CommunicationsDataTextBoth the Data and Text options prompt you to send data either in Row-Format or in Column FormatLast, you are also prompted to specify a project filename to execute upon entering VisualSmartWare CommunicationsSend All SpreadsheetAfter specifying the fields to send, you are prompted to enter a project file to execute upon entering VisualSmartWare SpreadsheetSend All WordprocessorDataTextWith the Text option, you can choose to send data in row format or in column formatAfter selecting Row-Format or Column-Format, you must specify the fields whose data you want to sendWhen you complete this last entry, all views and data-files are unloadedData Send Cross-TabIf you select Data Send Cross-Tab, you are prompted to specify the name of the cross-tab definition file to be usedSend Cross-Tab CommunicationsIf you select Data Send Cross-Tab, you are prompted to enter a project file to execute upon entry into the Communication moduleSend Cross-Tab SpreadsheetIf you select Data Send Cross-Tab, you are prompted to enter a project file to execute upon entry into the Spreadsheet moduleSend Cross-Tab WordprocessorIf you select Data Send Cross-Tab, you are prompted to enter a project file to execute upon entry into the Word Processor moduleFile SendData TransactData Transact OptionsTransact CreateConstruct TransactThe Transact Definition MenuTransact Driver DefinitionTransact Link DefinitionTransact Action DefinitionTransact ExecuteTransact ModifyTransact RemoveData Transact Server-TransactionData Transact Server-Transaction OptionsBeginCommitAbortSet-Save-PointRestore-Save-PointData UtilitiesData Utilities OptionsUtilities AppendBefore you execute Append, load or activate the source view, then load the destination viewThe Append Definition MenuUtilities Change-CountNextRenumberUtilities File-FixData-FileYou are prompted to enter the name of the data-fileViewYou are prompted to enter the name of the standard view to be restoredSQLYou are prompted for the file type and SQL SELECT statementUtilities InformationViewData-FilesKeys on DRIVER Data-FileKeys on DRIVEN Data-FilesTablesFieldsUtilities PurgeUtilities BinaryUtilities Recalc-AllFile CommandsFile options listFile LoadFile OpenCustom-ViewStandard-ViewDatasheet-ViewForm-ViewSelect or enter the filename of the view you want to loadLoading a File ExclusivelyFile CreateAfter executing File Create, you are first prompted to enter a name for the viewNew or SimilarCustom-View or Standard-ViewPassword or No-PasswordFormFile ModifyCustom-View or Standard-ViewForm-ViewThe Form Definition WindowAttachAttach Data-FileAttach FieldA prompter then appears listing the fields in the data-files attached to the formCreateCreate BoxCreate Data-FileFixed-LengthVariable-LengthPassword or No-PasswordLocal-Smart5C/S-Smart5Smart4Create FieldData-FileViewProject-ProcessingField Definition MenuField TypeField WidthTitle PlacementExtended OptionsView Field NameField AttributesAutomatic AdvanceColorsField Display FormatField Input MaskData Entry MessageDefault EquationCreate EditCreate NoteCreate ButtonCreate ListBoxCreate ComboBoxCreate Image/PictureCreate ChartCreate TableCreate ActiveXCreate Page-BreakCreate X-LineCreate GroupEditEdit CutEdit Do-CopyEdit PasteEdit Select-AllEdit FieldEdit LinksEdit ActiveX-Property-SheetEdit View-SPLEdit ToolbarsX-Delete GroupX-Delete ItemX-Delete Data-FileX-Delete FieldX-Delete FieldCommon ControlSectionControl NameLeftTopRightBottomWidthHeightFont NameFont SizeFont ItalicFont UnderlineFont WeightValueBack ColorFore ColorBorder ColorBorder StyleVisibleTab StopTab IndexData SourceEdit ControlField AttributesDisplay FormatInput MaskEntry MessageDefault EquationText AlignRectangle ControlBorder WidthNote ControlButton ControlListBox ControlList TypeList SourceDisplay Field NumberBound Field NumberComboBox ControlList RowsImage/Picture ControlPicturePicture ModeTransparentTransparent ColorChart ControlList TypeList SourceChart TypeData File FieldsTable ControlActiveX ControlPage Break ControlLine ControlLine WidthLine ShapeFormTitleWindow BorderModalSystem MenuMaximum EnabledMinimum EnabledCenter WindowSortQuery FileWindow ReportTitleLeft MarginTop MarginRight MarginBottom MarginPrinterOrientationColumnsColumn LayoutSortQuery FileGroup HeaderGroup FieldGroup FooterGroup FieldThe View Definition WindowAttachAttach Data-FileAttach FieldA prompter then appears listing the fields in the data-files attached to the viewAttach Project-FileCreateCreate BoxDouble or SingleOptional Foreground ColorAt the prompt, move the cursor vertically and horizontally to produce or resize a box or lineCreate CalculationSameImmediateWaitManualThe Formula EditorCreate Data-FileFixed-LengthVariable-LengthPassword or No-PasswordLocal-Smart5C/S-Smart5Smart4Create FieldData-FileViewProject-ProcessingField Definition MenuField TypeField WidthTitle PlacementExtended OptionsView Field NameField AttributesAutomatic AdvanceColorsField Display FormatField Input MaskData Entry MessageDefault EquationCreate MenuTo define a menu, select Create MenuTo revise a menu, select Edit MenuBarPopupData-FileSameCreate NoteMove the cursor to a starting position on the view where the note is to appearCreate RuleCreate TableFirst, move the cursor to a starting position on the viewTable TitlesTable Column SeparatorTable Foreground, Background ColorTable Cursor Foreground, Background ColorCreate ActiveXDeleteDelete BlockDelete ItemDelete Item BoxDelete Item CalculationDelete Item Data-FileDelete Item FieldWhen you delete a field, you must indicate whether you want to delete the field from the view only (leaving it in the data-file) or from the data-file (which also deletes the field from the view)Delete Item MenuDelete Item NoteDelete Item RuleDelete Item TableDelete Item ActiveXDelete Item Project-FileEditEdit FieldEdit LinksEdit Property-SheetInput-OrderMoveMove BlockMove ItemSelect the option appropriate for the type of item to be moved: Box, Field, Note, Table, or ActiveXPaintReplicateReplicate Data-FileWhen you select Data-File, you specify which data-file attached to the current view is to be replicatedYou are prompted to enter a name for the new data-file that will be createdReplicate FieldAfter you select a field to copy, you are asked to enter a name for the new fieldData-FileViewProject-ProcessingReplicate ActiveXAfter you select a ActiveX control to copy, you are asked to enter a name for the new controlFile SaveFile UnloadFile CloseIn command lists, File Unload provides the options All and ViewFile ActivateActivate provides the options Custom-View, Standard-View, Datasheet-View, and Form-ViewFile Display-ActiveFile ImportAscii and SmartWhen you select either the Ascii or Smart format option, the Database allows you to "skip" certain fields that you do not want read from the import fileDbaseFixedWhen reading in Fixed format, you cannot "skip" fields310-SmartLocal-Smart5C/S-Smart54-Smart4ODBCViewFile ExportRow-FormatColumn-FormatYou must specify the fields whose data is to be writtenPress F10 or Enter when you have finished selecting the field orderAsciiDifM-SylkSmartText3-DbaseLocal-Smart5C/S-Smart54-Smart4File PasswordFile Password Data-FileEnter a data-file name, aided by a prompter showing the data-files attached to the current viewFile Password ViewAttachRemoveOrder CommandsOrder options listOrder KeyOrder Key OptionsKey AddThe Key Definition MenuKey DeleteKey RebuildOrder SortDifference Between Sort Indexes and KeysOrder Sort OptionsSort CreateSort Definition MenuSort ExecuteDictionarySmartYou are prompted to enter the name of the sort definition file to be referencedYou are prompted to enter a sort index filenameSort ModifySort NowDictionarySmartAfter you select the sort method, you are asked to enter a new sort index filenameYou are then shown a prompter from which you can select sort fieldsNext, you are asked to select either Ascending or Descending as the orderSort RemoveOrder ManualOrder ChangeOrder Change OptionsChange KeyChange IndexChange PhysicalPrint CommandsPrint options listPrint Current-RecordCurrent-Record ListCurrent-Record PageAllDataPrint Current-Record ViewPrint ViewPrint View ListPrint View ReportSelecting FieldsPrint FieldsPrinting to ScreenOutputting to PrinterPrint ReportTable ReportForm ReportCombination ReportsPrint Report OptionsPrint Report CreateCreate NewCreate SimilarReport Definition MenuForm DefinitionCalculationCalculated OptionsNumeric ResultsFormatted ResultsDate ResultsTime ResultsFieldDisplay OptionsLabelPlacing FieldsLabel OptionsPage-NumberPage-Number OptionsTextText OptionsDupeMoveRemoveUpdateSet-FontSet-Font DefaultSet-Font ChangeFont PrompterFont SelectorTable DefinitionColumnsColumns CalculationColumns FieldColumns TextColumns MoveColumns RemoveColumns UpdateColumns Set-FontSet-Font DefaultSet-Font ChangeBreakpointsBreakpoints AddThis is an optional label which can be printed next to the result line you specified in the previous settingYou can select the number of lines to skip after each breakIf you select YesYou can print the number of records in each group by answering YesFor example, you may wish to know the total sales for each salesman, and the average dollar amount of his salesYou must move the highlighter to the field on which the operation will be performedTable 9-15Multiple SummarizationsUnique Summary LabelsAdding Break LinesMultiple BreakpointsBreakpoints in Combination ReportsBreakpoints RemoveBreakpoints UpdateBreakpoints Set-FontSet-Font DefaultSet-Font ChangeGrand-TotalsGrand-Totals AddGrand-Totals RemoveGrand-Totals UpdateGrand-Totals Set-FontTitlesSet-FontSet-Font DefaultSet-Font Column-HeadingsSet-Font Heading-TitlesSet-Font Footing-TitlesPage DefinitionCombination Report OptionIf the table overflows the bottom of the page, you must decide where to start the overflow on the next pageViews with View TablesEdit-FontsRemove-FontsPrint Report ExecuteWhen you select Print Report Execute, a prompter appears listing all existing report definition files in the current directoryPrint to DiskPrint to PrinterPrint to ScreenPrint to Text-ScreenDetail printingTotals-OnlyThen you specify at which page you want the printing to start and stop and how many copies you would likePrint ReportPrint to PrinterPrint to ScreenReport TypePrint Report ModifyPrint Report RemovePrint Window-ReportPrint Window-Report OptionsPrint Window-Report CreateWindow Report Definition MenuPrint Window-Report ExecuteWhen you select Print Window-Report Execute, a prompter appears listing all existing report definition files in the current directoryPrint to DiskPrint to PrinterPrint to ScreenPrint Window-Report ModifyPrint Window-Report RemoveTools CommandsTools PreferencesTools Preferences DatabaseDefault Numeric FormatNumber of Key BuffersDefault Data PathMacro File LoadAutomatic Load of ViewProject File to Run on EntryEncryption driverBroadcast portTimeout for listeningServer-Transactions apply to all files from the same serverWhen server is left blank, use this server nameMake server data-file requests locallyPath to find local copies of server data-filesWindow CommandsWindow options listWindow SplitSplit HorizontalSplit VerticalWindow CloseWindow ZoomWindow BorderWindow PaintPaint OptionsBorderCursorDataGraphicsTitlesWindow-AreaWhen you select one of the Paint options, a list of numbered colors appears at the bottom of your screen accompanied by a prompt to enter a colorWindow LinkIn order to link two views, you must define a pair of linked fieldsBefore executing Windows Link, load the views you wish to link into separate windowsThen execute Window LinkWindow UnlinkWindow GotoWindow MaximizeWindow X-MinimizeWindow RestoreHelp CommandsHelp TutorialQuit CommandsQuitMain-MenuCommunicationsSpreadsheetWordprocessorMain MenuSpreadsheet Command ReferenceBasic ConceptsData Entry and Command ModesWhen the program is in Data Entry Mode, the Enter:Using CommandsEntering DataFormulas and RecalculationCell ReferencesExternal WorksheetsAbsolute and Relative ReferencesEditing Cells and FormulasMoving the HighlighterMarking BlocksMarking Rows and ColumnsDefinition MenusPrompter ListingsLayout CommandsLayout Alter-ShadingEditClearShadeLayout Cell-SizeLayout Cell-Size WidthLayout WidthBefore you select either the Columns or the All option, VisualSmartWare prompts you to Enter width:(unit of measureColumnsAllLayout Cell-Size HeightLayout HeightAt the prompt, specify the height to useRowsAllLayout DefaultCompared to Worksheet-OptionsLayout Default TextLayout Default ValuesLayout Numeric DefaultMany of the Layout Default Values options allow you to specify the following format settingsIn addition, the Layout Default Values commands allow you to define the default alignment for value cellsBarDateWhen you select the Date option, choose either Date1TimeE-NotationCurrencyNumericPercentGeneralLayout FormatPreformattingLayout Format OptionsMany of the Layout Format options allow you to specify the following format settingsBarDateTimeE-NotationCurrencyNumericPercentResetGeneralLayout Format Formula-DisplayMapTextValuesLayout JustifyOnce you specify the type of alignment to be performed, you must determine the area to be justifiedLeftRightCenterLayout LinesEditClearOutlineTopBottomLeftRightGridLayout Set-FontLayout FontLayout Set-Font SelectLayout Font SelectPoint to the font you want to use as the default and press EnterLayout Set-Font ChangeLayout Font ChangeWhen you select Change, you are asked to identify the type of area to be affected by choosing the BlockAfter you have specified the area to be changed, the Font Prompter is displayedLayout Set-Font EditLayout Font EditCurrent-SheetNew-SheetFont 0 is always the default font for new worksheetsTo edit an existing font with either the Current-Sheet or New-Sheet option, point to the desired font, or enter the font number or descriptionLayout Set-Font RemoveAfter you select either Current-Sheet or New-Sheet, the Font Prompter menu appearsCurrent-SheetNew-SheetLayout Worksheet-OptionsLayout Worksheet-Options Current-SheetRecalculation OrderDefault value formatCell SizeLayout Worksheet Options New-SheetPrint Dialog BoxPrint OptionsPrint CommandsPrint OptionsPrint WorksheetStep 2: Select All to print the entire worksheet, or Block to print only part of the worksheetStep 3: Select Draft or Enhanced printingStep 4: Enter the number of copies you want printed5Print FormulasStep 2: Select All to print all formulas in the entire worksheet, or Block to print only formulas in part of the worksheetStep 3: Select Printer to send the data to the current printer, select Disk to send the data to a disk file, or select Screen to send the data to the print previewerPrint MapStep 2: Select All to print the entire worksheet, or Block to print only part of the worksheetStep 3: Select Draft or Enhanced printingStep 4: Enter the number of copies you want printedStep 5: Select Printer to send the data to the current printer, select Disk to send the data to a disk file, or select Screen to send the data to the print previewerPrint ReportPrint Report CreateStep 3: Enter a name for the report definition you are about to createStep 4: Select New or SimilarSelecting NewPrint GroupsSpecifying Print GroupsUsing Multiple Block ReferencesReferencing Multiple WorksheetsAdding Print GroupsDeleting Print GroupsReport Headings and FootingsHeadings and FootingsPrint Heading/Footing OnBlank Lines after Heading/FootingUse Secondary Heading/FootingPrimary and Secondary Headings/FootingsPrint Control CodesExampleDate StylePage Number StyleLines to Enclose ReportStart Page NumberSpacingLines Per InchDraft modePaper ProfileOrientationPrint on Both Sides of the FormUse Secondary BordersPage BordersReport ModifyPrint Report RemovePrint Report ExecuteStep 2: Enter the name of the report to be executedStep 3: Select Draft or Enhanced printingStep 4: Enter the number of copies you want printedStep 5: Select Printer to send the data to the current printer,select Disk to send the data to a disk file, or select Screen to send the data to the print previewerPrint OptionsPrinting Row and Column NumbersLines per inch in draft modeCharacters per inch in draft modePaper ProfileOrientationPage BordersPrint PresetPrint Options New-WorksheetsEdit CommandsEdit BlankBlockColumnsRowsAllEdit CopyEdit Value-CopyEdit Copy Down or Edit Value-Copy DownSingle-CellRowEdit Copy Right or Edit Value-Copy RightSingle-CellColumnEdit Copy From or Edit Value-Copy FromYou are prompted to enter the name or block reference of the source block, the area you want to copyVisualSmartWare then asks you for the name or the location of the destinationFor either Edit Copy or Edit Value-Copy, you are asked to specify the number of copies, which is the number of times the cells in the designated area are to be duplicatedEdit DeleteBlockColumnsRowsEdit InsertBlockColumnsRowsDefining Insert or Delete AreasWhen you select the BlockWhen you select the ColumnsWhen you select the RowsEdit Edit-CellFormula EditorEdit FillAfter you define the area to be filled, you are prompted to enter a starting value, and a number by which to increment your starting valueBlockColumnsRowsEdit HideBlockColumnsRowsAllDisableEnableEdit UnhideBlockColumnsRowsAllDefining Hide or Unhide AreasFor either Edit Hide or Edit Unhide, you are prompted to enter the name or block reference of the cells you want to hide or unhideFor either Edit Hide or Edit Unhide, you are prompted to enter the number of columns to hide or unhideFor either Edit Hide or Edit Unhide, you are prompted to enter the number of rows to hide or unhideEdit MoveBlockYou must enter a name or block reference for the destination locationColumnsRowsEdit SortSort AreaAscending or DescendingRow or ColumnSort KeyFile CommandsFile LoadFile OpenWhen selected, VisualSmartWare displays a file promptor or Windows dialog box requesting the name of the worksheet to loadSearching for Specific FilesDisplaying Directories Within a File ListFile SaveAfter you select the File Save command, VisualSmartWare prompts you to enter the name of the worksheet you want to saveYou can create a copy of the worksheet by typing a different name in response to the name promptFile UnloadFile CloseWith multiple worksheets activated, VisualSmartWare prompts you to enter the name of the worksheet you want to unloadIf you want to deactivate all active worksheets, type allIf you have modified the worksheet you want to unload, VisualSmartWare gives you the option of saving the changes by prompting: Worksheet has been modifiedFile ActivateWhen you select File Activate, you are prompted to enter the name of the worksheet to be activatedFile NewnameWhen you select File Newname, VisualSmartWare prompts you to enter the new name you want to assign to the worksheetIf you answer yFile Display-ActiveFile CombineThe File Combine command allows you to select either the Add, Copy, or Subtract optionVisualSmartWare then asks you to specify either that the entire external worksheet (by selecting WorksheetIf cells in the destination worksheet are locked, the message Some cells are lockedFile Combine AddFile Combine CopyFile Combine SubtractFile ImportDIFSYLKAnswer yText"Flat text" is the output commonly derived from "print to disk" options in many software packages123, R2-123File ExportWhen you select File Export, VisualSmartWare asks you to indicate whether you want to export the entire worksheet or only a block of cells to a fileFormat options include ASCII, DIF, WP-Doc, Smart, Text, Lotus 1-2-3 (Release 1A), and Lotus 1-2-3 (Release 2)ASCIIDIFWP-DocSmartText123R2-123File PasswordFile Password AttachFile Password RemoveGraph CommandsConvertQuickData Blocks for Quick GraphsGenerating a Graph Definition File from a Quick GraphDefineComponents of a GraphPlot AreaLegend AreaTitle AreaFootnote AreaBackground AreaMaking Entries on a Graph Definition MenuMoving the Cursor on a Graph Definition MenuEntering the Filename and Graph TypeDefining the PlotData Settings for Business GraphsData Settings for High-Low GraphsData Settings for Scientific GraphsData Settings for Elevation GraphsText SettingsGeneral Settings3d SettingsAxis SettingsPlot Interior SettingsDefining the LegendDefining Titles and FootnotesDefining the BackgroundDefining Text GraphsDefining Composite GraphsDefining AreasCommon Definition ItemsWorksheet ReferencesColorsLine and Fill PatternsBorder TypesSymbolsFontsCharacter and Line SizesText Control CharactersView, Print, and Xy-PlotA prompter appears listing all the graph definition files, CGM files, and GMF (SmartWare II version 1To print a graph or metafile, select Graph PrintMetafileEraseSet-DefaultSelecting a Graph TypeBusiness Graphs (13 types):High-Low Graphs (1 type):Scientific Graphs (2 types):Elevation Graphs (3 types):Text Graphs (1 type):Composite Graphs (1 type):Bar GraphsLine GraphsArea GraphsStep GraphsCombination GraphsPie GraphsHigh-Low GraphsXy GraphsPolar GraphsContour, Surface, and Wireframe GraphsText GraphsComposite GraphsGraph TerminologyGraphWindow CommandsWindow SplitWhen you select Window Split, indicate whether you want a HorizontalWindow CloseWindow ZoomWindow BorderWindow NumbersColumnRowWindow PaintOnce you have chosen an option, a palette of available background colors is shown in the Control Area of your screen to help you visualize and select a colorWindow Paint BorderWindow Paint CellsCursorFormulaHighlightLocked-CellsTextValueWindow Paint NumbersWindow Paint WindowWindow TitlesWindow Titles FixIf you choose to fix a title, VisualSmartWare asks you to indicate whether you want to affect rows or columnsWindow Title DropWindow LinkWindow UnlinkSpreadsheet Error MessagesThe value you entered as the exponent was either negative or zeroWhile protecting the formulas in the current worksheet, VisualSmartWare encountered a reference to an unloaded external worksheet and was unable to continueWhen entering a long data string, you allowed the input line to exceed the width of the screenHelp CommandsTutorialQuit CommandsOptions for Quit include the following:QuitMain-MenuCommunicationsDatabaseWordprocessorMain MenuRemember CommandsSheet CommandsSheet AuditSheet Audit CircularSheet Audit EmptySheet Audit FormulasBy selecting BlanksThe Child and Parent options allow you to identify the use of cell references in formulasSheet Audit Formulas UnusedUnusedYou are given the choice of highlighting all the unused cells in your worksheet, only unused text cells, or only unused value cellsRestoreSheet Calc-ModeSheet Calc-Mode AutomaticSheet Calc-Mode ManualSheet Calc-Mode DisplaySheet Calc-Mode Calc-OrderNatural-OrderSheet Calc-Mode IterateTo set the condition to a specific number of recalculations, select CountTo define a specific test condition, select TestVisualSmartWare asks you to Enter delta value:VisualSmartWare then prompts you to Enter maximum number of iterations:To remove Count or Test recalculation processing from your worksheet, select RemoveSheet FindWhen you select the Sheet Find command, VisualSmartWare prompts you to indicate the section of the worksheet you want to searchSheet Find Calc-ErrorSheet Find EmptySheet Find HighlightSheet Find TextSheet Find ValueSheet GotoSheet Goto CellSheet Goto SheetSheet Goto WindowSheet Goto OtherSheet LockBlanksFormulasTextValuesAllDisableEnableProtectSheet UnlockBlanksFormulasValuesTextAllLocking or Unlocking Selected AreasLockSelect AllUnlockSelecting AllFor either Sheet Lock or Sheet Unlock, enter a block name or reference or the number of columns or rows, beginning with the current column or rowSheet MatrixMatrix OverviewSource MatrixAux DiagonalResult MatrixAux Normalize and RankDiagonal, Parallel, N-SolveInvert, MultiplySheet Matrix AuxDeterminantNormalizeAfter you choose either the Standard option or the Unit option, select either the Column option or the Row optionPowerYou are then prompted to enter the exponent, or the power to which the matrix is to be raisedRankSheet Matrix DiagonalCopyProductSumSheet Matrix InvertYou are prompted to enter a name or block reference of a matrix block, which will be the source matrixSheet Matrix MultiplyWhen you select the Multiply option, you will be prompted to enter three matrix blocksSheet Matrix N-SolveWhen you select the N-Solve option, you are prompted to enter a matrix blockSheet Matrix ParallelAddDivMultSubWhen you select the Parallel option of Sheet Matrix, you are prompted to enter a matrix blockYou are prompted to enter a matrix block, value or single cell for matrix BSheet Matrix RegressionWhen you select the Regression option, you are prompted to enter a matrix blockNo-ReportReportAfter you select either Report or No-Report, you are prompted to enter a cell or vector to receive the computed regression coef