`next` version: Google Sheets maxes out at 1000 rows

Open
  • Is something wrong?
#151 0 comments 0 reactions 0 assignees View on GitHub

Maintainers usually reply within 1 day

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
35/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Stale
Tech stack
node.js, typescript
Domain
api, cli

Research direction

The report names no source file or test. Start by tracing the Google Sheets write path for the “Lighthouse Results” sheet and reproduce the A1001 grid-limit failure; done means an audit exceeding 1,000 rows continues or recovers without manual row expansion.

Written by the indexing model from the issue text.

Description

I was running an audit and suddenly the audit got stuck with this error:

Error: Range ('Lighthouse Results'!A1001) exceeds grid limits. Max rows: 1000, max columns: 121

I manually added more rows to the Google Sheet at that point, but the process could not get out of that error state.

My workaround was to start a new process, then as soon as the new Google Sheet was opened, I added 10K rows to ensure it wouldn't get stuck again with that 1000 max row error.

Dominant language
TypeScript
Stars
373
Forks
15
Avg merge
19h 16m
Merged PRs (30d)
23

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from cloudfour/lighthouse-parade

All issues in cloudfour/lighthouse-parade

Similar issues

More TypeScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.