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.

Bug fixes in version 4.0

Date: August 28, 2006 (last updated on December 11, 2007)
reference id: QA0102


  • Information » Count duplicates in selection
    1. Now also handles cells with more than 255 characters correctly. It can now recognize cells with the maximum length of 32767 characters.
    2. Now supports multiple selected ranges (multiple areas)
  • Select » Conditional select » duplicates
    1. Now also handles cells with more than 255 characters correctly. It can now recognize cells with the maximum length of 32767 characters.
    2. Select duplicates now works when you have selected multiple areas (non-adjacent cells).
  • Information » Fast calculation
    Better calculation of duplicates and unique values. It now also handles cells with more than 255 characters correctly. It can now recognize cells with the maximum length of 32767 characters.
  • Text » Convert to upper etc.
    Keeps formulas, but converts them to uppercase (if you have text displayed). Is doesn't convert formula's to values anymore
  • Text » Start first word with uppercase.
    Now also converts the rest of the text to lowercase so for example BASTIEN becomes Bastien
  • Select » Select cells with maximum value.
    In some cases the cells with the maximum value were found but were not selected. This had something to do with the number of decimals the max value contained and the way they were displayed in Excel. E.g. a value of 21,723801267259 was displayed as 21,72380127 which didn't match when we used Excel's built in search function. We've changed the way of selecting the cell with the max value so it works in these occasions as well. It now also checks at the start if you selection contains numbers.
  • Objects/Comments » Delete all objects from current sheet
    Remove objects handles form/VBA buttons better.
  • Web » Clean web imported data...
    Remove objects handles form/VBA buttons better.
  • Favorites menu
    The cursor stays highlighted after you add or remove a tool.
    The insert and delete button have an accelerator key (Alt+i and Alt+d)
    Improved handling of the location of the favorites menu.
  • Information » Count duplicates in selection.
    In some cases duplicates weren't correctly found (numbers with decimals), and I think also depending on your computer settings (different from US/international).
  • Fill » Overwrite filled cells in selection.
    Did not work when you entered a zero (0). This is now corrected.
  • General
    Improved range rebuild when you select entire rows or columns where the first rows/columns are empty.
  • Select » Conditional column and row select, hide, delete...
    Remove duplicates in column fixed
    Hide duplicates in column fixed
  • Fill » Fill 'between values' linear in selection (horizontal)
    Didn't work, fixed it and is now working
  • Range » Paste Special (with combinations)...
    Operations (like multiply) now function too
  • Fill » Copy values to empty cells below filled cells in selection
    Resulted in an error when your selection included a cell in row number 1 and that cell was empty. This is now fixed.
  • General
    When you close Excel, and then chose "No", the ASAP Utilities menu was removed. This is now fixed. The ASAP Utilities menu will only be removed if you really closed down Excel.
  • System » Rename current file...
    When you use this tool to rename a template file (xlt) the renamed file was opened as a workbook based on the template. This is now corrected. The renamed template will be opened for editing.
  • Text » Delete leading and trailing spaces
    Fixed the bug that could incorrectly convert dates. These cells are now skipped.
  • Text » Delete leading and trailing and excessive spaces
    Fixed the bug that could incorrectly convert dates. These cells are now skipped.
  • Range » Find / replace in all sheets...
    Can now handle large text cells too that contain more than 255 characters.
  • Text » Advanced character removal
    Can now handle large text cells too that contain more than 255 characters.
  • Select » Expand selection to last row
    Now support multiple selected areas
  • Select » Expand selection to last column
    Now support multiple selected areas
  • Select » Inverse selection
    Produced an error if you cancelled the selection of a cell.
  • Information » Count unique values in selection
    Produced an error if your selection contained cells with an error.
  • Numbers » Use a significant number of decimals
    Gave an error when you used it on cells without decimals.
    The speed of this utility is increased too.
  • Range » Find / Replace in all sheets...
    Bug fixed in combination with Excel 2003.
  • System » Clear recent files list in file menu
    Used to reset the amount of recent files back to Excel's default which is 4.
    This is now fixed and your setting will be kept.
  • Objects » Select all objects on current sheet
    Gave an error if the sheet contained comments. A workaround has been made to make it work in that occasion too.
  • System » Rename current file
    If you specified a filename of a file that already existed that file was overwritten. ASAP Utilities will now ask you if you want to overwrite the
    existing file. In Excel 2000 the utility made Excel crash when the renamed file was about to be openend. This is now fixed.
  • Sheet » Copy a sheet’s page and print settings
    Fixed a bug during the startup of the utility which caused the utility not to work.
  • General
    Several minor bug fixes.
    Corrected some typing errors.





« 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