'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