In addition, authors can specify a pool of fields for analysis by designating a record source for a PivotTable control on a Web page. Web page authors can empower users to build and analyze data with PivotTables by adding the PivotTable control to their Web pages. In addition, users can readily filter data for individual row and column category variables, as well as a third category of page variables. Web page users can rearrange row and column categories for aggregating data. The user interface for a PivotTable component enables a user to create cross-tab-style reports on a Web page dynamically. PivotTable reports are decision-support tools for aggregating and filtering data. You can display charts in 2-D and 3-D formats on your Web pages with the Chart component.
#Microsoft office xp update#
The ability to link charts to other Web components makes it possible to update charts automatically as the contents of these other components change. Users can change the data for a chart and get an instant update of the chart on your Web pages. The Chart component can operate independently to chart data typed directly into it or in coordination with other Web components. By tapping the recalculation engine, you can create custom calculators that perform all kinds of functions, such as those for net present value and various interest rates and payments. This capability makes it easy to import data into one page and then display it in another. The Spreadsheet component in Office XP Web Components supports multiple worksheets.
#Microsoft office xp how to#
Anyone who knows how to work a spreadsheet will feel right at home on your Web pages because the Spreadsheet component gives them the look and feel of a worksheet. Second, it provides a user interface similar to Excel’s. First, it includes a recalculation engine based on the one that ships with Excel 2002. The Spreadsheet component provides two main features. Each component also has an object model that enables developers to program the Web components for custom dynamic and interactive behavior. Web authors can insert these controls on a Web page and graphically manipulate them to display interactive spreadsheets, charts, PivotTable reports, and data-bound forms and reports. Each component has an ActiveX control that supports its functionality. Office XP ships with four Web components. You will also learn about the requirements for building solutions with Office XP Web Components. Separate sections drill down on each of the four Office XP Web Components to give you a feel for their capabilities. You will learn the kinds of tasks the Web components perform. Those of you already using Office 2000 Web Components will gain valuable information that will help you decide whether and how to upgrade. If you passed on adopting Web components with Office 2000, you have new and improved reasons for learning about them with Office XP.
#Microsoft office xp series#
This first Daily Drill Down in a five-part series provides an overview of Office XP Web Components. Happily, you can use Office XP Web Components on computers running Office 2000 (and, of course, Office XP). The new components, however, are incompatible with their predecessors. The Web components in Office XP offer enhancements over those available in Office 2000.
Some readers may recall Office Web Components from Office 2000. The Office XP Web Components, which ship as part of Office XP, provide functionality similar to traditional Office components, except that they work on Web pages. In this first Daily Drill Down of his five-part series, Rick Dobson gives an overview of Office XP Web Components, which provide the nuts and bolts of Web page authoring. Office XP offers more than just a pretty new GUI.
0 kommentar(er)
