Page 1 of 1
Invalid file when exporting to Excel/OpenDocument
Posted: Tue Aug 04, 2015 1:52 pm
by 16556067
Hello,
I'm using TeeChart Pro v2015.15.150420 and files exported as Excel or OpenDocument cannot be opened with Excel 2013 (15.0.4737.1003).
I always get a "We found a problem with some content in...". I can provide an invalid file if it helps.
Re: Invalid file when exporting to Excel/OpenDocument
Posted: Tue Aug 04, 2015 2:03 pm
by narcis
Hello Ael,
This is a bug we found some days ago (
Bug #1257). I have increased its priority and we will try to fix it for upcoming releases.
Re: Invalid file when exporting to Excel/OpenDocument
Posted: Tue Aug 04, 2015 2:23 pm
by 16556067
Thank you, I'll add some details directly in bugzilla then.
Re: Invalid file when exporting to Excel/OpenDocument
Posted: Tue Aug 04, 2015 2:24 pm
by narcis
Ael wrote:Thank you, I'll add some details directly in bugzilla then.
Excellent, thanks for your collaboration.
Re: Invalid file when exporting to Excel/OpenDocument
Posted: Tue Aug 04, 2015 2:43 pm
by 16556067
Also, I'm not sure if you want to open another bug or if you're already aware of this one :
If I export a file to a read-only file TeeChart used to generate an exception. This seems fixed now, however there is still an exception if the file is already open.
- Create an ODS or Excel file
- Open it in Excel
- Export a chart and try to overwrite this file
An exception in TTeeExportData.SaveToFile->TFileStream.Create is generated.
Re: Invalid file when exporting to Excel/OpenDocument
Posted: Tue Aug 04, 2015 2:57 pm
by narcis
Hello,
I'm not able to reproduce it working the mangled .xls file generated reproducing the bug mentioned above with Excel 2013. Should this show the problem?
Re: Invalid file when exporting to Excel/OpenDocument
Posted: Wed Mar 23, 2016 3:33 pm
by 16555944
Hello
I habe the same error (see title), when i export ma data to Excel.
Follow the Code:
Code: Select all
// Create dummy chart without inactive series
tmpChart := TChart.Create(Self);
FOR i := Chart1.SeriesCount - 1 DOWNTO 0 DO
IF Chart1[i].Active THEN
CloneChartSeries(Chart1.Series[i]).ParentChart := tmpChart;
{ nil = all series in Chart1 }
WITH TSeriesDataXLS.Create(tmpChart, NIL) DO
TRY
IncludeIndex := True;
IncludeHeader := True;
FN:=ExtractFilepath(SaveDialog.FileName) + ChangeFileExt(ExtractFilename(SaveDialog.FileName),'') + '_Analogwerte.xls';
SaveToFile(FN);
FINALLY
Free;
END;
tmpChart.Free;
I use teechart version 2015.16.150901 and i try to open the file with MS Office 2016. When i open the file with OpenOffice 4.1.4 or MS Office 2010 i can open it.
May somebody can help me!
Best Regards
Gregor
Re: Invalid file when exporting to Excel/OpenDocument
Posted: Thu Mar 24, 2016 3:09 pm
by yeray
Hello Gregor,
Indeed, I'm afraid the ticket
#1257 hasn't been closed yet.
Feel free to add your mail to the CC list to be automatically notified when an update arrives.