Export to Excel in Chart Previewer not working

TeeChart VCL for Borland/CodeGear/Embarcadero RAD Studio, Delphi and C++ Builder.
Post Reply
OSNick
Newbie
Newbie
Posts: 23
Joined: Thu Apr 21, 2016 12:00 am

Export to Excel in Chart Previewer not working

Post by OSNick » Tue Aug 23, 2016 4:27 pm

Hi
I'm using D2007 with TeeChart Pro v2016.18 .160504 32bit VCL. Running on Windows 10. Office 2016 32 bit.
I'm trying to use the Chart Previewer to export to Excel but in the IDE I get an Interface Error. If I run the exe outside of the IDE it says the spreadsheet is corrupted. The other exports seem to work OK. Is there a fix for this?
Secondary question: Is it possible to resize the Chart Previewer form when it is shown. The size looks too small - buttons are hidden.
Thanks
Attachments
SmallDashBoardEditor.JPG
SmallDashBoardEditor.JPG (60.8 KiB) Viewed 22200 times

Yeray
Site Admin
Site Admin
Posts: 9614
Joined: Tue Dec 05, 2006 12:00 am
Location: Girona, Catalonia
Contact:

Re: Export to Excel in Chart Previewer not working

Post by Yeray » Wed Aug 24, 2016 10:34 am

Hello,
OSNick wrote:I'm trying to use the Chart Previewer to export to Excel but in the IDE I get an Interface Error. If I run the exe outside of the IDE it says the spreadsheet is corrupted. The other exports seem to work OK. Is there a fix for this?
It sounds similar to the bug reported here:
http://www.teechart.net/support/viewtop ... =3&t=15683
OSNick wrote: Is it possible to resize the Chart Previewer form when it is shown. The size looks too small - buttons are hidden.
I can resize the dialog dragging its bottom-right corner, can't you?
Best Regards,
ImageYeray Alonso
Development & Support
Steema Software
Av. Montilivi 33, 17003 Girona, Catalonia (SP)
Image Image Image Image Image Image Please read our Bug Fixing Policy

OSNick
Newbie
Newbie
Posts: 23
Joined: Thu Apr 21, 2016 12:00 am

Re: Export to Excel in Chart Previewer not working

Post by OSNick » Wed Aug 24, 2016 10:58 am

Yes, sounds the same bug. Exporting to Excel is an important feature for our users. Is there an update on when it might get fixed please?

Yes, I can resize the window, but I would like to show it to a size where all the controls are visible.

Yeray
Site Admin
Site Admin
Posts: 9614
Joined: Tue Dec 05, 2006 12:00 am
Location: Girona, Catalonia
Contact:

Re: Export to Excel in Chart Previewer not working

Post by Yeray » Thu Aug 25, 2016 7:51 am

Hello.
OSNick wrote:Yes, sounds the same bug. Exporting to Excel is an important feature for our users. Is there an update on when it might get fixed please?
Feel free to add your mail to the CC list of the public ticket to get an automatic notification when an update arrives.
http://bugs.teechart.net/show_bug.cgi?id=1257
OSNick wrote:Yes, I can resize the window, but I would like to show it to a size where all the controls are visible.
Please check if this option is set:
- Right click on a TChart at design time and select "Options...".
- Go to the "Chart Editor" tab and select "Remember Size" checkbox.
Best Regards,
ImageYeray Alonso
Development & Support
Steema Software
Av. Montilivi 33, 17003 Girona, Catalonia (SP)
Image Image Image Image Image Image Please read our Bug Fixing Policy

OSNick
Newbie
Newbie
Posts: 23
Joined: Thu Apr 21, 2016 12:00 am

Re: Export to Excel in Chart Previewer not working

Post by OSNick » Thu Aug 25, 2016 8:15 am

Thanks for the reply. That works for the TChart editor, but on the TDashboard when I call Dashboard1.Showeditor (from a buttonclick), it does not remember it's size and always displays quite small. Is there another way I should be invoking the editor on a TDashboard?

OSNick
Newbie
Newbie
Posts: 23
Joined: Thu Apr 21, 2016 12:00 am

Re: Export to Excel in Chart Previewer not working

Post by OSNick » Thu Aug 25, 2016 3:23 pm

Actually forget about the TDashboard editor, we have decided to allow users to edit the underlying charts and save the chartsettings (stream) to the database.

The more pressing issue is the title of this post - cannot export to Excel. (Windows 10, Office 2016).

Marc
Site Admin
Site Admin
Posts: 1272
Joined: Thu Oct 16, 2003 4:00 am
Location: Girona
Contact:

Re: Export to Excel in Chart Previewer not working

Post by Marc » Fri Aug 26, 2016 2:37 pm

Hello,

Yes I see there is a long-standing bug report on Excel export: http://bugs.teechart.net/show_bug.cgi?id=1257.

We'll review the issue and get back with an update.

Regards,
Marc Meumann
Steema Support

Post Reply