Programming MS Office 2000 Web Components Chapter 2 Section 2

Chapter 2 Section 2 advanced functions of workbook Components

We have discussed most of the basic functions of the workbook component. Now let's turn to some advanced functions. Most of these advanced features are not included in Excel2000, because these are the special features specifically required by components. The functions in Excel2000 are also enhanced in the workbook component to provide some new functions.

Property binding and real-time data
"Property binding" is one of the most novel new functions of the workbook component. It refers to the ability of the control to use the attributes and methods of other objects on the same web page as unit values or formula parameters. The workbook control uses the standard COM mechanism to bind to a property. When the data source object notifies that the property value has changed, it automatically receives the new value and recalculates the associated unit.

For example, if you develop a component that exposes some attributes and methods to return the final sales price of a given stock code, you can use the workbook control to view this information, and observe its changes when the price is updated. If the other part of the workbook