Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

xls tempalte saved as XLSM lost the charts

 Post Reply Post Reply
Author
Christian Hungbaur View Drop Down
New Member
New Member
Avatar

Joined: 11 Nov 2014
Posts: 29
Post Options Post Options   Quote Christian Hungbaur Quote  Post ReplyReply Direct Link To This Post Topic: xls tempalte saved as XLSM lost the charts
    Posted: 01 Nov 2018 at 12:39pm
Dear FlexCel team,

we need your help.

Our customer claimed that a template (was created as xls file with macros) loses the charts if it was saved as XLSM file at runtime.

we use this method:

FlexCel.Core

public void Save(Stream aStream, TFileFormats fileFormat);

with 
TFileFormats.Xlsm (Xlsm = 5)

Our FlexCel version is
FlexCel, Version=6.18.5.0
Back to Top
Adrian Gallero View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 1226
Post Options Post Options   Quote Adrian Gallero Quote  Post ReplyReply Direct Link To This Post Posted: 01 Nov 2018 at 1:03pm
Hi,
Sadly indeed charts are not converted when converted a xls file to xlsx/m. While we are working in a big overhaul of charts right now which will include rendering xlsx charts and adding them with code, chart conversion between xls and xlsx is still outside our scope.

The only solution here is to provide 2 templates: One in xls and the other in xlsm. When the user wants to save as xlsm you use the xlsm template, and if the user wants to save as xls, you use the xls template.
Back to Top
Christian Hungbaur View Drop Down
New Member
New Member
Avatar

Joined: 11 Nov 2014
Posts: 29
Post Options Post Options   Quote Christian Hungbaur Quote  Post ReplyReply Direct Link To This Post Posted: 01 Nov 2018 at 2:36pm
Ok, we will do it (2 templates).
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down