Excel PowerUps Premium Suite Update History

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

Leave a Reply

Your email address will not be published. Required fields are marked *