Changes in version 4.5.6 - December 22, 2009

Finished

On December 22, 2009 the new version 4.5.6 is released. Download

New/improved

• NEW: French language added
  All the tools are now also available in the French language (Français).
  If you have the French language of Excel then ASAP Utilities will now start in French.
  You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities Options » Settings, language and contact information......
  Note: Only ASAP Utilities itself it translated at this moment. The setup is still in English and so is our website.

French Excel 2000, 2002/XP or 2003 with the new ASAP Utilities in its menu


French Excel 2007 with ASAP Utilities in its menu

• Improved undo
• Numbers » Spell/write out numbers or amounts (EN, DE, NL)...
  If you used rupees (Rs, IRs or NRs) the currency would be listed at the front.
  We now do this for the fully written currency "Rupee" as well.
  This will also affect the worksheet function =ASAPSPELLNUMBER()
  For example: =ASAPSPELLNUMBER(2450.25,"EN","TRUE","Rupee","Rupee",,"Paisa","Paisa Only") would produce
  "Two Thousand Four Hundred Fifty Rupee and Twenty Five Paisa"
  but wil now produce:
  "Rupee Two Thousand Four Hundred Fifty and Twenty Five Paisa"

Bug fixes

• Columns Rows » Remove unused empty ending rows/columns
  Added a workaround to have it work with some specific files too.
• Text » Delete number of leading characters...
  Updated so that leading zeros are preserved when the result is something such as -003.
• Text » Delete number of ending characters...
  Updated so that leading zeros are preserved when the result is something such as -003.
• Text » Delete all after a given number of characters...
  Updated so that leading zeros are preserved when the result is something such as -003.
• Range » Advanced sorting...
  The undo for this tool is working again. Since version 4.5.1 undo didn't work anymore.
• A few small bugfixes and improvements.