How to check if a cell has a single quote in the beginning?

Tie CHENG 11 Reputation points

In Excel, in a cell we could add a single quote before a formula (e.g., '=3+4), to let the formula not evaluate. And in the formula bar, we could see the single quote.


Is there a JavaScript API to check if a cell has such a single quote?

We tried formulasLocal and values, but they all returned the formulas and formulas without the single quote.

JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
942 questions
0 comments No comments
{count} votes