DOKK / manpages / debian 11 / gnumeric / ssgrep.1.en

ssgrep - search spreadsheets for strings

ssgrep [OPTIONS] [FILES]

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.

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

Recalculate all cells

The path to a text file containing one key per line
Ignore differences in letter case
Match only whole words
Pattern is a set of fixed strings
Search results of expressions too
Search for cells that do not match

Only print a count of matches per file
Print filenames without matches
Print filenames with matches
Suppress all normal output
Print the filename for each match
Do not print the filename for each match
Print the location of each match
Print the location type of each match

Display ssgrep's version
-?, --help
Display the supported options
Display a brief usage message

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

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 ⟨URL: ⟩.

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

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

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

The Gnumeric Homepage ⟨URL: ⟩.

The GNOME project page ⟨URL: ⟩.

2009-02-08 gnumeric