请输入您要查询的百科知识：

　

词条 LibreOffice Calc
释义

  1. Features

     Pivot Table 

  2. Release history

  3. See also

  4. References

  5. External links

{{multiple issues|{{notability|Products|date=June 2013}}{{primary sources|date=June 2013}}
}}{{Infobox software
| name = LibreOffice Calc
| logo = LibreOffice 6.1 Calc Icon.svg
| logo size = 52px
| screenshot =
| caption = Screenshot of LibreOffice Calc 5.1
| collapsible =
| developer = The Document Foundation
| status = Active
| latest release version = {{Latest stable software release/LibreOffice}}
| latest release date =
| operating system = Linux, OS X, Microsoft Windows[1] and FreeBSD[2]
| genre = Spreadsheet
| license = MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[3]
| website = {{URL|https://www.libreoffice.org/discover/calc/}}
}}LibreOffice Calc is the spreadsheet component of the LibreOffice software package.[4][5]

After forking from OpenOffice.org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix a large number of defects in formula calculations involving external references, and to boost data caching performance, especially when referencing large data ranges.[6]

Additionally, Calc now supports 1 million rows in a spreadsheet[7] with macro references to each cell.

Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format.[4] Calc is also capable of saving spreadsheets as PDF files.[4]

As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows,[1] and FreeBSD.[2] Available under the Mozilla Public License, Calc is free and open-source software.[8]

There is now a closed beta of LibreOffice on AmigaOS 4.1.[9]

Features

Capabilities of Calc include:

  • Ability to read/write OpenDocument (ODF), Excel (XLS), CSV,[10] and several other formats.[11][12]
  • Support for a large number of functions, including those for imaginary numbers, as well as financial and statistical functions.[13][14]
  • Supports 1 million rows in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.[19] However, the number of columns is restricted to at most 1024, much lower than Excel's limit of 16384.[15]
  • Up to now, new functions such as IFS, Switch TEXT JOIN, MAXIFS, MINIFS functions, etc. were available only in Excel 2016 and later. Libre Office Calc can use them.

In its internal data structure, Calc until version 4.1 relies on cells as the base class throughout, which has been blamed for "extreme memory use, slow computation, and difficult code". Version 4.2 (released in January 2014) addresses these issues by instead storing the data in arrays where possible.[16]

Pivot Table

Originally called DataPilot,[6] Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis.[17]

Pivot table has support for an unlimited number of fields. Previously Pivot Table only supported up to 8 column/row/data fields and up to 10 page fields.[6]

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.[18]

Release history

Calc has continued to diverge since the fork from its parent OpenOffice with new features being added and code cleanups taking place.[19]

Versions for LibreOffice Calc include the following:
Year Released Version Comments
2011-06-16 3.3.3
  • More-familiar default key bindings.[20]
  • Toolbar icon for toggling sheet grids in Calc similar to Excel.[18]
  • Improved Excel interoperability.[18]
  • Documents drawn with the UNO api can be inserted in calc.[18]
  • New options for CSV (Comma-Separated Value) importation in Calc, allowing the import of custom delimited files common in engineering scenarios.
  • Support for 3 different formula syntaxes: Calc A1, Excel A1 and Excel R1C1.[18]
  • 1 million rows in a spreadsheet in Calc, making Calc more suitable for heavier scientific or financial spreadsheets.[18]
2011-06-03 3.4.0
  • Re-work of the drawing layer, to improve precision on re-positioning and re-sizing of drawing objects.[6]
  • Support for unlimited number of fields: Previously DataPilot only supported up to 8 column/row/data fields and up to 10 page fields. 3.4 has lifted this restriction to allow unlimited number of fields in each field type.[6]
  • Previously, Calc only supported named ranges in global scope, that is, all named ranges were made available for the entire document regardless of the current sheet. In 3.4 Calc now supports named ranges that are local to a sheet. The named range dialog (Insert->Names->Define) has been modified to reflect this change.[6]
  • Now preserves OLE links to other Excel documents when importing an Excel document. OLE links get converted to external references upon import. Previously, Calc ignored OLE links and cells containing OLE links resulted in error upon import.[6]
  • Multiple subtotals on a single sheet: It is now possible to define more than one subtotal range in a single sheet via Data->Subtotals. Previously, setting a second subtotal range removed the first one if they were on the same sheet.[6]
2012-02-15 3.5.0[21]
  • support for up to 10,000 sheets[21]
  • a new multi-line input area[21]
  • new Calc functions conforming to the ODF OpenFormula specifications[21]
  • better performance when importing files from other office suites[21]
  • multiple selections in autofilter[21]
  • unlimited number of rules for conditional formatting[21][22]
2012-08-08 3.6.0
  • Improved OOXML and ODF1.2 support[23]
  • Improved CSV file import[23]
  • Added a "Save cell formulas instead of calculated values" option to CSV export[23]
  • New spreadsheet functions[23]
  • GUI improvements[23]
  • Remove the limitation to 3 sort entries in calc[23]
  • Improved performance[23]
2013-02-07 4.0.0
  • Improved performance[24]
  • Increased size limit on (uncompressed) ODF documents[24]
  • Easier XML import[24]
  • Improved conditional formats[24]
  • initial support for the file format of gnumeric[24]
  • New spreadsheet functions[24]
2013-07-25 4.1.0
  • Embedding fonts in a Calc spreadsheet[25]
  • Add a Stepped Lines line type to Line and XY (Scatter) graphs[25]
  • Count the number of selected cells[25]
  • Import large HTML documents with more than 64k table cells[25]
  • New spreadsheet functions[25]
  • Improved hyphenation[25]
2014-01-30 4.2.0
  • New spreadsheet functions[26]
  • Random number generation (non-dynamic)[26]
  • Statistics toolkit[26]
  • Other features: Redesign of data structures and Calc core to use OpenCL, threading and dynamic data storage
2014-07-30 4.3.0
  • Smarter highlighting of cell in formula[27]
  • Number of selected rows and columns shown in the status bar[27]
  • Allow starting of cell edit with the content of the cell above it as its initial content.[27]
  • User selectable text conversion models.[27]
  • Pivot Table layout improvement.[27]
  • Add 34 new spreadsheet functions.[27]
  • Enable [https://projects.coin-or.org/CoinMP CoinMP] solver for additional options to previously enabled LpSolve.[27]
  • Added three Statistics Wizard options.[27]
  • Additional functionality to random number generator.[27]
2015-01-29 4.4.0
  • Added three Statistics Wizard options.[28]
  • Add direct conversion of formulas to static values.[28]
  • Add one new spreadsheet function.[28]
  • Toolbar improvements[28]
  • Add sheet context menu.[28]
2015-08-05 5.0.0
  • Added optional ability to repeat pivot table item labels.[29]
  • Added additional conditional formatting options.[29]
  • Improvements to XLSX import and export.[29]
  • Additional engineering notation options[29]
  • Improvements to table structured references.[29]
  • New spreadsheet functions and improvements to function import and export.[29]
  • Added capabilities in references of entire column/row (A:A / 1:1).[29]
  • Added ability to crop, change, and save an image.[29]
  • Toolbar improvements.[29]

See also

{{Portal|Free and open-source software|Computer Science}}
  • List of spreadsheets
  • Comparison of spreadsheets
{{-}}

References

1. ^1 {{Cite web|url = https://www.libreoffice.org/get-help/system-requirements/|title = System Requirements|accessdate = 8 September 2011|last = The Document Foundation|year = n.d.}}
2. ^1 FreeBSD Handbook, 7.3.5 LibreOffice
3. ^{{cite web | title = Licenses | url = https://www.libreoffice.org/download/license/ | publisher = The Document Foundation | accessdate = 16 December 2015}}
4. ^1 2 {{Cite web|url=https://www.libreoffice.org/discover/calc/|title=Calc, the LibreOffice spreadsheet program|last=|first=|date=|website=|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=8 September 2011}}
5. ^{{cite book | first1=Richard | last1=Petersen | year=2011 | page=170 | title=Ubuntu 11. 04 Desktop Handbook | publisher=Surfing Turtle Press | isbn=1-936280-28-0 | url=https://books.google.com/books?id=CS7txn0x8OEC&pg=PA170 }}
6. ^1 2 3 4 5 6 7 {{Cite web|url=https://www.libreoffice.org/download/3-4-new-features-and-fixes/|title=3.4 New Features and Fixes|first=|date=|website=|publisher=The Document Foundation|archive-url=https://web.archive.org/web/20131214213702/https://www.libreoffice.org/download/3-4-new-features-and-fixes/|archive-date=14 December 2013|dead-url=|accessdate=8 September 2011}}
7. ^{{Cite web|url=https://arstechnica.com/information-technology/2011/01/the-document-foundation-announces-first-release-of-libreoffice/|title=First release of LibreOffice arrives with improvements over OOo|last=Paul|first=Ryan|date=25 January 2011|work=Ars Technica|archive-url=https://web.archive.org/web/20181127022527/https://arstechnica.com/information-technology/2011/01/the-document-foundation-announces-first-release-of-libreoffice/|archive-date=27 November 2018|dead-url=No|accessdate=8 September 2011}}
8. ^{{Cite web|url=https://www.libreoffice.org/download/license/|title=Licenses|first=|authorlink=|date=|website=|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=21 June 2011}}
9. ^{{Cite web|url=https://www.generationamiga.com/2017/02/28/new-beta-libreoffice-for-amigaos-4-1/|title=New beta LibreOffice for AmigaOS 4.1|first=|date=28 February 2017|website=GenerationAmiga.com|archive-url=|archive-date=|dead-url=}}
10. ^{{Cite web|url=https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files|title=Importing and Exporting CSV Files|last=|first=|website=LibreOffice Help|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=8 September 2011}}
11. ^{{Cite web|url=https://help.libreoffice.org/Common/About_Import_and_Export_Filters|title=About Import and Export Filters|last=|first=|date=|website=LibreOffice Help|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=8 September 2011}}
12. ^{{Cite web|url=https://wiki.documentfoundation.org/LibreOffice_OOXML|title=The Document Foundation, LibreOffice and OOXML|last=|first=|website=The Document Foundation Wiki|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=8 September 2011}}
13. ^{{Cite web|url=https://help.libreoffice.org/Calc/Financial_Functions_Part_One|title=Financial Functions Part One|last=|first=|website=LibreOffice Help|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=8 September 2011}}
14. ^{{Cite web|url=https://help.libreoffice.org/Calc/Add-in_Functions,_List_of_Analysis_Functions_Part_Two#IMAGINARY|title=Add-in Functions, List of Analysis Functions Part Two|first=|website=LibreOffice Help|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=8 September 2011}}
15. ^[https://bugs.freedesktop.org/show_bug.cgi?id=50916 Bug 50916 - Allow more than 1024 columns in calc]
16. ^{{Cite web|url=https://lwn.net/Articles/571291/|title=A LibreOffice Update|last=Corbet|first=Jonathan|date=23 October 2013|website=LWN.net|archive-url=|archive-date=|dead-url=|access-date=}}
17. ^{{Cite web|url=https://help.libreoffice.org/Calc/Pivot_Table|title=Pivot Table|first=|website=LibreOffice Help|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=13 November 2011}}
18. ^1 2 3 4 5 6 {{Cite web|url=https://www.libreoffice.org/download/3-3-new-features-and-fixes/|title=3.3 New Features and Fixes|first=|authorlink=|date=|year=2011|website=LibreOffice|publisher=The Document Foundation|archive-url=https://web.archive.org/web/20140227184750/https://www.libreoffice.org/download/3-3-new-features-and-fixes/|archive-date=27 February 2014|dead-url=|accessdate=29 July 2011}}
19. ^{{Cite web|url=https://www.pcworld.com/article/229353/despite_oracles_antics_libreoffice_gets_a_big_update.html|title=Despite Oracle's Antics, LibreOffice Gets a Big Update|last=Noyes|first=Katherine|authorlink=|date=3 June 2011|work=PC World|archive-url=|archive-date=|dead-url=|accessdate=8 September 2011}}
20. ^{{Cite web|url=http://www.infoworld.com/print/151716/|title=Open office dilemma: OpenOffice.org vs. LibreOffice|last=McAllister|first=Neil|date=16 February 2011|work=InfoWorld|accessdate=8 September 2011|archive-url=https://archive.fo/hVnUC|archive-date=1 October 2013}}
21. ^1 2 3 4 5 6 {{cite web|url=https://blog.documentfoundation.org/blog/2012/02/14/the-document-foundation-announces-libreoffice-3-5-the-best-free-office-suite-ever/|title=The Document Foundation announces LibreOffice 3.5: “the best free office suite ever”|last=Vignoli|first=Italo|date=14 February 2012|website=|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|access-date=}}
22. ^{{Cite web|url=https://web.archive.org/web/20131124100155/https://www.libreoffice.org/download/3-5-new-features-and-fixes/|title=3.5 New Features and Fixes|last=|first=|date=|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=}}
23. ^1 2 3 4 5 6 {{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/3.6|title=LibreOffice 3.6: Release Notes|last=|first=|date=|website=The Document Foundation Wiki|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=3 November 2013}}
24. ^1 2 3 4 5 {{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.0|title=LibreOffice 4.0: Release Notes|last=|first=|date=|website=The Document Foundation Wiki|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=3 November 2013}}
25. ^1 2 3 4 5 {{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.1|title=LibreOffice 4.1: Release Notes|last=|first=|date=|website=The Document Foundation Wiki|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=3 November 2013}}
26. ^1 2 {{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.2|title=LibreOffice 4.2: Release Notes|last=|first=|date=|website=The Document Foundation Wiki|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=3 January 2014}}
27. ^1 2 3 4 5 6 7 8 {{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.3#Calc|title=LibreOffice 4.3: Release Notes {{!}} Calc|last=|first=|date=|website=The Document Foundation Wiki|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=14 April 2015}}
28. ^1 2 3 4 {{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.4#Calc|title=LibreOffice 4.4: Release Notes {{!}} Calc|last=|first=|date=|website=The Document Foundation Wiki|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=14 April 2015}}
29. ^1 2 3 4 5 6 7 8 {{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/5.0#Calc|title=LibreOffice 5.0: Release Notes {{!}} Calc|last=|first=|date=|website=The Document Foundation Wiki|publisher=The Document Foundation|archive-url=|archive-date=|dead-url=|accessdate=6 August 2015}}

External links

{{commons category|Screenshots of LibreOffice Calc}}
  • {{Official website|https://www.libreoffice.org/discover/calc/}}
{{Spreadsheets}}{{DEFAULTSORT:Libreoffice.Org Calc}}

6 : Cross-platform free software|Free spreadsheet software|LibreOffice|Spreadsheet software|Spreadsheet software for macOS|Spreadsheet software for Windows
随便看

　

开放百科全书收录14589846条英语、德语、日语等多语种百科知识，基本涵盖了大多数领域的百科知识，是一部内容自由、开放的电子版国际百科全书。

　

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间：2024/11/13 18:49:40