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 4.5.8 - March 10, 2010

Published: March 10, 2010
reference id: QA0220


On March 10, 2010 the new version 4.5.8 is released. Download

New features and improvements

Bug fixes

  • Text » Delete all numbers in selection
    Improved. In specific situations this utility could cause problems when Excel automatically changed the value. For example a cell with a value 230 A1 was changed by Excel to 3:00 AM. Apparently this is a rare situation because this bug was only reported by one person. This is now fixed.
  • Formulas » Insert function from the ASAP Utilities library...
    Fixed the bug in the =MERGECELLS() formula. This function didn't work as expected when the parameter 'optional skip_empty_cells' was set to FALSE.
  • Vision Control...
    The option 'Apply current settings to all worksheets' produced an error if you  didn't change the zoom first with this tool: "Run-time error '1004': Unable to set the Zoom property of the Window class". This bug was introduced in version 4.5.5 and it is now fixed.
  • Range » Advanced sorting...
    Produced an error in a specific situation. The error occurred if your workbook had multiple windows, another then window 1 was active and window 1 wasn't  visible. The error was: "Error 1004: Select method or Range class failed".
    This is now fixed.
  • Text » Delete all text characters (a-z) in selected cells
    For this utility we used Excel's find/replace command, which is fast, but it drops leading zeros if all that is left is a number, such as for example BP0517.
    You can now specify to use a (slower) technique to preserve any leading zeros.
    Delete all text characters (a-z) in selected cells and preserve leading zeros
  • Export » Export selection as HTML table to clipboard...
    In Excel 2007 the amount of colors in the HTML export was limited to Excel's (pre Excel 2007) color palette of 56 colors. This is now corrected.
  • A few small bug fixes.

« back

Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us

Empowering Excel Users Worldwide for 25 Years