New version: 6 april 2006
A new beta version of ASAP Utilities is available:
3.11.x beta (6 april 2006).
In this version a bug in the protect all sheets has been fixed regarding the option to enable/disable the selection of unlocked cells. Furthermore the following is changed/added:
- Text » Advanced character removal
Besides removing the characters you can now also have them replaced with a certain character.
(This can for instance be usefull to replace all characters in a Google adwords keyword list that are not allowed (everything but numbers letters and a dash), and have them replaced by a space. Later you can use ASAP Utilties to remove all excess spaces.) - Select » Expand selection to last row
The last cell will be reset first before expanding your selection to the last row.
Will now also work on protected worksheets. - Select » Expand selection to last column
The last cell will be reset first before expanding your selection to the last column.
Will now also work on protected worksheets. - Export » Export selection as values to clipboard
Will give you a warning message if your selection contains cells with an error. You can then choose to continue or correct the errors first. - System » Close all files except the current one
Has been renamed to:
System » Close multiple files at once... - Improved progress indicators.
- Several small additions and improvements.
- Corrected some typing errors (thanks Peter!).
Harlan Chizen
The text tool that makes the first letter of each word uppercase doesn't work according to common English usage, in that it doesn't consider a punctuation mark to end a previous work. For example, johnson c.a. should be changed to Johnson C.A., but is actually changed to Johnson C.a.
Similarly, letters immediately following parentheses and hyphens are not recognized as beginning a new word, when they almost always should be. Letters following apostrophes are also not recognized, but that is usually correct.