Release Notes

Historical versions are not available for download unless specifically requested by corporate clients.

For information on how to upgrade from an existing version, visit the upgrade page.

Version 0.9.90

[30 May 2024]

LATEST

Fixed an issue whereby a range with more than 100 columns would fail to load the Array Evaluations window
Fixed an issue where the Formula Tree window would fail to load under certain circumstances

Version 0.9.89

[05 Mar 2024]

Fixed an issue affecting a small number of users during Excel start-up
Now targeting .NET Framework 4.6.2 instead of 4.6.1

Version 0.9.88

[21 Feb 2024]

Internal changes only.

Version 0.9.87

[20 Feb 2024]

Fixed an issue when the characters '<' or '>' appeared as text in a formula, that formula would fail to format in the Formula formatter taskpane.
Formula editor line number gutter now has a fixed width.
Formula editor collapse function marker buttons now have a different background color than the expand buttons.

Version 0.9.86

[15 Feb 2024]

Light ribbon icons are now used for Excel theme DarkGray. This is a better match than the dark icons.
Changing the theme will now also change the ribbon icons to match the current Excel theme. Previously, if the Excel theme changed, restarting Excel was required to make the FormulaBoost ribbon icons match.
The XLL files are now code signed. Previously only the MSI file was code signed.

Version 0.9.85

[11 Feb 2024]

Added support for formatted formulas in the Formula Tree window
Added 'Pane orientation' option to Formula Tree window
Added 'View array evaluations' option to context menu for 1D and 2D array evaluations in Formula Tree window
Added refresh button to Formula Tree window
Added refresh button to Formula Tree window
Added 'Expand all active nodes' to the context menu that appears at the bottom of the Formula Tree
Added Formula bar interaction feature; you can now press F2 on any row in the Formula Tree and the corresponding portion of the formula in Excel's formula bar will be highlighted
Added new option 'Show range/array values' which allows you to view array values in their condensed, ie. {a,b,c,..}, format
Added a new column 'Info' to the Formula Tree which displays the argument name of the Excel function and when clicked on, will launch Excel's Function Argument window for the respective function and highlight the corresponding argument
Added Function collapse feature in the Formula Editor
Added License Transfer dialog
Added a 'Format formula on load' option to the Formula Tree
Added 'FormulaEditor - Formatting' options panel to Formula Tree window; all formatting options from the Formula Formatter task pane are now available within the Formula Tree
Added 'Show added spaces' and 'Show indentations' and 'Show bracket lines' options to the Formula Tree
Added 'Reset' button Formula Tree which restores all Fomula Tree options to their default values
Added 'Simple Functions on one line' option to Formula Tree and Formula Formatter task pane
Added a new icon for LET function name tree nodes; previously they had no image
Added option 'Show extra brackets in formula' to Formula Tree
Added new Excel functions for arrays and text functionality, eg. REDUCE, WRAPCOLS, ARRAYTOTEXT etc.
Added support to parse functions with long ranges like ABC:ABC
Formulas such as INDIRECT("A1"):A10, ie. when reference type functions are used in a range syntax, can now be parsed
RefersTo column of the Formula Tree window now underlines the sheet reference text when hovered and clicking on the text will select that cell/range
Hash operator (#) now works with named ranges and structured references
RefersTo column of the Formula Tree now shows the workbook name for sheet references belonging to workbooks other than the current workbook
Autosize on reload no longer triggers when the Formula Tree window is moved
'Combine operators with next node' Formula Tree option now defaults to false
Formula Tree option 'Spaces between function brackets' now default to false
Formula Topography ribbon icon now changes to match the current topography type
Replaced Formula Editor 'Vertical spacing' combo box option with checkbox option 'Compact line height'
If the workbook is saved with formula topograhpy currently active, the topography is now turned off prior to saving
Change of Formula Topography type is reflected immediately when active
If Show legend ribbon button is checked on and Formula Topography is active, the legend is now shown immediately
Format option 'LET function parameters on same line' now works when functions are nested on that line
IFERROR function now reflects Inactive node coloring
Changed default value of 'Inactive row style' option to 'Block effect' from 'Solid tree lines'
Changed 'Show vertical gridlines' option default value to true
Changed default font type of Formula Editor from Courier New to Consolas
Changed default 'Spaces between brackets' option of Formula Editor from true to false
Changed 'Multiselect' Formula Tree option default value to false
Changed default option 'Show empty cell' to (0 grey)
Removed Formula Tree context menu option 'Open in secondary editor' which has not yet been implemented
Removed option 'Interact with Excel (non-modal) and set to true always
Removed option 'Autosize on load' of Formula Editor options
Removed options 'Function error coloring', 'Formula error coloring', 'Cell error coloring' and replace with single option 'Error underline coloring'
Removed Formula Tree context menu option 'Expand all dependent cells (max depth 25)' since it was never implemented
Removed option 'Show range as' and moved range/array size information from the Value column to the Info column of the Formula Tree
Removed the CurL (current length), CurN (current node), CurD (current depth) info in bottom bar of the Formula Tree window
Improved formatting of prefix operators, eg in "=-1+2" a space will no longer be added between the "-" and "1" during formatting
Improved how prefix operators behave in the Formula Tree; they will now always appear in the row of the element they affect
Improved the accuracy of the classification of unnecessary vs necessary brackets
Improved the interactions of format text options 'Spaces between operators' and 'Spaces between brackets'
Improved performance and ability to evaluate extremely long formulas
Improved formula parsing performance by about 60%
Improved alignment of the shortcut key text in context menus
Improved tree icons of both light and dark themes
Fixed an issue where negative numbers in constant array arguments would not properly appear in the Formula Tree
Fixed an issue where formatting a formula from the formula bar would toggle the num lock key
Fixed issue with structured references that would occur when their evaluations would fail and return #VALUE! if the same structured ref was used more than once
Fixed an issue whereby sometimes the Formula Tree back navigation button would incorrectly be disabled
Fixed an issue where named ranges referring to other named ranges would fail to evaluate in the Formula Tree and return the unhandled error node
Fixed an issue where partial formulas of function nodes whose formula length was longer than 255 charachter would fail to evalulate in the Formula Tree
Fixed an issue where loading the formula of a named range using the 'Load in new window' context menu option would sometimes crash
Fixed an issue where the 'Select cell/range' context menu option would select the incorrect cell under certain circumstances
Fixed an issue where formulas with a prefix after an operator but before a constant array would fail to format, eg. =1*-{1,2,3}
Fixed an issue where negative signs preceeding some tree node formula text would not have an effect on the evaluation
Fixed an issue where the intersection operation would incorrectly receive extra spacing next to it during formatting
Fixed an issue where the Formula Tree window would appear on the unused monitor when launched for the first time
Fixed an issue where the Formula Topography legend window would appear on the unused monitor window if using multiple monitors
Fixed a crash that would occur under some circumstances when using the 'Expand all nodes at this level' context menu option (Shift+Right)
Fixed an issue with Formula formatter task pane that sent a formula with indentations to the cell when 'Use line breaks' was checked off
Fixed an issue where brackets around a constant array would fail to format, eg. =({1,2,3,4})+1
Fixed the Formula Tree context menu option 'Expand active children only' to expand active and not inactive children
Fixed issue in Formula Tree where Ctrl+N and Ctrl+L in tree did not trigger their respective actions
Fixed an issue where RefersTo column of LET function name parameters were not updating properly, ie LET(x,A1,x+10), the tree node of the second x was not showing RefersTo A1
Fixed an issue where named ranges converted to Excel tables (list objects) would return the unhandled error tree node
Fixed a crash that would occur in Formula Tree window 'Load in this window' context menu option that would occur under certain conditions

Version 0.9.84

[27 Mar 2023]

Combined Formula Highlight feature with a new and more powerful feature called Formula Topography
Formula Formatter now supports using semi-colon as list separator (previously only supported commas)
Fixed issue in Formula Tree with structured references such that sometimes their intermediate evaluations would fail
Fixed issue in Formula Tree such that intermediate evaluations of the function UNIQUE() when all arguments are empty would fail
Added Ribbon menu button Change Theme
Added Ribbon button Shortcut Keys
Added Ribbon button Check for Updates
Added Ribbon button Feedback
Added Ribbon button Activate
Added Ribbon button Parse Online

Version 0.9.83

[05 Feb 2023]

Fixed issue where named ranges such as "A1A1" would fail to format
Changed Formula Tree options pane visibility default value to 'Last visible' and for new users, it defaults to hidden
Formula Tree 'RefersTo' column now defaults to visible
Formula Tree 'Value' and 'RefersTo' column now default to right align
Reduced Formula Tree form size for new users
Added option 'Draw cell reference outlines on sheet' to Formula Formatter task pane, which colors cells that are part of the formula on the active sheet
Improved scroll behaviour of the Formula Formatter task pane
Added basic selection interaction behaviour to Formula Formatter task pane
Formula Formatter task pane dark theme now applies to scroll bars
In non-modal mode, Formula Tree window no longer becomes hidden when Excel becomes the active window
Formula Tree option 'Autosize on load' now default to true
Formula Tree option 'Autosize on resize' now default to false
Removed Formula Tree editor option 'Additional line'
Removed Formula Tree editor option 'Minimum row count'
Added Formula Formatter task pane option 'Use white background for light theme'
Added Formula Formatter task pane option 'Use line breaks'
Renamed 'Highlight Formulas' ribbon button to 'Formula Highlight'
Renamed 'Formula Task Pane' ribbon button to 'Formula Formatter'
Renamed 'Analyze Formula' ribbon button to 'Formula Tree'

Version 0.9.82

[31 Dec 2022]

Fixed issue where multi column array formulas would sometimes failed to format
Fixed issue where two or more unnecesary brackets would fail to format
Improved accuracy of the determination of necessary vs unnecessary brackets
Added sheet reference coloring to formula formatter taskpane and option to disable it
Removed formula tree option 'Save options for this Excel session only'
Moved 'Highlight Formulas' ribbon button next to 'About' button
Added information to formula metrics, including white space characters, net effect of formatting formula, sheet reference breakdown
Added button to formula formatter taskpane that removes all unnecessary whitespace from formula and sends that formula to cell
Added link to release notes webpage when a new version is available for download
Installer now requires .NET Framework version 4.6.1, up from 4.5.2
Dropped support for Excel 2007

Version 0.9.81

[17 Nov 2022]

Fixed issue where FormulaBoost logo failed to appear in certain windows

Version 0.9.80

[10 Nov 2022]

Added formula formatter task pane
Added application level theme support
Added support for # symbol in formulas for dynamic arrays
Constant array arguments now receive their own formatting
Improved support for Excel LET function in formula tree

Version 0.9.70

[12 Jun 2022]

Internal updates and performance improvements

Version 0.9.60

[04 May 2021]

Internal updates and performance improvements

Releases prior to 0.9.60 are not listed on this page.