Libreoffice spreadsheet7/2/2023 ![]() ![]() ![]() The menus specific to Calc are Sheet and Data in addition, several important data analysis tools are found in the Tools menu. Most of the menus are similar to those in other components of LibreOffice, although the specific commands and tools may vary. You can also customize the Menu bar see Chapter 14, Customizing LibreOffice, for more information. When you select one of the menu items, a sub-menu drops down to show commands. When you save a spreadsheet for the first time, you are prompted to enter a name of your choice. When a spreadsheet is newly created from a template or a blank document, its name is Untitled X, where X is a number. The Title bar, located at the top, shows the name of the current spreadsheet. You can show or hide many of the parts as desired, using the View menu on the Menu bar. The parts of this window are described below. When Calc is started, the main window opens ( Figure 1). A particular cell is identified by its row number and column letter.Ĭells hold the individual elements – text, numbers, formulas, and so on – that make up the data to display and manipulate.Įach spreadsheet can have up to 10,000 sheets, and each sheet can have a maximum of 1,048,576 rows and a maximum of 1024 columns. Spreadsheets consist of a number of individual sheets, each sheet containing cells arranged in rows and columns. Spreadsheets, sheets, and cellsĬalc works with documents called spreadsheets. If you want to use macros written in Microsoft Excel using the VBA macro code in LibreOffice, you must first edit the code in the LibreOffice Basic IDE editor.įor more information, refer to Chapter 12, Calc Macros, in the Calc Guide. LibreOffice can run some Excel Visual Basic scripts if you enable this feature at Tools > Options > Load/Save > VBA Properties. 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. |