Calligra Sheets (formerly ''KSpread'' and ''Calligra Tables'') is a
free software
Free software, libre software, libreware sometimes known as freedom-respecting software is computer software distributed open-source license, under terms that allow users to run the software for any purpose as well as to study, change, distribut ...
spreadsheet
A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in c ...
application that is part of
Calligra Suite, an integrated
graphic art and
office suite
Productivity software (also called personal productivity software or office productivity software) is application software used for producing information (such as documents, presentations, worksheets, databases, charts, graphs, digital paintin ...
developed by
KDE.
Features
Among Sheets’ features are multiple sheets per document, assorted formatting possibilities, support for more than 300 built-in functions, templates, chart, spell-check, hyperlinks, data sorting and scripting with
Python,
Ruby
Ruby is a pinkish-red-to-blood-red-colored gemstone, a variety of the mineral corundum ( aluminium oxide). Ruby is one of the most popular traditional jewelry gems and is very durable. Other varieties of gem-quality corundum are called sapph ...
and
JavaScript
JavaScript (), often abbreviated as JS, is a programming language and core technology of the World Wide Web, alongside HTML and CSS. Ninety-nine percent of websites use JavaScript on the client side for webpage behavior.
Web browsers have ...
.
Formats
Sheets’ native file format has been
OpenDocument
The Open Document Format for Office Applications (ODF), also known as OpenDocument, standardized as ISO 26300, is an open file format for word processor, word processing documents, spreadsheets, Presentation program, presentations and ...
since version two and previously used its own
XML
Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing data. It defines a set of rules for encoding electronic document, documents in a format that is both human-readable and Machine-r ...
format, compressed with
ZIP. Sheets also has the ability to import several spreadsheet formats, including XLS (
Microsoft Excel
Microsoft Excel is a spreadsheet editor developed by Microsoft for Microsoft Windows, Windows, macOS, Android (operating system), Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a ...
), Applix Spreadsheet,
Quattro Pro,
CSV, dBase,
Gnumeric, SXC (
OpenOffice.org XML), Kexi and TXT. It supports export of OpenDocument Spreadsheet, SXC, Tables document, CSV, HTML, Gnumeric, TeX and TXT. Sheets does not support export of XLS.
KChart
KChart is the
chart
A chart (sometimes known as a graph) is a graphics, graphical representation for data visualization, in which "the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart". A chart can repres ...
ing tool of Calligra Suite. The plug-in is relatively simple compared to other office applications such as
OpenOffice, being designed for small datasets, and using only the most common 5–6 types of chart (
histogram
A histogram is a visual representation of the frequency distribution, distribution of quantitative data. To construct a histogram, the first step is to Data binning, "bin" (or "bucket") the range of values— divide the entire range of values in ...
s,
pie charts,
line chart
A line chart or line graph, also known as curve chart, is a type of chart that displays information as a series of data points called 'markers' connected by straight wikt:line, line segments. It is a basic type of chart common in many fields. ...
s, etc.)
See also
*
Comparison of spreadsheet software
References
Calligra Suite
Free spreadsheet software
Spreadsheet software
{{KDE-stub