:Base vcf1.hlp :Title Formula One 3.0 Help 1 Introduction to Formula One 2 Welcome to Formula One=IDH_Contents 2 Reaching Our Technical Support Department=Reaching_Our_Technical_Support_Department 2 New Features in the Professional Edition of Formula One 3.0=New_Features_in_Version_3_0 1 Getting Started 2 Adding the OCX to Your Application=Adding_the_OCX_to_Your_Application 2 Distributing Formula One Applications=Distributing_Formula_One_Applications 1 Views and Workbooks 2 Using Views and Workbooks=Using_Views_and_Workbooks 2 Working with Workbooks=Working_with_Workbooks 2 Working with Views=Working_with_Views 2 Using View Information=Using_View_Information 2 Attaching Views to Workbooks=Attaching_Views_to_Workbooks 2 One View That Can Display Multiple WorkBooks=One_View_That_Can_Display_Multiple_WorkBooks 2 One Workbook Displayed in Multiple Views=One_Workbook_Displayed_in_Multiple_Views 2 Controlling What is Displayed in a View=Controlling_What_is_Displayed_in_a_View 1 Workbooks and Worksheets 2 The Formula One Workbook=The_Formula_One_Workbook 2 Worksheet Management 3 Inserting Worksheets=Inserting_Worksheets 3 Sheet Index List=Sheet_Index_List 3 Selecting Worksheets=Selecting_Worksheets 3 Working with a Group of Worksheets=Working_with_a_Group_of_Worksheets 3 Inserting Multiple Worksheets=Inserting_Multiple_Worksheets 3 Deleting Worksheets=Deleting_Worksheets 3 Renaming Worksheets=Renaming_Worksheets 3 Positioning Worksheet Tabs=Positioning_Worksheet_Tabs 2 Worksheet Navigation 3 Navigating Through Worksheets=Navigating_Through_Worksheets 3 Using Keyboard Commands=Using_Keyboard_Commands 3 Performing Mouse Actions=Performing_Mouse_Actions 2 Selecting Parts of Worksheets 3 Selecting Cells=Selecting_Cells 3 Selecting Cells with the Mouse=Selecting_Cells_with_the_Mouse 3 Selecting Cells with Properties and Methods=Selecting_Cells_with_Properties_and_Methods 3 Selecting Rows and Columns=Selecting_Rows_and_Columns 1 Workbook Designer 2 Using the Workbook Designer=Using_the_Workbook_Designer 2 Workbook Designer Overview=Workbook_Designer_Overview 2 Workbook Designer Menus 3 File Menu=File_Menu 3 Edit Menu=Edit_Menu 3 View Menu=View_Menu 3 Data Menu=Data_Menu 3 Sheet Menu=Sheet_Menu 3 Format Menu=Format_Menu 3 Object Menu=Object_Menu 1 Working with Worksheets 2 Entering Data in Worksheets 3 Worksheet Data Entry=Worksheet_Data_Entry 3 Adding the edit bar=Adding_the_edit_bar 3 Data Entry 4 Entering Data with Properties=Entering_Data_with_Properties 4 Entering Multi-Line Data=Entering_Multi_Line_Data 4 Limiting Data Entry=Limiting_Data_Entry 4 Limiting Formula Entry=Limiting_Formula_Entry 4 Locking Cells=Locking_Cells 4 Displaying Formulas=Displaying_Formulas 4 Worksheet Errors=Worksheet_Errors 4 AutoFill Lists 5 Using AutoFill Lists=Using_AutoFill_Lists 5 Adding AutoFill Lists=Adding_AutoFill_Lists 5 Deleting AutoFill Lists=Deleting_AutoFill_Lists 4 Data Validation 5 Validating Data=Validating_Data 5 The Validation Formula=The_Validation_Formula 4 Types of Worksheet Data 5 Worksheet Data Types=Worksheet_Data_Types 5 Entering Constant Values=Entering_Constant_Values 5 Entering Formulas=Entering_Formulas 5 Formula Operators=Formula_Operators 5 Operator Precedence=Operator_Precedence 4 Referencing Cells 5 Cell References=Cell_References 5 Absolute and Relative References=Absolute_and_Relative_References 5 References to Other Worksheets=References_to_Other_Worksheets 5 References to Multiple Worksheets=References_to_Multiple_Worksheets 5 External References=External_References 5 Automatically Entering Cell References=Automatically_Entering_Cell_References 5 Using Names=Using_Names 4 Worksheet Functions 5 Built-In Worksheet Functions=Built_In_Worksheet_Functions 5 Understanding Functions=Understanding_Functions 5 Entering Functions=Entering_Functions 5 Nesting Functions=Nesting_Functions 5 Entering Arguments=Entering_Arguments 5 Syntax Errors=Syntax_Errors 3 Worksheet Calculation 4 Calculating Worksheets=Calculating_Worksheets 4 Setting Automatic Recalculation=Setting_Automatic_Recalculation 4 Solving Circular References=Solving_Circular_References 2 Editing Worksheets 3 Cut, Copy, and Paste Methods=Cut_Copy_and_Paste_Methods 3 Copying Data Across Ranges=Copying_Data_Across_Ranges 3 Copying Data Interactively=Copying_Data_Interactively 3 Interactively Copying Ranges=Interactively_Copying_Ranges 3 Moving Data=Moving_Data 3 Interactively Moving Ranges=Interactively_Moving_Ranges 3 Inserting Cells, Rows, and Columns=Inserting_Cells_Rows_and_Columns 3 Clearing and Deleting Cells, Rows, and Columns=Clearing_and_Deleting_Cells_Rows_and_Columns 3 Sorting Data in Worksheets=Sorting_Data_in_Worksheets 2 Formatting Worksheets 3 Formatting Worksheets=Formatting_Worksheets 3 Formatting Data 4 Built-in Number Formats=Built_in_Number_Formats 4 Formatting Rows and Columns=Formatting_Rows_and_Columns 4 Obtaining Formatted Text=Obtaining_Formatted_Text 4 Custom Formatting=Custom_Formatting 4 Aligning Data=Aligning_Data 3 Formatting Rows and Columns 4 Changing Row Heights and Column Widths=Changing_Row_Heights_and_Column_Widths 4 Interactively Sizing Rows and Columns=Interactively_Sizing_Rows_and_Columns 4 Sizing Rows and Columns with Properties and Methods=Sizing_Rows_and_Columns_with_Properties_and_Methods 4 Fixing Rows and Columns=Fixing_Rows_and_Columns 4 Setting Cell Borders and Colors=Setting_Cell_Borders_and_Colors 3 Formatting Row and Column Headings 4 Formatting Row and Column Headings=Formatting_Row_and_Column_Headings 4 Selecting Row and Column Heading Areas=Selecting_Row_and_Column_Heading_Areas 4 Sizing Row and Column Headings=Sizing_Row_and_Column_Headings 4 Setting Row and Column Text=Setting_Row_and_Column_Text 2 File Handing 3 Reading and Writing Files=Reading_and_Writing_Files 3 Using BLOB access=Using_BLOB_access 2 Worksheet Functions 3 ABS=ABS 3 ACOS=ACOS 3 ACOSH=ACOSH 3 ADDRESS=ADDRESS 3 AND=AND 3 ASIN=ASIN 3 ASINH=ASINH 3 ATAN=ATAN 3 ATAN2=ATAN2 3 ATANH=ATANH 3 AVERAGE=AVERAGE 3 CEILING=CEILING 3 CHAR=CHAR 3 CHOOSE=CHOOSE 3 CLEAN=CLEAN 3 CODE=CODE 3 COLUMN=COLUMN 3 COLUMNS=COLUMNS 3 CONCATENATE=CONCATENATE 3 COS=COS 3 COSH=COSH 3 COUNT=COUNT 3 COUNTIF=COUNTIF 3 COUNTA=COUNTA 3 DATE=DATE 3 DATEVALUE=DATEVALUE 3 DAY=DAY 3 DB=DB 3 DDB=DDB 3 DOLLAR=DOLLAR 3 ERROR.TYPE=ERROR_TYPE 3 EVEN=EVEN 3 EXACT=EXACT 3 EXP=EXP 3 FACT=FACT 3 FALSE=FALSE 3 FIND=FIND 3 FIXED=FIXED 3 FLOOR=FLOOR 3 FV=FV 3 HLOOKUP=HLOOKUP 3 HOUR=HOUR 3 IF=IF 3 INDEX=INDEX 3 INDIRECT=INDIRECT 3 INT=INT 3 IPMT=IPMT 3 IRR=IRR 3 ISBLANK=ISBLANK 3 ISERR=ISERR 3 ISERROR=ISERROR 3 ISLOGICAL=ISLOGICAL 3 ISNA=ISNA 3 ISNONTEXT=ISNONTEXT 3 ISNUMBER=ISNUMBER 3 ISREF=ISREF 3 ISTEXT=ISTEXT 3 LEFT=LEFT 3 LEN=LEN 3 LN=LN 3 LOG=LOG 3 LOG10=LOG10 3 LOOKUP=LOOKUP 3 LOWER=LOWER 3 MATCH=MATCH 3 MAX=MAX 3 MID=MID 3 MIN=MIN 3 MINUTE=MINUTE 3 MIRR=MIRR 3 MOD=MOD 3 MONTH=MONTH 3 N=N 3 NOT=NOT 3 NOW=NOW 3 NPER=NPER 3 NPV=NPV 3 ODD=ODD 3 OFFSET=OFFSET 3 OR=OR 3 PI=PI 3 PMT=PMT 3 PPMT=PPMT 3 PRODUCT=PRODUCT 3 PROPER=PROPER 3 PV=PV 3 RAND=RAND 3 RATE=RATE 3 REPLACE=REPLACE 3 REPT=REPT 3 RIGHT=RIGHT 3 ROUND=ROUND 3 ROUNDDOWN=ROUNDDOWN 3 ROUNDUP=ROUNDUP 3 ROW=ROW 3 ROWS=ROWS 3 SEARCH=SEARCH 3 SECOND=SECOND 3 YEAR SIGN=YEAR_SIGN 3 SIN=SIN 3 SINH=SINH 3 SLN=SLN 3 SQRT=SQRT 3 STDEV=STDEV 3 STDEVP=STDEVP 3 SUBSTITUTE=SUBSTITUTE 3 SUM=SUM 3 SUMIF=SUMIF 3 SUMSQ=SUMSQ 3 SYD=SYD 3 T=T 3 TAN=TAN 3 TANH=TANH 3 TEXT=TEXT 3 TIME=TIME 3 TIMEVALUE=TIMEVALUE 3 TODAY=TODAY 3 TRIM=TRIM 3 TRUE=TRUE 3 TRUNC=TRUNC 3 TYPE=TYPE 3 UPPER=UPPER 3 VALUE=VALUE 3 VAR=VAR 3 VARP=VARP 3 VDB=VDB 3 VLOOKUP=VLOOKUP 3 WEEKDAY=WEEKDAY 3 YEAR=YEAR 1 Working with Objects 2 Working with Objects=Working_with_Objects 2 Creating Objects 3 Creating Objects=Creating_Objects 3 Creating Objects with Methods=Creating_Objects_with_Methods 3 Interactively Drawing Objects=Interactively_Drawing_Objects 3 Picture Objects=Picture_Objects 3 Setting Mouse Mode=Setting_Mouse_Mode 3 Identifying Objects=Identifying_Objects 3 Naming Objects=Naming_Objects 2 Selecting Objects 3 Selecting Objects=Selecting_Objects 3 Interactively Selecting Objects=Interactively_Selecting_Objects 3 Limiting Interactive Object Selection=Limiting_Interactive_Object_Selection 3 Selecting Objects Programmatically=Selecting_Objects_Programmatically 2 Positioning Objects 3 Moving, Sizing, and Arranging Objects=Moving_Sizing_and_Arranging_Objects 3 Interactively Positioning Objects=Interactively_Positioning_Objects 3 Positioning Objects Programmatically=Positioning_Objects_Programmatically 3 Determining Object Position and Size=Determining_Object_Position_and_Size 3 Arranging Overlapping Objects=Arranging_Overlapping_Objects 3 Arranging Objects and Object Order=Arranging_Objects_and_Object_Order 2 Formatting Objects 3 Formatting Objects=Formatting_Objects 3 Formatting Colors and Patterns=Formatting_Colors_and_Patterns 3 Showing and Hiding Objects=Showing_and_Hiding_Objects 3 Formatting List Boxes=Formatting_List_Boxes 3 Formatting Check Boxes=Formatting_Check_Boxes 3 Formatting Buttons=Formatting_Buttons 3 Selecting Check Box and List Box Items=Selecting_Check_Box_and_List_Box_Items 3 Setting Values Interactively=Setting_Values_Interactively 3 Setting Values Programmatically=Setting_Values_Programmatically 3 Setting Values by Cell Reference=Setting_Values_by_Cell_Reference 3 Editing Polygons=Editing_Polygons 1 Charting Formula One Data 2 Working with Chart Objects=Working_with_Chart_Objects 2 Using the Chart Wizard=Using_the_Chart_Wizard 2 Chart Formatting=Additional_Chart_Formatting 2 Chart Options=Chart_Options 2 Referencing Data on Another Worksheet=Referencing_Data_on_Another_Worksheet 1 Connecting to a Database 2 Working with Databases=Working_with_Databases 2 Installing the ODBC Drivers=Installing_the_ODBC_Drivers 2 Setting up a Data Source=Setting_up_a_Data_Source 2 Overview of Formula One Connections=Overview_of_Formula_One_Connections 2 Connecting to the Data Source=Connecting_to_the_Data_Source 2 Querying the Data Source=Querying_the_Data_Source 2 Disconnecting from the Data Source=Disconnecting_from_the_Data_Source 1 Printing Worksheets 2 Printing Worksheets=Printing_Worksheets 2 Specifying Print Areas=Specifying_Print_Areas 2 Specifying Row and Column Print Titles=Specifying_Row_and_Column_Print_Titles 2 Specifying Headers and Footers=Specifying_Headers_and_Footers 2 Specifying Page Breaks=Specifying_Page_Breaks 2 Page Break Methods=Page_Break_Methods 2 Setting Printing Orientation=Setting_Printing_Orientation 2 Using the Windows API DEVMODE Structure=Using_the_Windows_API_DEVMODE_Structure 1 Formula One Workbook Properties 2 Formula One Workbook Properties=General_Tab 1 Programming Reference 2 The Formula One Control=The_Formula_One_Control 2 Using Properties=Using_Properties 2 Setting Properties=Setting_Properties 2 Property Data Types=Property_Data_Types 2 Retrieving Property Values=Returning_Property_Values 2 Properties that take an index=Properties_that_take_an_index 2 Using Methods=Using_Methods 2 Handling Errors=Handling_Errors 2 OCX Property and Method Reference 3 Dialog box Methods 4 CalculationDlg=CalculationDlg_Method 4 ColorPaletteDlg=ColorPaletteDlg_Method 4 ColWidthDlg=ColWidthDlg_Method 4 DefinedNameDlg=DefinedNameDlg_Method 4 FilePageSetupDlg=FilePageSetupDlg_Method 4 FilePrintSetupDlg=FilePrintSetupDlg_Method 4 FormatAlignmentDlg=FormatAlignmentDlg_Method 4 FormatBorderDlg=FormatBorderDlg_Method 4 FormatDefaultFontDlg=FormatDefaultFontDlg_Method 4 FormatFontDlg=FormatFontDlg_Method 4 FormatNumberDlg=FormatNumberDlg_Method 4 FormatPatternDlg=FormatPatternDlg_Method 4 GotoDlg=GotoDlg_Method 4 LineStyleDlg=LineStyleDlg_Method 4 ObjNameDlg=ObjNameDlg_Method 4 ObjOptionsDlg=ObjOptionsDlg_Method 4 OpenFileDlg=OpenFileDlg_Method 4 ProtectionDlg=ProtectionDlg_Method 4 RowHeightDlg=RowHeightDlg_Method 4 SaveFileDlg=SaveFileDlg_Method 4 SortDlg=SortDlg_Method 4 ValidationRuleDlg=ValidationRuleDlg_Method 3 Workbook Methods and Properties 4 Attach=Attach_Method 4 AttachToSS=AttachToSS_Method 4 InitTable=InitTable_Method 4 SSUpdate=SSUpdate_Method 4 SS=SS_Method 4 SwapTables=SwapTables_Method 4 TableName=TableName_Property 4 Title=Title_Property 3 Worksheet Methods and Properties 4 DeleteSheets=DeleteSheets_Method 4 EditDeleteSheets Method=EditDeleteSheets_Method 4 EditInsertSheets=EditInsertSheets_Method 4 InsertSheets=InsertSheets_Method 4 NumSheets=NumSheets_Property 4 Sheet=Sheet_Property 4 SheetName=SheetName_Property 4 SheetSelected=SheetSelected_Property 3 Data Entry Methods and Properties 4 AllowAutoFill Property=AllowAutoFill_Property 4 AllowEditHeaders=AllowEditHeaders_Property 4 AllowInCellEditing=AllowInCellEditing_Property 4 AutoFillItems=AutoFillItems_Property 4 AutoFillItemsCount=AutoFillItemsCount_Property 4 CancelEdit=CancelEdit_Method 4 Clip=Clip_Property 4 ClipValues=ClipValues_Property 4 DeleteAutoFillItems=DeleteAutoFillItems_Method 4 EndEdit=EndEdit_Method 4 Entry=Entry_Property 4 EntryRC=EntryRC_Property 4 FormattedText=FormattedText_Property 4 FormattedTextRC=FormattedTextRC_Property 4 Formula=Formula_Property 4 FormulaRC=FormulaRC_Property 4 GetTabbedText=GetTabbedText_Method 4 GetValidationRule=GetValidationRule_Method 4 Logical=Logical_Property 4 LogicalRC=LogicalRC_Property 4 Number=Number_Property 4 NumberRC=NumberRC_Property 4 SetTabbedText=SetTabbedText_Method 4 SetValidationRule=SetValidationRule_Method 4 StartEdit=StartEdit_Method 4 Text=Text_Property 4 TextRC=TextRC_Property 4 Type=Type_Property 4 TypeRC=TypeRC_Property 3 Database Methods 4 ODBCConnect Method=ODBCConnect_Method 4 ODBCDisconnect Method=ODBCDisconnect_Method 4 ODBCQuery Method=ODBCQuery_Method 3 Formatting Methods and Properties 4 AllowDesigner=AllowDesigner_Property 4 AllowResize=AllowResize_Property 4 BackColor=BackColor_Property 4 BorderStyle=BorderStyle_Property 4 ColHidden=ColHidden_Property 4 ColText=ColText_Property 4 ColWidth=ColWidth_Property 4 ColWidthTwips=ColWidthTwips_Property 4 ColWidthUnits=ColWidthUnits_Property 4 ExtraColor=ExtraColor_Property 4 FixedCol=FixedCol_Property 4 FixedCols=FixedCols_Property 4 FixedRow=FixedRow_Property 4 FixedRows=FixedRows_Property 4 FormatCurrency0=FormatCurrency0_Method 4 FormatCurrency2=FormatCurrency2_Method 4 FormatFixed=FormatFixed_Method 4 FormatFixed2=FormatFixed2_Method 4 FormatFraction=FormatFraction_Method 4 FormatGeneral=FormatGeneral_Method 4 FormatHmmampm=FormatHmmampm_Method 4 FormatMdyy=FormatMdyy_Method 4 FormatPercent=FormatPercent_Method 4 FormatScientific=FormatScientific_Method 4 GetAlignment=GetAlignment_Method 4 GetBorder=GetBorder_Method 4 GetDefaultFont=GetDefaultFont_Method 4 GetFont=GetFont_Method 4 GetPattern=GetPattern_Method 4 HdrHeight=HdrHeight_Property 4 HdrWidth=HdrWidth_Property 4 LaunchDesigner=LaunchDesigner_Method 4 LeftCol=LeftCol_Property 4 MaxCol=MaxCol_Property 4 MaxRow=MaxRow_Property 4 MinCol=MinCol_Property 4 MinRow=MinRow_Property 4 NumberFormat=NumberFormat_Property 4 PaletteEntry=PaletteEntry_Property 4 RowHeight=RowHeight_Property 4 RowHidden=RowHidden_Property 4 RowText=RowText_Property 4 ScrollToLastRC=ScrollToLastRC_Property 4 SetAlignment=SetAlignment_Method 4 SetBorder=SetBorder_Method 4 SetColHidden=SetColHidden_Method 4 SetColWidth=SetColWidth_Method 4 SetColWidthAuto=SetColWidthAuto_Method 4 SetColWidthTwips=SetColWidthTwips_Method 4 SetDefaultFont=SetDefaultFont_Method 4 SetFont=SetFont_Method 4 SetPattern=SetPattern_Method 4 SetRowHeight=SetRowHeight_Method 4 SetRowHeightAuto=SetRowHeightAuto_Method 4 SetRowHidden=SetRowHidden_Method 4 ShowColHeading=ShowColHeading_Property 4 ShowEditBar=ShowEditBar_Property 4 ShowEditBarCellRef=ShowEditBarCellRef_Property 4 ShowFormulas=ShowFormulas_Property 4 ShowGridLines=ShowGridLines_Property 4 ShowHScrollBar=ShowHScrollBar_Property 4 ShowRowHeading=ShowRowHeading_Property 4 ShowSelections=ShowSelections_Property 4 ShowTabs Property=ShowTabs_Property 4 ShowTypeMarkers=ShowTypeMarkers_Property 4 ShowVScrollBar=ShowVScrollBar_Property 4 ShowZeroValues=ShowZeroValues_Property 4 TopLeftText=TopLeftText_Property 4 TopRow=TopRow_Property 3 Worksheet Editing Methods and Properties 4 AllowArrows=AllowArrows_Property 4 AllowDelete=AllowDelete_Property 4 AllowFillRange=AllowFillRange_Property 4 AllowMoveRange=AllowMoveRange_Property 4 AllowTabs=AllowTabs_Property 4 ClearRange=ClearRange_Method 4 CopyAll=CopyAll_Method 4 CopyRange=CopyRange_Method 4 CopyRangeEx=CopyRangeEx_Method 4 DeleteRange=DeleteRange_Method 4 EditClear=EditClear_Method 4 EditCopy=EditCopy_Method 4 EditCopyDown=EditCopyDown_Method 4 EditCopyRight=EditCopyRight_Method 4 EditCut=EditCut_Method 4 EditDelete=EditDelete_Method 4 EditInsert=EditInsert_Method 4 EditPaste=EditPaste_Method 4 EditPasteValues=EditPasteValues_Method 4 EnterMovesDown=EnterMovesDown_Property 4 InsertRange=InsertRange_Method 4 MoveRange=MoveRange_Method 3 Recalculation Methods and Properties 4 AllowFormulas=AllowFormulas_Property 4 AutoRecalc=AutoRecalc_Property 4 CalculationDlg=CalculationDlg_Method 4 CheckRecalc=CheckRecalc_Method 4 GetIteration=GetIteration_Method 4 Recalc=Recalc_Method 4 SetIteration=SetIteration_Method 3 Selection Methods and Properties 4 AddSelection=AddSelection_Method 4 AllowSelections=AllowSelections_Property 4 Col=Col_Property 4 DefinedName=DefinedName_Property 4 DefinedNameByIndex=DefinedNameByIndex_Property 4 DefinedNameCount=DefinedNameCount_Method 4 DeleteDefinedName=DeleteDefinedName_Method 4 FormatRCNr=FormatRCNr_Method 4 GetActiveCell=GetActiveCell_Method 4 GetHdrSelection=GetHdrSelection_Method 4 GetSelection=GetSelection_Method 4 Row=Row_Property 4 RowMode=RowMode_Property 4 Selection=Selection_Property 4 SelectionCount=SelectionCount_Property 4 SelEndCol=SelEndCol_SelEndRow_SelStartCol_and_SelStartRow_Properties 4 SelEndRow=SelEndCol_SelEndRow_SelStartCol_and_SelStartRow_Properties 4 SelStartCol=SelEndCol_SelEndRow_SelStartCol_and_SelStartRow_Properties 4 SelStartRow=SelEndCol_SelEndRow_SelStartCol_and_SelStartRow_Properties 4 SetActiveCell=SetActiveCell_Method 4 SetHdrSelection=SetHdrSelection_Method 4 SetSelection=SetSelection_Method 4 ShowActiveCell=ShowActiveCell_Method 4 ShowSelections=ShowSelections_Property 3 Object Methods and Properties 4 AllowObjSelections=AllowObjSelections_Property 4 GetLineStyle=GetLineStyle_Method 4 LineStyleDlg=LineStyleDlg_Method 4 ObjAddItem=ObjAddItem_Method 4 ObjAddSelection=ObjAddSelection_Method 4 ObjBringToFront=ObjBringToFront_Method 4 ObjDeleteItem=ObjDeleteItem_Method 4 ObjFirstID=ObjFirstID_Method 4 ObjGetCell=ObjGetCell_Method 4 ObjGetItemCount=ObjGetItemCount_Method 4 ObjGetPos=ObjGetPos_Method 4 ObjGetSelection=ObjGetSelection_Method 4 ObjGetSelectionCount=ObjGetSelectionCount_Method 4 ObjGetType=ObjGetType_Method 4 ObjInsertItem=ObjInsertItem_Method 4 ObjItem=ObjItem_Property 4 ObjItems=ObjItems_Property 4 ObjName=ObjName_Property 4 ObjNameDlg=ObjNameDlg_Method 4 ObjNameToID=ObjNameToID_Method 4 ObjNew=ObjNew_Method 4 ObjNewPicture=ObjNewPicture_Method 4 ObjNextID=ObjNextID_Method 4 ObjOptionsDlg=ObjOptionsDlg_Method 4 ObjPosToTwips=ObjPosToTwips_Method 4 ObjSendToBack=ObjSendToBack_Method 4 ObjSetCell=ObjSetCell_Method 4 ObjSetPicture=ObjSetPicture_Method 4 ObjSetPos=ObjSetPos_Method 4 ObjSetSelection=ObjSetSelection_Method 4 ObjText=ObjText_Property 4 ObjValue=ObjValue_Property 4 ObjVisible=ObjVisible_Property 4 PolyEditMode=PolyEditMode_Property 4 SetLineStyle=SetLineStyle_Method 3 Printing Properties and Methods 4 AddColPageBreak=AddColPageBreak_Method 4 AddPageBreak=AddPageBreak_Method 4 AddRowPageBreak=AddRowPageBreak_Method 4 FilePrint=FilePrint_Method 4 GetPrintScale=GetPrintScale_Method 4 NextColPageBreak=NextColPageBreak_Method 4 NextRowPageBreak=NextRowPageBreak_Method 4 PrintArea=PrintArea_Property 4 PrintBottomMargin=PrintBottomMargin_Property 4 PrintColHeading=PrintColHeading_Property 4 PrintDevMode=PrintDevMode_Property 4 PrintFooter=PrintFooter_Property 4 PrintGridLines=PrintGridLines_Property 4 PrintHCenter=PrintHCenter_Property 4 PrintHeader=PrintHeader_Property 4 PrintLandscape=PrintLandscape_Property 4 PrintLeftMargin=PrintLeftMargin_Property 4 PrintLeftToRight=PrintLeftToRight_Property 4 PrintNoColor=PrintNoColor_Property 4 PrintRightMargin=PrintRightMargin_Property 4 PrintRowHeading=PrintRowHeading_Property 4 PrintTitles=PrintTitles_Property 4 PrintTopMargin=PrintTopMargin_Property 4 PrintVCenter=PrintVCenter_Property 4 RemoveColPageBreak=RemoveColPageBreak_Method 4 RemovePageBreak=RemovePageBreak_Method 4 RemoveRowPageBreak=RemoveRowPageBreak_Method 4 SetPrintAreaFromSelection Method=SetPrintAreaFromSelection_Method 4 SetPrintScale=SetPrintScale_Method 4 SetPrintTitlesFromSelection Method=SetPrintTitlesFromSelection_Method 3 Event-related Methods and Properties 4 DoCancelEdit=DoCancelEdit_Property 4 DoClick=DoClick_Property 4 DoDblClick=DoDblClick_Property 4 DoEndEdit=DoEndEdit_Property 4 DoEndRecalc=DoEndRecalc_Property 4 DoObjClick=DoObjClick_Property 4 DoObjDblClick=DoObjDblClick_Property 4 DoObjGotFocus=DoObjGotFocus_Property 4 DoObjLostFocus=DoObjLostFocus_Property 4 DoObjValueChanged=DoObjValueChanged_Property 4 DoRClick=DoRClick_Property 4 DoRDblClick=DoRDblClick_Property 4 DoSelChange=DoSelChange_Property 4 DoStartEdit=DoStartEdit_Property 4 DoStartRecalc=DoStartRecalc_Property 4 DoTopLeftChanged=DoTopLeftChanged_Property 3 Miscellaneous Methods and Properties 4 AboutBox=AboutBox_Method 4 AppName=AppName_Property 4 ClearClipboard=ClearClipboard_Method 4 DragIcon=DragIcon_Property 4 DragMode=DragMode_Property 4 Draw=Draw_Method 4 Enabled=Enabled_Property 4 EnableProtection=EnableProtection_Property 4 ErrorNumberToText=ErrorNumberToText_Method 4 FileName=FileName_Property 4 GetProtection=GetProtection_Method 4 HeapMin=HeapMin_Method 4 hWnd=HWnd_Method 4 LastCol=LastCol_Property 4 LastColForRow=LastColForRow_Property 4 LastRow=LastRow_Property 4 LeftCol=LeftCol_Property 4 Mode=Mode_Property 4 Modified=Modified_Property 4 MouseIcon=MouseIcon_Property 4 MousePointer=MousePointer_Property 4 RangeToTwips=RangeToTwips_Method 4 Read=Read_Method 4 ReadBromBlob=ReadFromBlob_Method 4 Repaint=Repaint_Property 4 SaveWindowInfo=SaveWindowInfo_Method 4 SetProtection=SetProtection_Method 4 Sort=Sort_Method 4 Sort3=Sort3_Method 4 SSVersion=SSVersion_Method 4 TopRow=TopRow_Property 4 TransactCommit=TransactCommit_Method 4 TransactRollback=TransactRollback_Method 4 TransactStart=TransactStart_Method 4 TwipsToRC=TwipsToRC_Method 4 ViewScale=ViewScale_Property 4 Visible=Visible_Property 4 Write=Write_Method 4 WriteToBlob=WriteToBlob_Method 2 Events 3 Using Events=Using_Events 3 Drilling for Data=Drilling_for_Data 3 Events and Other Controls=Events_and_Other_Controls 3 Capturing Mouse Movements=Capturing_Mouse_Movements 3 Click Event=Click_Event 3 DblClick Event=DblClick_Event 3 DragDrop Event=DragDrop_Event 3 DragOver Event=DragOver_Event 3 EndEdit Event=EndEdit_Event 3 EndRecalc Event=EndRecalc_Event 3 GotFocus Event=GotFocus_Event 3 KeyDown, KeyUp Events=KeyDown_KeyUp_Events 3 KeyPress Event=KeyPress_Event 3 LostFocusEvent=LostFocusEvent 3 Modified Event=Modified_Event 3 MouseDown, MouseUp Events=MouseDown_MouseUp_Events 3 MouseMove Event=MouseMove_Event 3 ObjClick Event=ObjClick_Event 3 ObjDblClick Event=ObjDblClick_Event 3 ObjGotFocus Event=ObjGotFocus_Event 3 ObjLostFocus Event=ObjLostFocus_Event 3 ObjValueChanged Event=ObjValueChanged_Event 3 RClick Event=RClick_Event 3 RDblClick Event=RDblClick_Event 3 SelChange Event=SelChange_Event 3 StartEdit Event=StartEdit_Event 3 StartRecalc Event=StartRecalc_Event 3 TopLeftChanged Event=TopLeftChanged_Event 3 ValidationFailed Event=ValidationFailed_Event 1 Performance Tuning and Specification 2 Performance Tuning=Performance_Tuning 2 Specifications=Specifications