A new version of ASAP Utilities is in progress. You can download 4.0.4 preview, September 19, 2006:
ASAPUtilities_setup_4-0-4-preview.exe (1.1 MB)
Depending on the feedback I will release this version officially withing a couple of days.
Major reason for this release are a few bugfixes.
Improved
- 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)...
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"
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> again.
Thank you all for the feedback!