10020.txt Copyright Notice 10021.txt Who should read this book 10022.txt Terms and concepts 10023.txt Organization 10024.txt What is DataLens? 10025.txt DataLens capabilities 10026.txt Using the sample file 10027.txt Capabilities of the dBASE IV driver 10028.txt Using dBASE IV index files 10030.txt Driver-supported dBASE IV files and commands 10031.txt Creating dBASE IV tables 10032.txt About dBASE IV data types 10033.txt File access 10034.txt Using macros for transaction control 10035.txt Table security 10036.txt Using character sets 10037.txt Prerequisites 10038.txt Using the sample file 10039.txt Capabilities of Database Manager 10040.txt Basic database tasks 10041.txt Operators and functions 10042.txt Connecting to the driver and database 10043.txt Using the Catalog Tool 10044.txt Creating Database Manager tables 10045.txt About Database Manager data types 10046.txt Supported Database Manager commands 10047.txt Database Manager functions 10048.txt Specifying SQL CREATE TABLE statement parameters 10049.txt Using macros for transaction control 10050.txt Performance considerations and security mechanisms 10051.txt Using character sets 10052.txt Prerequisites 10053.txt Using the sample file 10054.txt Capabilities of the Informix driver 10055.txt Connecting to the driver and database 10056.txt Creating Informix tables 10057.txt About Informix data types 10058.txt Guidelines for creating Informix tables 10059.txt Supported Informix commands 10060.txt Using macros for transaction control 10061.txt Performance considerations and table security 10062.txt Using character sets 10063.txt Using the sample file 10064.txt Capabilities of the Paradox driver 10065.txt Driver-supported commands and files 10066.txt Creating Paradox tables 10067.txt About Paradox data types 10068.txt Paradox sort orders 10069.txt File access and table security 10070.txt Using character sets 10071.txt Using the sample file 10072.txt Operators and functions 10073.txt Capabilities of the SQL Server driver 10074.txt Creating external tables 10075.txt About SQL Server data types 10076.txt Using macros for transaction control 10077.txt Using character sets 10078.txt Introduction 10079.txt Driver records 10080.txt Driver and database record syntax 10081.txt Database records 10082.txt Creating standard registration files 10083.txt Setting up the workstations 10084.txt Creating database access plans 10085.txt Testing the driver 10086.txt Modifying the registration file 10087.txt Driver records 10088.txt Database records 10089.txt Driver and database record syntax 10090.txt Sequence of records in the registration file 10091.txt Installing the driver 10092.txt Driver records 10093.txt Driver configuration options 10094.txt Database records 10095.txt Driver and database record syntax 10096.txt Standard registration files 10097.txt The registration file 10098.txt Driver records 10099.txt Driver and database record syntax 10100.txt Database records 10101.txt Database and driver communication and security 10102.txt Creating standard registration files 10103.txt Introduction 10104.txt Driver records 10105.txt Driver configuration options 10106.txt Driver and database record syntax 10107.txt Example of a driver record 10108.txt Database records 10109.txt Database configuration options 10110.txt Creating standard registration files 10111.txt SQL Server Net-Library technology 10112.txt About this manual 10113.txt About the online materials 10114.txt Conventions 10115.txt System requirements 10116.txt Network requirements 10117.txt Install Approach 10118.txt Register your software 10119.txt A word about Windows 10120.txt Starting Approach 10121.txt Exiting Approach 10122.txt From here... 10123.txt How Approach handles data 10124.txt Perspectives of your data 10125.txt The Approach work area 10126.txt Environments in Approach 10127.txt Basic steps for building a database 10128.txt Start Approach and open a view file 10129.txt About records and fields 10130.txt Sort records 10131.txt Switch to a specific record 10132.txt Find records 10133.txt View a report 10134.txt Switch between Design and Browse 10135.txt Change the font and size 10136.txt Close and save the view file 10137.txt Summary 10138.txt Create a new file 10139.txt Define database fields 10140.txt Move fields 10141.txt Save the view file 10142.txt Fill fields automatically 10143.txt Verify data 10144.txt Create a value list for a field 10145.txt Fill in fields 10146.txt Summary 10147.txt Create a new form 10148.txt Add an illustration 10149.txt Add a border to the illustration 10150.txt Format field names 10151.txt Add a title 10152.txt Summary 10153.txt Create a new report 10154.txt Add a footer 10155.txt Create a summary report 10156.txt Create a summary field 10157.txt Create a form letter 10158.txt Create mailing labels 10159.txt Summary 10160.txt Join database files 10161.txt Create a relational form 10162.txt Summary 10175.txt Hardware Requirements 10176.txt System Software 10177.txt Network Software 10178.txt System Memory 10179.txt HardðDisk Space 10180.txt Hardware and Software Chart 10181.txt For Upgraders: Before You Install 10182.txt Installing Freelance Graphics 10183.txt Using Install 10184.txt After You Install 10185.txt Backing Up Your Disks 10186.txt Restoring Compressed Files 10187.txt Starting Freelance Graphics 10188.txt Closing Freelance Graphics 10189.txt Modifying Freelance Graphics Directories 10190.txt Modifying Country Formats 10191.txt Modifying the Configuration File 10192.txt Adding Freelance Graphics to a Folder 10193.txt Starting Improv 10194.txt Using Keyboard Equivalents 10195.txt Displaying Quick Menus 10196.txt The Improv Worksheet 10197.txt Using the Dynamic Status Bar 10198.txt Using SmartIcons 10199.txt Opening Existing Models and Creating New Models 10200.txt Saving Your Work 10201.txt Discarding Changes 10202.txt Closing Worksheets and Models 10203.txt Exiting Improv 10204.txt Using Online Help 10205.txt Learning Tools 10206.txt Dealing with Error Messages 10207.txt Welcome to Improv! 10208.txt About This Book 10209.txt Making the Switch 10210.txt Conventions 10211.txt The Improv Worksheet: A Break with Tradition 10212.txt Creating Items 10213.txt Naming Items 10214.txt Assigning Sequential Item Names Automatically 10215.txt Naming Categories 10216.txt Adding Categories: The Multidimensional Worksheet 10217.txt Adding Items to Expand the Worksheet Structure 10218.txt Moving Categories 10219.txt Deleting Items and Categories 10220.txt Creating Item Groups 10221.txt Automatically Calculating Subtotals 10222.txt Using Summary Items to Calculate Grand Totals 10223.txt Using Group Functions in Manually Entered Formulas 10224.txt Adding a Custom Summary Item 10225.txt Collapsing Groups 10226.txt Ungrouping Items 10227.txt Working with Multiple Instances of a Group 10228.txt Deciding Whether to Create a Category or a Group 10229.txt Advantages of Categories 10230.txt Disadvantages of Categories 10231.txt Advantages of Groups 10232.txt Disadvantages of Groups 10233.txt Entering Data into Cells 10234.txt Entering Date and Time Numbers 10235.txt Automatically Formatting Cells as You Enter Numbers 10236.txt Entering Fractions 10237.txt Entering International Characters and Symbols 10238.txt Filling a Range of Cells or Item Names 10239.txt Filling a Range with Numbers 10240.txt Filling a Range with Dates or Times 10241.txt Overlapping Calculated Values with Data 10242.txt Selecting Worksheet Elements 10243.txt Making Item Selections 10244.txt Making Refined Item Selections 10245.txt Making Item-Names-Only and Cells-Only Selections 10246.txt Making Cell Selections 10247.txt Selecting Formulas 10248.txt Editing Text 10249.txt Navigating a Worksheet 10250.txt Selecting Categories 10251.txt Cut, Copy, and Paste 10252.txt Choosing Options for Pasting Values in the Cell Area 10253.txt Pasting in the Item Name Area 10254.txt Pasting Text Without Styles 10255.txt Pasting Data Over Calculated Values 10256.txt Cutting, Deleting, and Clearing Values That Overlap Calculat 10257.txt Cutting, Copying, and Pasting Formulas 10258.txt Sorting Items by Cell Contents 10259.txt Sorting Items by Item Name 10260.txt How Improv Applies Styles in a View 10261.txt Choosing the Right Selection Method 10262.txt Assigning Numeric Formats to Cells and Tick Mark Labels 10263.txt Using Custom Formats 10264.txt Changing the Font, Size, and Emphasis of Text 10265.txt Changing Fill Colors, Fill Patterns, and Text Colors 10266.txt Changing Line Styles and Line Colors 10267.txt Changing Alignment 10268.txt Customizing the Color Palettes 10269.txt Copying Styles 10270.txt Clearing Styles 10271.txt Making Item Names and Cell Contents Fit 10272.txt What's So Different About Improv Formulas? 10273.txt Formula Syntax: How You "Copy" Formulas 10274.txt Types of Improv Formulas 10275.txt Writing General Formulas 10276.txt Entering Formulas 10277.txt Creating Formula References 10278.txt Referring to Items by Position 10279.txt Using the Formula Bar 10280.txt Working in the Formula Pane 10281.txt Types of Formula Calculations 10282.txt Improv Functions 10283.txt Entering Functions Automatically 10284.txt Arithmetic Operators and Order of Precedence 10285.txt Identifying and Correcting Formula Errors 10286.txt Marking Related Cells and Formulas 10287.txt Annotating Formulas 10288.txt Understanding Formula Status Indicators 10289.txt Understanding Formula Mismatches 10290.txt When and How Formulas Recalculate 10291.txt Resolving a Circular Reference 10292.txt Understanding Formula Overlaps 10293.txt Using The Formula Overlap Button to Change Formula Priority 10294.txt Displaying Overlap Information 10295.txt Understanding and Using Data Overlap 10296.txt Clearing Data Overlaps 10297.txt Writing Constant Value Formulas 10298.txt Writing Restricted Formulas 10299.txt Writing Recurrence Formulas 10300.txt References in Recurrence Formulas 10301.txt Modifying Recurrence Keywords with Integers 10302.txt Recurrence Formula Direction 10303.txt Writing Intersheet Formulas 10304.txt Intersheet, Single-Cell Formulas 10305.txt Intersheet Formulas Where Categories Match 10306.txt Intersheet Formulas Where Categories Do Not Match 10307.txt Using Link Formulas to Share Data Between Models and Applica 10308.txt Why Create Views? 10309.txt How Changes You Make to a View Affect Other Views 10310.txt Creating New Views 10311.txt Moving Categories 10312.txt Hiding and Displaying Items 10313.txt Hiding Particular Instances of an Item 10314.txt Collapsing and Expanding Groups 10315.txt Changing the Display of Elements in a View 10316.txt Choosing How Style Changes Affect Views 10317.txt Browser Basics 10318.txt Opening the Parts of a Model 10319.txt Moving Among the Parts of a Model 10320.txt Naming the Parts of a Model 10321.txt Annotating the Parts of a Model 10322.txt Adding Views to a Model 10323.txt Adding Worksheets to a Model 10324.txt Cutting, Copying, and Pasting the Parts of a Model 10325.txt Deleting the Parts of a Model 10326.txt Getting Ready to Print 10327.txt Specifying Page Setup Options 10328.txt Specifying What to Print from a View 10329.txt Adding Print Titles to a View 10330.txt Specifying the Order of Page Numbering in a View 10331.txt Setting Margins 10332.txt Changing Page Orientation 10333.txt Shrinking a View to Fit on a Page 10334.txt Scaling the Page Image 10335.txt Specifying the First Printed Page Number 10336.txt Creating and Saving Default Page Setup Settings 10337.txt Adding Headers and Footers 10338.txt Adding, Clearing, and Displaying Page Breaks 10339.txt Previewing 10340.txt Printing 10341.txt Creating a Print File 10342.txt Getting Help on Lotus Chart 10343.txt Creating a Chart 10344.txt The Default Chart 10345.txt How Lotus Chart Assigns Data to a Chart 10346.txt Using the InfoBox to Enhance Charts 10347.txt Using the Style Panel 10348.txt Using the Settings Panel 10349.txt Changing the Chart Type 10350.txt Types of Charts 10351.txt Styling and Manipulating Charts 10352.txt Changing How Lotus Chart Assigns Data 10353.txt Plotting a 2nd Y-axis 10354.txt Deleting Charts 10355.txt Hiding and Displaying Data Series 10356.txt What Is a Presentation? 10357.txt Creating Drawn Objects 10358.txt Creating Text Blocks 10359.txt Creating Buttons 10360.txt Working with Objects 10361.txt Grouping and Ungrouping Objects 10362.txt Shuffling Objects in Front or in Back of Each Other 10363.txt Adding Additional Charts 10364.txt A Summary of Function Types and Their Uses 10365.txt Getting Online Help 10366.txt Entering Functions Automatically 10367.txt Add-in Functions 10368.txt Registering the Add-in Functions 10369.txt Writing the Script That Registers the Add-in Functions 10370.txt Troubleshooting Problems with the Add-in Functions 10371.txt A Summary of Functions 10372.txt The Functions 10373.txt ABS - CODE 10374.txt COMBINE - EXP 10375.txt FACT - GROUPVARS 10376.txt HEX - LOG 10377.txt LOOKUP - PAYMT 10378.txt PERMUT - RIGHT 10379.txt ROUND - SELECTMIN 10380.txt SELECTSTD - SUM 10381.txt SUMPRODUCT - YIELD 10382.txt Creating Models 10383.txt Integrating Improv with Other Applications 10384.txt Changing the Look of a Worksheet 10385.txt Working with Formulas 10386.txt Performing Database Operations 10387.txt Working with Charts 10388.txt Working with Graphic Objects 10389.txt Miscellaneous Tasks 10390.txt Printing Your Work 10391.txt Changing Defaults 10392.txt Improv Equivalents for 1-2-3 @Functions 10393.txt Improv Equivalents for Excel Functions 10394.txt Creating Custom Formats 10395.txt Adding and Deleting Custom Formats 10396.txt Including International Characters and Symbols 10397.txt Creating Custom Number Formats 10398.txt Creating Custom Date/Time Formats 10399.txt Combining Text with Numbers in a Format 10400.txt Using the Windows Character Map Accessory 10401.txt Using the CHAR Function 10402.txt Using Compose Sequences 10403.txt Getting Help on LotusScript 10404.txt Glossary of LotusScript Terms 10405.txt Numbers in LotusScript 10406.txt Operators and Order of Precedence 10407.txt Punctuation 10408.txt Data Types 10409.txt Variables, Arrays, and Lists 10410.txt Loops 10411.txt Conditionals 10412.txt Branches 10413.txt Error Handling 10414.txt Mathematical Functions 10415.txt Input, Output, and Printing 10416.txt User-Defined Functions and Subroutines 10417.txt String-Handling Functions 10418.txt Numeric Value-Handling Functions 10419.txt Date and Time Functions 10420.txt Improv-Specific Functions 10421.txt Handle, Selection, and Iterator Functions 10422.txt Status Bar Equivalents 10423.txt The Lotus Dialog Editor and Dialog Box Access Functions 10424.txt Improving Script Performance 10425.txt Information Functions 10426.txt Improv Menu Equivalents 10427.txt Direct Manipulation 10428.txt C-Language Functions 10429.txt Dialog Box Callback Functions 10430.txt Menu Customization Functions 10431.txt Custom @Functions 10432.txt Trigger Functions 10433.txt Improv Specifications and Limits 10434.txt Adding Data from a Worksheet in the Same Model 10435.txt Aligning Objects to a Grid 10436.txt Adding Pages to a Presentation 10437.txt Adding Data and Pictures from Other Applications 10438.txt Choosing a Format for Pasting 10439.txt Printing a Presentation 10440.txt An Overview of DDE and OLE in Improv 10441.txt Using Data from Another Model or Application in an Improv Wo 10442.txt Using Data from Another Application in an Improv Presentatio 10443.txt Why Create a Linked Object? 10444.txt Why Create an Embedded Object? 10445.txt Creating Linked or Embedded Objects 10446.txt Scripting and OLE Objects 10447.txt Using Data from Improv in Other Applications 10448.txt The Lotus Mail Connection 10449.txt Importing Worksheet Files 10450.txt Exporting Worksheet Files 10451.txt Importing Text Files into Improv 10452.txt Exporting Improv Worksheets to Text Files 10453.txt Exchanging Improv Files 10454.txt Positioning, Sizing, and Hiding SmartIcons 10455.txt Customizing the Default Icon Sets 10456.txt Creating and Deleting Icon Sets 10457.txt Associating an Icon Set with a Particular Part of a Model 10458.txt Attaching Scripts to Custom SmartIcons 10459.txt Choosing User Setup Options 10460.txt Setting Default Paths 10461.txt International Settings 10462.txt What Is LotusScript? 10463.txt What Can You Do with a Script? 10464.txt Getting Help on LotusScript 10465.txt Recording a Script 10466.txt Writing a Script 10467.txt Running a Script 10468.txt Stopping a Script 10469.txt Debugging a Script 10470.txt Annotating a Script 10471.txt Opening, Saving, and Deleting Scripts in Models 10472.txt Opening, Saving, and Deleting Scripts in Libraries 10473.txt LotusScript Tutorial 10474.txt Generalizing the Recorded Script 10475.txt Copyright Notice 10476.txt What's In Your 123 Package 10477.txt System requirements 10478.txt Installing 1-2-3 on a stand-alone computer 10479.txt Installing 1-2-3 on a network node 10480.txt Returning to Install 10481.txt Reading product updates 10482.txt Who Should Read This Book 10483.txt Using this book with Help 10484.txt Organization 10485.txt Conventions used in this book 10486.txt Guide for using the documentation 10487.txt Starting 1-2-3 10488.txt Getting Help 10489.txt Screen Elements 10490.txt SmartIcons 10491.txt The Worksheet window 10492.txt Worksheet tabs 10493.txt Ending 1-2-3 10494.txt How To Use This Book 10495.txt Copyright Notice 10496.txt Why use a Lotus application on a network? 10497.txt Steps for administrators 10499.txt What Are Macros? 10500.txt Macro Command Categories 10501.txt Chart Macro Commands 10502.txt Data Manipulation Macro Commands 10503.txt Database Macro Commands 10504.txt DDE and OLE Macro Commands 10505.txt Link Commands 10506.txt OLE commands 10507.txt Edit Macro Commands 10508.txt File Commands 10509.txt Flow-of-Control Macro Commands 10510.txt Keystroke Equivalents 10511.txt Navigation Macro Commands 10512.txt Range Macro Commands 10513.txt SmartIcons Macro Commands 10514.txt Solver Macro Commands 10515.txt Style Macro Commands 10516.txt Text File Manipulation Macro Commands 10517.txt Tools Macro Commands 10518.txt User Environment Macro Commands 10519.txt Version Manager Macro Commands 10520.txt Window and Screen Display Macro Commands 10521.txt Sample DDE Macros 10522.txt {--comment} 10523.txt {subroutine} 10524.txt What is the {?} Macro Command 10525.txt {ADDIN-INVOKE}{ADDIN-LOAD}{ADDIN-REMOVE}{ADDIN-REMOVE-ALL} 10526.txt {ALERT} 10527.txt {APP-ADJUST}{WINDOW-ADJUST} 10528.txt Designing a directory structure for Lotus applications 10529.txt Starting the Install program 10530.txt Using online installation instructions 10531.txt Determining the license count 10532.txt Creating personal directories 10533.txt Creating shared data directories 10534.txt Information to give users 10535.txt Common problems and solutions 10536.txt What is 1-2-3? 10537.txt What are the 1-2-3 windows? 10538.txt Using the mouse 10539.txt Working with 1-2-3 windows 10540.txt Opening a file 10541.txt Inserting and deleting worksheets 10542.txt Naming worksheets 10543.txt Moving around a file 10544.txt Moving to another file 10545.txt Viewing worksheets 10546.txt Freezing rows and columns as titles 10547.txt Grouping worksheets 10548.txt Saving a file 10549.txt Closing a file 10550.txt Using main menu commands 10551.txt Using 1-2-3 quick menus 10552.txt Using a dialog box 10553.txt Canceling a command 10554.txt Undoing an action 10555.txt Using 1-2-3 keys 10556.txt Using 1-2-3 Classic 10557.txt Selecting a single cell 10558.txt Selecting a range 10559.txt Selecting a collection 10560.txt Selecting columns and rows 10561.txt Selecting worksheets 10562.txt Summary of selection techniques 10563.txt Entering data 10564.txt Entering numbers 10565.txt Entering text 10566.txt Entering dates and times 10567.txt Entering data automatically 10568.txt Editing data 10569.txt Copying data 10570.txt Moving data 10571.txt Inserting and deleting columns, rows, and ranges 10572.txt Related Help topics 10573.txt What is a range name? 10574.txt Naming ranges 10575.txt Using range names 10576.txt What is a formula? 10577.txt Types of formulas 10578.txt Building a formula 10579.txt Entering a formula 10580.txt Referring to cells and ranges in formulas 10581.txt Referring to other files in formulas 10582.txt How 1-2-3 calculates a formula 10583.txt Copying and moving formulas 10584.txt Recalculating formulas 10585.txt Related Help topics 10586.txt What is an @function? 10587.txt @Function format 10588.txt Entering an @function 10589.txt Customizing the @Function menu 10590.txt Learning about each @function 10591.txt Changing the appearance of numbers 10592.txt Changing font and attributes 10593.txt Changing colors and patterns 10594.txt Adding borders and frames 10595.txt Changing alignment 10596.txt Using named styles 10597.txt Copying and deleting styles 10598.txt Changing column width 10599.txt Changing row height 10600.txt Hiding data 10601.txt Related Help topics 10602.txt Quick printing 10603.txt Print previewing 10604.txt Adding headers and footers 10605.txt Adding and removing page breaks 10606.txt Adding print titles 10607.txt Enhancing your printed pages 10608.txt Using named page settings 10609.txt Related Help topics 10610.txt Sealing a file 10611.txt Preventing others from opening a file 10612.txt What is a chart? 10613.txt Creating a chart 10614.txt Changing the chart type 10615.txt Types of charts 10616.txt Naming and finding charts 10617.txt Related Help topics 10618.txt Styling chart elements 10619.txt Working with titles, footnotes, and legends 10620.txt Changing axis titles 10621.txt Adding and changing units titles 10622.txt Changing the axis scale 10623.txt Positioning tick marks and labels 10624.txt Enhancing pie charts 10625.txt Related Help topics 10626.txt What are drawn objects? 10627.txt Creating lines, arcs, and arrows 10628.txt Creating rectangles and ellipses 10629.txt Creating polylines and polygons 10630.txt Drawing freehand 10631.txt Using text blocks 10632.txt Bringing Pictures into 1-2-3 10633.txt Working with drawn objects 10634.txt Changing lines or edges 10635.txt Changing fill patterns 10636.txt Changing colors 10637.txt Arranging drawn objects 10638.txt Why audit your worksheets? 10639.txt Using Tools Audit 10640.txt Calculating a frequency distribution 10641.txt Performing a regression analysis 10642.txt Using data matrixes 10643.txt Using Backsolver 10644.txt Using what-if tables 10645.txt Solving a problem by changing one variable 10646.txt Solving a problem by changing two variables 10647.txt Solving a problem by changing three variables 10648.txt Charting what-if tables 10649.txt What can Solver do? 10650.txt How Solver works 10651.txt Using Solver 10652.txt Solver example 10653.txt Solver answers 10654.txt Tips on using Solver 10655.txt Introducing Ami Pro features 10656.txt Introducing the Ami Pro documentation 10657.txt Using the Ami Pro printed documentation 10658.txt Understanding Ami Pro terminology 10659.txt Learning about Ami Pro for Windows 10660.txt Checking your package 10661.txt System requirements 10662.txt Installing Ami Pro 10663.txt Starting Ami Pro 10664.txt Becoming familiar with the Ami Pro window 10665.txt Understanding Ami Pro basics 10666.txt Understanding Ami Pro pointer shapes 10667.txt Using the status bar 10668.txt Using Help 10669.txt Stopping Ami Pro 10670.txt Setting User Setup defaults 10671.txt Setting document defaults 10672.txt Setting Default Paths 10673.txt Setting Load Defaults 10674.txt Setting View Preferences 10675.txt Understanding screen fonts 10676.txt Understanding how Ami Pro uses screen fonts 10677.txt Creating a new Ami Pro document 10678.txt Assigning paragraph styles 10679.txt Saving an Ami Pro document 10680.txt Using Password Protect 10681.txt Closing a document 10682.txt Opening an Ami Pro document 10683.txt Moving around in a document 10684.txt Selecting text 10685.txt Deselecting text 10686.txt Editing text 10687.txt Inserting the date or time into a document 10688.txt Undoing one or more actions 10689.txt Understanding text formatting and text enhancements 10690.txt Applying a font to selected text 10691.txt Applying an alignment to selected text 10692.txt Applying an indention to selected text 10693.txt Applying line spacing to selected text 10694.txt Applying attributes to selected text 10695.txt Applying special effects to selected text 10696.txt Removing text formatting and enhancements 10697.txt Using Fast Format for selected text 10698.txt Using a bullet 10699.txt Understanding page layout 10700.txt Modifying the page layout 10701.txt Modifying the standard page layout 10702.txt Using an inserted page layout 10703.txt Understanding tabs and rulers 10704.txt Using the current ruler 10705.txt Using page and column breaks 10706.txt Understanding other options that affect page layout and page 10707.txt Understanding style sheets 10708.txt Overriding the style sheet 10709.txt Overriding a paragraph style 10710.txt Understanding the formatting hierarchy 10711.txt Managing paragraph styles 10712.txt Creating a style sheet 10713.txt Using another style sheet 10714.txt Using different views 10715.txt Using display modes 10716.txt Displaying the parts of the Ami Pro window 10717.txt Viewing multiple documents 10718.txt Understanding Outline mode 10719.txt Assigning outline levels 10720.txt Accessing Outline mode 10721.txt Using the outline level and command icons 10722.txt Using the outline buttons 10723.txt Editing in Outline mode 10724.txt Displaying text in Outline mode 10725.txt Printing in Outline mode 10726.txt Understanding outline numbering 10727.txt Using outline numbering 10728.txt Using proofing tools 10729.txt Using Spell Check 10730.txt Editing the dictionary 10731.txt Using Language Options 10732.txt Using Grammar Check 10733.txt Understanding printing 10734.txt Printing the current document 10735.txt Printing in the background 10736.txt Selecting a printer for a document 10737.txt Printing in landscape mode 10738.txt Printing an envelope 10739.txt Understanding printer fonts 10740.txt Printing pictures 10741.txt Understanding headers and footers 10742.txt Using a fixed header or footer 10743.txt Using a floating header or footer 10744.txt Editing text that contains a floating header or footer mark 10745.txt Using page layout options for a header and footer 10746.txt Using Page Numbering 10747.txt Understanding frames 10748.txt Creating a frame 10749.txt Selecting one or more frames 10750.txt Editing a frame 10751.txt Grouping frames 10752.txt Using layered frames 10753.txt Using text in a frame 10754.txt Using Modify Frame Layout 10755.txt Understanding graphics 10756.txt Using a picture in a frame 10757.txt Understanding Tables 10758.txt Creating a table 10759.txt Placing information into a table 10760.txt Moving around in a table 10761.txt Selecting cells in a table 10762.txt Modifying the appearance of information in a table 10763.txt Editing a table 10764.txt Modifying a table 10765.txt Understanding cell addresses 10766.txt Using formulas 10767.txt Using footnotes in a table 10768.txt Using tabs in a table 10769.txt Using a page break in a table 10770.txt Sorting data in a table 10771.txt Using a table for merge 10772.txt Using table data to create a chart 10773.txt Creating a form 10774.txt Understanding Drawing 10775.txt Accessing Draw mode 10776.txt Using the draw icons 10777.txt Creating a drawing 10778.txt Selecting objects in a drawing 10779.txt Editing a drawing 10780.txt Grouping objects 10781.txt Using layered objects 10782.txt Modifying an object 10783.txt Using a grid 10784.txt Modifying Draw settings 10785.txt Importing a drawing 10786.txt Saving a drawing or an object as a graphic file 10787.txt Copying a drawing or an object 10788.txt Exiting Draw mode 10789.txt Understanding Charting 10790.txt Creating data for a chart 10791.txt Understanding chart types 10792.txt Creating a chart 10793.txt Setting charting defaults 10794.txt Editing a chart 10795.txt Using a chart created in another application 10796.txt Using Graphics Scaling 10797.txt Moving a picture in a frame 10798.txt Understanding gray scale images 10799.txt Using Image Processing 10800.txt Using Go To 10801.txt Using Find & Replace 10802.txt Using Bookmarks 10803.txt Using Line Numbering 10804.txt Using Sort 10805.txt Understanding text and data file filters 10806.txt Using import and export file filters 10807.txt Importing and exporting files 10808.txt Using import and export options 10809.txt Using the import and export table 10810.txt Using Doc Info 10811.txt Using Revision Marking 10812.txt Comparing Documents 10813.txt Using Notes 10814.txt Understanding SmartIcons 10815.txt Positioning and sizing SmartIcons 10816.txt Displaying SmartIcons 10817.txt Selecting a set of SmartIcons 10818.txt Specifying the order of SmartIcons 10819.txt Modifying a set of SmartIcons 10820.txt Deleting a set of SmartIcons 10821.txt Modifying custom SmartIcons 10822.txt Understanding paragraph styles 10823.txt Modifying the formatting information for a paragraph style 10824.txt Defining a paragraph style 10826.txt Creating a new paragraph style 10827.txt Understanding reference tools 10828.txt Using Thesaurus 10829.txt Using Footnotes 10830.txt Using Table of Contents 10831.txt Using Index 10832.txt Using Glossary 10833.txt Understanding Master Document 10834.txt Creating a master document 10835.txt Modifying a master document 10836.txt Generating a table of contents or an index 10837.txt Printing a master document 10838.txt Editing a document included in a master document 10839.txt Updating a master document 10840.txt ANSI & ASCIICharacter Set 10841.txt Understanding power fields 10842.txt Inserting a power field 10843.txt Understanding syntax conventions 10844.txt Using formatting options 10845.txt Displaying power fields 10846.txt Printing power fields 10847.txt Updating power fields 10848.txt Editing a power field 10849.txt Using File Management 10850.txt Understanding Merge 10851.txt Creating a merge data file 10852.txt Creating a merge document 10853.txt Merging the data 10854.txt Assigning an Ami Pro merge data file 10855.txt Modifying an Ami Pro merge data file 10856.txt Creating labels 10857.txt Printing multiple records on a page 10858.txt Using Merge conditions 10859.txt Using different types of data files for a merge 10860.txt Using Mail 10861.txt Understanding links 10862.txt Creating a link 10863.txt Using Link Options 10864.txt Creating a macro that uses DDE 10865.txt Embedding an object 10866.txt Editing an OLE object 10867.txt Using Paste Special 10868.txt Understanding Equations 10869.txt Accessing Equation mode 10870.txt Using the equation icons 10872.txt Moving the insertion point in an equation 10873.txt Selecting parts of an equation 10874.txt Editing an equation 10875.txt Modifying the appearance of an equation 10876.txt Modifying equation character and symbol icons 10877.txt Saving as a TeX file 10878.txt Importing a TeX file 10879.txt Exiting Equation mode 10880.txt Understanding Macros 10881.txt Recording and playing a quick macro 10882.txt Recording and playing a macro 10883.txt Modifying a macro 10884.txt What are versions? 10885.txt What are scenarios? 10886.txt Working with Version Manager 10887.txt Using versions 10888.txt Using scenarios 10889.txt Sharing versions and scenarios 10890.txt Related Help topics 10891.txt Related Help topics 10892.txt What is a 1-2-3 database table? 10893.txt Creating a 1-2-3 database table 10894.txt Using Criteria 10895.txt Using query tables 10896.txt Finding records 10897.txt Appending records to a database table 10898.txt Deleting records from a database table 10899.txt Related Help topics 10900.txt COPYRIGHT 10901.txt How to Use This Guide 10902.txt An Overview of the Organizer 10903.txt Planning Your Organizer Installation 10904.txt Conventions Used in This Guide 10905.txt Requirements 10906.txt Supported Networks 10907.txt A Typical Configuration 10908.txt Summary of Installation and Configuration Steps 10909.txt Installation Checklist 10910.txt Step 1: Installing the Organizer on the Server 10911.txt Step 2: Running SETUPDIR 10912.txt Steps 3 and 4: Setting Access Rights/Adding ORGACCT 10913.txt Step 5: Installing the Organizer on Users Workstations 10914.txt Step 6: Running the Organizer Agent 10915.txt Upgrading to Release 1.1 10916.txt Setting Up Organizer Files for Resources 10917.txt Using DIRADMIN 10918.txt Using SRVADMIN 10919.txt Using ORGUTILS in Batch Mode 10920.txt Using PWDADMIN 10921.txt Some Common Problems and Solutions 10922.txt Agent Error Messages 10923.txt What's an external database table? 10924.txt Connecting to an external database table 10925.txt Creating an external database table 10926.txt Sending commands to an external database 10927.txt Disconnecting from an external database table 10928.txt Working with sets of SmartIcons 10929.txt Creating and modifying sets of SmartIcons 10930.txt Customizing icons 10931.txt What is a macro? 10932.txt Summary of how to create a macro 10933.txt Planning a macro 10934.txt Deciding where to enter a macro 10935.txt Creating macro commands 10936.txt Recording a macro 10937.txt Naming a macro 10938.txt Working with a macro button 10939.txt Running a macro 10940.txt Stopping a macro 10941.txt Recalculating during a macro 10942.txt Using autoexecute macros 10943.txt Debugging a macro 10944.txt Documenting a macro 10945.txt Saving a macro 10946.txt Learning about each macro 10947.txt Related Help topics 10948.txt Using mail 10949.txt Linking 1-2-3 with other applications 10950.txt Creating links 10951.txt Getting information about links 10952.txt Modifying links 10953.txt Embedding objects 10954.txt Entering LMBCS characters 10955.txt LMBCS tables 10956.txt How 1-2-3 allocates memory 10957.txt Regaining memory 10958.txt Hard disk storage 10959.txt Copyright 10960.txt How to Use This Book 10961.txt Calculating Running Totals: Checkbood Register 10962.txt Creating Custom Forms: Expense Report 10963.txt Qualification and Amortization of Loans 10964.txt Data Queries: Accounts Receivable 10965.txt Organizing Data: Integrated Financials 10966.txt Consolidation and Allocation: Performance Planning 10967.txt Index to Improv Techniques 10968.txt About files in Approach 10969.txt Creating and opening files 10970.txt Saving and closing files 10971.txt Deleting a file 10972.txt Types of fields 10973.txt Defining new fields 10974.txt Customizing a field for data entry 10975.txt Editing a field definition 10976.txt Deleting a field 10977.txt About joined databases 10978.txt Joining and unjoining 10979.txt About Design 10980.txt Design regions 10981.txt Design screen guides 10982.txt Adding design objects 10983.txt Selecting and manipulating objects and text 10984.txt Changing object and text styles 10985.txt Working with more than one object at a time 10986.txt Managing views 10987.txt About forms and reports 10988.txt Creating a form based on one database 10989.txt Adding fields to a form 10990.txt Modifying fields 10991.txt Creating a form for joined databases 10992.txt Using a repeating panel in a form 10993.txt Examples of forms 10994.txt About reports 10995.txt Formatting a report 10996.txt Summarizing data in reports 10997.txt Examples of reports 10998.txt About form letters and mailing labels 10999.txt Creating a form letter 11000.txt Creating mailing labels 11001.txt Designing labels 11002.txt Removing extra space between fields 11003.txt About Browse 11004.txt Views for entering data 11005.txt Moving to another record 11006.txt Adding records 11007.txt Entering data in fields 11008.txt Selecting a value for a field 11009.txt Putting a picture or OLE object in a field 11010.txt Filling a field with a new value 11011.txt Hiding and showing records 11012.txt Deleting records 11013.txt Finding data in records 11014.txt Finding duplicate values 11015.txt Sorting records by data in fields 11016.txt Showing all records in their original order 11017.txt How a view looks when printed 11018.txt Getting ready to print 11019.txt Printing a view 11020.txt A few pointers 11021.txt Defining a macro 11022.txt Editing or deleting a macro 11023.txt Attaching a macro to a button or object 11024.txt Running a macro 11025.txt Creating sample macros 11026.txt About file formats 11027.txt Importing data or views 11028.txt Exporting data from Approach 11029.txt Copying a PicturePlus picture to a file 11030.txt About OLE objects 11031.txt Linking OLE objects from other applications 11032.txt Embedding an OLE object 11033.txt About networking with Approach 11034.txt Setting up your network environment 11035.txt Protecting your files 11036.txt Working with a database on a network 11056.txt Choose a Look 11057.txt Choose a Page Layout 11058.txt Fill in the Blanks 11059.txt See the Big Picture 11060.txt Add Speaker Notes 11061.txt Save a Presentation 11062.txt Print a Presentation 11063.txt Navigate in a Presentation 11064.txt Use SmartIcons to Take Shortcuts 11065.txt Use Online Help 11066.txt Tips 11067.txt For More Information 11068.txt About Text Blocks 11069.txt Type Text in "Click here..." Text Blocks 11070.txt Create a Text Block 11071.txt Drag Existing Text into "Click here..." Text Blocks 11072.txt Edit Text 11073.txt Change the Attributes of Selected Text 11074.txt To create a presentation in Freelance Graphics 11075.txt Choose a Look 11076.txt Format Text by Paragraph 11077.txt Cut, Copy, and Paste Text 11078.txt Add or Change the Text Block Border and Pattern 11079.txt Curve Text 11080.txt Check Your Spelling 11081.txt Tips 11082.txt For More Information 11083.txt Work with Charts 11084.txt Create a Chart 11085.txt The Two Views of the Chart Data & Titles Window 11086.txt Preview a Chart as You Work 11087.txt Change Chart Data 11088.txt Add Headings, Notes, and Axis Titles 11089.txt Change to a New Chart Type 11090.txt Change Chart Settings 11091.txt Tips 11092.txt Choose a Page Layout 11093.txt Display Your Presentation in Outliner View 11094.txt Create a Presentation in Outliner View 11095.txt Expand and Collapse an Outline 11096.txt Select More Than One Page or Paragraph 11097.txt Promote and Demote Text 11098.txt Move One or More Pages or Bulleted Items 11099.txt Add a New Page 11100.txt Delete a Page 11101.txt Print the Outline 11102.txt Tips 11103.txt For More Information 11104.txt American National Standards Institute (ANSI) character set 11105.txt Four Ways to Transfer Data 11106.txt Share Data with Other Windows Applications 11107.txt Embed Objects in Applications 11108.txt Fill in the Blanks 11109.txt File Import and File Export 11110.txt Tips 11111.txt For More Information 11112.txt See the Big Picture 11113.txt Add Speaker Notes 11114.txt Save a Presentation 11115.txt Print a Presentation 11116.txt Navigate in a Presentation 11117.txt Use SmartIcons to Take Shortcuts 11118.txt Use Online Help 11119.txt Tips 11120.txt For More Information 11121.txt Bring Chart Data into Freelance Graphics 11122.txt Copy Data from a File 11123.txt Copy Data from an Open Windows Application 11124.txt Copy Charts from 1-2-3 and Symphony 11125.txt About Text Blocks 11126.txt Type Text in "Click here..." Text Blocks 11127.txt Update Links 11128.txt View and Edit Links 11129.txt Create a Text Block 11130.txt Delete Links 11131.txt Tips 11132.txt Drag Existing Text into "Click here..." Text Blocks 11133.txt For More Information 11134.txt Edit Text 11135.txt Change the Attributes of Selected Text 11136.txt Format Text by Paragraph 11137.txt Select Objects 11138.txt Deselect Objects 11139.txt Copy Objects 11140.txt Delete Objects 11141.txt Size Objects 11142.txt Move Objects 11143.txt Cut, Copy, and Paste Text 11144.txt Change Object Attributes 11145.txt Align, Space, Flip, and Rotate Objects 11146.txt Group Objects 11147.txt Add or Change the Text Block Border and Pattern 11148.txt Connect Lines 11149.txt Edit an Object's Points 11150.txt Curve Text 11151.txt Break Objects Apart 11152.txt Convert Open Objects to Closed Objects 11153.txt Check Your Spelling 11154.txt Convert Closed Objects to Open Objects 11155.txt Tips 11156.txt For More Information 11157.txt Tips 11158.txt For More Information 11159.txt Display Your Presentation in Outliner View 11160.txt Create a Presentation in Outliner View 11161.txt Expand and Collapse an Outline 11162.txt Select More Than One Page or Paragraph 11163.txt Draw Objects 11164.txt Zoom In for Detailed Work 11165.txt Promote and Demote Text 11166.txt Customize the Drawing Environment 11167.txt For More Information 11168.txt Move One or More Pages or Bulleted Items 11169.txt Add a New Page 11170.txt Delete a Page 11171.txt Print the Outline 11172.txt Tips 11173.txt For More Information 11174.txt Take a Shortcut 11175.txt Reposition the Set of SmartIcons 11176.txt Customize a Set of SmartIcons 11177.txt Create a New Set of SmartIcons 11178.txt Choose a Different Set of SmartIcons 11179.txt Hide or Show SmartIcons 11180.txt Change or Create SmartIcons 11181.txt Tips 11182.txt For More Information 11183.txt Create a Chart 11184.txt The Two Views of the Chart Data & Titles Window 11185.txt Preview a Chart as You Work 11186.txt Change Chart Data 11187.txt Add Headings, Notes, and Axis Titles 11188.txt Change to a New Chart Type 11189.txt Change Chart Settings 11190.txt Tips 11191.txt Bring Chart Data into Freelance Graphics 11192.txt Copy Data from a File 11193.txt Copy Data from an Open Windows Application 11194.txt Copy Charts from 1-2-3 and Symphony 11195.txt Update Links 11196.txt View and Edit Links 11197.txt Delete Links 11198.txt Tips 11199.txt For More Information 11200.txt Add Symbols to a Presentation 11201.txt Use Symbols as Bullets 11202.txt Edit a Symbol 11203.txt Add an Image to a Page 11204.txt Tip 11205.txt For More Information 11206.txt Add Symbols to a Presentation 11207.txt Use Symbols as Bullets 11208.txt Edit a Symbol 11209.txt Add an Image to a Page 11210.txt Tip 11211.txt For More Information 11212.txt Add Headers and Footers 11213.txt Change the Page Orientation 11214.txt Print Your Presentation 11215.txt Print One or More Pages 11216.txt Print Speaker Notes, Audience Notes, or Handouts 11239.txt Copyright Notice 11240.txt How To Use This Book 11241.txt New features 11242.txt System requirements 11243.txt Upgrading to 1-2-3 Release 4 11244.txt To remove copy protection 11245.txt Learning 1-2-3 11246.txt Starting 1-2-3 11247.txt Looking at the 1-2-3 window 11248.txt Control panel 11249.txt SmartIcons 11250.txt Looking at the worksheet window 11251.txt Status bar 11252.txt Mouse and keyboard 11253.txt Menu commands 11254.txt Dialog boxes 11255.txt Ending 1-2-3 11256.txt A new look 11257.txt SmartIcons 11258.txt Getting Help 11259.txt Selecting data 11260.txt File basics 11261.txt Changing the worksheet's appearance 11262.txt Entering and editing data 11263.txt Copying, moving, and deleting 11264.txt Charting and drawing 11265.txt Copyright 11266.txt About Lotus Organizer 11267.txt Before you begin 11268.txt Lotus Organizer terminology 11269.txt Users Guide conventions 11270.txt Learning about the Organizer 11271.txt Installing the Organizer 11272.txt Starting and stopping the Organizer 11273.txt Organizer pointer shapes 11274.txt Using shortcuts 11275.txt Saving an Organizer file 11276.txt Using Help 11277.txt Using passwords 11278.txt Setting up your Organizer file 11279.txt Introducing the Calendar section 11280.txt Scheduling an appointment 11281.txt Editing an appointments text 11282.txt Setting duration using the TimeTracker 11283.txt Rescheduling an appointment 11284.txt Creating repeating appointments 11285.txt Setting alarms 11286.txt Running an application at a preset time 11287.txt Setting cost codes for an appointment 11288.txt Making an appointment confidential 11289.txt Showing information from other sections in the Calendar 11290.txt Customizing your Calendar 11291.txt About meetings 11292.txt Scheduling a Meeting 11293.txt Tracking meeting invitations 11294.txt Responding to meeting invitations 11295.txt Introducing the To Do section 11296.txt Entering a To Do task 11297.txt Editing a task 11298.txt Managing your To Do tasks 11299.txt Showing To Do tasks in the Calendar 11300.txt Introducing the Address section 11301.txt Entering names and addresses 11302.txt Editing a record 11303.txt Shortcuts for entering names and addresses 11304.txt Finding names and addresses 11305.txt Changing the sort order 11306.txt Making phone calls 11307.txt Using the phone log 11308.txt Introducing the Notepad section 11309.txt Adding a Notepad page 11310.txt Editing the Notepad page options 11311.txt Copying and moving pages 11312.txt Tips on inserting Notepad pages 11313.txt Modifying the table of contents 11314.txt Working with picture pages 11315.txt Bringing in information from other applications 11316.txt Copying information to other applications 11317.txt Introducing the Planner section 11318.txt Entering a Planner event 11319.txt Using your Planner and Calendar together 11320.txt Customizing your Planner 11321.txt Introducing the Anniversary section 11322.txt Entering an anniversary 11323.txt Editing an anniversary 11324.txt Working with multiple sections 11325.txt Adding a section 11326.txt Customizing section tabs 11327.txt Including sections from other Organizer files 11328.txt Introducing links 11329.txt Linking information in the Organizer 11330.txt Linking to a file or application 11331.txt Displaying a list of links 11332.txt Introduction 11333.txt Using the Windows Clipboard 11334.txt Using mail 11335.txt Using Dynamic Data Exchange (DDE) links 11336.txt Using DDE links to bring information into the Organizer 11337.txt Importing records into your Address section 11338.txt Exporting records from your Address section 11339.txt Introduction 11340.txt Selecting a printer 11341.txt Selecting printing options 11342.txt Tips for printing from specific sections 11343.txt Customizing your page layout 11344.txt Header and footer commands 11345.txt Overview 11346.txt Introduction 11347.txt Getting Started with the Working Together Pack 11348.txt Working Together Bonus Pack Macros 11349.txt What is the Working Together Bonus Pack? 11350.txt Selecting the Working Together Bonus Pack Icon Set 11351.txt Contents of the Working Together Bonus Pack 11352.txt Integration with all Lotus Windows products 11353.txt Integration with 1-2-3 Release 4 for Windows 11354.txt Integration with Freelance Graphics for Windows 11355.txt Integration with Lotus Notes and cc:Mail 11356.txt Integration with Lotus Organizer for Windows 11357.txt Integration with Improv for Windows 11358.txt Integration with Lotus DocOnline 11359.txt Copyright 11360.txt What's New 11361.txt Faster and Easier Presentations 11362.txt Improved Output Quality 11363.txt Working Together 11364.txt OS/2 Workplace Shell 11365.txt SmartIcons 11366.txt Add Headers and Footers 11367.txt Change the Page Orientation 11368.txt Print Your Presentation 11369.txt Print One or More Pages 11370.txt Print Speaker Notes, Audience Notes, or Handouts 11371.txt Change Printers 11372.txt Print to Black-and-White Printers 11373.txt Tips 11374.txt Run a Screen Show 11375.txt Choose Replacement Effects and Advancement 11376.txt Draw Onscreen During a Show 11377.txt Control the Sequence of Pages 11378.txt Use Multimedia 11379.txt Tips 11380.txt How SmartMaster Sets Work 11381.txt Add Text or Graphics to Every Page in a Presentation 11382.txt Change Text Attributes Globally 11383.txt Customize SmartMaster Sets 11384.txt "Click here..." Blocks for Text and Graphic Objects 11385.txt For More Information 11386.txt Change the Color of an Object 11387.txt Palettes and the Color Library 11388.txt Choose a Color That Will Not Change 11389.txt Switch Between Color and Black and White 11390.txt Change Graduated Fills to Solid for Printing 11391.txt Adjust for Color Printing 11392.txt Make Global Color Changes 11393.txt Tips 11394.txt For More Information 11395.txt Take a Shortcut 11396.txt Reposition the Set of SmartIcons 11397.txt Customize a Set of SmartIcons 11398.txt Create a New Set of SmartIcons 11399.txt Choose a Different Set of SmartIcons 11400.txt Hide or Show SmartIcons 11401.txt Change or Create SmartIcons 11402.txt Tips 11403.txt Draw Objects 11404.txt Zoom In for Detailed Work 11405.txt Customize the Drawing Environment 11406.txt For More Information 11407.txt Select Objects 11408.txt Deselect Objects 11409.txt Delete Objects 11410.txt Size Objects 11411.txt Move Objects 11412.txt Copy Objects 11413.txt Change Object Attributes 11414.txt Align, Space, Flip, and Rotate Objects 11415.txt Group Objects 11416.txt Connect Lines 11417.txt Edit an Object's Points 11418.txt Break Objects Apart 11419.txt Convert Open Objects to Closed Objects 11420.txt Convert Closed Objects to Open Objects 11421.txt Tips 11422.txt For More Information 11423.txt Four Ways to Transfer Data 11424.txt Share Data with Other Windows Applications 11425.txt Embed Objects in Applications 11426.txt Copy Data from Files 11427.txt File Import and File Export 11428.txt Tips 11429.txt For More Information 11430.txt Compose Sequences 11431.txt Freelance Graphics Characters !ltsdoc.zip All Lotus Documentation Technotes, zipped files.txt Listing of the Lotus Documentation directory