Published: Januari 24, 2008 (latest revision Januari 21, 2009)
reference id: QA0173
Finished
On February 19, 2008 the new version 4.2.3 is released. Download
Update information
At this moment there are a few known bugs in version 4.2.2
These have been fixed in version 4.2.3 which I'm currently developing and of which you can download a pre-release: ASAPUtilities_setup_4-2-3-RC7_NoManual.exe 1.9 MB (February 14, 2008)
New
General Several minor improvements
Fill » Add leading zeros... has been renamed to: Fill » Fill up with leading zeros... We think this is a better description of what the utility does; Fill the current value with leading zeros up to the total length you specify. For example if you enter 3, the number 1 becomes 001 and 11 becomes 011. If you enter 6, the number 1 becomes 000001.
New worksheetfunction =ASAPISBOLD() Returns true of the referenced cell is bold.
Bugs fixed
Range » Find / Replace in all sheets... When you pressed the "Find all" button you immediately got Error 401: Application-defined or object-defined error. This is now fixed. (this bug only existed in version 4.2.2.)
Favorites menu Fixed the bug where in some cases you got an error stating that ASAP Utilities can't access the favorites folder.
Import » Insert (delimited) text file... Fixed the bug when imported date values where not displayed as dates (cell formatting) but displayed as numbers instead.
Fill » List filenames in folder... Fixed the bug where in column B the filename was listed including its full path when the option to create hyperlinks to the files was checked. This is now corrected.
General Several minor bugfixes The favorites menu can now be located on a network path, such as \\server2\user\data\