home *** CD-ROM | disk | FTP | other *** search
Microsoft Windows Help File Content | 1997-11-20 | 23.8 KB | 683 lines |
- :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
-