1,066 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 78%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
I have the same question. Is anybody out there who can answer?
Access Excels formula checking & error reporting via JavaScript API
Johannes Boyne
21
Reputation points
Hi everyone,
Trying to figure out if it is possible to access the Excel formula checking, especially the error reporting:
I have found some hints for the VBA API but not for the JavaScript one.
Best,
Johannes
Microsoft 365 and Office Development Office JavaScript API
Microsoft 365 and Office Development Other
4,374 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2022-09-15T10:53:29.317+00:00 @Johannes Boyne I have seen you can access formulas containing an error e.g. writing =SUMM with two m's using:
range.getSpecialCellsOrNullObject( Excel.SpecialCellType.formulas, Excel.SpecialCellValueType.errors );Would also be interested if we could access these more nuanced issues detected by excel in formulas via the js API
Sign in to comment