For example, I have a Formula in a xlsx file
=‘D:\xx\xx\xx[source.xlsx]Sheet1’!A1
And source.xlsx is another file on my local drive (maybe in the same folder or in a stable relative path). When I pass these files to someone else while maintaining their relative path relationships, they open these files using Aspose.Cells, and sometimes the referenced file paths are automatically updated, while other times they are not. How can I control this behavior in Aspose.Cells through which API, for example, if I want to stop the automatic updating of reference sources, or manually update these reference sources through a policy I have written?
To control those external links with Aspose.Cells, we think you may try the methods of ExternalLink. If it is not what you need, please provide one example for the source and expected resultant so we can help you further.
It looks like ExternalLink can solve my problem. Thank you very much for your response.
@Jason_Wang
Thank you for your feedback. I’m glad your problem has been resolved. You are welcome. If you have any questions, please feel free to contact us at any time