logo ASAP Utilities

Receive our newsletter

Get an email when a new version of ASAP Utilities is released

RSS Feed

The new version will be announced in our news RSS feed.

Changes in version 4.0.4 - September 20, 2006

Date: September 20, 2006 (last updated on December 21, 2009)
reference id: QA0120

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 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
    tag so I reversed this change and added the tag again.

« back

Home Privacy Policy Cookie Policy EULA Sitemap Search List of all utilities Printer friendly page Contact Us ^ Back to Top
© 1999-2021 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook