Your Add-in is awesome! I have no idea why Microsoft has not added this functionality built-in.
Just a couple of quick notes\suggestions.
Issue 1: It looks like Capitalize Each Word only works if you do one of the other functions first.
Issue 2:
It takes an extended amount of time (sometimes more than 30 secs) when selecting by column (as most people do) and running the functions. I think the delay comes from trying to execute the function on the entire col regardless of if the data only goes down part of the way (as most spreadsheets do). I'm sure the delay comes from the function taking the time to execute on all the selected cells, even if they are blank. When manually selecting down to just the bottom of the data, the function is much faster.
The tricky part is how to get the function to select just the data range in typical selection scenarios (so the user dosn't have to). I can't find a keyboard way to do that (even with endmode, or all the Home\End\Arrow combinations) when the cols are not full. In the sample data set below I show a couple of the tricky scenarios.
-
I would want to select Col B and execute the function only on rows 1-3000. The blank rows in Col B prevent any End+Down type selections.
-
I would want to select Cols R and S and execute the function only on R1...S3000 (and make sure to get R3000). The blank cell at the bottom of Col S prevents proper End+Down type selection to catch R3000.
Example:
| Ex: |
A |
B |
... |
R |
S |
T |
| 1 |
x |
x |
|
x |
x |
x |
| 2 |
x |
x |
|
|
x |
x |
| ... |
|
|
|
|
|
|
| 232 |
x |
x |
|
x |
x |
x |
| 233 |
x |
|
|
|
|
x |
| 234 |
x |
x |
|
x |
x |
x |
| ... |
|
|
|
|
|
|
| 2999 |
x |
x |
|
x |
x |
x |
| 3000 |
x |
x |
|
x |
|
x |
Your Add-in is awesome! I have no idea why Microsoft has not added this functionality built-in.
Just a couple of quick notes\suggestions.
Issue 1: It looks like Capitalize Each Word only works if you do one of the other functions first.
Issue 2:
It takes an extended amount of time (sometimes more than 30 secs) when selecting by column (as most people do) and running the functions. I think the delay comes from trying to execute the function on the entire col regardless of if the data only goes down part of the way (as most spreadsheets do). I'm sure the delay comes from the function taking the time to execute on all the selected cells, even if they are blank. When manually selecting down to just the bottom of the data, the function is much faster.
The tricky part is how to get the function to select just the data range in typical selection scenarios (so the user dosn't have to). I can't find a keyboard way to do that (even with endmode, or all the Home\End\Arrow combinations) when the cols are not full. In the sample data set below I show a couple of the tricky scenarios.
I would want to select Col B and execute the function only on rows 1-3000. The blank rows in Col B prevent any End+Down type selections.
I would want to select Cols R and S and execute the function only on R1...S3000 (and make sure to get R3000). The blank cell at the bottom of Col S prevents proper End+Down type selection to catch R3000.
Example: