 | Steema Issues DatabaseNote: This database is for bugs and wishes only. For technical support help, if you are a customer please visit our online forums;otherwise you can use StackOverflow. Before using this bug-tracker we recommend a look at this document, Steema Bug Fixing Policy. |
Bug 1186
| Summary: | Data exporting in Excel exports as HTML file | ||
|---|---|---|---|
| Product: | .NET TeeChart | Reporter: | amoisii |
| Component: | Exporting | Assignee: | Steema Issue Manager <issuemanager> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | critical | CC: | chris, sandra |
| Priority: | High | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows | ||
| Chart Series: | --- | Delphi / C++ Builder RAD IDE Version: | |
| Attachments: |
screen capture movie showing the export
xls and htm exported files |
||
The problem isn't reproduced using latest TeeChart.Net maintenance release, build number 4.1.2015.03114. Thanks in advance, regards Thanks a client clarification; finally, I can reproduce the problem. The same problem occurs in TeeChartJava version. Here's the bug link: http://bugs.teechart.net/buglist.cgi?quicksearch=excel&list_id=5192 This issue is caused by "Extension hardening", first introduced into Excel 2007 [ http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/03/11/excel-2007-extension-warning.aspx ]: "The alert is a new security feature in Excel 2007 called Extension Hardening, which ensures that the file content being opened matches the extension type specified in the shell command that is attempting to open the file. Because the MIME types listed above are associated with the .XLS extension, the file must be in XLS (BIFF8) file format to open without this warning prompt. If the file type is a different format (such as HTML, XML, CSV, etc.) the prompt is expected since the file content is different that the extension or MIME type. The alert is first seen when opening the file from a URL site directly. If you cancel the alert, the open will fail, but then IE will attempt to download the file and open again using a different shell command. Depending on what the file contents is and what extension IE gives the file it downloads, you may see the second open attempt succeed, or you may see the prompt again but with a different filename in the alert dialog. The alert prompt is "by design", but the interaction of the cancel action and IE's attempt to open the file again is a known problem under investigation for a future fix. Probably I didn't made myself clear, so I will try again:attached is a screenshot showing the xls file created by TeeChart when choosing "Excel export" and the htm file created by TeeChart when choosing "HTML export". My point (and the obvious TeeChart bug) is that the so called Excel exported file is actually a html file, with xls extension. The problem is not the warning threw by Excel when opening the file, but the file format, which is not Excel! Created attachment 437 [details]
xls and htm exported files
|
Created attachment 423 [details] screen capture movie showing the export Using TeeChart Pro for .NET version 4.1.2014.5094, if we select data exporting in Excel format and click Save, the data is saved in HTML format.