Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Fri Sep 09, 2016 7:47 pm

I have a pie chart being created in Spire XLS and it has extra secondary labels using this line of code

cs.DataPoints.DefaultDataPoint.DataLabels.ValueFromCell = ws.Range[headerRow +1, 3, rownumber - 1, 3];

this works when I look in the chart (they are percent values so it each label in the chart is 10%, 33 etc)

But when i call wb.SaveChartAsImages(ws) the extra labels are not showing in the image (it shows the 33 but not the 10%)

But on a stacked column with single series doing the same thing, the extra labels are showing in the image. So I have to assume it is the way you are processing the image in a pie chart.

Can you confirm?

To recreate the issue create the following data

Task Total
item1 9 12 %
item2 8 11 %
item3 6 8 %
item4 5 7 %
item5 4 5 %
item6 4 5 %
item7 4 5 %
item8 4 5 %
item9 4 5 %
item10 3 4 %



then create a pie chart using the first two columns (the second column is the values) and add the 3rd column as the extra data labels. It will work.

Then get the image from the worksheet and paste it into Word using Spire.Doc. The secondary labels do not work

ppdevs
 
Posts: 20
Joined: Sat Jan 09, 2016 7:23 pm

Mon Sep 12, 2016 3:15 am

Dear ppdevs,

Thanks for your inquiry.
I have noticed the issue and posted it to our Dev team. We will inform you when it is fixed.
Sorry for inconvenience.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Oct 04, 2016 9:49 am

Hi,

I have smililar problem with bar chart - labels are not visible when chart is saved as image or when workbook is saved as pdf. Could You please tell when this issue will be fixed? It's quite important feature for me :)

Thanks in advance.

Regards,
Iza

zukowska.iza
 
Posts: 5
Joined: Mon Aug 29, 2016 11:44 am

Wed Oct 05, 2016 6:39 am

Hello,

Thanks for your feedback. Please attach the document you have encountered the issue.

Thanks,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Wed Oct 05, 2016 7:43 am

Hi,
I've attached sample document and below is the code I'm using to export workbook to PDF.

Workbook workbook2 = new Workbook();
workbook2.Version = ExcelVersion.Version2013;
workbook2.LoadFromFile(@"C:\test.xlsx");
workbook2.SaveToFile(@"C:\testPDF.pdf", FileFormat.PDF);

Regards,
Iza
Attachments
test.zip
(8.77 KiB) Downloaded 290 times

zukowska.iza
 
Posts: 5
Joined: Mon Aug 29, 2016 11:44 am

Wed Oct 05, 2016 8:04 am

Hello,

Thanks for your response. I have noticed the issue and posted it to our Dev team for investigation further, once it is resolved, or we have some other update, we will let you know ASAP.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Wed Oct 26, 2016 7:37 am

Hello zukowska.iza,

The issue you posted has been resolved, you could download the Spire.XLS Pack Hotfix Version:7.11.1 and have a try.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Fri Oct 28, 2016 8:33 am

Hello zukowska.iza,

Did you test the version ? Has your issue been resolved ?
Could you please give us some feedback at your convenience ?

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Fri Nov 11, 2016 8:19 am

Hi ppdevs,

Thanks for waiting.
Now the issue has been resolved in Spire.Office Platinum Version:2.15, welcome to test it.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS