
1,068 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.