2 sheets tagged with "functions":

Although a simple example, this spreadsheet shows off several key features of Resolver One.

The Fibonacci sequence is implemented as a Python generator function (in user code) which is called and configured from cells in the spreadsheet grid. The resulting generator object is stored directly in a cell, and used to generate values from the sequence - as a Python list also stored directly in the grid.

It shows how easy it is to write simple functions and call them from formulas, and how the basic Python types (including arbitrary objects) can be stored and displayed in your spreadsheet.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.

This is the example that is worked through in the Quick Start Guide.

It demonstrates creating a simple Python function in user code and using it from formulas.

It also uses the BackColor property on rows for conditional formatting (BackColor is available on all the spreadsheet objects including cells and cellranges as part of the formatting API).

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.