1. NAME

ssgrep - search spreadsheets for strings

2. SYNOPSIS

ssgrep [OPTIONS] [FILES]

3. 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.

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

4.1. Options controlling input file handling

--recalc

    Recalculate all cells

4.2. 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

4.3. 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

4.4. Help options

-V, --version

    Display ssgrep's version

-?, --help

    Display the supported options

--usage

    Display a brief usage message

5. 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 \fB--keyword-file=keywords foo.xls

6. LICENSE

ssgrep is licensed under the terms of the General Public License (GPL), version 2. 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" .

7. 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.

8. AUTHOR

ssgrep's primary author is Jody Goldberg < >; ssgrep builds on the gnumeric codebase. The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen (Ray) < >.

9. SEE ALSO

beagled(1), gnumeric(1), ssconvert(1), ssindex(1) .URL "http://www.gnome.org/projects/gnumeric/" "The Gnumeric Homepage" . .URL "http://www.gnome.org/" "The GNOME project page" .