Updating Embedded Excel File with Multi Cell References in C# Requires Opening the File and Opening the Object to Update

Aspose.Slides Product Family
, ,
1

In a C# standalone environment with these nuget packages installed

<PackageReference Include="Aspose.Cells" Version="24.10.0" />
<PackageReference Include="Aspose.Slides.NET" Version="24.10.0" />
<PackageReference Include="DocumentFormat.OpenXml" Version="3.1.0" />
<PackageReference Include="Newtonsoft.Json" Version="13.0.3" />

With the following file

bugs.2027 - Copy.zip (476.0 KB)

I use OpenXML to open/update the underlying data for this object

#region Aspose Ignore This Part

then I use Aspose Libraries in order to save and run all “update” procedures.

//  Refresh things using Aspose

Since I run these “RefreshData” methods from Aspose, I would assume these are the ones I need to call. However, I notice when I open the file again, the data does not appear to be updated, although I have to not only open the file, but open the excel object to finally see the updated data.

Observe this as at first, the left hand table has 4 rows;

1st Phorm
Living Essentials LLC
Ghost Energy
0.0

But after the code is run, another row, “Dr Pepper” should be added.

I notice one part of this code that may be a culprit

CalculationOptions opts = new()
{
    Recursive = true,
    IgnoreError = true
};

Set IgnoreError to false and an exception is being thrown, but I can’t see why this would be thrown in this area.

code.zip (4.2 KB)

2

@BK.Broiler.730,
Thank you for contacting free support.

Please note that after loading the PowerPoint presentation using Aspose.Slides and changing the chart data, you do not save the presentation (the Presentation.Save method is not called). I hope this will help you. If the issue persists, please simplify the code as much as possible to reproduce the issues you found.

3

I added this line on Line 132

ap.Save(@"[Directory Omitted]\abc.pptx", Aspose.Slides.Export.SaveFormat.Pptx);

The problem persist even after I saved this new file, opened it, and the same problem occurs, I have to open the object to see the data updated.

The Aspose code is from line 78 - 135, the #region Aspose Ignore this is the underlying sheet update, it can be ignored.

4

@BK.Broiler.730,
I need some time to check the problem. I will get back to you as soon as possible.

5

@BK.Broiler.730,
Thank you for your patience. I’ve reproduced the issue with an OLE object preview not updating after changing the object data.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): SLIDESNET-44743

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.