View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0008972mantisbtlocalizationpublic2008-03-14 11:072009-06-23 15:28
Reporterbandrack Assigned Tosiebrand  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformAMD Athlon XP 1500+OSWinXP ProOS Version2002 SP2
Product Versiongit trunk 
Fixed in Version1.2.0rc1 
Summary0008972: Excel Export via XML utf-8 problem
Description

When I use the "Excel Export" link the generated xml-file does not include all characters in a proper way.

see attachments (see the field "summary")

TagsNo tags attached.
Attached Files
viewing issues.gif (8,309 bytes)   
viewing issues.gif (8,309 bytes)   
subpro3-1.xml (2,580 bytes)    
<?xml version="1.0" encoding="UTF-8"?><?mso-application progid="Excel.Sheet"?>
 <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
<Worksheet ss:Name="subpro3-1">
<Table>
<Column ss:Index="1" ss:AutoFitWidth="0" ss:Width="110"/>
<Row><Cell><Data ss:Type="String">ID</Data></Cell><Cell><Data ss:Type="String">Project</Data></Cell><Cell><Data ss:Type="String">Reporter</Data></Cell><Cell><Data ss:Type="String">Assigned To</Data></Cell><Cell><Data ss:Type="String">Priority</Data></Cell><Cell><Data ss:Type="String">Severity</Data></Cell><Cell><Data ss:Type="String">Reproducibility</Data></Cell><Cell><Data ss:Type="String">Product Version</Data></Cell><Cell><Data ss:Type="String">Projection</Data></Cell><Cell><Data ss:Type="String">Category</Data></Cell><Cell><Data ss:Type="String">Date Submitted</Data></Cell><Cell><Data ss:Type="String">ETA</Data></Cell><Cell><Data ss:Type="String">OS</Data></Cell><Cell><Data ss:Type="String">OS Version</Data></Cell><Cell><Data ss:Type="String">Platform</Data></Cell><Cell><Data ss:Type="String">View Status</Data></Cell><Cell><Data ss:Type="String">Updated</Data></Cell><Cell><Data ss:Type="String">Summary</Data></Cell><Cell><Data ss:Type="String">Status</Data></Cell><Cell><Data ss:Type="String">Resolution</Data></Cell><Cell><Data ss:Type="String">Fixed in Version</Data></Cell></Row><Row><Cell><Data ss:Type="Number">0000004</Data></Cell>
<Cell><Data ss:Type="String">subpro3-1</Data></Cell>
<Cell><Data ss:Type="String">ba</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">normal</Data></Cell>
<Cell><Data ss:Type="String">feature</Data></Cell>
<Cell><Data ss:Type="String">always</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">none</Data></Cell>
<Cell><Data ss:Type="String">General</Data></Cell>
<Cell><Data ss:Type="String">2008-03-14</Data></Cell>
<Cell><Data ss:Type="String">none</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">public</Data></Cell>
<Cell><Data ss:Type="String">2008-03-14</Data></Cell>
<Cell><Data ss:Type="String">übermütige Änderung</Data></Cell>
<Cell><Data ss:Type="String">new</Data></Cell>
<Cell><Data ss:Type="String">open</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
</Row></Table>
</Worksheet></Workbook>
subpro3-1.xml (2,580 bytes)   

Activities

seiji

seiji

2008-09-15 08:40

reporter   ~0019399

Last edited: 2008-09-15 11:24

I have same problem.

core/excel_api.php 131L

$t_ret .= utf8_encode( $t_value );

utf_encode() broke non-ascii strings. It should be used only for iso-8859-1.
karotos

karotos

2008-10-23 13:10

reporter   ~0019662

same here with Greek characters. I have UTF-8 charset in mysql and the export in excel xml file scrambles all Greek text.
siebrand

siebrand

2009-03-30 19:13

developer   ~0021316

Fixed in git trunk.