What's new in Essential Excel Add-In 1.18.1
Jan 29, 2014
- Fixed: Issues with Find and Replace not finding all matches
- Fixed: Find and Replace file is now correctly located in My Documents folder
- Added: Option for Find and Replace to match whole words only
New in Essential Excel Add-In 1.18.0 (Jan 29, 2014)
- Added shifting of columns to Cells popup.
- Add Select Blank Cells and Select Non-Blank Cells.
- Minor corrections to Series generator.
- Selection area not limitied to used range unless a complete row or column is selected.
New in Essential Excel Add-In 1.17.0 (Jan 29, 2014)
- SaveAll now does not flick through wokrbooks.
- Enable Get and Set buttons on RegEx Helper. You can now read the the string to be examined and read/write a RegEx exression from/to a cell.
- RegEx helper now Modal so that RefEdit works.
- Replaced Find and Replace listview with two text boxes. When used, the 1st line of Find is replaced with the 1st line of replacea and so on for the 2nd, 3rd lines. You can now paste data from Excel, or load the text file (tab separated).
New in Essential Excel Add-In 1.16.1 (Jan 29, 2014)
- Added automatic update check.
New in Essential Excel Add-In 1.16.0 (Jan 29, 2014)
- Added option in Text Case Changer to replace blank cells (only) with replacement text
- Rewrote RegEx function
- Added RegEx test popup
- Integrated help into the Ribbon
- Added 'StringSub' UDF to perform string replacements
- Added 'Series' to Text Case Changer
- Added 'Append from Range' feature
- Redesign of Ribbon to include 'Text Tools' and 'Selection' buttons to make certain functions easier to access
- Made Text Case Changer button bigger on the Ribbon
- Added Cells button that brings up a popup allowing cells to be moved
- Added BlankIfZero UDF
- Added 'Delete Custom Styles' function
New in Essential Excel Add-In 1.15.0 (Sep 4, 2013)
- Added 'Replace cell contents' option in Text Case Changer. This is useful when used with Excel's FindAll dialog that allows all the matching cells to be selected.
- Added examples Workbook to the install folder to help with Regular Expressions.
- Fixed issue in Text Case Changer that caused all cells to be identified as changed.
- Added 'Edit' button to Text Case Changer which will also create the FindReplace file if it does not exist.
New in Essential Excel Add-In 1.14.1 (May 24, 2013)
- Fixed issue with Highlight Matches area check causing an error with Worksheet without spaces in the name.
New in Essential Excel Add-In 1.14 (Mar 8, 2013)
- Fixed problem detecting Worksheet in Find Matches window.
- Fixed problem causing Find Matches to not allow multiple Workbooks.
New in Essential Excel Add-In 1.13 (Feb 27, 2013)
- Added dropdown lists that act as sheet selectors.
- One in the order of the sheets and one alphabetical.
- Added support for Office 2013.
New in Essential Excel Add-In 1.12 (Feb 27, 2013)
- Added:
- Levenshtein distance (string similarity).
- SelectMostSimilar, Similarity and SelectMostSimilarVLookup UDFs.
New in Essential Excel Add-In 1.11 (Feb 27, 2013)
- Modified the RegExp code to include matches and groupings.
- Linked UDF help to the default help file location (in program files).
- Changed Add-In to create a custom UDF category.
New in Essential Excel Add-In 1.10 (Feb 27, 2013)
- Added:
- Created separate xlam for Office 2007/2010 with graphics.
- Changed:
- Removed Sync Scroll (moved to Spreadsheet Compare project).
New in Essential Excel Add-In 1.9 (Feb 27, 2013)
- Fixed:
- No error when trimming a string that is shorter than the trim value.
- Changed: \
- Replaced comdlg32.ocx with comdlg32.dll
- Added:
- Sync Scrolling function that helps synchronised scrolling of Windows.
- Support for Excel 2010.