# Microsoft Office Excel 2003 Readme File

Microsoft Office Excel 2003 Readme File

### © 2003 Microsoft Corporation. All rights reserved.

This document provides late-breaking information about Microsoft Office Excel 2003.

### How to use this document

To view the Readme file on the screen, maximize the browser window. To print the Readme file, click the Print button on the toolbar.

## Contents

### Working with Microsoft Office Excel 2003

Installing Office XP Web Components

Data type display differences between Microsoft Windows SharePoint Services 2.0 and Office Excel 2003

Saving a worksheet as a Web Page with interactivity does not save XML mapping and XML lists

Microsoft XML Core Services (MSXML) Version 3.0 no longer supported

Functionality changed in Office Excel 2003 to facilitate lists

### General issues

Problems with currency in Office Excel 2003 linked lists

Problems handling events when using Microsoft Office 2003 Web Components on Windows Forms

Certain XPath expressions produce exported XML that is not well-formed

AutoFilter does not work properly when one or more cells in a range are mapped to nonrepeating elements

Installing Office XP Web Components after installing Microsoft Office 2003 disables the Microsoft Office 2003 Web Components .NET Programmability Support

Behavior change when importing an Office Database Connection (.odc) file with a saved user name and password into the Spreadsheet Web Component

## Working with Microsoft Office Excel 2003

### Installing Office XP Web Components

Microsoft Office Professional Edition 2003 includes Windows Installer Package files for both Office 2003 Web Components (Owc11.msi) and an upgraded version of Office XP Web Components (Owc10.msi). Both .msi files are located on the installation CD, and both versions are included in Microsoft Office 2003 Setup (although they are not exposed to end users as options in the Microsoft Office 2003 Setup user interface). Office 2003 Web Components are installed by default; however, the upgraded Office XP Web Components are installed only if a previous version of Office XP Web Components exists on the user's computer.

If you want to install the upgraded Office XP Components manually on a computer that does not have a previous version of Office XP Web Components, you can run Owc10.msi directly from the setup CD.

If you use solutions that rely on Office XP Web Components, you are deploying to new clients (that is, not upgrading), and you want to perform a customized setup, you can ensure that the upgraded Office XP Web Components are included in the Office 2003 installation by setting the OWC10EXISTS property either on the command line when running Setup.exe or in the Setup settings file (Setup.ini).

Example:

    OWC10EXISTS=1

### Data type display differences between Microsoft Windows SharePoint Services 2.0 and Office Excel 2003

The displayed precision of numbers may sometimes be different in Windows SharePoint Services and Office Excel 2003. This only affects records that have been changed in Office Excel 2003. Although there may be differences in the way numbers are displayed, the precision of the underlying values will be the same in Windows SharePoint Services and Office Excel 2003, except for numbers greater than 15 digits in SharePoint lists. These numbers lose precision in Office Excel 2003.

### Saving a worksheet as a Web page with interactivity does not save XML mapping and XML lists

If you save an Excel worksheet that contains an XML map or XML list as a Web Page (*.htm; *.html) or as a Single File Web Page (*.mht; *.mhtml), select Add interactivity, and set the Selection: Sheet option, which saves only the current worksheet, the XML map or XML list will not be saved with the Web page.

To save the XML map or XML list with the interactive Web page, you must save the entire workbook by selecting the Entire Workbook option. This is because the XML map information on which XML lists depend is stored as part of the workbook and may be shared across multiple worksheets.

### Microsoft XML Core Services (MSXML) Version 3.0 no longer supported

Office Excel 2003 only uses Microsoft XML Core Services (MSXML) Version 5.0 to work with XML. To improve security, Excel no longer supports applying XSL style sheets when opening XML files that use the old XSL Namespaces to transform XML data by using MSXML Version 3.0. For example, you might have previously used this feature to load XML data as HTML or transform the XML into XML Spreadsheet (XMLSS). XSL transforms applied to XML files that contain a default processing instruction to transform them into HTML using the old XSL syntax and MSXML Version 3.0 will no longer work in Office Excel 2003.

### Functionality changed in Office Excel 2003 to facilitate lists

Several changes have been made to existing Excel functionality in order to facilitate list management and promote list integrity. Included are changes to navigation, range selection, and editing, as well as minor changes to other functionality to ensure that Excel lists behave with the desired functionality.

Navigation inside the list

A list in Excel can be said to behave like its own spreadsheet within the larger Excel spreadsheet. For example, pressing the END+arrow key combinations navigates in the direction specified by the arrow key to the last cell within the list boundary in that direction. Also, if you press TAB in the right-most column of a list, the cell pointer relocates to the first (left-most) cell in the next row below.

List range selection borders

As with PivotTable reports and with the spreadsheet itself, there are areas around the list border that allow you to perform structured selection, such as selecting an entire row or column within the list, or selecting the entire list itself. The area just inside the top and left list borders facilitates this functionality. When you place the mouse pointer over these areas, the shape of the pointer changes to indicate the available functionality to the user.

Moving selected ranges in a list

The Move Selection pointer appears when you rest on the edge of a selected range, or if you rest on any part of the list border. You cannot move a selection within a list in such a way that it destroys the integrity of the list. You can change the order of rows or columns, and you can move a row or column completely out of the list range; but you cannot, for example, move a row or column to where it overlaps the list border.

There are additional restrictions to data movement in lists that are linked to Windows SharePoint Services.

Editing ranges in a list

Actions taken inside a list generally act on the list itself, and not on any part of the spreadsheet within the list. When you delete a row or column from a list, only the cells in the row or column that are within the list are deleted. The exception is AutoFilter, which acts on entire rows of data in the spreadsheet.

Automatic list expansion

When you type in a cell immediately below or to the right of an unlinked list, the list automatically expands to include the new data. When the list expands, a smart tag is displayed that allows you to undo the automatic expansion or to modify the setting to disable expanding completely.

This functionality is on by default, but can be disabled: On the Tools menu, select AutoCorrect Options, and then in theAutoCorrect dialog box, on the AutoFormat As You Type tab, clear the Include new rows and columns in list check box.

List resize handle

Excel provides a direct method of resizing a list as an alternative to the menu command. You can drag a resize handle in the lower left corner of the list border to resize by columns or by rows. However, you cannot resize by both columns and rows at once.

Editing ranges outside of a list

The most important thing to consider when editing ranges outside of a list is that, in general, you cannot perform range-related functions on ranges that include cells within a list and cells outside of the list.

One notable exception to this is when you select an entire row or column of the spreadsheet (not just the list) and delete it. In that case, the row or column data that falls within the list is also deleted. This is the case only when the list is not linked to Windows SharePoint Services.

Other functionality changes

Sort options The sort options that are displayed in the list AutoFilter drop-down boxes are present in all AutoFilter drop-down boxes, whether or not the drop-down boxes are inside of a list.

Subtotal function The Subtotal function has added new arguments that facilitate subtotaling in the total row of a list. The first argument in the Subtotal function specifies what type of aggregation to use (for example, Sum, Average, etc.). In earlier versions, these arguments are numbered 1-10.

In Excel 2003, these arguments have changed, adding 100 to each number, to specify that the Subtotal function is being used inside of a list. The following table shows the aggregate function, its previous argument, and its current argument, used in the list total row.

Total row calculation is facilitated by changes to the Subtotal() function:

Aggregate function | Previous argument | List subtotal argument
Average | Subtotal(1,<range>) | Subtotal(101,<range>)
Count Nums(Count numbers) | Subtotal(2,<range>) | Subtotal(102,<range>)
Count | Subtotal(3,<range>) | Subtotal(103,<range>)
Max | Subtotal(4,<range>) | Subtotal(104,<range>)
Min | Subtotal(5,<range>) | Subtotal(105,<range>)
StDev (Standard Deviation) | Subtotal(7,<range>) | Subtotal(107,<range>)
Sum | Subtotal(9,<range>) | Subtotal(109,<range>)
Var (Variance) | Subtotal(10,<range>) | Subtotal(110,<range>)

Note These subtotal arguments are not compatible with lists in earlier versions.

## General issues

### Problems with currency in Office Excel 2003 linked lists

Publishing national currencies previous to the institution of the euro currency for the European Union (either the currency symbol or the ISO code) will result in a number data type, not currency. This is expected behavior.

Excel 2003 supports some currency symbols that are not supported by Windows SharePoint Services. Excel 2003 publishes these currencies to SharePoint sites as numbers.

Changing the currency type in a linked list will not change the currency type on the server. This is by design.

### Problems handling events when using Microsoft Office 2003 Web Components on Windows Forms

To handle events for a Microsoft Office 2003 Web Component on a .NET Windows Form, you must modify the class wrappers that Microsoft Visual Studio .NET generates for the component. You can work around this problem by using the same techniques documented for Office XP Web Components in the following Knowledge Base articles: "319341- HOW TO: Handle Events for the Office XP Spreadsheet Component on a Windows Form in Visual C# .NET" and "319342 - HOW TO: Handle Events for the Office XP Spreadsheet Component on a Windows Form in Visual Basic .NET."

### Certain XPath expressions produce exported XML that is not well-formed

You can create code using the Office Excel 2003 Object Model to map an XML element in which the XPath expression contains an attribute filter to a cell. In some cases, it's possible to create XML that is not well-formed when you export it. Avoid the following:

- Using the object model to map an attribute to a cell, in which the XPath expression does not contain a predicate expression to a cell (for example, /Root/Element@Attribute maps to cell A1), and then using the object model to map the same attribute to a different cell, in which the XPath expression does contain a predicate expression (for example, /Root/Element[@Attribute='Value'] maps to cell A2).
- Inconsistently using white space or mixing the use of double-quote (") and single-quote (') delimiters, which might lead to the same XPath expression being mapped more than once in an XML map.

### AutoFilter does not work properly when one or more cells in a range are mapped to nonrepeating elements

If you use AutoFilter on a range of data that contains one or more cells mapped to nonrepeating XML elements, the filter does not behave as expected. This can be especially confusing if the blue border that indicates which cells are mapped to nonrepeating XML elements is not visible.

### Installing Office XP Web Components after installing Microsoft Office 2003 disables the Microsoft Office 2003 Web Components .NET Programmability Support

If your computer has Microsoft .NET Framework 1.1 and Microsoft Office 2003 installed with Microsoft Office 2003 Web Components .NET Programmability Support, and you install Microsoft Office XP Web Components (by running OWC10.msi), Microsoft Office 2003 Web Components. NET Programmability Support will no longer work correctly.

Microsoft Office 2003 Web Components. NET Programmability Support installs and registers the Microsoft Office 2003 Web Components primary interop assembly (PIA), which is used to work with the Microsoft Office 2003 Web Components COM type library from managed code in Microsoft Visual Studio .NET. Installing Microsoft Office XP Web Components after installing Microsoft Office 2003 causes the PIA to be incorrectly registered.

You can confirm that the Microsoft Office 2003 Web Components PIA is installed on your computer by opening the C:\Windows\Assembly folder. You should see Microsoft.Office.Interop.Owc11.

To correct this problem, run Microsoft Office 2003 Setup again, select Add or Remove Features, and then click Next. Select Choose advanced customization of applications, and then click Next. Expand Office Shared Features, expand Office 2003 Web Components, click .NET Programmability Support, select Run from my Computer, and then click Update.

### Behavior change when importing an Office Database Connection (.odc) file with a saved user name and password into the Spreadsheet Web Component

The Spreadsheet Web Component in Microsoft Office 2002 Web Components allowed you to import an Office Database Connection (.odc) file with a saved user name and password without selecting the Save password in file check box on the last page of the Import Wizard. However, the Spreadsheet Web Component in Microsoft Office 2003 Web Components now requires selecting the Save password in file check box in the Import Wizard and will display an authentication error if you do not. In either case, saving security credentials in an Office Database Connection (.odc) file is not secure. Microsoft recommends using Windows authentication.