# User Guide

# Troubleshooting and Limitations

This chapter includes the following topics:

- Hyperlinks
- Special Phone Number and Time Cell Properties
- Non-US Currency Formats
- Installation of Excel Components
- Chart Images Do Not Display Properly

## Hyperlinks

Excel portlets will not detect a hyperlink that is not active within the source Excel file. You must create an active hyperlink (URL) in the source file if one should be displayed within the portlet.

## Special Phone Number and Time Cell Properties

Excel portlets do not properly display data stored in Excel files using the Special Phone Number format or the Time format. Excel portlets convert data stored using the Special - Phone Number and Time cell properties to a number.

- To properly display telephone numbers in Excel portlets, store phone numbers in the Microsoft Excel file using the Text cell property.
- To display time formatted data in Excel portlets, BEA recommends using an Excel Date cell property in the date-time format.

## Non-US Currency Formats

Non-US currency formats that do not include a locale qualifier are not properly displayed in Excel portlets.

Microsoft Excel uses two types of symbols in the currency cell format property. In the Symbol list on the "Format Cell" dialog box, there are entries that include only the currency symbol, "$" (machine locale is US English), in addition to "$ English" (United States). Similarly, when the machine locale is Korean, multiple currency symbol options are listed including: "W" (won sign) and "W Korean". If the option "W" is chosen and not "W Korean", the Korean currency format will be converted to a number when displayed in the Excel portlet. This issue occurs in all non-US locale for currency formats.

### Workaround

For non-US locales, choose the currency format in the Excel file that displays the locale next to the respective currency symbol (e.g., "W (Korean)", "C Spanish (Costa Rica)").

## Installation of Excel Components

If a Method '~' of object '~' failed message is displayed when access the Excel Portlet Framework, it is an indication that not all Excel components were installed correctly on the Remote Server.

### Workaround

Re-run the installer for Microsoft Excel on the Remote Server.

## Chart Images Do Not Display Properly

### Scenario 1

If the message, "You do not have permission to view this content" is displayed in place of the chart image, it is an indication that the set of gateway URLs specified in the portlet registration is incomplete.

### Workaround

Update set of gateway URLs in gadget registration to include:

    gadget/

    images/

### Scenario 2

If a red X is displayed in place of the chart image, it is an indication that the ISAPI filter is not properly installed in Microsoft Internet Information Server (IIS) on the Remote Server.

### Workaround

Remove and reinstall the ISAPI filter in Microsoft IIS on the Remote Server.