< All Topics

Versions and change log

This page shows the changes, including new features and bug fixes, in each version of Openbox, starting at v1.9.0. Changes are shown newest first (i.e. the newest version is always at the top).

Version 1.9.22 – Section formatting and bug fixes

  • Can now edit labels in Focus Mode
  • Importing components now much faster for large components
  • Fix bug with Ctrl+[ in preview
  • More logical layout of report items in Ribbon
  • Can now change the time suffixes for reports
  • When importing into a model with two timelines, ask what timeline the component should be on
  • Better warning about making sections into table sections
  • Update form now offers link to this change log
  • Right click menu in Preview now includes “Calculate Now” and “Toggle manual/ automatic calculation”

Version 1.9.21 – Reports, circularity, ingestion and bug fixes

  • Can now simultaneously add reports for all timelines between model timeline and yearly (e.g. add monthly, quarterly, semi annual and annual reports for a monthly model)
  • Line items with no arrays now correctly inserted on reports with arrays
  • Allow user to build circular models by clicking “Ignore” in the circularity warning window
  • Allow multi-row IRR/ XIRR functions to be ingested
  • Fix counterflow bug
  • “Secondary vars refer to primary” is now a warning not an error
  • Allow choice not to duplicate time sheet in multi timeline models
  • Fix ingestion issue with opening balances
  • Add PREVIOUSVALUES function which gives the total of the current line item for all previous periods
  • Add tooltips to import window to show which sheet items are on
  • Allow “add both” when merging
  • Fix bug with ingestion of text values
  • Allow user to insert a named range for constant inputs
  • Read named ranges and values when ingesting

Version 1.9.20 – Better ingestion and copy paste

  • Ingestion can now deal with references to row totals
  • Added XNPV function
  • Correct standard copy/ paste macro
  • Populate placeholders when ingesting from Excel
  • Deal with¬† single quote marks ‘ in the middle of sheet names
  • Better warnings about invalid sheet names
  • Ctrl +[ now goes to the first precedent in the preview (same behaviour as Excel).
  • Ctrl+0 in preview shows the Focus view for that item
  • Fix pasting in from preview so it brings values not text.¬†
  • Warn about pasting more than 255 columns from Excel, because of an Excel limitation
  • Check for “balances” that don’t include a reference to the BEG value in the formula
  • Allow user to use custom copy/ paste macro instead of the standard one

Version 1.9.8 – Full model ingestion

  • New option “Import selected sheet(s)” on the Openbox part of the Excel Ribbon. Allows you to bring whole sheets or models into Openbox in one step
  • Update report layout approach, to deal with complex arrays
  • Deal with any placeholders ending “POS” in the Openbox screen – offer to merge them with the corresponding line item e.g. “Operating costs POS” merges with “Operating costs”

Version 1.9.7 – Bug Fixes

  • Reports on single sheet option now works with complex multi-period reports
  • Ingesting multi-row InpT inputs now works
  • Fix period end flag calculation in hybrid timelines which failed if there was a leap year during construction
  • Don’t allow opening or closing [ ] in labels
  • Tidy up timeline letters on sheets and inputs
  • Don’t allow switching to secondary axis if the model has a hybrid timeline
  • Put units for InpT items in correct row
  • Allow user to refer to table items on another sheet, in a normal FAST calculation block
  • Correct some broken/ out of date help links

Version 1.9.6 – Bug fixes

  • Fix InpT (table input) sheet bugs, and add buttons for toggling time/ table view to Ribbon
  • Don’t check time axis of built in sheets
  • Don’t store temporary model results in saved files
  • Warnings if issues ingesting input tables

Version 1.9.5 – Bug fixes

  • Scenario and comparison buttons now operational
  • Fix issue with circularity breaker in preview window, where it was incorrectly reporting that the results did not converge
  • Fix issue with the input selector formula on InpC

Version 1.9.4 – Scenarios and bug fixes

  • Allow users to display multiple scenarios, and compare scenarios, on charts
  • Fix bug where some circular references were not being detected
  • Improve circularity handler
  • Fix bugs with Delete key
  • Allow changes to scenario names on InpC
  • Find/Replace now lets you search in section, sheet or model

Version 1.9.3 – bug fixes

  • Fix issues with copying and pasting items
  • Fixed bug which caused the screen to jump occasionally
  • Fix issue with circular reference screen buttons
  • Fix bug where the ‘Delete’ key wouldn’t let you delete sheets
  • Insert the current unit into the dropdown when the unit editing box is displayed

Version 1.9.2 – formula help

  • Formula help now displayed below formula bar at all times when editing. Includes help on function syntax and arrays
  • Add “online help” button in formula help bar which takes you to the function help page on this site
  • Add “unpin all charts” functionality

Version 1.9.1 – Charts and bug fixes

  • Fix bug which caused duplicate labels for some constants on two timeline models
  • Include copy paste block check in overall check
  • Tidy up Equation charts
  • Fix issue with financial close date calculation for new models

Version 1.9.0

  • Improved chart display in Focus Mode
  • Improved file name suggestions for saving
  • Fix issue where there are reports with different arrays, and the user chooses to put all reports on one page
  • Fix issue where pasting beyond column IV in the preview
  • Copied and pasted items in the main view are now put beside the original, not in ‘Unallocated’
  • OBXValues function now correctly deals with array elements in the second argument
  • Counterflow arrows now refreshed on validation
  • Fix bug where array formulas in the template would cause an error
  • Improved Focus Mode layout and redrawing
  • Fix bug where a template with automatic calculation would cause a crash

Leave a Reply

Your Cart

No Item Found
Subtotal 0
Shipping 0
Tax 0
Total 0