Bug fixes in version 4.0.5

• Range » Sort random (shuffle)
  Produced an error if your worksheet had all columns used (256). ASAP Utilities needs to create a temporary extra column in order to perform its random sorting. If no extra column can be added you will now be kindly informed about this in stead of getting an error message.
• Sheet » Protect all sheets...
  In Excel XP/2002/2003: The use of the options "edit objects" and "edit scenarios" was reversed, meaning you had to turn them off in order to activate them. This has now been correct.
• Information » List all fonts in a new workbook
  Excel allows only a limited amount of formatting in a workbook. If you have a large amount of fonts installed you might run into Excels limit. I have experienced this when I had more than 500 different fonts installed. The error message has been updated to inform you about the possibility that the limit is reached.
• Select » Conditional select cells...
  Improved handling of cells with errors in your selection. ASAP Utilities could produce an error for example if you wanted to select certain cells and there were cells with errors in your selection.
• Select » Select cell in selection where value changes
  Improved. The utility could produce an error if your selection contained cells with an error.
• Import » Insert textfile (with options)...
  Used to produce an error if you cancelled the import. This is now fixed.
• Text » Convert dates...
  Remember settings improved. This now works too if for example the first two options in the to-date were empty.
• Fill » Fill empty cells in selection
  Didn't properly reset the calculation status of your workbook. For example in some cases it set the calculation status to manual and didn't turn it back to automatic.
• Export » Export selection as HTML table to clipboard...
  Used to truncate the subaddress (the part after the dash #) from a hyperlink.
  This is now corrected.
  An example of such an address is:
  download-alternative-options.php#zip
  It used to be truncated to
  download-alternative-options.php
• Worksheetfunction: =ASAPGETHYPERLINK()
  Used to truncate the subaddress (the part after the dash #) from a hyperlink.
• Text » Insert before current value...
  Now supports adding leading zeros again.
• Text » Insert before current value...
  Now supports adding leading zeros again.
• Text » Delete leading and trailing spaces
  No longer strips leading zeros from numeric values.
  Time values will no longer be converted to text-values which happened in some cases.
• Text » Delete leading and trailing spaces
  No longer strips leading zeros from numeric values.
  Time values will no longer be converted to text-values which happened in some cases.
• Text » Delete leading, trailing and excessive spaces
  No longer strips leading zeros from numeric values.
• Text » Delete number of leading characters...
  No longer strips leading zeros from numeric values.
• Text » Delete number of ending characters...
  No longer strips leading zeros from numeric values.
• Text » Delete all after n'th character...
  No longer strips leading zeros from numeric values.
• Select » Conditional select cells...
  Fixed a few bugs. Improved speed.
• Select » Conditional row and column select, hide or delete...
  New option: Select every n'th row/column number
• Sheets » Insert sheets(s) name in selected cell(s)
  This utility will now check to see if all your selected worksheets are unprotected before continuing.
• Sheets » Create an index page with all sheets (clickable)...
  ASAP Utilities will now inform you if you have an existing index sheet that is hidden.
• General
  On some computers the shortcuts did not work. This is now fixed.
• Information » Fast calculation on selected cells...
  Now shows the resulting calculations formatted in your local country settings. This also fixes the bug in the "Copy to new workbook" which produced wrong results on computes which used the point as thousand separator in stead of decimal separator.
• Select » Conditional row and column select, hide or delete...
  Fixed the error when you wanted to hide unique rows
• Format » Copy a sheet's page and print settings...
  Fixed the error that occurred when your workbook contained other sheets than just worksheets. For example you got an error if your workbook also contained a MS Excel 5.0 Dialog.
• Import » Insert text files separated
  Excel 2000 only: Improved several text-import utilities that in some cases didn't split the data correctly.
• Numbers » Delete the number of leading characters
  Fixed a bug that stopped ASAP Utilities from continueing when your selection contained cells with formulas.
  This utility will now work on both numeric and text-cells. Cells with (array)formulas in your selection will be replaced with their calculated values.
• A few minor bugfixes