1SSGREP(1)                            GNOME                           SSGREP(1)
2
3
4

NAME

6       ssgrep - search spreadsheets for strings
7
8

SYNOPSIS

10       ssgrep  [OPTIONS] [FILES]
11
12

DESCRIPTION

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

OPTIONS

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

EXAMPLE

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

LICENSE

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

AUTHOR

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

SEE ALSO

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)
Impressum