I updated a slide with an embedded Excel chart. I updated the Chart using Aspose.Cells' Smart Marker feature. The problem is that it appears that Aspose changed the format of the labels.
I am attaching three slides (original one, one after update, templatewith smart markers) for this posting so you can see the difference.
The label on the top of each blue bar shows the height or value of each blue bar. After updating with current data, Aspose changed the background color the label for the blue bars so you see a little black rectangle in the background of each label. Why is this? Could there a bug somewhere? Could the serializer (save as stream) lost some information?
I am expecting the format to be just the same as the original. I am not sure if Aspose.Cells or Aspose.Slides doing this. Note my code does not touch any formating at all, it just calls Aspose.Cells.WorkbookDesigner to inject data into the smart markers.
My code is something like this:
Dim dsBenchmarkReturn As DataSet = Me.getPeBenchmarkReturnData()
Dim dtBmkReturn As DataTable = dsBenchmarkReturn.tables(0)
Dim chartShape As Shape = slide.FindShape("ComparisonWithBenchmarkChart")
Dim oof As OleObjectFrame = CType(chartShape, OleObjectFrame)
Dim mstream As MemoryStream = New MemoryStream(oof.ObjectData)
Dim designer As Aspose.Cells.WorkbookDesigner = New Aspose.Cells.WorkbookDesigner()
oof.ObjectData = designer.Workbook.SaveToStream().ToArray()