Back to problems

Design Extensible Spreadsheet Aggregation APIs

Object-Oriented Programming · Google · Medium

Design an extensible API for a spreadsheet that provides three aggregate operations over a rectangular range of cells: get_sum – the arithmetic sum of relevant values get_max – the maximum value get_min – the minimum value A cell can contain a raw number, plain text, or a formula (a string that starts with = and references other cells, e.g., =A1). Aggregation functions must consume the final computed numeric value of each cell through a single, reusable evaluation interface.…

Checking your access…