View Single Post
Old 09-16-2013, 02:52 PM   #5
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,476
Karma: 8025702
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Lady Fitzgerald View Post
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).

Last edited by chaley; 09-16-2013 at 02:59 PM.
chaley is offline   Reply With Quote