Commit | Line | Data |
---|---|---|
81973239 KB |
1 | .\" $Revision $ |
2 | .TH PPNAME 1 | |
3 | .SH NAME | |
4 | ppname \- prepare pname files | |
5 | .SH SYNOPSIS | |
6 | .B ppname | |
7 | [ | |
8 | .I -fLkr | |
9 | ] | |
10 | [ | |
11 | .I -s cell | |
12 | ] | |
13 | [ | |
14 | .I -R n | |
15 | ] | |
16 | [ | |
17 | .I -C n | |
18 | ] | |
19 | [ | |
20 | .I -n n | |
21 | ] | |
22 | [ | |
23 | .I -d c | |
24 | ] | |
25 | ||
26 | .SH DESCRIPTION | |
27 | .I Ppname | |
28 | is used to prepare data for input to the spread sheet calculator | |
29 | .I pname(1). | |
30 | It accepts normal ascii data on standard input. Standard output | |
31 | is a | |
32 | .I pname | |
33 | file. | |
34 | With no options, | |
35 | .I ppname | |
36 | starts the spread sheet in cell A0. Strings are right justified. | |
37 | All data on a line is entered on the same row; new input lines | |
38 | cause the output row number to increment by one. The default delimiters | |
39 | are tab and space. The column formats are set to one larger | |
40 | than the number of columns required to hold the largest value | |
41 | in the column. | |
42 | ||
43 | Options: | |
44 | ||
45 | .IP "\-f" | |
46 | Omit column width calculations. This option is for preparing | |
47 | data to be merged with an existing spreadsheet. If the option is not | |
48 | specified, the column widths calculated for the data read by | |
49 | .I ppname | |
50 | will override those already set in the existing spreadsheet. | |
51 | ||
52 | .IP "\-L" | |
53 | Left justify strings. | |
54 | ||
55 | .IP "\-k" | |
56 | Keep all delimiters. This option causes the output cell to change on | |
57 | each new delimiter encountered in the input stream. The default | |
58 | action is to condense multiple delimters to one, so that the cell only | |
59 | changes once per input data item. | |
60 | ||
61 | .IP "\-r" | |
62 | Output the data by row first then column. For input consisting of a single | |
63 | column, this | |
64 | option will result in output of one row with multiple columns | |
65 | instead of a single | |
66 | column spread sheet. | |
67 | ||
68 | .IP "\-s cell" | |
69 | Start the top left corner of the spread sheet in | |
70 | .I cell. | |
71 | For example, | |
72 | .I "-s B33" | |
73 | will arrange the output data so that the | |
74 | spread sheet starts in column B, row 33. | |
75 | ||
76 | .IP "\-R n" | |
77 | Increment by | |
78 | .I n | |
79 | on each new output row. | |
80 | ||
81 | .IP "\-C n" | |
82 | Increment by | |
83 | .I n | |
84 | on each new output column. | |
85 | ||
86 | .IP "\-n n" | |
87 | Output | |
88 | .I n | |
89 | rows before advancing to the next column. This option is used when | |
90 | the input is arranged in a single column and the spread sheet is to | |
91 | have multiple columns, each of which is to be length | |
92 | .I n. | |
93 | ||
94 | .IP "\-d c" | |
95 | Use the single character | |
96 | .I c | |
97 | as the delimiter between input fields. | |
98 | ||
99 | .SH SEE ALSO | |
100 | pname(1) | |
101 | ||
102 | .SH AUTHOR | |
103 | ||
104 | Robert Bond |