Shows "#REF!" for formatted values which is different from the @googleapis/sheet

[thejasonxie]

When a cell value is:
{ type: "REF", message: "Circular dependency detected. To resolve with iterative calculation, see File > Settings.", }

The formatted value is "#REF!".

Whereas when I use @googleapis/sheet to access that cell that shows "#REF!", I get the value that is displayed:

import google from "@googleapis/sheets";

const sheets = google.sheets({ version: "v4", auth: serviceAccountAuth });
const doc = await sheets.spreadsheets.get({ spreadsheetId: SHEET_ID });
const sheetTitle = doc.data?.sheets?.[1]?.properties?.title;

const sheet = await sheets.spreadsheets.values.get({
  spreadsheetId: SHEET_ID,
  range: `${sheetTitle}!A1:Z100`,
});

console.log(sheet.data.values[37][1]);