New
- Formula Explorer now displays R1C1 addresses when Excel is in R1C1 mode.
New
- Auto-formatting of formulas in the formula editor can be turned off.
Improved
- Better display array and spill formulas in Formula Explorer.
Fixed
- Formula Explorer throws error when a formula contains a unioned range address on another sheet ie: includes sheet name.
- R1C1 format not always processed correctly.
- ';' list delimiter not always processed correctly.
New
- Bulk equation inserts feature.
- Setting to define the number of decimal places to display in equations.
Fixes
- Calculation Sheet doesn't display subscripts/superscripts containing commas correctly.
- Bulk Equation Editor: inserting row above or column to left doesn't work correctly.
- Text transformation doesn't work correctly with some closing brackets.
- Error in Word Writer when inserting formulas as equations.
- Extra space included win equation when result is displayed, if the cell was formatted with extra space.
- When equations with multiple equations are printed, they omit the final equation.
New
- Drag and drop sheet tabs to re-organise in the enhanced sheet tabs view when orderd by default ordering (index).
- Automatically size the enhanced sheet tabs view to the required height.
Fixes
- Virtual folders for sheets not working.
- Focus not set to the worksheet when sheets changed by clicking on the sheet tabs.
- Track Active Cell setting not remembered inbetween sessions.
- Quick Navigator doesn't auto-hide after releasing CTRL+SHIFT+TAB.
- Right-clicking sheet tabs when displayed as a vertical tree makes the popup menu display and immediately disappear.
- Clicking enhanced sheet tabs doesn't work while editing a formula.
- Some settings not saved correctly.
Fixes
- High memory usage when using the Track Active Cell feature.
New
- Added settings to Math Viewer to allow specifying of display of decimal places.
Improved
- Equations displaying FormattedValue can show too many spaces.
Fixed
- Custom equation formats containing multiple equations on lines in the Math Viewer not displayed correctly.
Improved
- Capitalisation of menu items.
- Added help links to some features.
Fixed
Improved
- Capitalisation of menu items.
- Added help links to some features.
Fixed
Improved
- Improvements to UI and UX of the Style Explorer.
- Capitalisation of menu items.
- Added help links to some features.
New
- Added ability to 'focus' selected nested functions in formulas in the Formula Explorer text editor.
- In Style Explorer, add the ability to limit styles to those in (or not in) the styles in a selected range.