Although the programming languages are the same, the objects and methods are different and therefore not entirely compatible. Microsoft Office uses Visual Basic for Applications (VBA) code, and LibreOffice uses Basic code based on the LibreOffice API. However, if you are familiar with Excel you may wish to change the default syntax in Calc by going to Tools > Options > LibreOffice Calc > Formula and choosing Excel A1 or Excel R1C1 in the Formula syntax drop-down menu.įor more information on formula syntax, see Chapter 7, Using Formulas and Functions, in the Calc Guide. LibreOffice will translate seamlessly between the two. Formula syntaxīy default, LibreOffice Calc uses its own formula syntax, referred to as Calc A1, rather than the Excel A1 syntax used by Microsoft Excel. Simple wildcards such as the asterisk (*), question mark (?), and tilde (~) from other spreadsheet applications are recognized by LibreOffice in formula expressions. Import and export of spreadsheets in multiple formats, including HTML, CSV (without or with formulas), dBase, PDF, and PostScript.Ĭollaborate with others seamlessly by sharing the spreadsheet.Ĭompatibility with other spreadsheet applications Wildcards Macros, for recording and executing repetitive tasks scripting languages supported include LibreOffice Basic, Python, BeanShell, and JavaScript.Ībility to open, edit, and save Microsoft Excel spreadsheets. You can enter data (usually numerical) in a spreadsheet and then manipulate this data to produce certain results.Īlternatively, you can enter data and then use Calc in a “What if.” manner by changing some of the data and observing the results without having to retype the entire spreadsheet or sheet.įunctions, which can be used to create formulas to perform complex calculations on data.ĭatabase functions, to arrange, store, and filter data.ĭynamic charts, including a wide range of 2D and 3D charts. For a more detailed list, see the application Help.Ĭontrol+click and/or right-click depending on computer setupĬalc is the spreadsheet component of LibreOffice. The table below gives some common substitutions for the instructions in this book. Some keystrokes and menu items are different on macOS from those used in Windows and Linux. Other versions of LibreOffice may differ in appearance and functionality. Please direct any comments or suggestions about this document to the Documentation Team’s mailing list: you send to a mailing list, including your email address and any other personal information that is written in the message, is publicly archived and cannot be deleted. You may distribute it and/or modify it under the terms of either the GNU General Public License ( ), version 3 or later, or the Creative Commons Attribution License ( ), version 4.0 or later.Īll trademarks within this guide belong to their legitimate owners. This document is Copyright © 2022 by the LibreOffice Documentation Team.
0 Comments
Leave a Reply. |