Update shapes with variable data

Aspose.Cells Product Family
1

dear Aspose support,

I am linking the text value of a text shape to an excel cell.
Unfortunately, the text value of the shapes do not get updated after exporting to html or pdf.
Any idea ?

2

@GuidoDeBouver,

Thanks for providing us details.

Could you provide us template Excel file and sample code to reproduce the issue on our end, we will check it soon.

Thank you.

3

please find attached source spreadhseet

shapes.zip (37.6 KB)

The code is equally simple ( in VB .NET )
Dim w1 As New Aspose.Cells.Workbook(“shapes.xlsx”)
w1.Worksheets(“Sheet1”).Cells(“A1”).PutValue(DateTime.Now)
w1.Save(“shapes.pdf”, Aspose.Cells.SaveFormat.Pdf)

In my source excel, there is a tetxbox of which the tetx comes from cell A1.
Also, I have included a linked picture. The text also not get copied.

In addition, the picture should get its format ( eg color ) from the source cell - that also does not seem to work. The Glow, Shadow, SOftEdges… of the pciture are alos not included - but I guess that is a different issue.

Thanks for your help,

guido

4

@GuidoDeBouver,

Please add a line to your code before rendering to PDF file format, it works fine as I tested:
e.g
Sample code:

w1.Worksheets("Sheet1").Shapes.UpdateSelectedValue()

Please start a new thread with all the details, sample files, sample code, etc., we will check it soon.

Thank you.

5

it works fantastic - thanks for your much appreciated help

6

@GuidoDeBouver,

Good to know that your issue is sorted out by the suggested code. Feel free to write us back if you have further comments or questions, we will be happy to assist you soon.

Thank you.