SSGREP(1)

🦋 ssgrep(1) — the GNOME spreadsheet grep, bestie edition 🦋

okay so real talk, this is the ssgrep man page from the GNOME fam — she lives in section 1 of the manual, and honestly? she's lowkey iconic for doing one job extremely well. let's get into it 💅

---

✨ NAME ✨

ssgrep — search spreadsheets for strings 🍓

🌸 SYNOPSIS 🌸

ssgrep [OPTIONS] [FILES]

💖 DESCRIPTION 💖

so this page is a brief little doc for the ssgrep command — like, the vibes version, not the whole saga.

ssgrep is a command line utility that searches for strings in spreadsheets of any format supported by gnumeric. yes, any. she's versatile like that 🫶

Without any output-modifying options, ssgrep prints one line for each match. And what counts as a match? The matching content of a cell or — if you pass the -R option — the matching expression result of a cell. iykyk ⭐

🔥 OPTIONS 🔥

this program follows the usual GNU command line syntax, bestie — single letter options start with a single dash (-), and longer options start with two dashes (--). periodt.

🎀 Options controlling input file handling 🎀

• --recalc — recalculate all cells. that's it, that's the whole vibe.

🌈 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 (Case Girlies stay winning)
• -w, --word-regexp — match only whole words, no partials sneaking through
• -F, --fixed-strings — treat the pattern as a set of fixed strings (literally just what it says, no fancy regex business)
• -R, --search-results — search results of expressions too 👀
• -v, --invert-match — search for cells that do not match (the contrarian option, we stan)

👑 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 ⭐

wanna search for the string "SUM" in the file foo.gnumeric? say less:

ssgrep SUM foo.gnumeric

and if you wanna search for the strings from the file keywords in the spreadsheet foo.xls, do this:

ssgrep --keyword-file=keywords foo.xls

ate, no crumbs 💀

💜 LICENSE 💜

ssgrep is licensed under the terms of the General Public License (GPL), version 2 or 3. For info on this license, look at the source code that came with the software, or go see the GNU project page at ⟨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. (yes, the source code, go read it, she's thorough ✨)

🦋 AUTHOR 🦋

ssgrep's primary author is Jody Goldberg <jody@gnome.org> — and just so you know, ssgrep builds on the gnumeric codebase. main character energy, honestly.

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

🌸 SEE ALSO 🌸

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

The Gnumeric Homepage ⟨https://www.gnumeric.org/⟩.

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

---

ok that's the whole page bestie, go forth and grep those spreadsheets 💅✨

and that's a wrap! this page came to you courtesy of gnumeric, dated 2009-02-08, filed under SSGREP(1) — vintage but still serving 🎀💖