4 sheets tagged with "UI":

Drop-downs allow you to create lists of values for the user to select from. They enable richer user interfaces for your spreadsheet applications.

Drop-down lists in cells can be created from the GUI (where you specify the values as a cellrange), or from user code (where you can use any Python list as the source of values).

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

The workbook is a simple sheet that allows a user to enter the parameters of a share trade. They can then click on a button, and the details are written to a database.

The code is structured in three layers: a general database access layer, a "business" layer that knows how to translate from concepts that make sense in the application domain (such as stock symbols and prices) into database commands, and then a UI layer that interfaces between the spreadsheet and the business layer.

The database access layer is a simple bit of generic IronPython in the pre-constants user code. It uses the .NET API to execute a non-query SQL statement against a database, the latter being specified by an ODBC connection string.

See the documentation page (the More Information link) for the kind of database this spreadsheet expects to work with.

An image is a rectangular grid of pixels, each with a single colour. By coincidence, with Resolver One we have a grid of rectangles where we can control the colour of each cell. We can also change the row height and column width to make them a little more 'pixel-shaped'.

A simple bit of user code turns Resolver One into an image viewer! This spreadsheet even lets you change the size of each pixel to magnify the image, and uses the OpenFileDialog to select new images.

This spreadsheet was created for the Resolver Hacks website, and not by Resolver Systems.

Resolver One doesn't currently support importing from CSV files out of the box. Resolver One version 1.4 allows you to set data in the grid using the Formula property on cells. This spreadsheet is a tool to import CSV files into Resolver One.

Click the button on the 'Import' spreadsheet and select the CSV file to import. After importing, the contents of the file will be in the 'Data' worksheet and you can delete the user code and save the spreadsheet with a new name.

As well as being a useful tool this spreadsheet provides examples of using the cell Formula property plus using the OpenFileDialog and MessageBox (Windows Forms) dialogs from user code.

This spreadsheet was created for the Resolver Hacks website, and not by Resolver Systems.