Since the end of the Openbox beta round 3 in October, we’ve been hard at work fixing the issues our beta users have found and implementing their feature requests. Here is the complete list to date.
New features
- Create LAMBDAs from Openbox calculations.
- Read LAMBDAs from Excel and convert to Openbox calculations.
- “Unfold” recursive LAMBDAs to help with understanding and testing.
- Added “Import” to right click/ context menu.
- If a calculation does not have a flag applied, don’t leave a blank space for the flag icon.
- The main window now scrolls left and right if you drag items over the left/right-hand margins.
- Single click anywhere on a calculation block selects it, double click edits.
- If you edit a calculation name, and it is the same as an existing one, pressing “Escape” will now go back to the name it had before editing.
- TAB in the formula bar now works like Enter/ Return.
- After importing a component, you now see what calculations have been connected to the rest of the model, and have the option to make further connections manually.
- You can now add actuals at any stage, and new actuals will be added if new report items are added.
- Master checks sheet now added – any calculation in the model with the unit “check” will be included in the overall check.
- Added a dropdown to set the number format for each calculation.
- Added new number format manager windows. You can now change the built-in formats.
- Number formats now read from the template.
- When a report is in focus, underline the name.
- F2 now puts the cursor at the end of the formula bar.
- Sensitivities now included by default on InpC.
- LET functions are now translated to Openbox formulas.
Bug fixes
- Can now undo “Paste”.
- Double-clicking a calculation name in the formula autocomplete list now inserts it in the formula.
- The formula autocomplete window is not shown if there are no possible autocomplete choices.
- Report lines are now shown in a lighter colour when selected. The text was not readable before.
- Can now merge a “sum of above” calculation with another.
- When you drag a section including placeholders to the Inputs sheet, all the placeholders are now coloured as inputs.
- Pressing “]” in the formula bar no longer inserts the current autocomplete suggestion.
- Check for “OPENINGVALUE” being used in calculations that are not balances (and conversely, for balance calculations that don’t refer to their opening value).
- Placeholders on a report sheet now have “[” “]” around them.
- Arrow keys now work in Focus mode.
- Sections in the “Input” sheet are now correctly ordered in the spreadsheet.
- When you group items into a section, the section is left where the items are, not placed at the end of the sheet.
- The Master check cell now works correctly even if all checks are constants.
- The formula bar now updates when you update the name of a balance.
- The list of flags, indices and discounts now updates automatically when something is deleted.
- When you have a section highlighted, and add a new calculation, the calculation is put into that section, not “Unallocated”.