1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
|
.de URL
\\$2 \(laURL: \\$1 \(ra\\$3
..
.if \n[.g] .mso www.tmac
.TH SSGREP 1 "2009-02-08" gnumeric "GNOME"
.SH NAME
ssgrep \- search spreadsheets for strings
.SH SYNOPSIS
\fBssgrep \fR [\fIOPTIONS\fR] [\fIFILES\fR]
.SH DESCRIPTION
This manual page briefly documents the \fBssgrep\fR command.
\fBssgrep\fR is a command line utility to search for strings in spreadsheets of
any format supported by gnumeric. Without any output modifying options,
\fBssgrep\fR prints one line for each match. A match consists of the matching
content of a cell or, if the \fB\-R\fR option is given, the matching expression
result of a cell.
.\".SH "RETURN VALUE"
.\".SH "EXIT STATUS"
.\".SH ERRORS
.SH OPTIONS
This program follows the usual GNU command line syntax, with single
letter options starting with a single dash (`-') and longer options
starting with two dashes (`--').
.SS "Options controlling input file handling"
.TP
.B \-\-recalc
Recalculate all cells
.SS "Options controlling patterns and pattern matching"
.TP
.B \-f, \-\-keyword\-file=\fIFILE\fR
The path to a text file containing one key per line
.TP
.B \-i, \-\-ignore\-case
Ignore differences in letter case
.TP
.B \-w, \-\-word\-regexp
Match only whole words
.TP
.B \-F, \-\-fixed\-strings
Pattern is a set of fixed strings
.TP
.B \-R, \-\-search\-results
Search results of expressions too
.TP
.B \-v, \-\-invert-match
Search for cells that do not match
.SS "Options controlling output in general"
.TP
.B \-c, \-\-count
Only print a count of matches per file
.TP
.B \-L, \-\-files\-without\-matches
Print filenames without matches
.TP
.B \-l, \-\-files\-with\-matches
Print filenames with matches
.TP
.B \-q, \-\-quiet
Suppress all normal output
.TP
.B \-H, \-\-with\-filename
Print the filename for each match
.TP
.B \-h, \-\-without\-filename
Do not print the filename for each match
.TP
.B \-n, \-\-print\-locus
Print the location of each match
.TP
.B \-T, \-\-print\-type
Print the location type of each match
.SS "Help options"
.TP
.B \-V, \-\-version
Display ssgrep's version
.TP
.B \-?, \-\-help
Display the supported options
.TP
.B \-\-usage
Display a brief usage message
.\".SH USAGE
.SH EXAMPLE
To search for the string "SUM" in the file \fIfoo.gnumeric\fR :
.PP
\fBssgrep\fR \fISUM\fR \fIfoo.gnumeric\fR
.PP
To search for the strings from the file \fIkeywords\fR in the spreadsheet \fIfoo.xls\fR :
.PP
\fBssgrep\fR \fB\-\-keyword\-file=\fIkeywords\fR \fIfoo.xls\fR
.PP
.\".SH FILES
.\".SH ENVIRONMENT
.\".SH DIAGNOSTICS
.\".SH SECURITY
.\".SH CONFORMING TO
.\".SH NOTES
.\".SH BUGS
.SH LICENSE
\fBssgrep\fR is licensed under the terms of the General Public
License (GPL), version 2 or 3. For information on this license look at the
source code that came with the software or see the
.URL "http://www.gnu.org" "GNU project page" .
.SH COPYRIGHT
The copyright on \fBssgrep\fR and the \fBgnumeric\fR software and source
code is held by the individual authors as is documented in the source code.
.SH AUTHOR
\fBssgrep\fR's primary author is Jody Goldberg <jody@gnome.org>;
\fBssgrep\fR builds on the \fBgnumeric\fR codebase.
The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen
(Ray) <jdassen@debian.org>.
.SH SEE ALSO
\fBbeagled\fR(1),
\fBgnumeric\fR(1),
\fBssconvert\fR(1),
\fBssdiff\fR(1)
\fBssindex\fR(1)
.URL "http://www.gnome.org/projects/gnumeric/" "The Gnumeric Homepage" .
.URL "http://www.gnome.org/" "The GNOME project page" .
|