RE: EuCOM excel demo glitch
- Posted by Matt Lewis <matthewwalkerlewis at yahoo.com> Apr 14, 2003
- 531 views
[reposting from the web since it hasn't shown up in over 7 hours] > From: stabmaster_ at hotmail.com [mailto:stabmaster_ at hotmail.com] > Maybe it's just microsoft not sharing the same idea of what > rows and columns > mean, or maybe it's a mistake on your part. In any case, when > i enter a > higher value for "Row #" in the excel demo, the text moves to > the right, > while if i change the "Col #" it moves vertically (which is > the opposite of > what one would expect). Nope, this one was me. As you can see, I use RowEdit to make the column and ColEdit the row: -- get the cell row and column numbers, and format into a string cell = (getNumber( RowEdit ) + 'A' - 1) & (getNumber( ColEdit ) + '0') Matt Lewis