'Replacing text in a chart title

I'm afraid there's no code in this question, but I'm looking for feedback. I have a VBA addin called FlexFind (https://jkp-ads.com/excel-flexfind.asp) which I am currently trying to port to office-js.

One of the things you can do with the VBA add-in is search and replace in chart titles. The VBA tool is smart enough to detect if a chart title contains a formula to a cell. That means replacing in that chart title is only feasible if the tool is set to look in formulas. It will search and replace in the chart title's formula instead. Also, if the tool is set to S&R in Values, it ignores chart titles with a formula. As it should.

How would I detect a chart title with a formula in office-js as there appears to be no method or property to read the chart title formula?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source