Workaround for issue with Spreadsheet Import builder and jakarta-poi libraries

Technote (troubleshooting)


Problem

The Spreadsheet Import builder is attempting to interpret the data as date values instead of numeric values when a WEF application is deployed as a portlet.

Symptom

WEF includes poi 2.5.1, and portal includes an older version of poi. The portal version HSSFDateUtil.isCellDateFormatted method returns true incorrectly for a number of cell format strings which it shouldn't. (formats 164-173) This causes the spreadsheet data to be incorrectly interpreted as date values.


Resolving the problem

You can resolve this issue by forcing WEF exported portlet .war files to include the 2.5.1 version of jakarta-poi.jar.
The exclude line in portlet7.0.excludes should be removed to allow jakarta-poi.jar to be included in our .war files.

Find this files here:

<workspace>/<project_name>/.deployment/excludes/portletwar7.0.excludes

This is a simple text file which you can edit it in Eclipse or any text editor. You will need to remove the following line from the file:

WEB-INF/lib/jakarta-poi.jar

Then save the excludes file and perform an Export->Web Experience Factory Portlet WAR action to generate a new .war file that contains the jakarta-poi.jar library.

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Dashboard Framework
Framework Builders

Software version:

7.0.1

Operating system(s):

Linux, Windows

Reference #:

1600453

Modified date:

2012-07-12

Translate my page

Machine Translation

Content navigation