Excel Sheet Cell Dependencies and Cycle Detection

CodingOpenAILast reported April 2025Medium Frequency
Reported
4× across candidate reports
First seen
February 2025
Last reported
April 2025
Reported outcome
mixed

Problem Overview

Implement a Spreadsheet class with two methods: setCell(key, value) and getCell(key). Cells can hold either literal numeric values (e.g., '1', '2') or formula expressions that reference other cells (e.g., '=A1+A2', '=A3+A4'). getCell(key) must return the evaluated numeric value of the cell. The implementation must detect and handle circular references (e.g.,…

  • 4 candidate-reported follow-ups — the exact probes interviewers asked, with the trigger for each
  • The rest of the problem statement — full requirements, constraints, and edge cases
  • Approach and trade-offs — what passing candidates did, and the mistakes that sink people
Unlock the full OpenAI catalog
Full problem statements, candidate-reported follow-ups, and walkthroughs — for every OpenAI question.
Unlock with Pro
Already a member? Sign in
Verified Source
Every question is reconstructed from multiple independent candidate reports. Verbatim follow-ups, not invented ones.
Codex Fact-Checked
Technical claims, formulas, and scale numbers are reviewed against primary sources.
Interviewer Follow-ups
The exact follow-ups reported by candidates, with the trigger that prompts each one — plus the mistakes that sink people.
Is this helpful?