Invalid file when exporting to Excel/OpenDocument

[Ael]

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.

[Narcís]

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.

[Ael]

Thank you, I'll add some details directly in bugzilla then.

[Narcís]

Thank you, I'll add some details directly in bugzilla then.

Excellent, thanks for your collaboration.

[Ael]

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.

[Narcís]

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?

[viper]

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

[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.