'Getting formulasLocal from a rangeAreas
I have the code snippet below. Why doesn't this give me access to the formulasLocal property of found rangeAreas:
let foundRange = thisSheet.findAllOrNullObject(
$("#searchText")
.val()
.toString(),
{
completeMatch: matchComplete,
matchCase: matchCase
}
);
await context.sync();
let realFoundRange;
if (foundRange.isNullObject) {
//Do nothing
} else {
if (searchAllSheets) {
realFoundRange = foundRange;
} else {
if (searchRange.cellCount > 1) {
realFoundRange = foundRange.getIntersectionOrNullObject(searchRange);
} else {
realFoundRange = foundRange;
}
}
if (!realFoundRange.isNullObject) {
realFoundRange.load("areaCount,address,formulasLocal,values");
await context.sync();
foundSet.push(realFoundRange);
}
}
}
I was trying to get the formulasLocal from the first area like so:
console.log(foundSet[0].formulasLocal);
But that fails?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
