Changes in version 4.2.6 - August 14, 2008

Finished

On August 14, 2008 the new version 4.2.6 is released. Download

New

• Text » Replace accented characters (á, ë, Ã� etc.)...
  The character ő has been added to be replaced with a normal o.
• Export » Copy sum of selection to clipboard
  Changed so that it only calculates the sum of the visible cells in case of a filtered list or hidden cells. Although the sum that Excel displays in the statusbar only skips hidden rows, ASAP Utilities will also skip hidden columns in your selection.
• Export » Copy average of selection to clipboard
  Changed so that it only calculates the average of the visible cells in case of a filtered list or hidden cells. Although the sum that Excel displays in the statusbar only skips hidden rows, ASAP Utilities will also skip hidden columns in your selection.

Bugs fixed

• Fill » Random numbering of cells (without duplicates)
  Returned an error if only one cell was selected. This is now fixed.
• Columns & Rows » Merge row data (join cells)...
  Didn't work when you entered only one or more spaces and trailing spaces were cut off. This is now fixed.
  Furthermore you can no use the utility to have the data merged without a separator at all.
• Columns & Rows » Merge column data (join cells)...
  Fixed the bug where empty cells in the first column in your selection were not ignored, despite the fact that you choose this option.
• Fill » Insert before current value...
  When you inserted a single quote (') in front of every cell, the quote wasn't visible. By default Excel uses the single quote to identify the value in the cell as text. 
  You can for example enter '3-4 in a cell and then Excel doesn't automatically change it to a date-value. ASAP Utilities will now automatically add double single quotes if you entered a singe one in the utility so that is will be visible. (This bug was introduced in version 4.2.5)
• Fill » Insert current time with seconds
  The default shortcut Control+Shift+T has been changed to Control+Alt+T.
  We weren't aware that the shortcut Control+Shift+T was used for the find function in the Italian version of Excel. In the Dutch and French version of Excel the shortcut for the find is the same as the international version, Control+F and most other languages use Control+B for the find dialog.
• Fill » List filenames in folder...
  The column 'Last Accessed' wasn't filled, now it is again.
• Columns & Rows » Advanced Transposer...
  The start-button now has the focus when the utility is started. The tab-order is now correct too.
• Fill » Copy values to empty cells below filled cells in selection
  'Text' numbers (numbers beginning with an apostrophe) were converted to regular numbers when copied down. This is now fixed.
• Numbers » Use a significant number of decimals...
  The utility was accidentally listed twice in the numbers-submenu.
• Select » Select adjacent cells below active cell with the same value
  The utility used to be based on the equal formula in adjacent cells, now it is based on the (calculated) value of adjacent cells.
• Select » Select adjacent cells in column with the same value
  The utility used to be based on the equal formula in adjacent cells, now it is based on the (calculated) value of adjacent cells.
• Range » Delete all range names in the entire workbook
  Fixed a bug where in some case difficult/corrupt names were not removed.
• Information » Count unique values in selection
  Fixed a bug when in certain situations a number too small was reported. Furthermore the utility can now also handle a larger selection and longer cell values. Unlike the previous version this utility now also includes the hidden cells in your selection. If you want the utility to work only on the visible cells in your selection then press F5 (go to..) then click on the "Specialâ€�" button and choose "Visible cells only".
• Sheets » Freeze panes on multiple sheets at once
  Fixed a bug when in certain situations the visible region wasn't set properly.
• Columns & Rows » Insert in-between empty rows or columns...
  Fixed a small bug and improved speed.
• Numbers » Convert "textnumbers" to numbers
  Fixed the bug where dates written long, such as 7/16/2008 10:09:00 AM could be converted to 'text' numbers.
• Web » Clean Web Imported data...
  Fixed the bug where dates written long, such as '2-3-2008  13:39:00' could be converted on systems with non US date settings from March 2nd to February 3rd. This error occurred if you had the 'trim spaces' option checked.
• Text » Delete leading and trailing spaces
  Fixed the bug where dates written long, such as '2-3-2008  13:39:00' could be converted on systems with non US date settings from March 2nd to February 3rd.
• Text » Delete leading, trailing and excessive spaces
  Fixed the bug where dates written long, such as '2-3-2008  13:39:00' could be converted on systems with non US date settings from March 2nd to February 3rd.
• Range » Find / Replace in all sheets...
  Improved so that it ignores other applications/add-ins during the process.
  This solves a problem the add-in XLplus could cause when also installed.
  Fixed a few bugs that could occur when the 'Range' option was selected. One if this was the 'Replace all' in the selected range performed the action on the entire sheet instead of the selected range. Furthermore, if the 'replace with' values contained the 'Find what' value, the replace action was duplicated multiple times.
• Columns & Rows » View and manage hidden rows and columns...
  Produced an error when the first cell in a hidden row or column contained an error. This is now fixed.
• Setup
  On a few computers during the setup there was an error:
  Runtime Error (at 1:145): RegSvr32 failed with exit code 0x5
  This fixed in this version.