Refreshing Visio formula and cell references

We’re currently in the process of switching from making changes to our Visio files using Visio automation to using the Aspose Diagram product. We have a number of cells which contain formula that are in turn referenced by other cells. For example, when a cell is set to a certain value, a particular shape is made invisible. When a file is opened in Visio, these referencescan be updated automatically by setting flags in the file.

We are looking to remove Visio from our product and rely on Aspose instead. Can you let me know if it is possible to automatically update cells that reference other cells in formulas using the Aspose Diagram product? Otherwise we are exporting content to SVG without making all the required content changes.

Please let me know if you need any further explanation of the problem.

Thanks,
Andrew

@andrew.ridgeley,
Thank you for the details.

Kindly share more details about how you expect to set flags in the drawing using Microsoft Visio application. Please list down the complete steps one by one. We will take a closer look, and then share our findings with you. Your response is awaited.

Based on another client’s use case, Aspose.Diagram API has formulated the text of a shape from another shape, so Aspose.Diagram API can auto update formulated values while exporting a drawing to any other format. For example, the text box shape “firstname” (id=1) contains just plain text (no formula). After changing the whole text of this shape by running this line of code:

[C#]

shape.Text.Value.SetWholeText("Gerd");

The results are correctly changing the text value in the second text box shape “secondname” (id=2) which has a formula =SHAPETEXT(firstname!TheText) so the text in the box is populated with the text value of the first shape “firstname” (id=1). You can create a test case as per the expected behavior of the Aspose.Diagram API, and then let us know if this does not work in your environment.

Best Regards,
Imran Rafique