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 [Qt-options] [KDE-options] [options] [file...]

PARAMETERS

file...
    Specifies one or more spreadsheet files to be opened upon application launch. If no files are specified, a new blank document is typically opened.

--new-document
    Forces the application to open a new, blank spreadsheet document.

--help
    Displays a brief help message with available command-line options and then exits.

--version
    Shows the version information of the Calligra Sheets application and then exits.

--author
    Displays information about the authors of the application.

--license
    Shows the licensing information for the application.

--config filename
    Uses the specified configuration file instead of the default one.

--display displayname
    Connects to the specified X display, overriding the DISPLAY environment variable.

--geometry WxH+X+Y
    Sets the initial geometry (width, height, X-offset, Y-offset) of the main application window.

DESCRIPTION

Calligra Sheets is the robust spreadsheet component of the Calligra Suite, a comprehensive office suite developed by KDE. It provides users with a full set of tools for creating, editing, and managing spreadsheets, ranging from basic calculations to advanced data analysis and visualization. It supports a wide array of functions, charts, and pivot tables, making it suitable for both personal and professional use.

As a graphical user interface (GUI) application, calligrasheets primarily serves to launch the interactive spreadsheet environment. While it offers a few command-line options for opening files or specifying application behavior, its main interaction is through its visual interface. It is designed to be compatible with various spreadsheet file formats, including the OpenDocument Spreadsheet (ODS) format, Microsoft Excel (XLSX, XLS), and CSV.

CAVEATS

Calligra Sheets is primarily a graphical application. Its command-line interface is limited to launching the GUI, opening files, and setting basic display/configuration options. It is not designed for headless operation, batch processing of spreadsheets via scripts, or complex data manipulation without user interaction. Users requiring command-line spreadsheet processing might need to look for specific libraries or other CLI tools.

HISTORY

Calligra Sheets is a successor to KSpread, which was the spreadsheet component of the older KOffice suite. With the re-architecture and rebranding effort that led to the Calligra Suite, Sheets emerged as the new, modernized spreadsheet application. The development of Calligra, starting around 2010-2012, aimed to leverage newer technologies and provide a more robust and feature-rich office experience, including better support for OpenDocument formats and integration with KDE's desktop environment.

SEE ALSO

calligra(1), kspread(1), libreoffice(1) --calc, gnumeric(1)

Copied to clipboard