Test of all top row characters copied from Word into comment window
`1234567890-=~!@#$%^&*()_+ 2nd row Qwertyuiop[]QWERTYUIOP{}| 3rd row Asdfghjkl;?ASDFGHJKL:? 4th row Zxcvbnm,./ZXCVBNM<>?
posted by Posting Format Test on 02/11/09 at 11:20 AM
|
TEST FOR MAKING A LIST
JAN 0927409 FEB 4593975 MAR 5739058 APR 9589037 MAY 7903775 JUN 409248 JUL 82-84208 AUG 58-0830485 SEP 095480-348 OCT 209380-284 NOV 058038058 DEC 85-0385-03
posted by Posting Format Test on 02/11/09 at 11:34 AM
|
Test for writing text that is illustrated with data like this: The Primary Colors RED: roses, apples and cherries BLUE sky, moons, notes YELLOW bananas, lemons and the sun
Then we move on to the classical elements EARTH as in, terra firma WATER as in the seas FIRE as in the bowels of the volcano AIR as in the space around us
And did this work?
posted by Posting Format Test on 02/11/09 at 11:43 AM
|
Test for using the tab key
data
posted by Posting Format Test on 02/11/09 at 11:44 AM
|
tab key movement was not recognized try again
posted by Posting Format Test on 02/11/09 at 11:45 AM
|
test for columns one two three 123 123 123 456 456 456 789 789 789
posted by Posting Format Test on 02/11/09 at 11:46 AM
|
columns were separated, in each line by hitting the space bar 8 times, but the characters appeared with only one space between entries
posted by Posting Format Test on 02/11/09 at 11:47 AM
|
try again with dots ONE........TWO........THREE aaa........aaa........aaa sss........sss........sss ddd........ddd........ddd fff........fff........fff
posted by Posting Format Test on 02/11/09 at 11:49 AM
|
worked until the letter "F" probably because it is narrower than the others
posted by Posting Format Test on 02/11/09 at 11:50 AM
|
now with number values
YEAR........Quantity........Rate 2000........4444............3.3 2001........5555............6.6 2002........6666............7.7 2003........7777............8.8 2004........8888............9.9
posted by Posting Format Test on 02/11/09 at 11:53 AM
|
now lets see if it can be pasted now with number values
YEAR........Quantity........Rate 2000........4444............3.3 2001........5555............6.6 2002........6666............7.7 2003........7777............8.8 2004........8888............9.9
posted by Posting Format Test on 02/11/09 at 11:55 AM
|
testing export of data from Excel
Temperature Wind Humidity 23-Apr 11:40 67.6 66.5 68 2N 12W 21N 41 37 30 7-May 2:45 76.8 75.8 73.4 2S 2NNE 5N 30 27 29
posted by Posting Format Test on 02/11/09 at 11:56 AM
|
cell format was ignored
posted by Posting Format Test on 02/11/09 at 11:56 AM
|
another import from Excel, using dots as separators
YEAR??.. Quantity??.. Rate 2000??.. 9999??.. 5.5 2001??.. 8888??.. 6.6 2002??.. 7777??.. 7.7 2003??.. 6666??.. 8.8
Then some added text at the bottom
posted by Posting Format Test on 02/11/09 at 11:59 AM
|
those pesky question marks again
posted by Posting Format Test on 02/11/09 at 11:59 AM
|
that was with the dots in same cell as values, now trying dots with their own cells
YEAR ??.. Quantity ??.. Rate 2000 ??.. 5555 ??.. 4.4 2001 ??.. 6666 ??.. 5.5 2002 ??.. 3333 ??.. 6.6 2003 ??.. 7777 ??.. 7.7
how does this look?
posted by Posting Format Test on 02/11/09 at 12:14 PM
|
can't seem to get rid of the ??s
posted by Posting Format Test on 02/11/09 at 12:14 PM
|
this import from Excel has the cell format changed to text YEAR ??.. Quantity ??.. Rate 2000 ??.. 5555 ??.. 4.4 2001 ??.. 6666 ??.. 5.5 2002 ??.. 3333 ??.. 6.6 2003 ??.. 7777 ??.. 7.7
posted by Posting Format Test on 02/11/09 at 12:18 PM
|
drat
posted by Posting Format Test on 02/11/09 at 12:18 PM
|
this table has the dots separated with spaces
YEAR . . . . . . Quantity . . . . . . Rate 2000 . . . . . . 5555 . . . . . . 4.4 2001 . . . . . . 6666 . . . . . . 5.5 2002 . . . . . . 3333 . . . . . . 6.6 2003 . . . . . . 7777 . . . . . . 7.7
posted by Posting Format Test on 02/11/09 at 12:19 PM
|
well, what do you know? I got rid of the ????s
now, to fix the alignment:
YEAR . . . . . . . . Quantity . . . . . . . . . Rate 2000 . . . . . . . . 5555 . . . . . . . . . 4.4 2001 . . . . . . . . 6666 . . . . . . . . . 5.5 2002 . . . . . . . . 3333 . . . . . . . . . 6.6 2003 . . . . . . . . 7777 . . . . . . . . . 7.7
That's with eight dots in one column, then nine in the other
posted by Posting Format Test on 02/11/09 at 12:22 PM
|
first row has to have fewer dots, so those two cells have six
YEAR . . . . . . Quantity . . . . . . Rate 2000 . . . . . . . . 5555 . . . . . . . . . 4.4 2001 . . . . . . . . 6666 . . . . . . . . . 5.5 2002 . . . . . . . . 3333 . . . . . . . . . 6.6 2003 . . . . . . . . 7777 . . . . . . . . . 7.7
posted by Posting Format Test on 02/11/09 at 12:24 PM
|
BINGO
posted by Posting Format Test on 02/11/09 at 12:24 PM
|