[KLUG Members] Spread sheet problem

[Jim C.]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Well in theory you could always write a macro that does the renaming
for you when it changes the color, i.e. name every other cell Red and
add a location designator like RedA1, GreenB2 etc.

For that matter, what we are talking about is a simple two dimensional
array.  It shouldn't be to difficult to come up with an algorithm for
traversing it.

For example:

For variables we'll have
ROW = 0;
COLUMN = 0;
MAXROW = ?;
MAXCOLUMN = ?;

#Set MAXROW to the maximum number of columns you want to use.
#Set MAXCOLUMN to the maximum number of columns you want to use.
#Note that you really don't want to use more than required as it will
#make your spreadsheet file very large if you use all of them.


Begin
~ while ROW is less than MAXROW
~   while COLUMN is less than MAXCOLUMN

~     if ( ROW is even (i.e. evenly divisible by 2))
~      Then
~        1. Change the name to
~           "Red{place Cell Letter here}{Place cell number here}"
~        2. Set the color to Red.
~      else
~      do the opposite.  This way we get a checkerboard.
~     end if
~    add one to COLUMN
~   end while

~ add one to ROW
~ end while
End

| No that would be too much work. After all why we have machine ? I want
| something concrete and instanteous.
- --

- -----------------------------------------------------------------
| I can be reached on the following messenger services:		|
|---------------------------------------------------------------|
| MSN: j_c_llings@hotmail.com  AIM: WyteLi0n  ICQ: 123291844 	|
|---------------------------------------------------------------|
| Y!: j_c_llings               Jabber: jcllings@nureality.com	|
- -----------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3-nr1 (Windows XP)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFAEuCH57L0B7uXm9oRAiuZAJ9t/PFH3js1rTyGP6Oz/pwXQULCZACfa9Az
Mb273Pn844TmdfSXCDSj08s=
=DokW
-----END PGP SIGNATURE-----