NAME

       ssgrep - search spreadsheets for strings

SYNOPSIS

       ssgrep  [OPTIONS] [FILES]

DESCRIPTION

       This manual page briefly documents the ssgrep command.

       ssgrep  is  a  command  line  utility  to  search  for strings in spreadsheets of any format supported by
       gnumeric. Without any output modifying options, ssgrep prints one line for each match. A  match  consists
       of  the  matching  content  of  a cell or, if the -R option is given, the matching expression result of a
       cell.

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 (`--').

   Options controlling input file handling
       --recalc
              Recalculate all cells

   Options controlling patterns and pattern matching
       -f, --keyword-file=FILE
              The path to a text file containing one key per line

       -i, --ignore-case
              Ignore differences in letter case

       -w, --word-regexp
              Match only whole words

       -F, --fixed-strings
              Pattern is a set of fixed strings

       -R, --search-results
              Search results of expressions too

       -v, --invert-match
              Search for cells that do not match

   Options controlling output in general
       -c, --count
              Only print a count of matches per file

       -L, --files-without-matches
              Print filenames without matches

       -l, --files-with-matches
              Print filenames with matches

       -q, --quiet
              Suppress all normal output

       -H, --with-filename
              Print the filename for each match

       -h, --without-filename
              Do not print the filename for each match

       -n, --print-locus
              Print the location of each match

       -T, --print-type
              Print the location type of each match

   Help options
       -V, --version
              Display ssgrep's version

       -?, --help
              Display the supported options

       --usage
              Display a brief usage message

EXAMPLE

       To search for the string "SUM" in the file foo.gnumeric :

       ssgrep SUM foo.gnumeric

       To search for the strings from the file keywords in the spreadsheet foo.xls :

       ssgrep --keyword-file=keywords foo.xls

LICENSE

       ssgrep  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 GNU project page ⟨http://
       www.gnu.org⟩.

COPYRIGHT

       The copyright on ssgrep and the gnumeric software and source code is held by the individual authors as is
       documented in the source code.

AUTHOR

       ssgrep's primary author is Jody Goldberg <jody@gnome.org>; ssgrep builds on the gnumeric codebase.

       The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen (Ray) <jdassen@debian.org>.

SEE ALSO

       beagled(1), gnumeric(1), ssconvert(1), ssdiff(1) ssindex(1)

       The Gnumeric Homepage ⟨http://www.gnome.org/projects/gnumeric/⟩.

       The GNOME project page ⟨http://www.gnome.org/⟩.