LinuxCommandLibrary

calligrasheets

Create and edit spreadsheet documents

TLDR

Launch the spreadsheet application

$ calligrasheets
copy

Open a specific spreadsheet
$ calligrasheets [path/to/spreadsheet]
copy

Display help or version
$ calligrasheets --[help|version]
copy

SYNOPSIS

calligrasheets [options] [files...]

PARAMETERS

-h, --help
    Display help message and exit

--help-qt
    Show Qt library-specific help

--help-kde
    Show KDE Frameworks-specific help

--help-all
    Show all available options

--author
    Show author information

--license
    Show license details

--version
    Display version information

-s, --stylesheet style
    Specify KDE stylesheet

--embedding
    Enable embedding mode for KParts

DESCRIPTION

Calligra Sheets is a feature-rich spreadsheet program from the open-source Calligra Suite, designed for KDE Plasma but usable on any Linux desktop. It supports creating, editing, and analyzing complex spreadsheets with a modern, intuitive interface.

Key capabilities include OpenDocument Spreadsheet (.ods) native format, import/export of Microsoft Excel (.xlsx, .xls), CSV, and more. It offers over 400 functions, pivot tables, charts, data validation, conditional formatting, and Python scripting for automation.

Ideal for data analysis, financial modeling, and scientific computing, it handles large datasets efficiently with multi-threading support. Integration with Calligra Words and Stage enables embedding sheets in documents and presentations.

Launched via calligrasheets, it's primarily a GUI tool but accepts CLI file openings. Requires the calligra package; depends on Qt and KDE Frameworks for rendering and UI.

CAVEATS

GUI-only; no batch/headless mode. Requires graphical session (X11/Wayland). Large files may need ample RAM. Excel compatibility not 100% for complex macros.

EXAMPLES

calligrasheets example.ods
Opens specified spreadsheet file.

calligrasheets --version
Shows version and exits.

calligrasheets *.csv
Opens multiple CSV files.

INSTALLATION

Install via apt install calligra (Debian/Ubuntu) or dnf install calligra-sheets (Fedora). Part of calligra meta-package.

HISTORY

Originated as KSpread in KOffice (1998). Calligra Suite forked from KOffice 2.x in 2010 for focus on creative apps. Sheets rewritten with Qt5/KF5 in Calligra 3.x (2014+), adding modern features like 3D charts and better ODF support. Actively maintained by KDE community.

SEE ALSO

calligrawords(1), karbon(1), gnumeric(1), libreoffice(1)

Copied to clipboard