Gray colored box appearing in PPTX for datalabels- plot area border and chart legend

Aspose.Total Product Family
1

Hi Team,

I’m embedding excel sheet into pptx using OLE feature.

In my excel I have 2 charts. For the second chart I have datalabels (10.0, 20.0, 30.0) for the series added.

After embedding this excel sheet into pptx as OLE , we can see some gray colored box appearing for datalabels (10.0, 20.0, 30.0) and also the plot area border is also appearing in gray color.

In some scenarios the legend of the charts are also surrounded with gray colored box.

Could you please let us know why this gray colored box is visible only when we are embedding this excel sheet as OLE in pptx.

Please find the attached PPTX with OLE and the excel workbook for your reference.

Note: We can reproduce this issue using MS Office 2010, Aspose.Cells Java v8.7.2 jar, Aspose.Slides Java v15.7.0 jar


Regards,
Sanjeev


2

Hi Sanjeev,

Thanks for your posting and using Aspose APIs.

Could you please re-attach your .zip file because it is lost?


Attachment: Gray box issue in PPTX with OLE.zip

Please re-attach it so that we could look into this issue and help you out. Thanks for your cooperation.

3

Hi Shakeel Faiz,

Please find the attached zip file for your reference.
Kindly let me know if you still have some problem with attachment.

Regards,
Sanjeev

4

Hi,

Thanks for your posting and using Aspose APIs.

I have compared your excel and power point images, they both look same to me. Please highlight your issues in some screenshots for our investigation.

I have attached the excel and power point images for your reference. Both looks same and without problem.

5

Hi Shakeel Faiz,

As I have already mentioned the issue can be reproduced using the below:

MS Office 2010,
Aspose.Cells Java v8.7.2 jar,
Aspose.Slides Java v15.7.0 jar

From the screenshots you shared what I can observe is that you are viewing the results in MS Office 2013.
Please view them using MS Office 2010.

Regards,
Sanjeev

6

Hi,

Thanks for your clarification and using Aspose APIs.

We will set up MS-Office 2010. However, we try to reproduce issue with the latest version. Please make sure the latest version is also giving the same error. It may happen that error is occurring in older version and latest version has already fixed it.

It will also be helpful if you could share with us MS-Office 2010 screenshots showing the error you have mentioned.

Please download and try the latest version:
Aspose.Cells for Java 8.8.0 and let us know your feedback.

7

Hi Shakeel Faiz,

I’ve tested the same scenario with the Aspose.Cells v8.8.0 jar and still I can reproduce the same issue.

Please find attached the screenshot of the generated PPTX with OLE having gray boxes around the data labels of the line charts.

This problem exists for legend also.

Regards,
Sanjeev

8

Hi,

Thanks for your clarification and using Aspose APIs.

We have looked into this issue and found it is not the issue of Aspose.Cells but the PowerPoint 2010 and Excel 2010. Because if you double click your image, MS-Excel will open it up and then you click on slide, then the image will be updated by MS-Excel and you will see the same issue of gray boxes.

Please note, this issue occurs in Slide Show and not in Normal View.

I have attached the screenshots highlighting the issue and steps to reproduce them without Aspose.Cells. In the second slide, I have added the excel file manually and the same thing occurs. Please check it out and let us know your feedback.

9

Dear Shakeel Faiz,

Even I’ve tested the way you did and was able to replicate the same issue with MS PowerPoint 2010.

Could you please let me know whether there is any workaround that we can provide for this issue.

Note: This is a major issue in all the reports what we publish and also have a major impact on business.

Regards,
Sanjeev

10

Hi Sanjeev,

Thanks for your posting and using Aspose APIs.

It is strange why it happens on MS-Office 2010. Earlier I thought, it is because of Service Packs. But on my test machine, Service Pack 3 was installed in Windows XP. I will look into it further why it is happening and let you know my findings. Meanwhile, will you please test it on different Virtual Machines using the Virtual Box. It will help you isolate the issue and you will be able to guide your clients to right direction.

11

Hi,

Thanks for using Aspose APIs.

As per your request, we have logged this issue in our database with Enterprise Support priority. We will look into it and update you asap.

Enterprise Thread:
( )

This issue has been logged as

  • CELLSNET-44461 - Gray colored box appearing in PPTX for datalabels, plot area border and legend of charts

12

Hi,

Thanks for your posting and using Aspose.Cells.

Please send us the complete code with which you created “PPTX with Gray box issue.pptx”. Please also let us know, did you create “Excel without Gray box.xlsx” manually using Microsoft Excel or programmatically using Aspose.Cells. If you have created it with Aspose.Cells, then please also send that code too.

I am referring to your attachment Gray box issue in PPTX with OLE.zip at this post.

13

Hi,

Thanks for using Aspose APIs.

It is best you send us the complete code segment that created the report(pptx). Setting the color of chart area to white may also solve the issue before generating the report.

Please try the following code for your needs.

C#

Workbook book = new Workbook(sourceExcelFile);

for (int i = 0; i < book.Worksheets.Count; i++)
{
Worksheet sheet = book.Worksheets[i];

for (int j = 0; j < sheet.Charts.Count; j++)
{
Chart c = sheet.Charts[j];
c.ChartArea.Area.ForegroundColor = Color.White;
}
}//end-for