Steema Issues Database

Note: 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 - Data exporting in Excel exports as HTML file
Summary: Data exporting in Excel exports as HTML file
Status: RESOLVED NOTABUG
Alias: None
Product: .NET TeeChart
Classification: Unclassified
Component: Exporting (show other bugs)
Version: unspecified
Hardware: PC Windows
: High critical
Target Milestone: ---
Assignee: Steema Issue Manager
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-02 02:57 EDT by amoisii
Modified: 2015-04-29 14:27 EDT (History)
2 users (show)

See Also:
Chart Series: ---
Delphi / C++ Builder RAD IDE Version:

Attachments
screen capture movie showing the export (1.89 MB, video/mp4)
2015-04-02 02:57 EDT, amoisii 		Details
xls and htm exported files (786.33 KB, image/png)
2015-04-29 14:27 EDT, amoisii 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description amoisii 2015-04-02 02:57:06 EDT 
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.
Comment 1 sandra pazos 2015-04-13 11:13:13 EDT 
The problem isn't reproduced using latest TeeChart.Net maintenance release, build number 4.1.2015.03114. 

Thanks in advance,
regards
Comment 2 sandra pazos 2015-04-15 11:25:42 EDT 
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
Comment 3 christopher ireland 2015-04-29 08:33:34 EDT 
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.
Comment 4 amoisii 2015-04-29 14:25:07 EDT 
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!
Comment 5 amoisii 2015-04-29 14:27:56 EDT 
Created attachment 437 [details]
xls and htm exported files