Plain text formatted cells appear empty

[llamafilm]

In Google Sheets, I designate certain fields as "plain text" format, to ensure Google Sheets does not attempt to parse it as a number or date, etc. This causes a problem in Grafana. Apparently, any cell set to "plain text" appears blank in Grafana, and it also causes Grafana to interpret the column as a "number".

Example sheet: https://docs.google.com/spreadsheets/d/1Cl0Yqy_OSpuM5OUmv0-MUT2_iARp4ycJRqscx9fGiGc

Query inspector data:

{
  "traceId": "518c4180994f1fa55bd2a045173e6133",
  "request": {
    "url": "api/ds/query?ds_type=grafana-googlesheets-datasource&requestId=explore_5cd",
    "method": "POST",
    "data": {
      "queries": [
        {
          "refId": "A",
          "datasource": {
            "type": "grafana-googlesheets-datasource",
            "uid": "ddj4n7owk1n9ce"
          },
          "cacheDurationSeconds": 0,
          "spreadsheet": "1Cl0Yqy_OSpuM5OUmv0-MUT2_iARp4ycJRqscx9fGiGc",
          "range": "Sheet1!A:B",
          "datasourceId": 29,
          "intervalMs": 5000,
          "maxDataPoints": 846
        }
      ],
      "from": "1725929517708",
      "to": "1725933117708"
    },
    "hideFromInspector": false
  },
  "response": {
    "results": {
      "A": {
        "status": 200,
        "frames": [
          {
            "schema": {
              "name": "A",
              "refId": "A",
              "meta": {
                "typeVersion": [
                  0,
                  0
                ],
                "custom": {
                  "hit": false,
                  "range": "Sheet1!A:B",
                  "spreadsheetId": "1Cl0Yqy_OSpuM5OUmv0-MUT2_iARp4ycJRqscx9fGiGc",
                  "warnings": []
                }
              },
              "fields": [
                {
                  "name": "Issue",
                  "type": "string",
                  "typeInfo": {
                    "frame": "string",
                    "nullable": true
                  },
                  "config": {
                    "displayName": "Issue"
                  }
                },
                {
                  "name": "Room Name",
                  "type": "number",
                  "typeInfo": {
                    "frame": "float64",
                    "nullable": true
                  },
                  "config": {
                    "displayName": "Room Name"
                  }
                }
              ]
            },
            "data": {
              "values": [
                [
                  "Missing monitor",
                  "Missing monitor"
                ],
                [
                  null,
                  null
                ]
              ]
            }
          }
        ],
        "refId": "A"
      }
    }
  }
}