EPPS Versions Released
The below listing contains the high-level notes of changes included in the released versions of EPPS.
Version 1.15.4
New Functions
- pwrSHEETNAMES – returns the list of worksheet names from the current workbook
Enhancements
- pwrSHEETNAME updated to return the name of a specific worksheet number. The default remains to return the name of the current worksheet.
Version 1.15.3
Enhancements
- Added feature to invalidate functions, causing Excel to re-evaluate the functions as written rather than internal names.
- Updated the PowerUps tab on the Excel ribbon to be shareable with other Office PowerUps add-ins.
- Rehide worksheets tool added to allow for quick toggle between Unhiding all and then Rehiding.
- Made About button able to differentiate among Office PowerUps add-ins.
- Added color selection, line thickness, and line type to cell cross-out feature.
Bug Fixes
- Restored PowerUps tab on Excel 2007 ribbon.
- Removed ContextMenus from Excel 2007. They are not supported.
Version 1.15.2
Bug Fixes
- Link the following functions to ribbon menus.
- IFS
- pwrIFS
- MAXIFS
- pwrMAXIFS
- MINIFS
- pwrMINIFS
- SWITCH
- pwrSWITCH
- CONCAT
- pwrCONCAT
- TEXTJOIN
- pwrTEXTJOIN
- Fix MAXIFS, pwrMAXIFS wildcard matching bug.
- Fix MINIFS, pwrMINIFS wildcard matching bug.
Version 1.15.1
New Functions
- pwrSHEETNAME to return the name of the current worksheet.
- Unhide All Sheets feature added.
- Cross Out Cell(s) feature added.
Enhancements
- Context menus updated to cross out cells and unhide all worksheet tabs.
Bug Fixes
- IntelliSense information for pwrMATCH updated.
- pwrISREGEXMATCH documentation link corrected.
- pwrREGEXREPLACE documentation link corrected.
Version 1.14.1
Enhancements
- IntelliSense support from Excel-DNA added. Argument hints and descriptions are provided, similar to built-in functions of Excel.
- Dialog boxes enhanced to display version info, bitness level, and Excel version in the title bar. This is just really helpful if there are questions.
- Local activation support added in ribbon to minimize need for command prompt usage.
- pwrMATCH function can now find the ‘best’ similar match instead of just the first one.
Bug Fixes
- Some TRUE and FALSE values were returning as strings instead of Boolean type. This is fixed.
- Other minor fixes.
Version 1.13.1
Enhancements
- Improved activation of the IFS, MAXIFS, MINIFS, SWITCH, CONCAT and TEXTJOIN functions for non-Office 365 installations.
Bug Fix
- Numerous minor bug fixes.
Version 1.12.4
Bug Fix
- Fixed some intermittent activation issues.
- Added the IFS function to the drop-down menu.
New Functions
- pwrIFBLANK – returns the first value, if the first value is blank it returns the second value
- pwrIFZERO – returns the first value, if the first value is zero it returns the second value
Version 1.12.3
Bug Fix
- Fixed some instances where the About dialog was showing licensed copies as being in Trial state.
Version 1.12.2
Enhancements
- Introduction of subscriptions as a licensing option.
- Perpetual licensing unchanged.
Version 1.11.1
Enhancements
- .NET Framework updated to use version 4.5. pwrISBROKENURL supports https better now.
- Installer made more self contained. Uninstalling from Control Panel unregisters from Excel.
Version 1.10.1
New Functions
- pwrCONCAT – compatible with the CONCATENATE function
- pwrIFS – returns a value matching the first TRUE condition among multiple conditions
- pwrMINIFS – returns a value matching the smallest value among a set of conditions
- pwrMAXIFS – returns a value matching the largest value among a set of conditions
- pwrSWITCH – evaluates expressions against a set of values and returns the corresponding value of the first match
- pwrTEXTJOIN – combines text from multiple ranges, and includes an optional delimiter
Version 1.9.3
Bug fixes
- Fixed the display of license keys in the About box.
Version 1.9.1
Enhancements
- pwrRANDOMNAME has increased random name combinations to over 10,000,000 possibilities
- Updated license key validation system
- Uninstall updated to deactivate license key automatically when uninstalling or moving to another system
- Updated the ribbon button arrangement
Version 1.8.1
Bug fixes
- pwrISADDRESS fix for whitespace matching.
- pwrADDRESSPART fix for whitespace matching.
Enhancements
- About box specifies which bitness level is currently running.
New Functions
- pwrTRIM to remove extra whitespace from a string (beginning, middle, and end)
- pwrCONCATENATE to concatenate a range of cells
Version 1.7.9
Bug Fixes
- Trial expiration fix.
Enhancements
- pwrURLPART updated to pick out “PAGE” part of the URL
- pwrISBROKENURL updated to have a new optional parameter to control the page timeout value
Version 1.7.8
Bug Fixes
- Minor bug fixes for Excel 2016 and Windows 10
Enhancements
- Update to ribbon for Excel 2016
Version 1.7.7
Bug Fixes
- Minor bug fixes
Enhancements
- pwrSIMILARITY updated to allow for selected level of sensitivity in comparisons
Version 1.7.6
Bug Fixes
- Fixed 64-bit product registration bug
Version 1.7.5
New Functions
- pwrGAUSS – implementation of the GAUSS function approximation
Version 1.7.4
Bug Fixes
- Minor message update for expired trials
Enhancements
- PowerUps tab on ribbon updated to match Excel 2013 all-caps styling
- pwrISBROKENURL provides user agent string for sites detecting browser version
Version 1.7.3
Bug Fixes
- FORMULATEXT – internal parameter management issue caused #VALUE! result
- ISFORMULA – internal parameter management issue caused #VALUE! result
- NUMBERVALUE – return value as string instead of double
- pwrNUMBERVALUE – return value as string instead of double
Version 1.7.2
Bug Fixes
- Fixed uninstaller bug that prevented full uninstalls
- Added start menu option for uninstallation
Version 1.7.1
New Functions
- pwrCONTAINS – returns whether a string is found within another string
- pwrINPUTBOX – prompts for user input, and returns entered text
- pwrMESSAGEBOX – provides a visual popup with message, returns value of button selected
Version 1.6.4
Enhanced Functions
- pwrWEBSERVICE – added ability to open an XML file using the “file://” protocol
- pwrFILTERXML – added ability to open local files and directly call web services
- Registration category in ribbon updated text in “enter key” box after registration
Bug Fixes
- Minor fixes in ribbon function labeling
Version 1.6.3
Bug Fixes
- Ribbon function set made more contextual to version of Excel running
Version 1.6.2
New Functions
- SKEW.P – added to mach Excel 2013 function
- SHEET – added to match Excel 2013 function
- SHEETS – added to match Excel 2013 function
- pwrISREGEXMATCH – identify a regular expression match within a string
- pwrREGEXREPLACE – replace text identified by a regular expression
Enhanced Functions
- pwrISBROKENURL – added identification of bad URLs by Title or URL pattern (no longer limited to http status code)
Bug Fixes
- pwrISBROKENURL – bug fix
New Tools
- New version check feature to alert when updates are available
Version 1.5.2
New Functions
- pwrFETCHXMLVIAPOST – call XML web service using POST method
- pwrRANDOMNAME – generate a random name, by gender, first, last
- pwrRANDOMTEXT – generate random text, min/max words
- pwrVLOOKUP – VLOOKUP function enabled for fuzzy matching/lookup
- pwrHLOOKUP – HLOOKUP function enabled for fuzzy matching/lookup
- pwrMATCH – MATCH function enabled for fuzzy matching
Enhanced Functions
- pwrSENTIMENT – support user-defined sentiment terms
- pwrWEBSERVICE – support XML web service calls using POST method
New Tools
- Fuzzy Find and Replace – variably fuzzy search of a range of cells with various replace options
