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

SetDataLabels issue

 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: SetDataLabels issue
    Posted: 02 May 2019 at 11:00am
Dear .TMS software team,

can you help me to set the data labels for the chart properly (runtime)?

Unfortunately i did not found some working example. 


            FlexCel.Core.ExcelChart chart1 = xls.FXLS.GetChart(1, String.Empty);
            FlexCel.Core.TDataLabel[] label1 = chart1.GetDataLabels();

For example, I want to change the label to the text "100" or "Test" or some excel formula.
What should i write here?

??????
??????
??????

            chart1.SetDataLabels(label1);
            xls.FXLS.Save("c:\\Temp\\report_2.xls", TFileFormats.Automatic);
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: 02 May 2019 at 11:12am
Here is an example what we need.


Back to Top
Adrian Gallero View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 1223
Post Options Post Options   Quote Adrian Gallero Quote  Post ReplyReply Direct Link To This Post Posted: 03 May 2019 at 7:34am
Hi,
Sorry, but this isn't currently possible. SetDataLabels will change the labels on the chart object, but there is no way currently to update the XlsFile with the changed chart object. (There should be a "SetChart" methods besides a "GetChart" method for this to work).

The reason for this method missing is that when we were about to add an API to add charts and modify charts, Excel introduced xlsx and all our focus changed to that.

Right now as xlsx support is basically complete, we are working in FlexCel 7 which introduces chart rendering, and it will have the ability to create charts from scratch and modify them as you wish. But this FexCel 7 release is being a huge amount of work, much more than anything expected, and we aren't yet in a position to tell you an estimated date for it. In fact, as FlexCel 7 is already very delayed, it is looking more and more likely that we will release it when xlsx chart rendering is ready, and delay the API for writing charts to 7.1 (so people who only cares about xlsx chart rendering doesn't have to wait until we finish the chart API, APIMate, etc)
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down