Simple Spreadsheet Engine (SSE) - Kata by Sandra

( Quarta, 25 de Maio, 17h as 19h, Intacto, SCLN 210 Bloco C Sala 210 )

Simple Spreadsheet Engine (SSE)

You are faced with the task of quickly implementing a very simple spreadsheet engine (i.e. a much simplified version of Microsoft Excel).

A spreadsheet is a grid of cells. For simplicity, the coordinates are integer numbers.

We will need only two types of cells:

• “absolute value cell”: the cell contains an integer number;
• “formula cell”: the cell contains a formula that combines two “absolute value cells” using a binary operator. We can have the following operators: +, -, * and /.

Your job is to design the above simple spreadsheet engine, along with a test method, as described below.

The test method should initialize the spreadsheet with cells of both types (at least 8 absolute value cells and four formula cells, each pointing to two of the absolute value cells). After initializing the cells as described above, the updated contents of the spreadsheet should be displayed, whereby formula cells should display their computed values, based on the binary operator and the contents of the associated absolute value cells, and not the stored formula!

---

Participants:
- Sandra Dora
- Pedroso
- Fabricio Buzzeto
- Marcus Vinicius de Carvalho
- Julio
- Alessandro

:)
- very rich session;
- everyone participated;
- much refactoring done;
- we started from the code and did the tests after – refactoring kata;
- nice discovering small errors on a more organized code than the last kata;
- we started the dojo on time;
- new environment used;

:|
- The tests helped us understand the code by organizing what we know and don`t about the current code;

:(
- we broke sometimes the silence rule;
- we got engaged in talks behind the pilot/copilot
- we haven’t made a kata like suggested (we should try harder to make a kata and prepare it before properly)
- we didn’t commit a lot(Fabs) and we commited the complied files also;
- we didn’t get to the TDD part of the kata;