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