Changes for version 1.6

Released 21 August 2009

These changes apply to Resolver One, the Resolver One Player, the Resolver One Web Server, and the Financial Data Feeds add-on.

Major changes

  • Player mode. A Player license is a new kind of license key that allows people to use Resolver One in a cut-down mode, where they can't edit user code — its aim is to give you an easy way to distribute your spreadsheets to people who haven't bought Resolver One. You can simulate what Resolver One looks like when one of those keys is installed by choosing "Player mode" from the "View" menu.
  • Redistributable spreadsheets — while the player gives you a way to distribute spreadsheets to other people using a front-end we provide, Resolverlib gives you a way to build Resolver Spreadsheets into your IronPython scripts, with your own UI (or no interface at all) and redistribute them — royalty-free!
  • Expanded cells — make a cell expand to cover its neighbours by selecting a range, and then selecting "Expand Cell" from the "Edit" menu.
  • Images in cells. From user code, setting the value of a cell to an image displays it in the cell — this is particularly useful when combined with the expanded cells. You can control the placement of the image within the cell with the new ImagePlacement property, which can be set to ImagePlacement.Normal (top left), ImagePlacement.Center or ImagePlacement.Stretch. There is a new example that shows you how to use this.
  • Simple auto-complete in the Console: when you're typing code into the console, you can use control-space to trigger simple auto-complete. The auto-complete window will also pop up when you type the dot after an object reference.
  • NumPy support. Add an appropriate import (say, import numpy) to your pre-constants user code. The first recalculation after that will take a little time, but once that's completed, NumPy should work in full.

Minor changes

  • A fluent interface for cell ranges. Instead of writing code like
    r = CellRange(workbook["Sheet1"].Cells.A1, workbook["Sheet1"].Cells.D5)
    you can now write
    r = workbook["Sheet1"].Cells.A1.to.D5.
  • Cell.Formula performance is now much faster.
  • RunWorkbook performance improvements for worksheets that call the same sub-workbook repeatedly.
  • Cell.Href property that allows you to make a cell a hyperlink launching a URL in a browser (very useful if you're using the Resolver One Web Server).
  • Drag to re-order worksheet tabs. This one's pretty self-explanatory.
  • "Magic" variable self for use in formulae, representing current cell.
  • Make popup windows appear in sensible places.
  • When exporting to Excel, convert Python-style formulae into a style that it can handle (even if it can't execute them), and convert them back from that format when importing again.
  • Fonts. If you don't like our choice of fonts in the formula bar, console, code editor, output pane, or the default font for new documents, go to the "Preferences" option on the "Edit" menu, and change them to something you prefer.
  • Invite users to register on our website the second time they start Resolver One rather than on the first exit.
  • The popular ZedGraph graphing library is now bundled with Resolver One.
  • Splitter Orientation Menu Item
  • New formula functions LEFT and RIGHT.
  • Ctrl+A to select the whole worksheet
  • Cell ranges, offsets and headers sample enhancement

Bugfixes

  • Got rid of irritating beep when you hit return but are not at the end of the formula.
  • Fixed problem with repainting when you have one or more very wide columns or deep rows.
  • Prevent setting attributes on worksheet cells collections.
  • Store Resolver One license keys in the per-user registry settings, so that non-administrators can use it more easily.
  • Fixed error that made it possible to save on top of a read-only file.
  • Pressing a button doesn't finalise cell editing
  • Dropdowns only change their value after a recalc is finished
  • Clarified traceback when you delete the formula from an unpacked array.
  • Cells. Rows and Cols properties weren't showing up in the API documentation.
  • Only display first 65,535 letters of text in the grid to work around GDI+ problem.
  • Tracebacks claimed to have the most recent call last but actually had it first.
  • Fixed bug when programmatically selecting image worksheets.
  • IndexError in output pane when clicking on a dropdown

See changes in older versions