logo ASAP Utilities

Receive our newsletter

Get an email when a new version of ASAP Utilities is released

RSS Feed

The new version will be announced in our news RSS feed.

Changes in version 5.6 - December 1, 2015

Date: December 1, 2015
reference id: QA0282

Finished

On December 1, 2015 the new version 5.6 is released. Download

Your current license will work with all 4.x and 5.x versions.
All existing 4.x customers will get 5.x free of charge. You can use the same license details.

To upgrade, just install the new version "on top" of the existing version on your computer.
ASAP Utilities will then automatically recognize your settings and license information if you have already entered that previously.

Supported Excel versions

ASAP Utilities 5.6 works with:
  • Excel 2000
  • Excel 2002/XP
  • Excel 2003
  • Excel 2007
  • Excel 2010 (32-bit version)
  • Excel 2013 (32-bit version)
  • Excel 2016 (32-bit version)
  • Excel 365 (32-bit version)
  • On both 32- and 64-bit Windows, including the latest Windows 10.

Improved

  • Export » Export selection as HTML table to clipboard...
    The option 'Character encoding' now encodes more characters into their HTML character entities.
  • Export » Export worksheets as separate files...
    By request the following file formats have been added:
    - Text (Delimited by tilde '~') (*.txt)
    - Text unicode (Delimited by tilde '~') (*.txt)
    Export/Save worksheets as tilde (~) separated text files
  • NEW: Text » Subscript the numbers in Chemical Formulas
    This will subscript the numbers in chemical notations such as C8H10N4O2, Al(OH)3, AlF6Li3, AlO2, Al(NO3)3, Au2(SeO4)3, Ca(VO4)2, H6TeO6, KAlMg3Si3O12H2, Ca(NO3)2 4H2O, etc.
    It automatically detects which numbers should be subscripted.
    Quickly turn your chemical formulas into nicely formatted ones
  • Export » Export selection or active sheet as new file...
    You can now choose the Unicode encoding for the CSV/delimited text file format:
    - Unicode (UTF-16LE)
    - UTF-8
    Export/Save data in UTF-8 of UTF-16 text encoding
  • Improved: Import » Insert (delimited) text file...
    You can now choose the "File origin":
    - Windows (ANSI)
    - 65001 Unicode (UTF-8)
    (previously Windows (ANSI) was always used)
    Import text file; Choose file origin: UTF-8 or Windows (ANSI)
  • Select » Select cells based on content, formatting and more...
    We've added two new options. This allows you to select cells with values that are in all lowercase or all uppercase.
    - values in lowercase
    - values in UPPERCASE
    Select cells that are all in lowercase or UPPERcase - lowercase selected
  • NEW: Convert long HEX values to ASCII text in selected cells
    via ASAP Utilities Options » New tools in development (English only)
    This tool converts (long) HEX values in the selected cells to ASCII text.
    For example, it converts 
    "446f6e277420796f75207468696e6b207468617420457863656c2069732067726561743f"
    to "Don't you think that Excel is great?"
    It converts sets like the following:
    - 446f6e277420796f75207468696e6b207468617420457863656c2069732067726561743f
    - 44-6f-6e-27-74-20-79-6f-75-20-74-68-69-6e-6b-20-74-68-61-74-20-45-78-63-65-6c-20-69-73-20-67-72-65-61-74-3f
    - 44~6f~6e~27~74~20~79~6f~75~20~74~68~69~6e~6b~20~74~68~61~74~20~45~78~63~65~6c~20~69~73~20~67~72~65~61~74~3f
    - 44 6f 6e 27 74 20 79 6f 75 20 74 68 69 6e 6b 20 74 68 61 74 20 45 78 63 65 6c 20 69 73 20 67 72 65 61 74 3f
    - 44:6f:6e:27:74:20:79:6f:75:20:74:68:69:6e:6b:20:74:68:61:74:20:45:78:63:65:6c:20:69:73:20:67:72:65:61:74:3f
  • Improved: Favorites & Shortcut keys » Edit your favorite tools and shortcut keys...
    Change of default shortcuts for the following tools:
    • Ctrl+Shift+V is replaced by: Ctrl+Shift+I  - Vision Control...
    We recently discovered that recent Excel 2007+ uses this shortcut. You can use it to quickly copy the formatting from one shape to another (CTRL+SHIFT+C = Copy formatting only and CTRL+SHIFT+V = Paste formatting only.)
    Therefore we have changed these ASAP Utilities shortcuts to new ones.
    If you are upgrading then you need to press the "Reset to default values" button to have this changed, or you can manually make the changes if required:
    ASAP Utilities » ASAP Utilities Options » Edit your favorite tools and shortcut keys...
  • Improved: Import » Merge and/or import multiple files...
    You can now choose the "File origin", for example to choose if the file is in Windows (ANSI) mode or for example UTF-8 and many more.
    Up until now, Windows (ANSI) was always used by this tool.
    Merge/import text files; Choose the file origin: UTF-8 and many more
  • General
    . Better detection if Excel is started in 'embedded' mode. (Such as for example when you edit an embedded Excel table or chart from within Word or Powerpoint.) 
    . Several small improvements.

Bug fixes

  • Information » Count duplicates and give each set of duplicates its own color
    Now works on cells with (very) long cell contents too. (Previously you could get an error stating 'type mismatch' on code line 850).
  • Formulas » Change formula reference style (e.g. A1 to $A1 etc.)...
    Fixed the bug that caused array formulas in your selection to change to regular formulas.
  • File & System » Find and remove external links...
    External links to online locations (starting for example with https://) can now be removed too.
  • Improved compatibility with Excel 2013/2016
    We have created some workarounds for a few bugs (some very rare) in Excel 2013/2016 that for example could cause an extra empty Excel window, Excel being confused on what the active workbook was after you started a tool from ASAP Utilities via a shortcut, or that any tools from ASAP Utilities that you've added to the QAT (Quick Access Toolbar) were removed.
  • Startup, right-click menu
    A few users reported an error during the start of ASAP Utilities, similar to
    "Sorry, something unexpected went wrong at code line 560:
    Adding ASAP Utilities to the right-click menu: CELL
    Error -2147467259: Method '~' of object '~' failed"

    In version 5.5.1 the most popular tools added are added to the right-click/context menu for:
    - cells
    - column headings
    - row number
    - sheet tabs
    However, somehow that returned an error on the computers of a few users.
    This is now fixed by using a workaround for those situations.
  • General
    A few small improvements and bug fixes.





« back

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook