Unable to extract data behind linked chart (C# .NET)

Aspose.Slides Product Family
, ,
1

Hi,

After upgrading to the latest version of Aspose.Total for .NET I’m unable to extract data behind linked charts, it only seems to work with embedded ones.

I have attached an example (.pptx) file which includes an embedded chart on slide 2 and two linked charts on slide 3. Previously I was able to extract the chart’s data, even if the linked file wasn’t available.

Linked chart data example.zip (66.7 KB)

Has this functionality changed recently? are there any other ways in which I can get the data behind the chart?

Thank you.

2

@publishinteractive,

I have observed your comments. Can you please share which version of Aspose.Slides you have upgraded to on your end.

I am unable to understand this question. Can you please share the details in the form of sample project , source file and generated output with us so that we may investigate it further on our end.

3

Hi there,

We have upgraded to Aspose.Slides for .NET 20.2.0, Please find below a sample project, Input file and generated console Output screenshots for your investigations.

AsposeTableDataIssue.zip (67.9 KB)

If you build and run the program, it will print out the table data to console:

Img1.png (23.3 KB)

If you then edit the CSProj file to swap the aspose includes, clean and run the program, you get the error.

Img2.png (22.8 KB)

Thank you for your help.

4

@publishinteractive,

I have worked with the sample project shared by you using Aspose.Slides for .NET 20.2. I have not been able to observe any issue. You probably are using API without valid license. When you use API without license, you can access limited API features. I suggest you to please try using license of Aspose.Slides on your end.
image.png (23.9 KB)

5

Hi there,

Thank you for your response.

As mentioned in my previous post, did you edit the Aspose.csproj file to swap the PackageReference Include Aspose.Slides for .NET to Version 20.2.0?

I know it works when using PackageReference Include Aspose.Slides for .NET Version 15.9.0; I only get the “System.InvalidOperationException: External workbook is not available or can’t be loaded” error when using Version 20.2.0.

I have a valid Aspose.Total for .NET Developer OEM licence.

Thank you for your help.

6

Hi there,

Please find below a new version of the sample project which uses Aspose.Slides for .NET version 20.2.0, if you download and run this you should be able to observe the issue reported in my previous post.

AsposeTableDataIssue.zip (67.9 KB)

Thanks again.

7

@publishinteractive,

I have tested the new sample project shared by you and have been able to observe the issue. An issue with ID SLIDESNET-41808 has been created in our issue tracking system to further investigate and resolve the issue. This thread has been linked with the issue so that you may be notified once the issue will be fixed.

8

@publishinteractive,

We have investigated the requirements on our end. Latest versions of Aspose.Slides behave the same way as PowerPoint does. If linked workbook cannot be reached out from PP it’s not accessible from Aspose.Slides either.

Can you please clarify if that workbook is existing and available on your side?

The link to your workbook looks like this:

“file:///C:\Users\markchadwick\Downloads\1a%20-%20Total%20production.xlsx”

9

Thanks for investigating further.

The workbook isn’t available. However, when we were using version 15.9.0 we were still able to get the data from the chart, even when the workbook wasn’t available through PowerPoint.

When we upgraded to version 20.2.0 we started getting the "System.InvalidOperationException: External workbook is not available or can’t be loaded” For powerpoints and charts that used to work.

If you run this sample project that uses V15.9 you won’t encounter the error.
AsposeTableDataIssue.zip (67.9 KB)

However, if you run this sample project that uses V20.2 you will encounter the error

AsposeTableDataIssue.zip (67.9 KB)

So as you say aspose does follow what the behaviour in Powerpoint, in the past it was still able to get the data.

Thanks again for your help

10

@publishinteractive,

Thank you for sharing the details with us. We will get back to you as soon as the issue will be fixed.

11

The issues you have found earlier (filed as SLIDESNET-41808) have been fixed in this update.

12

The bug SLIDESNET-41808 is still happening on Aspose.Slides for .NET 20.7.

13

@publishinteractive,

We have added ISpreadsheetOptions.RecoverWorkbookFromChartCache property. If data source for the chart is an external workbook and it’s not available, it will be recovered from the chart cache using this property.

LoadOptions lo = new LoadOptions();
lo.SpreadsheetOptions.RecoverWorkbookFromChartCache = true;

using (Presentation pres = new Presentation("Presentation.pptx", lo))
{
    IChart chart = pres.Slides[0].Shapes[0] as IChart;
    IChartDataWorkbook wb = chart.ChartData.ChartDataWorkbook;
    ...
}