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

Tie CHENG 11 Reputation points
2021-09-26T09:10:41.693+00:00

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.

135313-screenshot-2021-09-26-at-110951.png

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