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.8.0 - October 26, 2011

Published: October 26, 2011 (latest revision August 28, 2012)
reference id: QA0244


On October 26, 2011 the new version 4.8.0 is released. Download

New features and improvements

Bug fixes

  • ASAP Utilities » Columns & Rows » Drawing paper
    With French regional settings in Windows this tool gave an error. This is now fixed.
    In Excel 2007 and 2010 when you had selected the entire sheet and started this utility it raised an error. That is now fixed.
  • Sheets » Freeze panes on multiple sheets at once
    When you have only selected one single sheet, ASAP Utilities selects them all for you, but that gives an error if you have any hidden sheets in your workbook. This is now fixed by automatically selecting only the visible sheets.
  • Web » Activate hyperlinks (create from cell values)...
    In version 4.7.2 we have updated this tool so that it automatically adds http:// in front of hyperlinks if needed. However if you link to a file and the link doesn't start with a drive or folder letter, it is treated by the tool as an internet hyperlink and http:// is automatically placed in front of it.
    We've have now updated the tool by using a better detection for internet hyperlinks.
  • Format » Detect and visualize adjacent data/group changes...
    Didn't work if your selection contained cells with an error. This is now fixed.
  • Range » Count and/or color duplicates in selection...
    Could produce an error if you had selected multiple non-adjacent columns. This is now fixed.
  • Columns & Rows » Put together rows or columns from several sheets...
    Fixed the bug that caused your chosen range to expand if your given columns or rows included merged cells.
  • Select » Select cells based on content, formatting and more...
    "When using "Select cells based on content, formatting and more..." and finding no cells matching the search criteria, I expect no cells to be selected.
    But in fact all cells from A1 to End-of-Sheet are selected!"
    If you have a single cell selected and then start the utility, the tool then assumes that you want to search in the entire workbook and pre-selects that. However, if no matching cells are found the entire sheet was still selected. This is now fixed.
  • Sheets » Split the selected range into multiple worksheets...
    Fixed the following bug:
    "When I use the tool Sheets->Split the selected range into multiple worksheets to split selection by number of rows (option: For every so many rows) and my selection doesn’t start in the first row of the sheet there is an error:
    The first newly created worksheet doesn’t contain the first couple of selected rows (depending on how far the selection is from the top of the sheet).
    For example, if I want to split range A3:A12 (10 rows) into two sheets with 5 rows each, the first two rows are lost."
  • Export » Export selection or active sheet as new file...
    Fixed the bug that caused the export to the clipboard as TAB delimited to be empty.
  • Export » Export worksheets as separate files...
    Fixed the bug that could sometimes appear with very large files:
    "Sorry, something unexpected went wrong at code line 800: Error 6: Overflow".
  • Undo
    Fixed two bugs that we found (but so far have never been reported).
    Improved reliability for the undo when your worksheet/selection was filtered.
    If the worksheet contained an autofilter and frozen panes then the freeze pane settings could become altered in some cases due to an Excel bug. This is now fixed.


« back

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

Empowering Excel Users Worldwide for 25 Years