/ Prima Shareware 3 / DuCom_Prima-Shareware-3_cd1.bin / PROGRAMO / PASCAL / OOGRID / EX_LIST1.OGL

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 4c 04 00 00 00 00 50 00 | 17 00 00 00 00 00 1f 20 |L.....P.|....... |
|00000010| 00 00 09 00 c3 00 ff ff | 04 00 27 4e 01 00 01 00 |........|..'N....|
|00000020| 4e 00 15 00 00 00 00 00 | 0c 20 00 00 01 00 01 00 |N.......|. ......|
|00000030| 11 03 03 00 02 00 01 00 | 01 00 ff 7f ff 7f 0c 4f |........|.......O|
|00000040| 4f 47 72 69 64 4c 76 31 | 2e 30 30 00 00 ff 7f ff |OGridLv1|.00.....|
|00000050| 7f 0a 02 08 03 20 24 20 | 07 00 6e 00 65 00 00 00 |..... $ |..n.e...|
|00000060| 02 00 00 00 00 00 00 00 | 00 00 00 00 21 4e 01 00 |........|....!N..|
|00000070| 63 00 39 00 20 61 72 65 | 20 74 68 65 20 66 69 65 |c.9. are| the fie|
|00000080| 6c 64 20 6e 61 6d 65 73 | 2e 20 20 59 6f 75 20 63 |ld names|.  You c|
|00000090| 61 6e 20 75 73 65 20 61 | 6e 79 20 6f 66 20 74 68 |an use a|ny of th|
|000000a0| 65 20 66 69 65 6c 64 20 | 6e 61 6d 65 73 21 4e 01 |e field |names!N.|
|000000b0| 00 64 00 3b 00 20 74 6f | 20 73 6f 72 74 20 74 68 |.d.;. to| sort th|
|000000c0| 65 20 6c 69 73 74 2c 20 | 65 69 74 68 65 72 20 69 |e list, |either i|
|000000d0| 6e 20 61 73 63 65 6e 64 | 69 6e 67 20 6f 72 20 64 |n ascend|ing or d|
|000000e0| 65 73 63 65 6e 64 69 6e | 67 20 6f 72 64 65 72 2e |escendin|g order.|
|000000f0| 21 4e 01 00 02 00 36 00 | 20 4f 4f 47 72 69 64 20 |!N....6.| OOGrid |
|00000100| 4c 69 62 72 61 72 79 28 | 54 4d 29 20 76 31 2e 30 |Library(|TM) v1.0|
|00000110| 20 66 6f 72 20 42 6f 72 | 6c 61 6e 64 2f 54 75 72 | for Bor|land/Tur|
|00000120| 62 6f 20 50 61 73 63 61 | 6c 20 28 54 56 29 21 4e |bo Pasca|l (TV)!N|
|00000130| 01 00 66 00 13 00 20 41 | 20 77 6f 72 64 20 6f 6e |..f... A| word on|
|00000140| 20 66 6f 72 6d 61 74 73 | 3a 21 4e 01 00 03 00 3d | formats|:!N....=|
|00000150| 00 20 43 6f 70 79 72 69 | 67 68 74 20 28 43 29 20 |. Copyri|ght (C) |
|00000160| 31 39 39 34 20 62 79 20 | 41 72 74 75 72 6f 20 4a |1994 by |Arturo J|
|00000170| 2e 20 4d 6f 6e 67 65 2e | 20 20 41 6c 6c 20 72 69 |. Monge.|  All ri|
|00000180| 67 68 74 73 20 72 65 73 | 65 72 76 65 64 2e 21 4e |ghts res|erved.!N|
|00000190| 01 00 04 00 40 00 20 50 | 6f 72 74 69 6f 6e 73 20 |....@. P|ortions |
|000001a0| 43 6f 70 79 72 69 67 68 | 74 20 28 43 29 20 31 39 |Copyrigh|t (C) 19|
|000001b0| 38 39 2c 31 39 39 30 20 | 62 79 20 42 6f 72 6c 61 |89,1990 |by Borla|
|000001c0| 6e 64 20 49 6e 74 65 72 | 6e 61 74 69 6f 6e 61 6c |nd Inter|national|
|000001d0| 2c 20 49 6e 63 2e 21 4e | 01 00 68 00 44 00 20 4e |, Inc.!N|..h.D. N|
|000001e0| 6f 74 69 63 65 20 74 68 | 65 20 63 6f 6c 75 6d 6e |otice th|e column|
|000001f0| 20 66 6f 72 6d 61 74 73 | 20 69 6e 20 74 68 65 20 | formats| in the |
|00000200| 6c 69 73 74 2e 20 20 54 | 6f 20 66 6f 72 6d 61 74 |list.  T|o format|
|00000210| 20 61 6e 20 65 6e 74 69 | 72 65 20 63 6f 6c 75 6d | an enti|re colum|
|00000220| 6e 2c 21 4e 01 00 69 00 | 39 00 20 63 6c 69 63 6b |n,!N..i.|9. click|
|00000230| 20 77 69 74 68 20 74 68 | 65 20 6d 6f 75 73 65 20 | with th|e mouse |
|00000240| 69 6e 20 74 68 65 20 63 | 6f 6c 75 6d 6e 27 73 20 |in the c|olumn's |
|00000250| 68 65 61 64 65 72 2e 20 | 20 54 68 65 20 63 6f 6c |header. | The col|
|00000260| 75 6d 6e 23 4e 01 00 06 | 00 2d 21 4e 01 00 6a 00 |umn#N...|.-!N..j.|
|00000270| 40 00 20 77 69 6c 6c 20 | 62 65 20 73 65 6c 65 63 |@. will |be selec|
|00000280| 74 65 64 2e 20 20 43 68 | 6f 6f 73 65 20 27 46 6f |ted.  Ch|oose 'Fo|
|00000290| 72 6d 61 74 20 43 65 6c | 6c 27 20 66 72 6f 6d 20 |rmat Cel|l' from |
|000002a0| 74 68 65 20 6d 65 6e 75 | 20 61 6e 64 20 65 6e 74 |the menu| and ent|
|000002b0| 65 72 21 4e 01 00 07 00 | 06 00 20 46 69 6c 65 3a |er!N....|.. File:|
|000002c0| 21 4e 01 00 6b 00 31 00 | 20 74 68 65 20 64 65 73 |!N..k.1.| the des|
|000002d0| 69 72 65 64 20 66 6f 72 | 6d 61 74 20 69 6e 20 74 |ired for|mat in t|
|000002e0| 68 65 20 27 46 6f 72 6d | 61 74 20 63 65 6c 6c 73 |he 'Form|at cells|
|000002f0| 27 20 64 69 61 6c 6f 67 | 2e 21 4e 02 00 07 00 09 |' dialog|.!N.....|
|00000300| 00 20 45 58 5f 4c 69 73 | 74 31 21 4e 01 00 08 00 |. EX_Lis|t1!N....|
|00000310| 0d 00 20 44 65 73 63 72 | 69 70 74 69 6f 6e 3a 21 |.. Descr|iption:!|
|00000320| 4e 02 00 08 00 2f 00 20 | 45 78 70 6c 61 6e 61 74 |N..../. |Explanat|
|00000330| 69 6f 6e 20 6f 66 20 68 | 6f 77 20 74 6f 20 75 73 |ion of h|ow to us|
|00000340| 65 20 68 65 61 64 65 72 | 73 20 61 6e 64 20 74 68 |e header|s and th|
|00000350| 65 20 73 6f 72 74 23 4e | 01 00 6d 00 2d 21 4e 02 |e sort#N|..m.-!N.|
|00000360| 00 09 00 2c 00 20 66 75 | 6e 63 74 69 6f 6e 20 69 |...,. fu|nction i|
|00000370| 6e 20 61 20 6c 69 73 74 | 2e 20 20 4c 6f 6f 6b 20 |n a list|.  Look |
|00000380| 61 74 20 66 69 6c 65 20 | 45 58 5f 4c 69 73 74 32 |at file |EX_List2|
|00000390| 2e 23 4e 01 00 0a 00 2d | 21 4e 01 00 6e 00 0d 00 |.#N....-|!N..n...|
|000003a0| 20 45 4e 44 20 4f 46 20 | 46 49 4c 45 2e 21 4e 07 | END OF |FILE.!N.|
|000003b0| 00 06 00 01 00 20 21 4e | 01 00 0c 00 10 00 20 43 |..... !N|...... C|
|000003c0| 4f 4c 55 4d 4e 20 48 45 | 41 44 45 52 53 3a 23 4e |OLUMN HE|ADERS:#N|
|000003d0| 01 00 0d 00 2d 21 4e 02 | 00 0d 00 01 00 20 21 4e |....-!N.|..... !N|
|000003e0| 01 00 0e 00 43 00 20 54 | 68 65 20 75 70 70 65 72 |....C. T|he upper|
|000003f0| 6d 6f 73 74 20 6c 69 6e | 65 20 6f 66 20 74 68 65 |most lin|e of the|
|00000400| 20 73 70 72 65 61 64 73 | 68 65 65 74 20 63 6f 6e | spreads|heet con|
|00000410| 74 61 69 6e 73 20 74 68 | 65 20 63 6f 6c 75 6d 6e |tains th|e column|
|00000420| 20 68 65 61 64 65 72 73 | 2e 21 4e 01 00 0f 00 41 | headers|.!N....A|
|00000430| 00 20 57 68 65 6e 20 61 | 20 73 70 72 65 61 64 73 |. When a| spreads|
|00000440| 68 65 65 74 20 69 73 20 | 63 72 65 61 74 65 64 2c |heet is |created,|
|00000450| 20 65 61 63 68 20 63 6f | 6c 75 6d 6e 20 69 6e 20 | each co|lumn in |
|00000460| 74 68 65 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |the spre|adsheet |
|00000470| 69 73 21 4e 07 00 6d 00 | 01 00 20 21 4e 07 00 0a |is!N..m.|.. !N...|
|00000480| 00 01 00 20 21 4e 01 00 | 10 00 45 00 20 61 73 73 |... !N..|..E. ass|
|00000490| 69 67 6e 65 64 20 61 20 | 6c 65 74 74 65 72 20 28 |igned a |letter (|
|000004a0| 69 6e 20 61 6c 70 68 61 | 62 65 74 69 63 61 6c 20 |in alpha|betical |
|000004b0| 6f 72 64 65 72 29 2c 20 | 77 68 69 63 68 20 69 73 |order), |which is|
|000004c0| 20 75 73 65 64 20 74 6f | 20 72 65 66 65 72 20 74 | used to| refer t|
|000004d0| 6f 21 4e 01 00 11 00 41 | 00 20 74 68 65 20 63 6f |o!N....A|. the co|
|000004e0| 6c 75 6d 6e 20 69 6e 20 | 61 20 63 65 6c 6c 20 61 |lumn in |a cell a|
|000004f0| 64 64 72 65 73 73 20 28 | 66 6f 72 20 65 78 61 6d |ddress (|for exam|
|00000500| 70 6c 65 2c 20 43 31 38 | 20 6d 65 61 6e 73 20 74 |ple, C18| means t|
|00000510| 68 65 20 63 65 6c 6c 20 | 69 6e 21 4e 01 00 12 00 |he cell |in!N....|
|00000520| 3f 00 20 63 6f 6c 75 6d | 6e 20 43 20 61 6e 64 20 |?. colum|n C and |
|00000530| 72 6f 77 20 31 38 29 2e | 20 20 54 68 69 73 20 6c |row 18).|  This l|
|00000540| 65 74 74 65 72 20 69 73 | 20 61 6c 77 61 79 73 20 |etter is| always |
|00000550| 64 69 73 70 6c 61 79 65 | 64 20 69 6e 20 65 61 63 |displaye|d in eac|
|00000560| 68 21 4e 01 00 13 00 19 | 00 20 63 6f 6c 75 6d 6e |h!N.....|. column|
|00000570| 27 73 20 64 65 66 61 75 | 6c 74 20 68 65 61 64 65 |'s defau|lt heade|
|00000580| 72 2e 21 4e 01 00 14 00 | 43 00 20 48 6f 77 65 76 |r.!N....|C. Howev|
|00000590| 65 72 2c 20 79 6f 75 20 | 63 61 6e 20 61 73 73 69 |er, you |can assi|
|000005a0| 67 6e 20 79 6f 75 72 20 | 6f 77 6e 20 63 75 73 74 |gn your |own cust|
|000005b0| 6f 6d 20 68 65 61 64 65 | 72 73 20 74 6f 20 61 20 |om heade|rs to a |
|000005c0| 63 6f 6c 75 6d 6e 2e 20 | 20 54 68 65 20 21 4e 01 |column. | The !N.|
|000005d0| 00 15 00 2b 00 20 70 72 | 6f 63 65 73 73 20 66 6f |...+. pr|ocess fo|
|000005e0| 72 20 64 6f 69 6e 67 20 | 74 68 69 73 20 69 73 20 |r doing |this is |
|000005f0| 65 78 70 6c 61 69 6e 65 | 64 20 62 65 6c 6f 77 2e |explaine|d below.|
|00000600| 21 4e 01 00 16 00 40 00 | 20 69 74 20 69 73 20 69 |!N....@.| it is i|
|00000610| 6d 70 6f 72 74 61 6e 74 | 20 74 6f 20 6e 6f 74 65 |mportant| to note|
|00000620| 20 74 68 61 74 2c 20 65 | 76 65 6e 20 74 68 6f 75 | that, e|ven thou|
|00000630| 67 68 20 64 69 66 66 65 | 72 65 6e 74 20 68 65 61 |gh diffe|rent hea|
|00000640| 64 65 72 73 20 63 61 6e | 21 4e 01 00 17 00 42 00 |ders can|!N....B.|
|00000650| 20 62 65 20 61 73 73 69 | 67 6e 65 64 20 74 6f 20 | be assi|gned to |
|00000660| 61 20 63 6f 6c 75 6d 6e | 2c 20 74 68 65 20 63 6f |a column|, the co|
|00000670| 6c 75 6d 6e 20 6c 65 74 | 74 65 72 20 6d 75 73 74 |lumn let|ter must|
|00000680| 20 73 74 69 6c 6c 20 62 | 65 20 75 73 65 64 20 74 | still b|e used t|
|00000690| 6f 20 21 4e 01 00 18 00 | 27 00 20 72 65 66 65 72 |o !N....|'. refer|
|000006a0| 20 74 6f 20 74 68 65 20 | 63 6f 6c 75 6d 6e 20 69 | to the |column i|
|000006b0| 6e 20 61 20 63 65 6c 6c | 20 61 64 64 72 65 73 73 |n a cell| address|
|000006c0| 2e 21 4e 01 00 1a 00 2b | 00 20 54 6f 20 61 64 64 |.!N....+|. To add|
|000006d0| 20 61 20 68 65 61 64 65 | 72 20 74 6f 20 61 20 63 | a heade|r to a c|
|000006e0| 6f 6c 75 6d 6e 2c 20 73 | 69 6d 70 6c 79 20 73 65 |olumn, s|imply se|
|000006f0| 6c 65 63 74 21 4e 01 00 | 1c 00 1c 00 20 20 20 20 |lect!N..|....    |
|00000700| 27 43 6f 6c 75 6d 6e 20 | 7c 20 43 68 61 6e 67 65 |'Column || Change|
|00000710| 20 48 65 61 64 65 72 27 | 21 4e 01 00 1e 00 3d 00 | Header'|!N....=.|
|00000720| 20 66 72 6f 6d 20 74 68 | 65 20 6d 65 6e 75 2e 20 | from th|e menu. |
|00000730| 20 41 20 64 69 61 6c 6f | 67 20 77 69 6c 6c 20 70 | A dialo|g will p|
|00000740| 72 6f 6d 70 74 20 79 6f | 75 20 66 6f 72 20 74 68 |rompt yo|u for th|
|00000750| 65 20 6e 65 77 20 68 65 | 61 64 65 72 2e 21 4e 01 |e new he|ader.!N.|
|00000760| 00 1f 00 3b 00 20 49 66 | 20 79 6f 75 20 61 72 65 |...;. If| you are|
|00000770| 20 63 68 61 6e 67 69 6e | 67 20 74 68 65 20 68 65 | changin|g the he|
|00000780| 61 64 65 72 20 6f 66 20 | 6f 6e 65 20 63 6f 6c 75 |ader of |one colu|
|00000790| 6d 6e 2c 20 74 68 65 20 | 63 6f 6c 75 6d 6e 27 73 |mn, the |column's|
|000007a0| 21 4e 01 00 20 00 3d 00 | 20 68 65 61 64 65 72 20 |!N.. .=.| header |
|000007b0| 77 69 6c 6c 20 61 70 70 | 65 61 72 20 73 65 6c 65 |will app|ear sele|
|000007c0| 63 74 65 64 20 69 6e 20 | 64 69 61 6c 6f 67 27 73 |cted in |dialog's|
|000007d0| 20 69 6e 70 75 74 20 6c | 69 6e 65 2e 20 20 49 66 | input l|ine.  If|
|000007e0| 20 79 6f 75 20 21 4e 01 | 00 21 00 3f 00 20 68 61 | you !N.|.!.?. ha|
|000007f0| 76 65 6e 27 74 20 61 73 | 73 69 67 6e 65 64 20 61 |ven't as|signed a|
|00000800| 20 6e 65 77 20 68 65 61 | 64 65 72 20 74 6f 20 61 | new hea|der to a|
|00000810| 20 63 6f 6c 75 6d 6e 2c | 20 74 68 65 20 69 6e 70 | column,| the inp|
|00000820| 75 74 20 6c 69 6e 65 20 | 77 69 6c 6c 21 4e 01 00 |ut line |will!N..|
|00000830| 22 00 45 00 20 64 69 73 | 70 6c 61 79 20 74 68 65 |".E. dis|play the|
|00000840| 20 63 6f 6c 75 6d 6e 20 | 6c 65 74 74 65 72 20 70 | column |letter p|
|00000850| 72 65 63 65 64 65 64 20 | 62 79 20 22 43 6f 6c 75 |receded |by "Colu|
|00000860| 6d 6e 22 2e 20 20 49 66 | 20 79 6f 75 20 61 72 65 |mn".  If| you are|
|00000870| 20 63 68 61 6e 67 69 6e | 67 21 4e 01 00 23 00 45 | changin|g!N..#.E|
|00000880| 00 20 74 68 65 20 68 65 | 61 64 65 72 73 20 6f 66 |. the he|aders of|
|00000890| 20 61 20 62 6c 6f 63 6b | 20 6f 66 20 63 6f 6c 75 | a block| of colu|
|000008a0| 6d 6e 73 2c 20 74 68 65 | 20 69 6e 70 75 74 20 6c |mns, the| input l|
|000008b0| 69 6e 65 20 77 69 6c 6c | 20 61 70 70 65 61 72 20 |ine will| appear |
|000008c0| 65 6d 70 74 79 2e 21 4e | 01 00 24 00 3e 00 20 54 |empty.!N|..$.>. T|
|000008d0| 6f 20 64 65 6c 65 74 65 | 20 61 20 68 65 61 64 65 |o delete| a heade|
|000008e0| 72 20 6f 66 20 61 20 63 | 6f 6c 75 6d 6e 20 2d 20 |r of a c|olumn - |
|000008f0| 6f 72 20 62 6c 6f 63 6b | 20 6f 66 20 63 6f 6c 75 |or block| of colu|
|00000900| 6d 6e 73 20 2d 20 73 65 | 6c 65 63 74 21 4e 01 00 |mns - se|lect!N..|
|00000910| 25 00 3e 00 20 27 44 65 | 6c 65 74 65 20 68 65 61 |%.>. 'De|lete hea|
|00000920| 64 65 72 73 27 20 66 72 | 6f 6d 20 74 68 65 20 6d |ders' fr|om the m|
|00000930| 65 6e 75 2e 20 20 41 6c | 73 6f 2c 20 79 6f 75 20 |enu.  Al|so, you |
|00000940| 6d 61 79 20 73 65 6c 65 | 63 74 20 27 43 68 61 6e |may sele|ct 'Chan|
|00000950| 67 65 21 4e 01 00 26 00 | 41 00 20 68 65 61 64 65 |ge!N..&.|A. heade|
|00000960| 72 73 27 20 66 72 6f 6d | 20 74 68 65 20 6d 65 6e |rs' from| the men|
|00000970| 75 2c 20 6c 65 61 76 65 | 20 74 68 65 20 64 69 61 |u, leave| the dia|
|00000980| 6c 6f 67 27 73 20 69 6e | 70 75 74 20 6c 69 6e 65 |log's in|put line|
|00000990| 20 65 6d 70 74 79 2c 20 | 61 6e 64 21 4e 01 00 27 | empty, |and!N..'|
|000009a0| 00 0d 00 20 70 72 65 73 | 73 20 65 6e 74 65 72 2e |... pres|s enter.|
|000009b0| 21 4e 01 00 29 00 15 00 | 20 54 68 65 20 27 43 6f |!N..)...| The 'Co|
|000009c0| 6c 75 6d 6e 20 27 20 70 | 72 65 66 69 78 23 4e 01 |lumn ' p|refix#N.|
|000009d0| 00 2a 00 2d 21 4e 02 00 | 2a 00 06 00 20 2d 2d 2d |.*.-!N..|*... ---|
|000009e0| 2d 2d 21 4e 01 00 2b 00 | 44 00 20 54 68 65 20 27 |--!N..+.|D. The '|
|000009f0| 43 6f 6c 75 6d 6e 20 27 | 20 70 72 65 66 69 78 20 |Column '| prefix |
|00000a00| 69 73 20 75 73 65 64 20 | 69 6e 20 74 68 65 20 53 |is used |in the S|
|00000a10| 6f 72 74 20 61 6e 64 20 | 43 68 61 6e 67 65 20 68 |ort and |Change h|
|00000a20| 65 61 64 65 72 20 64 69 | 61 6c 6f 67 73 2c 21 4e |eader di|alogs,!N|
|00000a30| 03 00 2a 00 01 00 20 21 | 4e 01 00 2c 00 41 00 20 |..*... !|N..,.A. |
|00000a40| 74 6f 20 61 76 6f 69 64 | 20 63 6f 6e 66 75 73 69 |to avoid| confusi|
|00000a50| 6f 6e 20 62 65 74 77 65 | 65 6e 20 74 68 65 20 64 |on betwe|en the d|
|00000a60| 65 66 61 75 6c 74 20 63 | 6f 6c 75 6d 6e 73 27 20 |efault c|olumns' |
|00000a70| 6c 65 74 74 65 72 73 20 | 61 6e 64 20 79 6f 75 72 |letters |and your|
|00000a80| 21 4e 01 00 2d 00 16 00 | 20 6f 77 6e 20 61 73 73 |!N..-...| own ass|
|00000a90| 69 67 6e 65 64 20 68 65 | 61 64 65 72 73 2e 21 4e |igned he|aders.!N|
|00000aa0| 01 00 2f 00 3e 00 20 41 | 73 20 61 6e 20 65 78 61 |../.>. A|s an exa|
|00000ab0| 6d 70 6c 65 2c 20 6c 65 | 74 27 73 20 73 61 79 20 |mple, le|t's say |
|00000ac0| 79 6f 75 20 68 61 76 65 | 20 61 20 6c 69 73 74 20 |you have| a list |
|00000ad0| 6c 69 6b 65 20 74 68 65 | 20 6f 6e 65 20 69 6e 20 |like the| one in |
|00000ae0| 66 69 6c 65 21 4e 01 00 | 30 00 3e 00 20 45 58 5f |file!N..|0.>. EX_|
|00000af0| 4c 69 73 74 32 20 61 6e | 64 20 79 6f 75 20 61 73 |List2 an|d you as|
|00000b00| 73 69 67 6e 65 64 20 68 | 65 61 64 65 72 20 27 43 |signed h|eader 'C|
|00000b10| 27 20 74 6f 20 63 6f 6c | 75 6d 6e 20 41 2e 20 4e |' to col|umn A. N|
|00000b20| 6f 77 2c 20 69 6e 20 74 | 68 65 21 4e 01 00 31 00 |ow, in t|he!N..1.|
|00000b30| 42 00 20 53 6f 72 74 20 | 61 6e 64 20 43 68 61 6e |B. Sort |and Chan|
|00000b40| 67 65 20 68 65 61 64 65 | 72 20 64 69 61 6c 6f 67 |ge heade|r dialog|
|00000b50| 73 2c 20 63 6f 6c 75 6d | 6e 20 41 20 63 61 6e 20 |s, colum|n A can |
|00000b60| 62 65 20 72 65 66 65 72 | 72 65 64 20 74 6f 20 75 |be refer|red to u|
|00000b70| 73 69 6e 67 21 4e 01 00 | 32 00 1a 00 20 65 69 74 |sing!N..|2... eit|
|00000b80| 68 65 72 20 27 43 27 20 | 6f 72 20 27 43 6f 6c 75 |her 'C' |or 'Colu|
|00000b90| 6d 6e 20 41 27 2e 21 4e | 01 00 34 00 3d 00 20 4e |mn A'.!N|..4.=. N|
|00000ba0| 6f 77 2c 20 6c 65 74 27 | 73 20 73 61 79 20 79 6f |ow, let'|s say yo|
|00000bb0| 75 20 77 61 6e 74 20 74 | 6f 20 73 6f 72 74 20 74 |u want t|o sort t|
|00000bc0| 68 65 20 6c 69 73 74 20 | 75 73 69 6e 67 20 74 68 |he list |using th|
|00000bd0| 65 20 76 61 6c 75 65 73 | 20 69 6e 21 4e 01 00 35 |e values| in!N..5|
|00000be0| 00 3e 00 20 63 6f 6c 75 | 6d 6e 20 43 2c 20 61 6e |.>. colu|mn C, an|
|00000bf0| 64 20 69 6e 20 74 68 65 | 20 73 6f 72 74 20 64 69 |d in the| sort di|
|00000c00| 61 6c 6f 67 20 79 6f 75 | 20 65 6e 74 65 72 20 27 |alog you| enter '|
|00000c10| 43 27 20 61 73 20 61 20 | 73 6f 72 74 20 6b 65 79 |C' as a |sort key|
|00000c20| 2e 21 4e 01 00 36 00 44 | 00 20 49 6e 20 74 68 69 |.!N..6.D|. In thi|
|00000c30| 73 20 63 61 73 65 2c 20 | 74 68 65 20 6c 69 73 74 |s case, |the list|
|00000c40| 20 77 6f 75 6c 64 20 62 | 65 20 73 6f 72 74 65 64 | would b|e sorted|
|00000c50| 20 75 73 69 6e 67 20 74 | 68 65 20 76 61 6c 75 65 | using t|he value|
|00000c60| 73 20 69 6e 20 63 6f 6c | 75 6d 6e 20 41 21 4e 01 |s in col|umn A!N.|
|00000c70| 00 37 00 44 00 20 69 6e | 73 74 65 61 64 20 6f 66 |.7.D. in|stead of|
|00000c80| 20 62 65 69 6e 67 20 73 | 6f 72 74 65 64 20 75 73 | being s|orted us|
|00000c90| 69 6e 67 20 74 68 65 20 | 76 61 6c 75 65 73 20 69 |ing the |values i|
|00000ca0| 6e 20 63 6f 6c 75 6d 6e | 20 43 21 20 20 54 6f 20 |n column| C!  To |
|00000cb0| 73 6f 6c 76 65 20 74 68 | 65 21 4e 01 00 38 00 42 |solve th|e!N..8.B|
|00000cc0| 00 20 70 72 6f 62 6c 65 | 6d 2c 20 77 68 65 6e 65 |. proble|m, whene|
|00000cd0| 76 65 72 20 79 6f 75 20 | 77 61 6e 74 20 74 6f 20 |ver you |want to |
|00000ce0| 72 65 66 65 72 20 74 6f | 20 61 20 63 6f 6c 75 6d |refer to| a colum|
|00000cf0| 6e 20 75 73 69 6e 67 20 | 69 74 73 20 64 65 66 61 |n using |its defa|
|00000d00| 75 6c 74 21 4e 01 00 39 | 00 41 00 20 6c 65 74 74 |ult!N..9|.A. lett|
|00000d10| 65 72 2c 20 79 6f 75 20 | 73 68 6f 75 6c 64 20 77 |er, you |should w|
|00000d20| 72 69 74 65 20 27 43 6f | 6c 75 6d 6e 20 27 20 62 |rite 'Co|lumn ' b|
|00000d30| 65 66 6f 72 65 20 65 6e | 74 65 72 69 6e 67 20 74 |efore en|tering t|
|00000d40| 68 65 20 63 6f 6c 75 6d | 6e 27 73 20 21 4e 01 00 |he colum|n's !N..|
|00000d50| 3a 00 45 00 20 6c 65 74 | 74 65 72 2e 20 20 49 6e |:.E. let|ter.  In|
|00000d60| 20 6f 75 72 20 65 78 61 | 6d 70 6c 65 2c 20 74 6f | our exa|mple, to|
|00000d70| 20 73 6f 72 74 20 74 68 | 65 20 6c 69 73 74 20 75 | sort th|e list u|
|00000d80| 73 69 6e 67 20 74 68 65 | 20 76 61 6c 75 65 73 20 |sing the| values |
|00000d90| 69 6e 20 63 6f 6c 75 6d | 6e 21 4e 01 00 3b 00 30 |in colum|n!N..;.0|
|00000da0| 00 20 43 2c 20 79 6f 75 | 20 73 68 6f 75 6c 64 20 |. C, you| should |
|00000db0| 65 6e 74 65 72 20 27 43 | 6f 6c 75 6d 6e 20 43 27 |enter 'C|olumn C'|
|00000dc0| 20 61 73 20 74 68 65 20 | 73 6f 72 74 20 6b 65 79 | as the |sort key|
|00000dd0| 2e 21 4e 01 00 3d 00 11 | 00 20 41 6e 6f 74 68 65 |.!N..=..|. Anothe|
|00000de0| 72 20 65 78 61 6d 70 6c | 65 3a 21 4e 01 00 3f 00 |r exampl|e:!N..?.|
|00000df0| 42 00 20 57 68 65 6e 20 | 79 6f 75 20 65 6e 74 65 |B. When |you ente|
|00000e00| 72 20 74 68 65 20 68 65 | 61 64 65 72 20 27 43 6f |r the he|ader 'Co|
|00000e10| 6c 75 6d 6e 20 42 27 20 | 69 6e 20 74 68 65 20 43 |lumn B' |in the C|
|00000e20| 68 61 6e 67 65 20 68 65 | 61 64 65 72 20 64 69 61 |hange he|ader dia|
|00000e30| 6c 6f 67 2c 21 4e 01 00 | 40 00 40 00 20 74 68 65 |log,!N..|@.@. the|
|00000e40| 20 63 6f 6c 75 6d 6e 27 | 73 20 68 65 61 64 65 72 | column'|s header|
|00000e50| 20 77 69 6c 6c 20 62 65 | 20 73 65 74 20 74 6f 20 | will be| set to |
|00000e60| 27 42 27 2e 20 20 49 66 | 20 74 68 65 20 73 65 6c |'B'.  If| the sel|
|00000e70| 65 63 74 65 64 20 63 6f | 6c 75 6d 6e 21 4e 01 00 |ected co|lumn!N..|
|00000e80| 41 00 42 00 20 77 61 73 | 20 63 6f 6c 75 6d 6e 20 |A.B. was| column |
|00000e90| 42 2c 20 63 68 61 6e 67 | 69 6e 67 20 74 68 65 20 |B, chang|ing the |
|00000ea0| 68 65 61 64 65 72 20 74 | 6f 20 63 6f 6c 75 6d 6e |header t|o column|
|00000eb0| 20 42 20 6d 65 72 65 6c | 79 20 72 65 74 75 72 6e | B merel|y return|
|00000ec0| 73 20 74 68 65 20 21 4e | 01 00 42 00 3f 00 20 68 |s the !N|..B.?. h|
|00000ed0| 65 61 64 65 72 20 74 6f | 20 69 74 73 20 64 65 66 |eader to| its def|
|00000ee0| 61 75 6c 74 20 73 65 74 | 74 69 6e 67 2e 20 20 49 |ault set|ting.  I|
|00000ef0| 66 20 74 68 65 20 73 65 | 6c 65 63 74 65 64 20 63 |f the se|lected c|
|00000f00| 6f 6c 75 6d 6e 20 77 61 | 73 20 61 6e 79 21 4e 01 |olumn wa|s any!N.|
|00000f10| 00 43 00 3f 00 20 6f 74 | 68 65 72 20 63 6f 6c 75 |.C.?. ot|her colu|
|00000f20| 6d 6e 2c 20 74 68 65 20 | 63 6f 6c 75 6d 6e 27 73 |mn, the |column's|
|00000f30| 20 68 65 61 64 65 72 20 | 77 69 6c 6c 20 62 65 20 | header |will be |
|00000f40| 73 65 74 20 74 6f 20 27 | 42 27 3b 20 68 6f 77 65 |set to '|B'; howe|
|00000f50| 76 65 72 2c 21 4e 01 00 | 44 00 3e 00 20 74 68 69 |ver,!N..|D.>. thi|
|00000f60| 73 20 64 6f 65 73 20 6e | 6f 74 20 6d 65 61 6e 20 |s does n|ot mean |
|00000f70| 74 68 61 74 20 74 68 65 | 20 63 6f 6c 75 6d 6e 27 |that the| column'|
|00000f80| 73 20 6c 65 74 74 65 72 | 20 77 61 73 20 63 68 61 |s letter| was cha|
|00000f90| 6e 67 65 64 20 74 6f 20 | 42 2e 21 4e 01 00 45 00 |nged to |B.!N..E.|
|00000fa0| 3e 00 20 59 6f 75 20 6d | 75 73 74 20 73 74 69 6c |>. You m|ust stil|
|00000fb0| 6c 20 75 73 65 20 74 68 | 65 20 63 6f 6c 75 6d 6e |l use th|e column|
|00000fc0| 27 73 20 64 65 66 61 75 | 6c 74 20 6c 65 74 74 65 |'s defau|lt lette|
|00000fd0| 72 20 74 6f 20 72 65 66 | 65 72 20 74 6f 20 69 74 |r to ref|er to it|
|00000fe0| 21 4e 01 00 46 00 13 00 | 20 69 6e 20 61 20 63 65 |!N..F...| in a ce|
|00000ff0| 6c 6c 20 61 64 64 72 65 | 73 73 2e 21 4e 01 00 48 |ll addre|ss.!N..H|
|00001000| 00 10 00 20 54 48 45 20 | 53 4f 52 54 20 44 49 41 |... THE |SORT DIA|
|00001010| 4c 4f 47 23 4e 01 00 49 | 00 2d 21 4e 02 00 49 00 |LOG#N..I|.-!N..I.|
|00001020| 01 00 20 21 4e 01 00 4a | 00 3a 00 20 59 6f 75 20 |.. !N..J|.:. You |
|00001030| 63 61 6e 20 73 6f 72 74 | 20 61 20 6c 69 73 74 20 |can sort| a list |
|00001040| 6f 66 20 64 61 74 61 2c | 20 75 73 69 6e 67 20 74 |of data,| using t|
|00001050| 68 65 20 53 6f 72 74 20 | 64 69 61 6c 6f 67 2e 20 |he Sort |dialog. |
|00001060| 20 54 68 69 73 21 4e 03 | 00 49 00 01 00 20 21 4e | This!N.|.I... !N|
|00001070| 01 00 4b 00 3f 00 20 64 | 69 61 6c 6f 67 20 6c 65 |..K.?. d|ialog le|
|00001080| 74 73 20 79 6f 75 20 64 | 65 66 69 6e 65 20 74 68 |ts you d|efine th|
|00001090| 72 65 65 20 64 69 66 66 | 65 72 65 6e 74 20 61 73 |ree diff|erent as|
|000010a0| 63 65 6e 64 69 6e 67 20 | 6f 72 20 64 65 73 63 65 |cending |or desce|
|000010b0| 6e 64 69 6e 67 21 4e 01 | 00 4c 00 0b 00 20 73 6f |nding!N.|.L... so|
|000010c0| 72 74 20 6b 65 79 73 2e | 21 4e 01 00 4d 00 40 00 |rt keys.|!N..M.@.|
|000010d0| 20 54 6f 20 65 6e 74 65 | 72 20 61 20 6b 65 79 2c | To ente|r a key,|
|000010e0| 20 79 6f 75 20 63 61 6e | 20 75 73 65 20 61 20 63 | you can| use a c|
|000010f0| 6f 6c 75 6d 6e 20 68 65 | 61 64 65 72 20 6f 72 20 |olumn he|ader or |
|00001100| 61 20 72 65 66 65 72 65 | 6e 63 65 20 74 6f 20 61 |a refere|nce to a|
|00001110| 21 4e 01 00 4e 00 23 00 | 20 63 6f 6c 75 6d 6e 20 |!N..N.#.| column |
|00001120| 75 73 69 6e 67 20 74 68 | 65 20 27 43 6f 6c 75 6d |using th|e 'Colum|
|00001130| 6e 20 27 20 70 72 65 66 | 69 78 2e 21 4e 01 00 50 |n ' pref|ix.!N..P|
|00001140| 00 41 00 20 57 68 65 6e | 20 73 6f 72 74 69 6e 67 |.A. When| sorting|
|00001150| 20 61 20 6c 69 73 74 2c | 20 74 68 65 20 64 69 66 | a list,| the dif|
|00001160| 66 65 72 65 6e 74 20 74 | 79 70 65 73 20 6f 66 20 |ferent t|ypes of |
|00001170| 63 65 6c 6c 73 20 77 69 | 6c 6c 20 62 65 20 73 6f |cells wi|ll be so|
|00001180| 72 74 65 64 21 4e 01 00 | 51 00 18 00 20 69 6e 20 |rted!N..|Q... in |
|00001190| 74 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 6f 72 |the foll|owing or|
|000011a0| 64 65 72 3a 21 4e 01 00 | 53 00 1e 00 20 20 20 20 |der:!N..|S...    |
|000011b0| 31 2e 20 56 61 6c 75 65 | 20 61 6e 64 20 46 6f 72 |1. Value| and For|
|000011c0| 6d 75 6c 61 20 43 65 6c | 6c 73 21 4e 01 00 54 00 |mula Cel|ls!N..T.|
|000011d0| 11 00 20 20 20 20 32 2e | 20 54 65 78 74 20 43 65 |..    2.| Text Ce|
|000011e0| 6c 6c 73 21 4e 01 00 55 | 00 13 00 20 20 20 20 33 |lls!N..U|...    3|
|000011f0| 2e 20 52 65 70 65 61 74 | 20 43 65 6c 6c 73 21 4e |. Repeat| Cells!N|
|00001200| 01 00 56 00 12 00 20 20 | 20 20 34 2e 20 45 6d 70 |..V...  |  4. Emp|
|00001210| 74 79 20 43 65 6c 6c 73 | 21 4e 01 00 57 00 1e 00 |ty Cells|!N..W...|
|00001220| 20 20 20 20 35 2e 20 43 | 65 6c 6c 73 20 77 69 74 |    5. C|ells wit|
|00001230| 68 20 45 52 52 4f 52 20 | 73 74 61 74 75 73 21 4e |h ERROR |status!N|
|00001240| 01 00 59 00 3e 00 20 43 | 65 6c 6c 73 20 6f 66 20 |..Y.>. C|ells of |
|00001250| 74 68 65 20 73 61 6d 65 | 20 74 79 70 65 2c 20 77 |the same| type, w|
|00001260| 69 6c 6c 20 62 65 20 73 | 6f 72 74 65 64 20 65 69 |ill be s|orted ei|
|00001270| 74 68 65 72 20 61 6c 70 | 68 61 62 65 74 69 63 61 |ther alp|habetica|
|00001280| 6c 6c 79 20 21 4e 01 00 | 5a 00 34 00 20 28 74 65 |lly !N..|Z.4. (te|
|00001290| 78 74 20 63 65 6c 6c 73 | 29 20 6f 72 20 62 79 20 |xt cells|) or by |
|000012a0| 76 61 6c 75 65 20 28 76 | 61 6c 75 65 20 61 6e 64 |value (v|alue and|
|000012b0| 20 66 6f 72 6d 75 6c 61 | 20 63 65 6c 6c 73 29 2e | formula| cells).|
|000012c0| 21 4e 01 00 5c 00 3b 00 | 20 49 66 20 61 20 62 6c |!N..\.;.| If a bl|
|000012d0| 6f 63 6b 20 69 73 20 6e | 6f 74 20 69 6e 64 69 63 |ock is n|ot indic|
|000012e0| 61 74 65 64 2c 20 61 6c | 6c 20 74 68 65 20 64 61 |ated, al|l the da|
|000012f0| 74 61 20 69 6e 20 74 68 | 65 20 66 69 6c 65 20 77 |ta in th|e file w|
|00001300| 69 6c 6c 21 4e 01 00 5d | 00 19 00 20 62 65 20 73 |ill!N..]|... be s|
|00001310| 65 6c 65 63 74 65 64 20 | 66 6f 72 20 73 6f 72 74 |elected |for sort|
|00001320| 69 6e 67 2e 21 4e 01 00 | 5f 00 0b 00 20 41 4e 20 |ing.!N..|_... AN |
|00001330| 45 58 41 4d 50 4c 45 23 | 4e 01 00 60 00 c4 21 4e |EXAMPLE#|N..`..!N|
|00001340| 02 00 60 00 01 00 20 21 | 4e 01 00 61 00 33 00 20 |..`... !|N..a.3. |
|00001350| 54 61 6b 65 20 61 20 6c | 6f 6f 6b 20 61 74 20 74 |Take a l|ook at t|
|00001360| 68 65 20 6c 69 73 74 20 | 6f 66 20 62 6f 6f 6b 73 |he list |of books|
|00001370| 20 69 6e 20 66 69 6c 65 | 20 45 58 5f 4c 69 73 74 | in file| EX_List|
|00001380| 31 2e 21 4e 01 00 62 00 | 38 00 20 45 61 63 68 20 |1.!N..b.|8. Each |
|00001390| 65 6e 74 72 79 20 68 61 | 73 20 31 35 20 64 69 66 |entry ha|s 15 dif|
|000013a0| 66 65 72 65 6e 74 20 66 | 69 65 6c 64 73 2e 20 20 |ferent f|ields.  |
|000013b0| 54 68 65 20 63 6f 6c 75 | 6d 6e 20 68 65 61 64 65 |The colu|mn heade|
|000013c0| 72 73 01 00 0f 07 00 05 | 24 4e 01 00 01 00 07 00 |rs......|$N......|
|000013d0| 12 00 01 00 01 00 00 24 | 4e 01 00 6d 00 01 00 73 |.......$|N..m...s|
|000013e0| 00 00 00 01 01 25 4e 4f | 00 01 00 01 00 15 00 00 |.....%NO|........|
|000013f0| 00 00 00 0d 20 00 00 01 | 00 00 00 01 00 01 00 01 |.... ...|........|
|00001400| 00 ff 7f 0f 00 01 00 1e | 1f b1 fe b2 00 00 68 00 |........|......h.|
|00001410| 25 4e 02 00 16 00 4c 00 | 01 00 00 00 00 00 0e 20 |%N....L.|....... |
|00001420| 00 00 01 00 00 00 01 00 | 01 00 01 00 ff 7f 06 00 |........|........|
|00001430| 01 00 11 10 b1 fe b2 00 | 00 1b 00 02 00 00 00 00 |........|........|
|00001440| 00 50 00 17 00 00 00 00 | 00 0c 20 00 00 01 00 00 |.P......|.. .....|
|00001450| 00 11 03 01 00 0f 01 00 | 01 00 50 00 17 00 01 00 |........|..P.....|
|00001460| 00 00 04 00 0c 45 58 5f | 4c 49 53 54 31 2e 4f 47 |.....EX_|LIST1.OG|
|00001470| 4c                      |                         |L       |        |
+--------+-------------------------+-------------------------+--------+--------+