Quote:
Originally Posted by Lady Fitzgerald
Ok, the justification issue is settled (that was a "duh!" moment). I discovered a problem with using an integer column. It sorts the numbers the way I want without the use of leading zeros (the leading zeros look junky and make reading a list of numbers harder) but, once I click on a row in the column, it will insert a zero and won't let me delete it. Same if if I put in a number in a row; I can't delete it. Adding insult to injury, if I, say, enter 112, then want to change it to 212, I would have to scroll thought every number between; it won't just let me highlight the number and change it.
Any ideas on how to deal with this?
|
If I click on a int cell and press F2 to edit it (I have turned off click-to-edit), I can type any number I want. If I hit escape, the editor closes without changing the cell, even if I had typed in it or even if it changed from empty to the initial zero. If when I click on the cell it contains, for example, 259, that number is selected and it is erased when I type something. If I am editing a cell and type Ctrl-A, all the contents are selected and the next thing I type overwrites it all. Are you saying that none of this works for you? Edit: I re-enabled click-to-edit and it behaves the same.
To return a cell to undefined, enter -100000 (negative one million).