Postby ConvertFromOldNGs » Fri Aug 07, 2009 10:43 am
by Stephen Persson >> Thu, 13 Jul 2000 0:07:21 GMT
Hmmm... where does one start
This biggest thing I would like to see if the ability to be able to enter text into the cells EASILY without a whole lot of messy code in the background trying to handle it all.
In particular:
* The ability to have a combination of Input Types.
In my case type None & TextNumeric. If I click on a cell I want the whole thing selected (type = None) when I start typing I want the type TextNumeric. However putting a type change on , say, the keyDown event, doesn't exactly work - you end up with the first char at the end of your typing - Eg elloh instead of hello. You also want to check the key pressed isn't a navigation key (up, down, left, right) or a key such as Alt, Shift or Ctrl before you clear the text in the cell and make it of type TextNumeric.
It just gets toooo messy.
* The selStart would also be nice to have - so you can progmatically put the cursor straight to the end of the cell text (when type = TextNumeric).
* Be nice to be able to overwrite the Tab key. I know Tabs go between controls and thats what they are supposed to do - but if you have a table with cells of type TextNumeric the left/right keys move along the text. So if you want to go to the next cell it scrolls all the way along the text then once its at the end goes to the next cell. No matter what you put in the keyPress event it won't do a thing with the Tab.
We have an app that has a lot of code numbers that need to be entered in, and this is a big complaint from the speed typists!
* Multiple lines of text in cells are difficult to use. Once the cell has the focus you can no longer see all the lines - only the line you are on. A bit of a nuisance if you want to check your text furthur up. The easiest way is to change cells so the whole lot is shown - then go back to the cell again - not nice.
When a multiple lined cell gets the focus it always puts the cursor at the end of the paragraph (or was it the beginning? can't recall sorry) - navigating around the paragraph you want to alter, is then a nightmare. Basically it would be nice to have all the text shown all the time, and let you click anywhere in the text to edit it.
My point in all this is that they are extremely messy to try and do nicely.
That'll do for now...
Stephen