Toggle on and off the select mode in a chart's Datasheet.
DatasheetColWidth
Syntax
DatasheetColWidth(Width As Integer)
Description
Specify a chart's Datasheet column width in number of characters.
Parameters
Width: numeric The column width in characters.
DatasheetDateFmt
Syntax
DatasheetDateFmt(Format As _DatasheetDateFmt_Format_enum, [CustFmtStr As String])
Description
Format the selected chart's Datasheet cells as dates.
Parameters
Format: enumeration The date format.
DD_MMM
DD_MMM_YY
General
HH_MM
HH_MM_SS
MM_DD
MM_DD_YY
MM_DD_YY_HH_MM_SS
MM_YY
MMM_DD
MMM_DD_YY
MMM_YY
Q_YY
QTR_YY
UserDef
YYYY
YYYY_MM_DD
CustFmtStr: string (optional) The user-defined date format. Contains the date string defining the user-defined date format.
DatasheetDelete
Syntax
DatasheetDelete(Direction As _DatasheetDelete_Direction_enum, Number As Integer)
Description
Remove rows or columns from a chart's Datasheet.
Parameters
Direction: enumeration Delete rows or columns.
Columns
Rows
Number: numeric The number of rows or columns to delete.
DatasheetDown
Syntax
DatasheetDown(Count As Integer, BlockExtend As _DatasheetDown_BlockExtend_enum)
Description
Move the insertion point down a specified number of cells in a chart's Datasheet.
Parameters
Count: numeric The number of cells down to move the insertion point.
BlockExtend: enumeration Moving the insertion point selects cells.
No
Yes
DatasheetExclude
Syntax
DatasheetExclude(Direction As _DatasheetExclude_Direction_enum)
Description
Exclude the data in the selected Datasheet rows or columns from a chart.
Parameters
Direction: enumeration Exclude columns or rows.
Columns
Rows
DatasheetExport
Syntax
DatasheetExport(Filename As String, Delimiter As Integer, Format As _DatasheetExport_Format_enum)
Description
Export data from a chart's Datasheet to a file.
Parameters
Filename: string The name of the file to contain exported data.
Delimiter: numeric The ASCII numeric equivalent of a character to use as a delimiter for each Datasheet cell.
Format: enumeration The file format.
Ansi
Ascii
DatasheetFillDates
Syntax
DatasheetFillDates(Start As Double, Step As Double, StepType As _DatasheetFillDates_StepType_enum, Direction As _DatasheetFillDates_Direction_enum)
Description
Fill the current chart's Datasheet with a series of dates.
Parameters
Start: numeric The starting date. The date 1/1/1900 12:00 am is represented by a 1. To determine the numeric equivalent of a date, type the date in the Start entry box, then choose Linear or Growth from the Type options.
Step: numeric Increment between dates.
StepType: enumeration The type of increment.
Days
Hours
Minutes
Months
Qtrs
Seconds
Weekdays
Weeks
Years
Direction: enumeration Fill a Datasheet by rows or columns.
Columns
Rows
DatasheetFillNumbers
Syntax
DatasheetFillNumbers(Start As Double, Step As Double, FillType As _DatasheetFillNumbers_FillType_enum, Direction As _DatasheetFillNumbers_Direction_enum)
Description
Fill a chart's Datasheet with a series of numbers.
Parameters
Start: numeric The starting number.
Step: numeric Increment between numbers.
FillType: enumeration The type of increment.
Growth
Linear
Direction: enumeration Fill a Datasheet by rows or columns.
Columns
Rows
DatasheetFormula
Syntax
DatasheetFormula(Function As _DatasheetFormula_Function_enum, RowCol As _DatasheetFormula_RowCol_enum, Dest As Integer, Arguments As String, MovAveArg As String, PolyFitOrder As Integer, FitForecast As Integer)
Description
Apply a formula to rows or columns of a chart's Datasheet.
Parameters
Function: enumeration The function to perform on selected data.
AbsVal
Average
Cosine
CumTotal
Difference
FitExp
FitLin
FitLog
FitPoly
FitPower
Max
Min
MovAve
None
Percent
Sine
Sum
RowCol: enumeration Fill by columns or rows.
Column
Row
Dest: numeric The row or column to contain the formula results.
Arguments: string The beginning and ending row or column numbers, separated by a comma.
MovAveArg: string The number of values to average before and after each chart item when calculating a moving average.
PolyFitOrder: numeric The number of points in the Order of Curve Fit when charting a fit polynomial curve.
FitForecast: numeric Indicate how far to forecast.
DatasheetGoto
Syntax
DatasheetGoto(Column As Integer, Row As Integer, BlockExtend As _DatasheetGoto_BlockExtend_enum, MouseClick As _DatasheetGoto_MouseClick_enum)
Description
Move the insertion point to a specified cell in a chart's Datasheet.
Parameters
Column: numeric The column number.
Row: numeric The row number.
BlockExtend: enumeration Creates a selected block of cells between, and including, the cell specified by the Column and Row parameter, and the cell that was selected prior to the execution of this method.
No
Yes
MouseClick: enumeration Cells scroll into view, as they do when you click the mouse to select a cell.
No
Yes
DatasheetHome
Syntax
DatasheetHome([ControlKey As _DatasheetHome_ControlKey_enum])
Description
Perform the function of the Home key in a chart's Datasheet. The Home key is used with other keystrokes to move the insertion point in a Datasheet.
Parameters
ControlKey: enumeration (optional) Indicate whether the Control key was pressed in addition to the Home key. This parameter will cause the cursor to move to cell 0,0.
No
Yes
DatasheetImport
Syntax
DatasheetImport(Filename As String, Clear As _DatasheetImport_Clear_enum, Link As _DatasheetImport_Link_enum, Transpose As _DatasheetImport_Transpose_enum, Location As _DatasheetImport_Location_enum, [Range As String])
Description
Import data from a spreadsheet file into a chart's Datasheet.
Parameters
Filename: string The datasheet file to import.
Clear: enumeration (optional) Clear the data chart Datasheet before importing spreadsheet data.
Clear
NoClear
Link: enumeration (optional) Link the import file to the file containing the data chart.
Link
NoLink
Transpose: enumeration (optional) Transpose the imported data.
NoTranspose
Transpose
Location: enumeration Import data to the top left cell (0,0), or the cell containing the insertion point.
CurrentCell
TopLeft
Range: string (optional) The range of spreadsheet cells from which to import data.
DatasheetImportOptions
Syntax
DatasheetImportOptions(Filename As String, Clear As _DatasheetImportOptions_Clear_enum, Link As _DatasheetImportOptions_Link_enum, InsertAt As _DatasheetImportOptions_InsertAt_enum)
Description
Specify default options for the Import Data dialog box, which is used to import data into a chart's Datasheet. This method exists for 0S/2 integration.
Parameters
Filename: string The default filename.
Clear: enumeration Clear Current Data is selected.
No
Yes
Link: enumeration The link to the Datasheet is selected.
No
Yes
InsertAt: enumeration Specify whether Import at Current Cell is selected. Otherwise, imported data begins at the top left cell.
CurrentCell
TopLeft
DatasheetImportText
Syntax
DatasheetImportText(Filename As String, FileFormat As _DatasheetImportText_FileFormat_enum, FieldDelimiter As String, RecordDelimiter As String, StripChars As String, EncapsulationChar As String, ClearData As _DatasheetImportText_ClearData_enum, Link As _DatasheetImportText_Link_enum, Transpose As _DatasheetImportText_Transpose_enum, Location As _DatasheetImportText_Location_enum)
Description
Import data from a text file to a chart's Datasheet.
Parameters
Filename: string The file from which to import data.
FileFormat: enumeration The format of the data file.
Ansi
Ascii
FieldDelimiter: string (optional) The field delimiter for imported text.
RecordDelimiter: string (optional) The record delimiter for imported text.
StripChars: string (optional) The characters to strip from imported text.
EncapsulationChar: string (optional) The character used to encapsulate each field.
ClearData: enumeration (optional) Clear the chart's Datasheet before importing data.
Clear
NoClear
Link: enumeration (optional) Link the data file to the Datasheet.
Link
NoLink
Transpose: enumeration (optional) Transpose the data before importing.
NoTranspose
Transpose
Location: enumeration Import data to the top left cell (0,0), or the cell containing the insertion point.
CurrentCell
TopLeft
DatasheetInclude
Syntax
DatasheetInclude(Direction As _DatasheetInclude_Direction_enum)
Description
Include the data in a specified chart's Datasheet rows or columns in a data chart.
Parameters
Direction: enumeration Include columns or rows.
Columns
Rows
DatasheetInput
Syntax
DatasheetInput(String As String)
Description
Insert data into a cell in a chart's Datasheet.
Parameters
String: string The data to insert.
DatasheetInsert
Syntax
DatasheetInsert(Direction As _DatasheetInsert_Direction_enum, Number As Integer)
Description
Add rows or columns to a chart's Datasheet.
Parameters
Direction: enumeration Add columns or rows.
Columns
Rows
Number: numeric The number of rows or columns to add.
DatasheetLeft
Syntax
DatasheetLeft(Count As Integer, BlockExtend As _DatasheetLeft_BlockExtend_enum)
Description
Move the insertion point a specified number of cells to the left in a chart's Datasheet.
Parameters
Count: numeric The number of cells to the left to move the insertion point.
BlockExtend: enumeration Moving the insertion point selects cells.
No
Yes
DatasheetNumericFmt
Syntax
DatasheetNumericFmt(FloatingDigits As Integer, Digits As Integer, NegParen As Integer, Currency As Integer, Thousands As Integer, Percent As Integer, Exponential As Integer)
Description
Specify a numeric format for selected cells of a chart's Datasheet.
Parameters
FloatingDigits: numeric Numeric format includes floating digits or a fixed number of digits after the decimal point. Use the Digits parameter to specify a fixed number. Use 0 for fixed and 1 for floating.
Digits: numeric A fixed number of digits. Use only when the value of the FloatingDigits parameter is 0.
NegParen: numeric Show negative numbers with a minus sign or in parentheses. Use 0 for minus sign and 1 for parentheses.
Currency: numeric Format numbers with a currency symbol. Use 0 for no currency symbol and 1 for a currency symbol.
Thousands: numeric Format numbers with a thousands separator. Use 0 for no thousands separator and 1 for a thousands separator.
Percent: numeric Determine whether to format numbers as percentages. Use 0 for no percentage and 1 for a percentage.
Exponential: numeric Determine whether to format numbers as exponents. Use 0 for no exponent and 1 for an exponent.
DatasheetOneColWidth
Syntax
DatasheetOneColWidth([Column As Integer]) As Integer
Description
Specify a chart's Datasheet column width in number of characters for one column.
Return Value
Returns the width of the specified column.
Parameters
Column: numeric (optional) The width of the column in characters.
DatasheetPgDn
Syntax
DatasheetPgDn(Count As Integer, BlockExtend As _DatasheetPgDn_BlockExtend_enum)
Description
Move the insertion point down a specified number of pages in a chart's Datasheet.
Parameters
Count: numeric The number of pages down to move the insertion point.
BlockExtend: enumeration Moving the insertion point selects cells.
No
Yes
DatasheetPgLeft
Syntax
DatasheetPgLeft(Count As Integer, BlockExtend As _DatasheetPgLeft_BlockExtend_enum)
Description
Move the insertion point a specified number of pages to the left in a chart's Datasheet.
Parameters
Count: numeric The number of pages left to move the insertion point.
BlockExtend: enumeration Moving the insertion point selects cells.
No
Yes
DatasheetPgRight
Syntax
DatasheetPgRight(Count As Integer, BlockExtend As _DatasheetPgRight_BlockExtend_enum)
Description
Move the insertion point a specified number of pages to the right in a chart's Datasheet.
Parameters
Count: numeric The number of pages right to move the insertion point.
BlockExtend: enumeration Moving the insertion point selects cells.
No
Yes
DatasheetPgUp
Syntax
DatasheetPgUp(Count As Integer, BlockExtend As _DatasheetPgUp_BlockExtend_enum)
Description
Move the insertion point up a specified number of cells in a chart's Datasheet.
Parameters
Count: numeric The number of pages up to move the insertion point.
BlockExtend: enumeration Moving the insertion point selects cells.
No
Yes
DatasheetRight
Syntax
DatasheetRight(Count As Integer, BlockExtend As _DatasheetRight_BlockExtend_enum)
Description
Move the insertion point a specified number of cells to the right in a chart's Datasheet.
Parameters
Count: numeric The number of cells right to move the insertion point.
BlockExtend: enumeration Moving the insertion point selects cells.
No
Yes
DatasheetUp
Syntax
DatasheetUp(Count As Integer, BlockExtend As _DatasheetUp_BlockExtend_enum)
Description
Move the insertion point up a specified number of cells in a chart's Datasheet.
Parameters
Count: numeric The number of cells up to move the insertion point.
BlockExtend: enumeration Moving the insertion point selects cells.
No
Yes
DateCode
Syntax
DateCode()
Description
Insert a date code into a text area or text line at the insertion point.
DateFormat
Syntax
DateFormat(DateFormatString As String)
Description
Specify a date format when inserting a date in the Text Editor.
Parameters
DateFormatString: string Specify a date format.
DateFormatDlg
Syntax
DateFormatDlg()
Description
Display the Date/Time Format dialog box, which is used to specify the appearance of the date and time when they are inserted into a text line or text area.
DateText
Syntax
DateText()
Description
Insert the current date at the insertion point in the Text Editor.
DefineBulletsDlg
Syntax
DefineBulletsDlg()
Description
Display the Define Bullets/Fonts dialog box, which is used to set bullets options, font options, and box/frame options in a bullet chart.
DefineSubTitleDlg
Syntax
DefineSubTitleDlg()
Description
Change subtitle attibutes.
DefineTitleDlg
Syntax
DefineTitleDlg()
Description
Change title attributes.
Delete
Syntax
Delete()
Description
Remove the character to the right of the insertion point in a text area or text line.
DeleteAlignBars
Syntax
DeleteAlignBars()
Description
Remove the alignment guides.
DeleteAlignmentBar
Syntax
DeleteAlignmentBar()
Description
Remove the alignment guide.
DeleteBackground
Syntax
DeleteBackground()
Description
Delete the current background.
DeleteKeyboard
Syntax
DeleteKeyboard([KeyboardName As String])
Description
Delete a keyboard.
Parameters
KeyboardName: string (optional) The name of the keyboard to delete.
DeleteLayout
Syntax
DeleteLayout()
Description
Delete the current layout from the slide show master.
DeleteMenu
Syntax
DeleteMenu([MenuName As String])
Delete a menu bar.
Description
Parameters
MenuName: string (optional) The name of the menu bar to delete.
DeleteObjects
Syntax
DeleteObjects()
Description
Delete the selected items when editing an object. You can delete an entire object, or selected points only.
DeleteSelectedSlides
Syntax
DeleteSelectedSlides([PromptToDelete As _DeleteSelectedSlides_PromptToDelete_enum])
Description
Remove the selected slides from the current slide show.
Parameters
PromptToDelete: enumeration (optional) Determine whether to prompt the user before deleting slides.
No
Yes
DeleteToBegOfWord
Syntax
DeleteToBegOfWord()
Description
Erase text from the insertion point to the beginning of the word containing the insertion point.
DeleteToEndOfWord
Syntax
DeleteToEndOfWord()
Description
Erase text from the insertion point to the end of the word containing the insertion point.
DeleteWord
Syntax
DeleteWord()
Description
Delete the word containing the insertion point.
DelToDocBottom
Syntax
DelToDocBottom()
Description
Delete all text from the insertion point to the end of the current text window.
DelToEndOfLine
Syntax
DelToEndOfLine()
Description
Delete text from the insertion point to the end of the current line.
DisplaySettingsDlg
Syntax
DisplaySettingsDlg()
Description
Display the Display dialog box, which is used to specify display preferences.
DocPrevious
Syntax
DocPrevious()
Description
Display the previous open document in the editing window.
DocumentBottom
Syntax
DocumentBottom()
Description
Move the insertion point to the end of the text in the current text line or text area.
DocumentFormSettings
Syntax
DocumentFormSettings(FormWidth As Integer, FormHeight As Integer, MarginLeft As Integer, MarginBottom As Integer, MarginRight As Integer, MarginTop As Integer, Orientation As _DocumentFormSettings_Orientation_enum, [ObjectFit As _DocumentFormSettings_ObjectFit_enum], [IsPosterMode As _DocumentFormSettings_IsPosterMode_enum], [PosterColumns As Integer], [PosterRows As Integer])
Description
Specify page size, margins, and poster options for the current drawing or slide show.
Parameters
FormWidth: measurement The paper width in WordPerfect units (1200ths of an inch).
FormHeight: measurement The paper height in WordPerfect units.
MarginLeft: measurement The size of the left margin in WordPerfect units.
MarginBottom: measurement The size of the bottom margin in WordPerfect units.
MarginRight: measurement The size of the right margin, in WordPerfect units.
MarginTop: measurement The size of the top margin, in WordPerfect units.
Orientation: enumeration The page orientation.
Landscape
Portrait
ObjectFit: enumeration (optional) Specify how to move or size objects to conform to the new page size.
Center
LowerLeft
LowerRight
MatchMarginsCenter
MatchMarginsExact
MatchMarginsLowerLeft
MatchMarginsLowerRight
MatchMarginsUpperLeft
MatchMarginsUpperRight
NoModify
ObjectsToMarginsCenter
ObjectsToMarginsExact
ObjectsToMarginsLowerLeft
ObjectsToMarginsLowerRight
ObjectsToMarginsUpperLeft
ObjectsToMarginsUpperRight
UpperLeft
UpperRight
IsPosterMode: enumeration (optional) Poster mode is active.
No
Yes
PosterColumns: numeric (optional) In poster mode, the number of columns that overlay the form.
PosterRows: numeric (optional) In poster mode, the number of rows that overlay the form.
DocumentMaximize
Syntax
DocumentMaximize()
Description
Expand the current document window to its maximum size. If the window is already maximized, this method terminates the macro or redirects the macro to the LABEL specified by ONERROR.
DocumentMinimize
Syntax
DocumentMinimize()
Description
Reduce the current document window to an icon. If the window is already minimized, this method terminates the macro or redirects the macro to the LABEL specified by ONERROR.
DocumentMove
Syntax
DocumentMove()
Description
Pause the macro to allow a user to move the current document window. Click the mouse or press Enter to continue playing the macro.
DocumentNext
Syntax
DocumentNext()
Description
Display the next open document in the editing window.
DocumentPageColor
Syntax
DocumentPageColor(FillType As _DocumentPageColor_FillType_enum, SolidColorRed As Integer, SolidColorGreen As Integer, SolidColorBlue As Integer, [GradientColorRed As Integer], [GradientColorGreen As Integer], [GradientColorBlue As Integer], [GradientType As _DocumentPageColor_GradientType_enum], [GradientAngle As Integer], [GradientSteps As Integer], [GradientRefX As Integer], [GradientRefY As Integer], [BrushPattern As Integer], [TextureFit As Integer], [TextureFileName As String])
Description
Set the page color for the current document.
Parameters
FillType: enumeration The type of page color.
Gradient
Pattern
Picture
Texture
SolidColorRed: numeric The amount of red (0-255) in a solid page color, the top color of a linear gradient, or the center color of a circular or rectangular gradient.
SolidColorGreen: numeric The amount of green (0-255) in a solid page color, the top color of a linear gradient, or the center color of a circular or rectangular gradient.
SolidColorBlue: numeric The amount of blue (0-255) in a solid page color, the top color of a linear gradient, or the center color of a circular or rectangular gradient.
GradientColorRed: numeric (optional) The amount of red (0-255) in the bottom color of a linear gradient, or the outer color of a circular or rectangular gradient.
GradientColorGreen: numeric (optional) The amount of green (0-255) in the bottom color of a linear gradient, or the outer color of a circular or rectangular gradient.
GradientColorBlue: numeric (optional) The amount of blue (0-255) in the bottom color of a linear gradient, or the outer color of a circular or rectangular gradient.
GradientType: enumeration (optional) The linear, circular, or rectangular gradient.
Grad_Ccircles
Grad_Linear
Grad_None
Grad_VRects
GradientAngle: numeric (optional) Specify a rotation angle for a gradient page color. The top of the gradient is rotated counter-clockwise. For example, a 90-degree angle places the top of the gradient along the left margin of the page.
GradientSteps: numeric (optional) The number of steps between colors in a gradient page color. A value of 0 represents the greatest possible number of steps.
GradientRefX: numeric (optional) The horizontal center of a circular or rectangular gradient relative to the page. Flush left is 0, center is 50, and flush right is 100.
GradientRefY: numeric (optional) The vertical center of a circular or rectangular gradient, or the top of a linear gradient relative to the page. Top is 0, center is 50, and bottom is 100.
BrushPattern: numeric (optional) The fill pattern.
TextureFit: numeric (optional) How the texture fills the page.
TextureFileName: string (optional) The filename of texture bitmap.
DocumentRestore
Syntax
DocumentRestore()
Description
Restore a document window to its previous size. If the window has already been restored, this method will terminate the macro or redirect the macro to the LABEL specified by ONERROR.
DocumentSize
Syntax
DocumentSize()
Description
Pause macro execution to allow the user to size the document window. Click the mouse or press Enter to continue playing the macro.
DocumentTop
Syntax
DocumentTop()
Description
Move the insertion point to the top of the current text area or text line.
DoubleSmartQuote
Syntax
DoubleSmartQuote([State As _DoubleSmartQuote_State_enum], [OpenQuote As String], [CloseQuote As String])
Description
Turn double SmartQuotes on or off and specify quote characters in QuickCorrect.
Parameters
State: enumeration (optional) Double smart quotes are on or off.
Off
On
OpenQuote: string (optional) The character to use for double open quote.
CloseQuote: string (optional) The character to use for double close quote.
DraftMode
Syntax
DraftMode()
Description
Turn Draft Mode on. In Draft Mode, images in a drawing window are displayed as outlines. To turn Draft Mode off, use PageMode.
DrawingSizeDlg
Syntax
DrawingSizeDlg()
Description
Display the Drawing Size dialog box, which is used to set the frame size for an OLE graphic.
DrawingSizeSettings
Syntax
DrawingSizeSettings(Left As Integer, Bottom As Integer, Right As Integer, Top As Integer, [UseEvenBorders As _DrawingSizeSettings_UseEvenBorders_enum], [BorderSize As Integer])
Description
Change the size of a drawing area when Corel Presentations is running as an OLE client.
Parameters
Left: measurement The left coordinate of a drawing area, in WordPerfect units (1200ths of an inch).
Bottom: measurement The bottom coordinate of a drawing area, in WordPerfect units.
Right: measurement The right coordinate of a drawing area, in WordPerfect units.
Top: measurement The top coordinate of a drawing area, in WordPerfect units.
UseEvenBorders: enumeration (optional) Move the borders to conform to drawing.
No
Yes
BorderSize: numeric (optional) A percentage of the drawing size. Values (0-100). Default (5).
