New and Improved 3.13 Beta. Highlights: Shareable filters and dashboards and lots of other goodies. Any feedback can be raised as JIRA issues in the JIRA project.
Issue Details (XML | Word | Printable)

Key: JRA-3956
Type: Bug Bug
Status: Resolved Resolved
Resolution: Won't Fix
Priority: Major Major
Assignee: Unassigned
Reporter: Keith Brophy
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
JIRA

I18N characters displayed incorrectly in Excel view with Weblogic 8.1

Created: 21/Jun/04 07:18 PM   Updated: 23/Oct/06 03:43 AM
Component/s: Internationalisation
Affects Version/s: 3.0 Pro Preview
Fix Version/s: 3.7

Time Tracking:
Not Specified

File Attachments: 1. Text File wloutput.log (130 kB)
2. Text File wloutput2.log (130 kB)
3. Text File wloutputexcel.log (44 kB)
4. Text File wloutputexcel2.log (44 kB)

Environment:
Weblogic 8.1
IE 6
Firefox 0.8
MS Excel
Issue Links:
Reference
 

Participants: Daniel Hurst, Dylan Etkin [Atlassian], Keith Brophy and Scott Farquhar [Atlassian]
Since last comment: 2 years, 2 weeks, 4 days ago
Resolution Date: 23/Oct/06 03:43 AM
Labels:


 Description  « Hide
I18N characters are not displayed correctly in excel view running on Weblogic 8.1. The chracters are replaced with 'question marks'.

JIRA standalone (Tomcat 4) produces an excel view with these characters displayed correctly - so the encoding is correctly set.

Weblogic incorrectly handles the encoding as set on the page for content of type 'application/vnd.ms-excel'.

The attached files indicate the issue - issue 'TP-999' contains Chinese characters that are displayed/encoded correctly when viewed as 'text/html'. The excel files are not encoded correctly showing these characters as question marks.



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Dylan Etkin [Atlassian] added a comment - 23/May/05 08:57 PM
This is a bug with the way that weblogic handles its encodings. If you add this:

<weblogic-web-app>
<jsp-descriptor>
<jsp-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</jsp-param>
<jsp-param>
<param-name>compilerSupportsEncoding</param-name>
<param-value>false</param-value>
</jsp-param>
</jsp-descriptor>
</weblogic-web-app>

to your weblogic.xml file then it behaves better but this issues problem still exists, you seen characters instead of ?? but the characters are not correct. The line in excelheader.jsp:
response.setContentType("application/vnd.ms-excel;charset=" + ManagerFactory.getApplicationProperties().getEncoding());

seems to mess up the encoding, if we leave that line out and save the file and manually choose the correct encoding then the characters come out fine. But we can't leave out that line since it tells the browser to open the file in excel and for most applications servers that the encoding should be that of the application.


Scott Farquhar [Atlassian] added a comment - 05/Jul/06 10:36 AM
I'm not sure what to do about this one. I'm tempted to mark as "won't fix".

Any objections?


Scott Farquhar [Atlassian] added a comment - 21/Jul/06 01:07 AM
We need to create a functional test to verify this, and then resolve this issue, regardless of whether we can fix it in weblogic.

Daniel Hurst added a comment - 02/Aug/06 09:34 PM
Scott,

I tested the ĦĘĹĹŐ string in Excel view in Linux and Windows (in Tomcat). Windows worked properly but Linux displayed ĦĘĹĹŐ instead of internationalised hello.

Will create to create these tests for a variety of languages and see if any work.

I assume these characters should be escaped?