How to enter letter "C" to cell?

[ioscat]

It seems to run system process that clears cell.

[Alan Kirk]

It seems to run system process that clears cell.

Yes, that's one that really grinds my teeth. It came about because someone finally agreed with the user base that having C alone as the Clear command was, shall we say, a little bit dangerous.

What did the user base ask for? (Or at lest several members of it that I know of, including me.) A multi-key command for the clear function so that it couldn't be executed accidentally.

What were at least some of us told that we were going to get? A multi-key command for the clear function so that it couldn't be executed accidentally.

What did we get? Someone who knows far better than the users who actually need to, well, use the product gave us that stupid sodding confirmation dialog which, as you have found, makes entering C into a cell pretty much impossible.

In 9.0 the input is... sorry, was... smart enough to distinguish between a numeric and a string cell. In 9.5.2 it's not. I thought that you did once have the option of entering multiple characters, and then editing the cell, backing out everything but a single "C" but that's not working in my 9.5.2 session. I imagine that that was "fixed" to show the accursed dialog whenever the entry ends up being a C.

The only options that leaves are:
- Do it by a DBSS formula;
- Use the Bulk Paste function of TM1 Tools in a slice; or
- CellPutS in TI.

But hey, don't worry, I'm sure that IBM are working on a shiny new Java App which will do this very thing, and will only take 3 minutes and two confirmation dialogs to launch. At which point they will raise their hands in victory and declare "Problem! Solved!" and pretend that they never heard anything about the multi-key solution discussed above.