Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
LibreOffice Calc
open-in-new
<h2 id="features">Features</h2> <p>Capabilities of Calc include: </p> <ul><li>Ability to read/write <a href="/facts/OpenDocument/pMtcVuNr">OpenDocument</a> (ODF), Microsoft Excel (XLSX), <a href="/facts/Comma-separated_values/dv1pSR1r">CSV</a>,<a class="footnote-ref" id="fnref:12" href="#fn:12"><sup>12</sup></a> and several other formats.<a class="footnote-ref" id="fnref:13" href="#fn:13"><sup>13</sup></a><a class="footnote-ref" id="fnref:14" href="#fn:14"><sup>14</sup></a></li> <li>Support for many functions, including those for <a href="/facts/Imaginary_number/6Xh9W3hq">imaginary numbers</a>, as well as financial and statistical functions.<a class="footnote-ref" id="fnref:15" href="#fn:15"><sup>15</sup></a><a class="footnote-ref" id="fnref:16" href="#fn:16"><sup>16</sup></a></li> <li>Supports 1,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.<a class="footnote-ref" id="fnref:17" href="#fn:17"><sup>17</sup></a> Version 7.0 introduced "very large spreadsheets" which can be enabled as an experimental feature.<a class="footnote-ref" id="fnref:18" href="#fn:18"><sup>18</sup></a> Version 7.4 made very large spreadsheets default.<a class="footnote-ref" id="fnref:19" href="#fn:19"><sup>19</sup></a></li> <li>Up to now, new functions such as IFS, Switch TEXT JOIN, MAXIFS, MINIFS functions, etc. were available only in Excel 2016 and later. LibreOffice Calc can use them.</li></ul> <h3>Pivot Table</h3> <p>Originally called DataPilot,<a class="footnote-ref" id="fnref:20" href="#fn:20"><sup>20</sup></a> Pivot Table provides similar functionality to the <a href="/facts/Pivot_table/FwXKTJog">Pivot table</a> found in <a href="/facts/Microsoft_Excel/Ezal6G75">Microsoft Excel</a>. It is used for interactive table layout and dynamic data analysis.<a class="footnote-ref" id="fnref:21" href="#fn:21"><sup>21</sup></a> </p><p>An advanced sort macro is included that allows data to be arranged or categorised based on either a user generated macro or one of several default included macros.<a class="footnote-ref" id="fnref:22" href="#fn:22"><sup>22</sup></a> </p> <h2 id="supported-file-formats">Supported file formats</h2> <table><tbody><tr><th>File format</th><th>Extension</th><th>Read/Write</th><th>Notes</th></tr><tr><td><a href="/facts/Apple_Numbers/Bl4SKeLs">Apple Numbers</a></td><td>NUMBERS</td><td>From 5.0</td><td></td></tr><tr><td><a href="/facts/Comma-separated_values/dv1pSR1r">Comma-separated values</a></td><td>CSV</td><td>Yes</td><td></td></tr><tr><td><a href="/facts/Data_Interchange_Format/o90EnaJt">Data Interchange Format</a></td><td>DIF</td><td>Yes</td><td></td></tr><tr><td><a href="/facts/DBase/9U0YCWEo">DBase</a>, <a href="/facts/Clipper/2tHzxph3">Clipper</a>, <a href="/facts/VP-Info/ek8sHFek">VP-Info</a>,<p><a href="/facts/FoxPro/1KBHyeug">FoxPro</a></p></td><td>DBF</td><td>Yes</td><td></td></tr><tr><td><a href="/facts/Gnumeric/HXPlB5yy">Gnumeric</a></td><td>GNM, GNUMERIC</td><td>From 5.1, cannot write</td><td></td></tr><tr><td><a href="/facts/Lotus_1-2-3/tnkvSG3M">Lotus 1-2-3</a></td><td>123, WKS, WKS1, WK2,<p>WK3, WK4</p></td><td>Yes</td><td></td></tr><tr><td><a href="/facts/Microsoft_Excel/Ezal6G75">Microsoft Excel</a> 4/5/95</td><td>XLS, XLW, XLT</td><td>Yes, writing up to 3.6</td><td></td></tr><tr><td>Microsoft Excel 97–2003</td><td>XLS, XLW, XLT</td><td>Yes</td><td></td></tr><tr><td>Microsoft Excel 2007-2021</td><td>XLSX, XLTX, XLSM,<p>XLTM</p></td><td>Yes</td><td></td></tr><tr><td>Microsoft Excel 2003 XML</td><td>XML</td><td>Yes</td><td></td></tr><tr><td>Microsoft Excel Web<p>Query File</p></td><td>IQY</td><td>From 5.4</td><td></td></tr><tr><td>Microsoft Pocket Excel</td><td>PXL</td><td>Yes</td><td>Requires Java</td></tr><tr><td><a href="/facts/OpenDocument/pMtcVuNr">OpenDocument</a><p>(spreadsheet)</p></td><td>ODS, FODS, OTS,</td><td>Yes</td><td></td></tr><tr><td><a href="/facts/OpenOffice.org_XML/jb6krPw5">OpenOffice.org XML</a><p>(spreadsheet)</p></td><td>SXC, STC</td><td>Yes</td><td></td></tr><tr><td><a href="/facts/Quattro_Pro/M1PgFfY6">Quattro Pro</a> 6.0</td><td>WB2, WQ1, WQ2</td><td>Yes</td><td></td></tr><tr><td>StarOffice StarCalc 3/4/5</td><td>SDC, VOR</td><td>Dropped in 4.0 then<p>added back in 5.3, writeup to 3.6</p></td><td></td></tr><tr><td><a href="/facts/SYmbolic_LinK_(SYLK)/WkUV85Ha">SYLK</a></td><td>SLK</td><td>Yes</td><td></td></tr></tbody></table> <h2 id="see-also">See also</h2> <ul> <li>Free and open-source software portal</li></ul> <ul><li><a href="/facts/LibreOffice_Writer/yKJw6vhp">LibreOffice Writer</a></li> <li><a href="/facts/List_of_spreadsheet_software/dxEsRbqr">List of spreadsheet software</a></li> <li><a href="/facts/Comparison_of_spreadsheet_software/CSkoam6l">Comparison of spreadsheet software</a></li></ul> <h2 id="external-links">External links</h2> Wikimedia Commons has media related to Screenshots of LibreOffice Calc. <ul><li><a href="https://www.libreoffice.org/discover/calc/">Official website</a></li></ul> <h2 id="references">References</h2> <ol> <li id="fn:1"><p>"Calc, the LibreOffice spreadsheet program". The Document Foundation. Retrieved 8 September 2011. <a href="https://www.libreoffice.org/discover/calc/" target="_blank">https://www.libreoffice.org/discover/calc/</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li> <li id="fn:2"><p>Petersen, Richard (2011). Ubuntu 11. 04 Desktop Handbook. Surfing Turtle Press. p. 170. ISBN 978-1-936280-28-5. <a href="978-1-936280-28-5" target="_blank">978-1-936280-28-5</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li> <li id="fn:3"><p>"3.4 New Features and Fixes". The Document Foundation. Archived from the original on 14 December 2013. Retrieved 8 September 2011. <a href="https://web.archive.org/web/20131214213702/https://www.libreoffice.org/download/3-4-new-features-and-fixes/" target="_blank">https://web.archive.org/web/20131214213702/https://www.libreoffice.org/download/3-4-new-features-and-fixes/</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li> <li id="fn:4"><p>"Calc, the LibreOffice spreadsheet program". The Document Foundation. Retrieved 8 September 2011. <a href="https://www.libreoffice.org/discover/calc/" target="_blank">https://www.libreoffice.org/discover/calc/</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li> <li id="fn:5"><p>"Calc, the LibreOffice spreadsheet program". The Document Foundation. Retrieved 8 September 2011. <a href="https://www.libreoffice.org/discover/calc/" target="_blank">https://www.libreoffice.org/discover/calc/</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></p></li> <li id="fn:6"><p>The Document Foundation (n.d.). "System Requirements". Retrieved 8 September 2011.{{cite web}}: CS1 maint: year (link) <a href="/wiki/The_Document_Foundation" target="_blank">/wiki/The_Document_Foundation</a> <a href="#fnref:6" class="footnote-back-ref">↩</a></p></li> <li id="fn:7"><p>FreeBSD Handbook, 7.3.5 LibreOffice <a href="http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/desktop-productivity.html" target="_blank">http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/desktop-productivity.html</a> <a href="#fnref:7" class="footnote-back-ref">↩</a></p></li> <li id="fn:8"><p>"Licenses". The Document Foundation. Retrieved 21 June 2011. <a href="https://www.libreoffice.org/download/license/" target="_blank">https://www.libreoffice.org/download/license/</a> <a href="#fnref:8" class="footnote-back-ref">↩</a></p></li> <li id="fn:9"><p>"Collabora Office". Google Play. Archived from the original on 31 December 2022. Retrieved 7 May 2023. <a href="https://play.google.com/store/apps/details?id=com.collabora.libreoffice" target="_blank">https://play.google.com/store/apps/details?id=com.collabora.libreoffice</a> <a href="#fnref:9" class="footnote-back-ref">↩</a></p></li> <li id="fn:10"><p>"Collabora Office". Apple App Store. 2023. Archived from the original on 5 October 2020. Retrieved 7 May 2023. <a href="https://apps.apple.com/us/app/collabora-office/id1440482071" target="_blank">https://apps.apple.com/us/app/collabora-office/id1440482071</a> <a href="#fnref:10" class="footnote-back-ref">↩</a></p></li> <li id="fn:11"><p>"New beta LibreOffice for AmigaOS 4.1". GenerationAmiga.com. 28 February 2017. Archived from the original on 2 December 2019. Retrieved 12 December 2018. <a href="https://web.archive.org/web/20191202060646/http://www.generationamiga.com/2017/02/28/new-beta-libreoffice-for-amigaos-4-1/" target="_blank">https://web.archive.org/web/20191202060646/http://www.generationamiga.com/2017/02/28/new-beta-libreoffice-for-amigaos-4-1/</a> <a href="#fnref:11" class="footnote-back-ref">↩</a></p></li> <li id="fn:12"><p>"Importing and Exporting CSV Files". LibreOffice Help. The Document Foundation. Retrieved 8 September 2011. <a href="https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files" target="_blank">https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files</a> <a href="#fnref:12" class="footnote-back-ref">↩</a></p></li> <li id="fn:13"><p>"About Import and Export Filters". LibreOffice Help. The Document Foundation. Retrieved 8 September 2011. <a href="https://help.libreoffice.org/Common/About_Import_and_Export_Filters" target="_blank">https://help.libreoffice.org/Common/About_Import_and_Export_Filters</a> <a href="#fnref:13" class="footnote-back-ref">↩</a></p></li> <li id="fn:14"><p>"The Document Foundation, LibreOffice and OOXML". The Document Foundation Wiki. The Document Foundation. Retrieved 8 September 2011. <a href="https://wiki.documentfoundation.org/LibreOffice_OOXML" target="_blank">https://wiki.documentfoundation.org/LibreOffice_OOXML</a> <a href="#fnref:14" class="footnote-back-ref">↩</a></p></li> <li id="fn:15"><p>"Financial Functions Part One". LibreOffice Help. The Document Foundation. Retrieved 8 September 2011. <a href="https://help.libreoffice.org/Calc/Financial_Functions_Part_One" target="_blank">https://help.libreoffice.org/Calc/Financial_Functions_Part_One</a> <a href="#fnref:15" class="footnote-back-ref">↩</a></p></li> <li id="fn:16"><p>"Add-in Functions, List of Analysis Functions Part Two". LibreOffice Help. The Document Foundation. Retrieved 8 September 2011. <a href="https://help.libreoffice.org/Calc/Add-in_Functions,_List_of_Analysis_Functions_Part_Two#IMAGINARY" target="_blank">https://help.libreoffice.org/Calc/Add-in_Functions,_List_of_Analysis_Functions_Part_Two#IMAGINARY</a> <a href="#fnref:16" class="footnote-back-ref">↩</a></p></li> <li id="fn:17"><p>"3.3 New Features and Fixes". LibreOffice. The Document Foundation. 2011. Archived from the original on 27 February 2014. Retrieved 29 July 2011. <a href="https://web.archive.org/web/20140227184750/https://www.libreoffice.org/download/3-3-new-features-and-fixes/" target="_blank">https://web.archive.org/web/20140227184750/https://www.libreoffice.org/download/3-3-new-features-and-fixes/</a> <a href="#fnref:17" class="footnote-back-ref">↩</a></p></li> <li id="fn:18"><p>"50916 – Allow more than 1024 columns in calc". bugs.documentfoundation.org. Retrieved 4 May 2022. <a href="https://bugs.documentfoundation.org/show_bug.cgi?id=50916" target="_blank">https://bugs.documentfoundation.org/show_bug.cgi?id=50916</a> <a href="#fnref:18" class="footnote-back-ref">↩</a></p></li> <li id="fn:19"><p>"LibreOffice 7.4 Community: Release Notes - The Document Foundation Wiki". wiki.documentfoundation.org. Retrieved 28 January 2023. <a href="https://wiki.documentfoundation.org/ReleaseNotes/7.4#General_Improvements_2" target="_blank">https://wiki.documentfoundation.org/ReleaseNotes/7.4#General_Improvements_2</a> <a href="#fnref:19" class="footnote-back-ref">↩</a></p></li> <li id="fn:20"><p>"3.4 New Features and Fixes". The Document Foundation. Archived from the original on 14 December 2013. Retrieved 8 September 2011. <a href="https://web.archive.org/web/20131214213702/https://www.libreoffice.org/download/3-4-new-features-and-fixes/" target="_blank">https://web.archive.org/web/20131214213702/https://www.libreoffice.org/download/3-4-new-features-and-fixes/</a> <a href="#fnref:20" class="footnote-back-ref">↩</a></p></li> <li id="fn:21"><p>"Pivot Table". LibreOffice Help. The Document Foundation. Retrieved 13 November 2011. <a href="https://help.libreoffice.org/Calc/Pivot_Table" target="_blank">https://help.libreoffice.org/Calc/Pivot_Table</a> <a href="#fnref:21" class="footnote-back-ref">↩</a></p></li> <li id="fn:22"><p>"3.3 New Features and Fixes". LibreOffice. The Document Foundation. 2011. Archived from the original on 27 February 2014. Retrieved 29 July 2011. <a href="https://web.archive.org/web/20140227184750/https://www.libreoffice.org/download/3-3-new-features-and-fixes/" target="_blank">https://web.archive.org/web/20140227184750/https://www.libreoffice.org/download/3-3-new-features-and-fixes/</a> <a href="#fnref:22" class="footnote-back-ref">↩</a></p></li> </ol>