On Sunday 09 September 2007 04:07:20 Diabolic Preacher wrote: > On 9/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > On Sunday 09 September 2007 01:58:03 Diabolic Preacher wrote: > > > > This could be done in OOo by setting up a short cut key that > > fires Enter and Home. The cursor would move down and back to > > the 1st column. > > what if your table doesn't start at column A? excel does detect > the first heading cell. if you have worked with the solver tool > in ms excel which needs you to prepare 2 tables like in > transportation model linear programming problems, students are > bound to randomly build a table anywhere on the sheet. yet the > shift back to first column of the table and not the entire sheet > is possible in ms excel. > > i was trying to find abnormalities in the excel behavior. ways to > make it fail. searching for the observations it made. my > observations: - 1. the cursor detects the left most occupied cell > in the rows above the current row. if your header row is c4 to > g4. the cursor will keep coming back to c column after entering > data under g column. if at say c7 you press shift+tab and move to > the b column (b7). and enter data till g7 (or even further), > pressing enter at this point takes you to b column and not to c > column anymore. think of cases where you might want to add some > text (as a table label) in a cell on the left of where you made a > table to just mark what that table is for. the special feature of > excel doesn't work as intended. it keeps goin back to the left > most cell. > 2. After entering few rows. press enter (in c column) a few times > to move down say 5-6 rows and try entering a row of data n > pressing enter. it still goes back to b column. > 3. now using your mouse, click on a cell 10 rows further below in > say e column and test the feature. make a 4 table column n as you > press enter, it moves back to the next row but in e column. not > in c or b column. > > its not just a simple enter and home key combo. > > it'll be good if more and more people could test for > abnormalities or 'catches' in this feature.
You are correct the combo I was talking about using will only work if the data starts in column A. Once again you are correct with your findings. -- http://24.197.142.167/ See the OpenOffice.org FAQ Microsoft users go to http://www.pclinuxos.com for a great user friendly Linux experience! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
