|
|
This chapter includes the following topics:
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.
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.
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.
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)").
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.
Re-run the installer for Microsoft Excel on the Remote Server.
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.
Update set of gateway URLs in gadget registration to include:
gadget/
images/
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.
Remove and reinstall the ISAPI filter in Microsoft IIS on the Remote Server.
|