Resolver One: Changes between 1.1.1 and 1.2
Major new features
- #1359, #1360, #1368, #1369, #1370, #1371, #1374, #1485 - New RunWorkbook functionality to allow users to "call" one spreadsheet from another, optionally allowing them to override cell values as a means of passing in parameters.
- #1081 Dropdown cells based on cellranges (or iterables) created in user code
- #860 Paste special: paste formulae/values/formatting/comments
- #1037 Box at the bottom right corner of the selected range that you can drag down to fill a larger range with auto-incrementing values
- #1380 Percentage formatting - numbers are multiplied by 100 and get a "%" at the end.
- #768 Percentages allowed in formulae or directly as cell values.
- #1103 Persistent state saved from recalc to recalc
- #1353 Header lookups now work with non-string headers
- #952 Ability to freeze first few rows/columns
Minor enhancements
- #1332 Make slicing work on .Rows and .Cols iterators for Worksheets and CellRanges
- #1349 Wait cursor when running click handlers for users' buttons
- #1351 Ability to make visible changes to the grid during a button handler
- #1460 Cell, row and col access bypassing headers
- #1463 Custom Numeric Types right aligned in grid and used by SUM (recognised because they define __abs__)
- #1235 Performance boost - upgrade to PLY 2.5
- #1341 Case-insensitive NPV, EXP, LN, SIN, ASIN, COS, ACOS, TAN, ATAN, INT functions.
- #1241 STDEV function
- #1242 COUNT function
- #1243 COUNTA function
- #1244 ISERR function
- #1261 The 'ABS' function doesn't appear in the API documentation for the 'Compatibility' module.
- #1167 Resolver One Web Server should print out version and build number on startup
- #1238 BDP function (Financial Edition only)
- #1239 BLP and BDP Bloomberg overrides (Financial Edition only)
- #1240 Arrays returned from BLP and BDP (Financial Edition only)
- #1253 Problem with Bloomberg functions when parameter cells are formatted (Financial Edition only)
- #1262 ParallelBloombergRequests doesn't handle BLP requests with > 2 params (Financial Edition only)
- #1295 Fixed typo in ParallelBloombergRequests doctstring (Financial Edition only)
- #1542 More graceful handling of invalid securities in ParallelBloombergRequests (Financial Edition only)
- #1543 More graceful handling of empty lists of securities in ParallelBloombergRequests (Financial Edition only)
Bugfixes
- #598 Button click handlers swallow exceptions
- #778 Formula not visible in cell, and not editable there, when editing a cell with an error cross
- #1298 Inserting/deleting rows does not always update names
- #1335 Crash when deleting rows
- #1338 Missing viewstate makes files un-openable
- #1357 Copying result-only cells doesn't copy quite the right values
- #1364 Attempt to make button current cell fails softly
- #1384 Out of memory in saving file (crasher)
- #1463 Custom Numeric Types right aligned in grid and used by SUM
- #1451 CopyRange won't copy across workbooks if sheet/range are the same
See previous changes