View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0011062mantisbtcsvpublic2009-10-21 07:422010-04-23 23:22
Reporterxyz123 Assigned Tovboctor  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
Product Version1.2.0rc2 
Summary0011062: Cannot export to Excel
Description

The Excel export doesn't work.

Excel can't open the downloaded file. Message: "The file cannot be opened because or errors"

Tested on both Excel 2003 and 2007. The test was done against View Issues of www.mantisbt.org.

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
duplicate of 0011016 closedvboctor Excel Export broken 

Activities

atrol

atrol

2009-10-21 10:00

developer   ~0023269

this is acknowledged at
http://www.mantisbt.org/bugs/view.php?id=11016
where I provided further details for the developers
watergad

watergad

2009-10-21 15:18

reporter   ~0023271

xyz123: Did you add "due_date" field to the "view issues" columns?
What is the end of the xml created? (export to excel - right click - save as - view binary contents with notepad.exe or smth like FAR file manager)
xyz123

xyz123

2009-10-21 22:10

reporter   ~0023273

No, I did not have due_date.

The download output is just the html header.

<?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="mantisbt">
<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">Date Submitted</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">