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

Tie CHENG 16 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.

Microsoft 365 and Office | Development | Office JavaScript API
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.