named range in googlesheet only populates when known

[judell]

Using the googlesheets plugin, I have a tab in a sheet with data in just two cells, a1:a2, and a named range that captures both. The range column populates if I ask for it explicitly. I am filing here, vs the plugin repo, because I suspect it's an fdw thing. (/cc @cbruno10 in case otherwise)

select row, col, range from reposheet.googlesheets_cell where range = 'NamedRange1';
 row | col |    range
-----+-----+-------------
   2 | A   | NamedRange1
   1 | A   | NamedRange1
(2 rows)

I don't understand this.

select row, col, range from reposheet.googlesheets_cell where range is null;
 row | col | range
-----+-----+-------
   1 | A   |
   2 | A   |
(2 rows)

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 90 days with no activity.