Version 4.1.1 - May 7, 2007

Finished

On May 7 the new version 4.1.1 is released. Download

Update information

At this moment there are a few known bugs in version 4.1.0
These have been fixed in version 4.1.1 of which you can download a pre-release:
ASAPUtilities_setup_4-1-1-RC6.exe

Bug fixes:

• Numbers » Round numbers (not formatting, but changing)...
  If you entered a zero the operation was incorrectly canceled.
  This is now fixed so you can round numbers to zero decimals again.
• Columns / Rows » Put together rows or columns from several sheets...
  Didn't work and produced an error if one of the selected sheets was protected.
• Import » Merge files together in a new file...
  Accidentally canceled the operation when you clicked on the 'Pick files and merge' button (After selecting the files you received the error "You cancelled the operation"). Furthermore the import didn't work as expected in Excel 2000. These two bugs were introduced in version 4.1.0 and are now fixed.
• Select » Conditional select cells...
  Select all numbers between two values, for example all between 1 and 50, didn't work. This is now fixed.
  Select non-empty cells didn't select cells with formulas. This is now corrected
  Select cells with a certain font-size didn't work. This is now fixed.
• Numbers » Use a significant number of decimals...
  Improved.
• Range » Paste special with combinations
  Fixed a few bugs that were related to the arithmetic operations
• Text » Convert dates...
  Better handling/support of dates with month names (mmm and mmmm)
• General
  A few small bug fixes.

New/improved

• Columns / Rows » Put together rows or columns from several sheets...
  Improved, now also copies the original column widths to the new sheet
• Columns / Rows » View and manage hidden rows and columns...
  Display the column titles along with the column numbers
• Select » Select cells in column with same value (above and below active cell)
  Has been renamed to:
  Select » Select adjacent cells in column with the same value
  Now works on protected sheets too.
• Select » Select cells in column with same value (below active cell)
  Has been renamed to:
  Select » Select adjacent cells below active cell with the same value
  Now works on protected sheets too.
• Format » Insert filename in header or footer...
  has been renamed to:
  Insert workbook's path and name in header, footer or cell...
  This utility is now also placed in the Fill submenu
• Export » Copy sum of selection to clipboard
  Copy the calculated sum of selected cells to your clipboard.
  Just like you can see in the statusbar of Excel.
• Export » Copy average of selection to clipboard
  Copy the calculated average of selected cells to your clipboard.
  Just like you can see in the statusbar of Excel.
• Import » Merge files together in a new file...
  I've added the option to exclude the file extensions (such as .dbf or .txt) from the sheetnames.
• System » Resize the Excel application...
  Resize the Excel application to fixed screen resolutions. This way you can easily test and see how your document or application will look on computers with different screen resolutions. However, the maximum size is limited (by Excel) to your current screen-resolution.
  
• Columns / Rows » Merge column data (join cells)...
  This utility now remembers your last used settings
• Columns / Rows » Merge row data (join cells)...
  This utility now remembers your last used settings

This new version will probably officially released as a new version before the end of March at the start end of April start of May.