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