What's New for Microsoft Office Web Components Developers

Microsoft Office Web Components Object Model

What's New for Microsoft Office Web Components Developers

Extensive changes have been made to the Microsoft Office Web Components Visual Basic object model to support new and improved features in the application. The following sections provide information about major features that are new in the Office Web Components object model.

Visit the Office Developer Center at MSDN Online for the latest Microsoft Office Web Components development information, including new technical articles, downloads, samples, product news, and more.

Click one of the following entries to jump to a section.

New Objects

New Events (Alphabetical)

New Events (By Object)

New Methods (Alphabetical)

New Methods (By Object)

New Properties (Alphabetical)

New Properties (By Object)

New Objects

The following table lists the new objects in the Microsoft Office Web Components Visual Basic object model.

Objects
ByRef
ChAxes
ChAxis
ChBorder
ChCategoryLabel
ChCategoryLabels
ChChart
ChChartDraw
ChChartField
ChChartFields
ChCharts
ChDataLabel
ChDataLabels
ChDataLabelsCollection
ChDropZone
ChErrorBars
ChErrorBarsCollection
ChFont
ChFormatMap
ChGridlines
ChInterior
ChLegend
ChLegendEntries
ChLegendEntry
ChLine
ChMarker
ChPlotArea
ChPoint
ChPoints
ChScaling
ChSegment
ChSegmentBoundary
ChSegments
ChSeries
ChSeriesCollection
ChSurface
ChTitle
ChTrendline
ChTrendlines
ChUserDefinedSelection
Coordinate
Font
Heading
Headings
Name
Names
OCCommand
OCCommands
OWCLanguageSettings
PivotAxisMember
PivotAxisMembers
PivotColumnMember
PivotColumnMembers
PivotHyperlink
PivotMemberProperties
PivotMemberProperty
PivotPageMember
PivotPageMembers
PivotResultAxis
PivotResultColumnAxis
PivotResultDataAxis
PivotResultField
PivotResultFilterAxis
PivotResultGroupAxis
PivotResultGroupField
PivotResultGroupFields
PivotResultLabel
PivotResultMemberProperties
PivotResultMemberProperty
PivotResultPageAxis
PivotResultRowAxis
PivotRowMember
PivotRowMembers
Sheets
Window
Windows
Workbook
Workbooks
Worksheets

New Events (Alphabetical)

The following table lists the new events (alphabetically) in the Microsoft Office Web Components Visual Basic type library.

Events
AfterDelete
AfterFinalRender
AfterInsert
AfterLayout
AfterRender
AfterUpdate
BeforeContextMenu
BeforeDelete
BeforeInitialBind
BeforeInsert
BeforeKeyDown
BeforeKeyPress
BeforeKeyUp
BeforeOverwrite
BeforeQuery
BeforeRender
BeforeScreenTip
BeforeUpdate
CommandBeforeExecute
CommandChecked
CommandEnabled
CommandExecute
CommandTipText
DataChange
Dirty
Focus
Initialize
LoadCompleted
MouseWheel
OnConnect
OnDisconnect
RecordExit
RecordsetSaveProgress
SheetActivate
SheetCalculate
SheetChange
SheetDeactivate
SheetFollowHyperlink
Undo

New Events (By Object)

The following table lists the new events (by object) in the Microsoft Office Web Components Visual Basic type library.

ObjectsEvents
ChartSpace
AfterFinalRender

AfterLayout

AfterRender

BeforeContextMenu

BeforeKeyDown

BeforeKeyPress

BeforeKeyUp

BeforeRender

BeforeScreenTip

CommandBeforeExecute

CommandChecked

CommandEnabled

CommandExecute

CommandTipText

MouseWheel

DataSourceControl
AfterDelete

AfterInsert

AfterUpdate

BeforeDelete

BeforeInitialBind

BeforeInsert

BeforeOverwrite

BeforeUpdate

Dirty

Focus

RecordExit

RecordsetSaveProgress

Undo

PivotTable
BeforeContextMenu

BeforeKeyDown

BeforeKeyPress

BeforeKeyUp

BeforeQuery

BeforeScreenTip

CommandBeforeExecute

CommandChecked

CommandEnabled

CommandExecute

CommandTipText

DataChange

MouseWheel

OnConnect

OnDisconnect

Spreadsheet
BeforeContextMenu

BeforeKeyDown

BeforeKeyPress

BeforeKeyUp

CommandBeforeExecute

CommandChecked

CommandEnabled

CommandExecute

CommandTipText

Initialize

LoadCompleted

MouseWheel

SheetActivate

SheetCalculate

SheetChange

SheetDeactivate

SheetFollowHyperlink

New Methods (Alphabetical)

The following table lists the new methods (alphabetically) in the Microsoft Office Web Components Visual Basic type library.

Methods
Activate
AddCalculatedField
AddCalculatedTotal
AddCustomGroupField
AddCustomGroupMember
AddFieldSet
ApplyFilter
AutoFit
BeginObject
BorderAround
CalculateFull
CopyFromRecordset
DeleteCustomGroupMember
DeleteField
DeleteFieldSet
DrawEllipse
DrawLine
DrawPolygon
DrawPolyLine
DrawRectangle
DrawText
DropZones
DuplicateFormat
EndObject
EuroConvert
Evaluate
ExportXML
FillDown
FillRight
FindNext
FindPrevious
GetPicture
Group
HideDetails
Insert
Item
LargeScroll
Move
MoveDetailLeft
MoveDetailTop
MoveLeft
MoveTop
Nz
PointsToScreenPixelsX
PointsToScreenPixelsY
Protect
RectIntersect
RectUnion
Repaint
Reset
ResetColors
ScrollIntoView
SetOneColorGradient
SetPatterned
SetPresetGradient
SetRootRecordset
SetSolid
SetSpreadsheetData
SetTextured
SetTwoColorGradient
ShowAbout
ShowContextMenu
ShowDetails
ShowHelp
SmallScroll
SortAscending
SortDescending
TextHeight
TextWidth
ToggleFilter
Ungroup
Unprotect
ValueToPoint

New Methods (By Object)

The following table lists the new methods (by object) in the Microsoft Office Web Components Visual Basic type library.

ObjectsMethods
ChartSpace
DropZones

GetPicture

Repaint

SetSpreadsheetData

ShowContextMenu

ShowHelp

ChAxis
ValueToPoint
ChChart
DuplicateFormat

SetSpreadsheetData

ChChartDraw
BeginObject

DrawEllipse

DrawLine

DrawPolygon

DrawPolyLine

DrawRectangle

DrawText

EndObject

TextHeight

TextWidth

ChInterior
SetOneColorGradient 

SetPatterned

SetPresetGradient

SetSolid

SetTextured

SetTwoColorGradient

ChSeries
Group

Ungroup

ValueToPoint

DataPage
ApplyFilter

SortAscending

SortDescending

ToggleFilter

DataSourceControl
EuroConvert

ExportXML

Nz

Reset

SetRootRecordset

Heading
Reset
Names
Item
PivotAxisMember
HideDetails

ShowDetails

PivotCell
MoveDetailTop
PivotColumnMember
HideDetails

MoveDetailLeft

ShowDetails

PivotData
HideDetails 

MoveLeft

MoveTop

ShowDetails

PivotField
AddCustomGroupMember 

DeleteCustomGroupMember

PivotFieldSet
AddCalculatedField 

AddCustomGroupField

DeleteField

PivotPageMember
HideDetails 

ShowDetails

PivotRowMember
HideDetails 

ShowDetails

PivotTable
ShowAbout 

ShowContextMenu

ShowHelp

PivotView
AddCalculatedTotal 

AddFieldSet

DeleteFieldSet

Range
Activate 

AutoFit

BorderAround

CopyFromRecordset

FillDown

FillRight

FindNext

FindPrevious

Insert

Sheets
Move
Spreadsheet
CalculateFull 

Evaluate

RectIntersect

RectUnion

Repaint

ShowAbout

ShowContextMenu

ShowHelp

Window
LargeScroll 

PointsToScreenPixelsX

PointsToScreenPixelsY

ScrollIntoView

SmallScroll

Workbook
Protect 

ResetColors

Unprotect

Worksheet
Activate 

Evaluate

Move

Protect

Unprotect

Worksheets
Move

New Properties (Alphabetical)

The following table lists the new properties (alphabetically) in the Microsoft Office Web Components Visual Basic type library.

Properties
ActiveObject
ActiveWindow
ActiveWorkbook
AllIncludeExclude
AllMember
AllowAdditions
AllowCustomOrdering
AllowDeletions
AllowEdits
AllowFormattingColumns
AllowFormattingRows
AllowHeadingRename
AllowLayoutEvents
AllowMultiFilter
AllowPointRenderEvents
AllowRenderEvents
AllowScreenTipEvents
AlternateRowColor
AlwaysIncludeInCube
AmbientLightIntensity
Application
AspectRatio
Axis
BackWall
Begin
Bookmark
Bottom
Build
ButtonBorder
ButtonFont
ButtonInterior
Calculation
CalculationVersion
CategoryLabels
CellsEx
ChartDepth
ChartFields
Checked
ChildAxisMembers
ChildColumnMembers
ChildPageMembers
ChildRowMembers
ColorIndex
Colors
ColumnHeadings
Commands
CompareMemberCaptionsBy
CompareOrderedMembersBy
ConnectionFile
Control
CurrentArray
CurrentCell
CustomGroupMembers
CustomGroupType
DashStyle
Data
DataSourceName
DefaultColor
DefaultMember
DesignMode
DetailColumnCount
DetailLeftOffset
DetailRowCount
DetailsExpanded
DetailTopOffset
DirectionalLightInclination
DirectionalLightIntensity
DirectionalLightRotation
DisplayAlert
DisplayCalculatedMembers
DisplayColumnHeadings
DisplayCustomHeadings
DisplayDesignTimeUI
DisplayFieldButtons
DisplayHeadings
DisplayIn
DisplayInFieldList
DisplayOfficeLogo
DisplayRowHeadings
DisplayScreenTips
DisplayTotal
DisplayWorkbookTabs
DisplayZeros
Divisions
DrawType
EditMode
EnableResize
End
ExcludedMembers
ExpandDetails
ExpandMembers
Expression
ExtrudeAngle
FillType
FilterCaption
FilterContext
FilterCrossJoins
FilterFunctionValue
FilterOn
FilterOnScope
FindAxisMember
FindColumnMember
FindMember
FindPageMember
FindRowMember
Floor
Format
FormatMap
FormulaArray
GapDepth
GradientDegree
GradientStyle
GradientVariant
GridlineColor
GridlineColorIndex
GroupedBackColor
GroupedFont
GroupedForeColor
GroupedHAlignment
GroupedHeight
GroupEnd
GroupField
GroupFields
GroupingTotalFunction
GroupingType
GroupingUnit
GroupingUnitType
GroupStart
HasAbsoluteLabels
HasArray
HasAutoAspectRatio
HasAutoChartDepth
HasAutoDivisions
HasDiscreteDivisions
HasMultipleCharts
HasPassiveAlerts
HasPlotDetails
HasRuntimeSelection
HasSelectionMarks
HasSeriesByRows
HasUnifiedScales
HeaderBackColor
HeaderFont
HeaderForeColor
HeaderHAlignment
HeaderHeight
HorizontalAlignment
Hwnd
id
Inclination
IncludedMembers
InternalPivotTable
International
IsConsistent
IsDataBound
IsDirty
IsHyperlink
IsValid
ItemCount
LanguageID
LanguagePreferredForEditing
LanguageSettings
Left2
LeftOffset
Level
LevelCount
LightNormal
Member
MemberCaptions
MemberProperties
MemberPropertiesOrder
MemberProperty
MergeCells
Miter
Names
Next
Offline
OfflinePublication
OfflineSource
OfflineType
Offset
OrderedMembers
PageAxis
PageMember
ParentAxisMember
ParentColumnMember
ParentLabel
ParentPageMember
ParentRowMember
Path
Pattern
PercentComplete
Period
Perspective
PivotAxis
PivotObject
PlotAllAggregates
PrefixCharacter
PresetGradientType
PresetTexture
Previous
PrintQuality3D
ProjectionMode
PropertyCaptionFont
PropertyCaptionHAlignment
PropertyCaptionWidth
PropertyHeight
PropertyValueFont
PropertyValueHAlignment
PropertyValueWidth
ProtectContents
ProtectionMode
ProtectStructure
ProviderFormattedValue
RangeSelection
ReadingOrder
RecordSelector
RefersTo
RefersToLocal
RefersToRange
Right
Rotation
RowHeadings
ScrollColumn
ScrollRow
Segments
SelectedSheets
Sheets
ShowAs
ShowAsValue
SideWall
SolveOrder
SourceAxis
SourceColumnAxis
SourceDataAxis
SourceField
SourceFilterAxis
SourceLabel
SourceMember
SourcePageAxis
SourceRowAxis
StandardHeight
StandardWidth
Status
SubtotalLabelBackColor
SubtotalLabelFont
SubtotalLabelForeColor
SubtotalLabelHAlignment
TabRatio
TextureFormat
TextureName
TexturePlacement
TextureStackUnit
Thickness
TickLabelUnitType
TickMarkUnitType
TimeValue
TipText
Toolbar
Top2
TopOffset
TotalColumnMember
TotalPageMember
TotalRowHeight
TotalRowMember
UsableHeight
UsableWidth
UserMode
UseStandardHeight
UseStandardWidth
UseXMLData
Value2
ValueType
VerticalAlignment
View
ViewOnlyMode
ViewportLeft
ViewportTop
WatermarkBorder
WatermarkFont
WatermarkInterior
WindowNumber
Windows
Workbooks
Worksheet
Worksheets
XMLDataTarget
XMLLocation
XMLURL
ZOrder

New Properties (By Object)

The following table lists the new properties (by object) in the Microsoft Office Web Components Visual Basic type library.

ObjectsProperties
AutoFilter
Application
Border
Application 

ColorIndex

Borders
Application 

ColorIndex

ChartSpace
AllowLayoutEvents 

AllowPointRenderEvents

AllowRenderEvents

AllowScreenTipEvents

Bottom

Commands

DataSourceName

DisplayFieldButtons

DisplayOfficeLogo

DisplayScreenTips

HasMultipleCharts

HasPassiveAlerts

HasPlotDetails

HasRuntimeSelection

HasSelectionMarks

HasSeriesByRows

HasUnifiedScales

InternalPivotTable

International

IsDirty

LanguageSettings

PlotAllAggregates

PrintQuality3D

Right

Toolbar

ViewOnlyMode

ChAxis
Bottom 

CategoryLabels

GroupingTotalFunction

GroupingType 

GroupingUnit 

GroupingUnitType 

Right 

TickLabelUnitType 

TickMarkUnitType 

ChBorder

DashStyle

ChCategoryLabel Bottom Level 

ParentLabel

PivotObject

Right

ChCategoryLabels
ItemCount 

LevelCount

PivotAxis

ChChart AmbientLightIntensity 

AspectRatio

Bottom

ChartDepth

DirectionalLightInclination

DirectionalLightIntensity

DirectionalLightRotation

ExtrudeAngle

GapDepth

HasAutoAspectRatio

HasAutoChartDepth

Inclination

LightNormal

Perspective

ProjectionMode

Right

Rotation

ChChartDraw
DrawType
ChChartField Bottom 

PivotObject

Right

ChDataLabel
Bottom 

Right

ChDataLabels
Bottom 

Right

ChDropZone
Bottom 

ButtonBorder

ButtonFont

ButtonInterior

ChartFields

Right

WatermarkBorder

WatermarkFont

WatermarkInterior

ChErrorBars
Bottom 

Right

ChFormatMap
Segments
ChInterior
DefaultColor 

FillType

GradientDegree

GradientStyle

GradientVariant

Pattern

PresetGradientType

PresetTexture

TextureFormat

TextureName

TexturePlacement

TextureStackUnit

ChLegend
Bottom 

Right

ChLegendEntry
Bottom 

PivotObject

Right

ChLine
DashStyle 

Miter

ChPlotArea
BackWall 

Bottom

Floor

Right

SideWall

ChPoint
Bottom 

PivotObject

Right

ChSegment
Begin 

Divisions

End

HasAbsoluteLabels

HasAutoDivisions

HasDiscreteDivisions

ChSegmentBoundary
ValueType
ChSeries
Bottom 

FormatMap

PivotObject

Right

Thickness

TipText

ZOrder

ChSeriesCollection
PivotAxis
ChSurface
Thickness
ChTitle
Bottom 

Right

ChTrendline
Bottom 

Period

Right

ChUserDefinedSelection
id
Criteria
Application
DataSourceControl
ConnectionFile 

IsDirty

Offline

OfflinePublication

OfflineSource

OfflineType

UseXMLData

XMLDataTarget

XMLLocation

DSCEventInfo
DisplayAlert 

PercentComplete

Status

ElementExtension
Format
Filter
Application
Filters
Application
Font
Application 

ColorIndex

GroupLevel
AllowAdditions 

AllowDeletions

AllowEdits

AlternateRowColor

RecordSelector

Heading
Application
Headings
Application
Hyperlink
Application
Interior
Application 

ColorIndex

Name
Application 

RefersTo

RefersToLocal

RefersToRange

Names
Application
OCCommand
Checked 

TipText

OWCLanguageSettings
Application 

LanguageID

LanguagePreferredForEditing

Pane
Application
Panes
Application
ParameterValue
Expression
PivotAggregate
ProviderFormattedValue 

ShowAsValue

PivotAxis
View
PivotAxisMember
Axis 

ChildAxisMembers

CustomGroupType

FindAxisMember

FindMember

GroupField

IsValid

MemberProperties

ParentAxisMember

Path

SourceMember

TimeValue View

PivotCell
Data 

DetailColumnCount

DetailRowCount

DetailTopOffset

PageMember

PivotColumnMember
Axis 

ChildAxisMembers

ChildColumnMembers

CustomGroupType

DetailLeftOffset

DetailsExpanded

FindAxisMember

FindColumnMember

FindMember

GroupField

IsValid

MemberProperties

ParentAxisMember

ParentColumnMember

Path

SourceMember

TimeValue

TotalColumnMember

View

PivotData
CellsEx 

Control

CurrentCell

IsConsistent

Left2

LeftOffset

PageAxis

Top2

TopOffset

View

ViewportLeft

ViewportTop

PivotDataAxis
View
PivotDetailCell
Bookmark
PivotField
CustomGroupMembers 

ExcludedMembers

Expression

FilterContext

FilterFunctionValue

FilterOn

FilterOnScope

GroupedBackColor

GroupedFont

GroupedForeColor

GroupedHAlignment

GroupedHeight

GroupEnd

GroupStart

IncludedMembers

IsHyperlink

MemberCaptions

MemberProperties

MemberPropertiesOrder

OrderedMembers

PropertyCaptionWidth

PropertyHeight

PropertyValueWidth

SubtotalLabelBackColor

SubtotalLabelFont

SubtotalLabelForeColor

SubtotalLabelHAlignment

PivotFieldSet
AllIncludeExclude 

AllMember

AllowMultiFilter

AlwaysIncludeInCube

CompareMemberCaptionsBy

CompareOrderedMembersBy

DefaultMember

DisplayInFieldList

FilterCaption

FindMember

Member View

PivotFilterAxis
View
PivotGroupAxis
View
PivotMember
CustomGroupType 

FindMember

IsValid

Path

TimeValue

View

PivotMemberProperty
DisplayIn
PivotPageMember
Axis 

ChildAxisMembers

ChildPageMembers

CustomGroupType

FindAxisMember

FindMember

FindPageMember

GroupField

IsValid

MemberProperties

ParentAxisMember

ParentPageMember

Path

SourceMember

TimeValue

TotalPageMember

View

PivotResultAxis
Data 

SourceAxis

PivotResultColumnAxis
Data 

GroupFields

Member

SourceAxis

SourceColumnAxis

PivotResultDataAxis
Data 

SourceAxis

SourceDataAxis

PivotResultField
Axis 

SourceField

PivotResultFilterAxis
Data 

SourceAxis

SourceFilterAxis

PivotResultGroupAxis
Data 

GroupFields

Member

SourceAxis

PivotResultGroupField
Axis 

DisplayTotal

SourceField

PivotResultLabel
SourceLabel
PivotResultMemberProperty
MemberProperty
PivotResultPageAxis
Data 

GroupFields

Member

PageMember

SourceAxis

SourcePageAxis

PivotResultRowAxis
Data 

GroupFields

Member

SourceAxis

SourceRowAxis

PivotRowMember
Axis 

ChildAxisMembers

ChildRowMembers

CustomGroupType

FindAxisMember

FindMember

FindRowMember

GroupField

IsValid

MemberProperties

ParentAxisMember

ParentRowMember

Path

SourceMember

TimeValue

TotalRowHeight

TotalRowMember

View

PivotTable
ActiveObject 

AllowCustomOrdering

Commands

DataSourceName

DisplayDesignTimeUI

DisplayOfficeLogo

DisplayScreenTips

EditMode

Hwnd

IsDirty

Toolbar

UserMode

ViewOnlyMode

PivotTotal
DisplayInFieldList 

Expression

ShowAs

SolveOrder

View

PivotView
AllowAdditions 

AllowDeletions

AllowEdits

Control

DisplayCalculatedMembers

ExpandDetails

ExpandMembers

FilterCrossJoins

HeaderBackColor

HeaderFont

HeaderForeColor

HeaderHAlignment

HeaderHeight

PageAxis

PropertyCaptionFont

PropertyCaptionHAlignment

PropertyValueFont

PropertyValueHAlignment

Protection
AllowFormattingColumns 

AllowFormattingRows

AllowHeadingRename

Application

Range
Application 

CurrentArray

End

FormulaArray

HasArray

HorizontalAlignment

MergeCells

Next

Offset

PrefixCharacter

Previous

ReadingOrder

UseStandardHeight

UseStandardWidth

Value2

VerticalAlignment

Worksheet

SchemaField
IsHyperlink 
SchemaParameter
IsHyperlink 
Sheets
Application
Spreadsheet
ActiveWindow 

ActiveWorkbook

Application

Build

Calculation

CalculationVersion

Commands

DesignMode

DisplayColumnHeadings

DisplayDesignTimeUI

DisplayOfficeLogo

DisplayRowHeadings

DisplayWorkbookTabs

International

LanguageSettings

Names

Sheets

Toolbar

ViewOnlyMode

Windows

Workbooks

Worksheets

XMLURL

TitleBar
Application
Window
Application 

ColumnHeadings

DisplayColumnHeadings

DisplayCustomHeadings

DisplayHeadings

DisplayRowHeadings

DisplayWorkbookTabs

DisplayZeros

EnableResize

GridlineColor

GridlineColorIndex

RangeSelection

RowHeadings

ScrollColumn

ScrollRow

SelectedSheets

TabRatio

UsableHeight

UsableWidth

WindowNumber

Windows
Application
Workbook
Application 

CalculationVersion

Colors

Names

ProtectStructure

Sheets

Windows

Worksheets

Workbooks
Application
Worksheet
Application 

IsDataBound

Names

Next

Previous

ProtectContents

ProtectionMode

StandardHeight

StandardWidth

Worksheets
Application