New version: September 20, 2006

A new version of ASAP Utilities is just released. You can download 4.0.4, September 20, 2006.

Major reason for this release are a few bugfixes.

Thank you all for the feedback on version 4.0.3 and the preview version of 4.0.4!

Improved utilities

• Delete leading and trailing spaces
  Cells with (array)formulas and errors will be skipped.
• Delete leading, trailing and excessive spaces
  Cells with (array)formulas and errors will be skipped.
• Numbers » Spell numbers or amounts (EN, DE, NL)...
  Your last used settings will be remembered.
  If you use rupees (Rs, IRs or NRs) the currency will be listed at the front.
  This will also affect the worksheet function =ASAPSpellNumber()
  For example:
  =asapspellnumber(2450.25,"EN","TRUE","Rs","Rs",,"Paisa","Paisa Only")
  would produce
  "Two Thousand Four Hundred Fifty Rs and Twenty Five Paisa"
  but wil now produce:
  "Rs Two Thousand Four Hundred Fifty and Twenty Five Paisa"
• General
  I have changed the hotkey (accelerator) for the ASAP Utilities in the menu.
  By default this is the letter A (so you can access the ASAP Utilities menu with Alt+A.) However in some countries this conflicts with other menu items (such as &Ansicht as German for Menu). Therefore, in the following countries the hotkey is the letter S:
  . Germany (new)
  . The Netherlands
  . Sweden
  . Spain
  . Brazil
  . Portugal
• Fill » Insert before / after
  Your last used settings will be remembered.

Bug fixes

• Text » delete leading / ending characters
  In version 4.0.3 I excluded numbers from being altered by this version.
  That has now been undone, making this utility work on numeric data too.
  I thought excluding numbers was a better approach but apparently a lot of people use this utility to edit numbers too.
• Import » Merge files...
  Produced an error if you had previously used the utility on files in a folder and this folder was no longer available. This is now fixed
• Fill » Insert before / after...
  When you apply this utility to numbers ASAP Utililities will no longer convert these numbers to "textnumbers" by adding an apostrophe in front. The insert before/after on formulas has been improved too so that your formulas will stay formulas. You can now for example change a formula from =12*B4 to =12*B4+SUM(A1:A10)
• Export » HTML Export...
  In april 2006 I've changed the NOBR setting in the HTML output from <NOBR>in each cell to a stylesheet setting for each row: style="white-space : nowrap;".
  However I found out this doesn't work as good as the old-school <NOBR>tag so I reversed this change and added the <NOBR>tag again.

Thank you all for the feedback!