Each cell in a field contains an individual data item or attribute, such as a name, while each record consists of related attributes that correspond to a single entity, like a person. Each row of a table represents a data record, while each column represents a field within each record. In a typical database, related data is organized into tables, which are arranged in a grid-like series of rows and columns similar to a spreadsheet. Much of the macro information on those pages is drawn or adapted from Andrew Pitonyak’s book, Macros Explained (OOME) and LibreOffice’s API reference at.
These are now available on The Document Foundation’s wiki at. See the Base Guide for more information.Įarlier versions of this chapter contained several example LibreOffice Basic macros. In the other direction, for Base users who wish to take advantage of some of Calc’s features to analyze or visualize their data, Base can be used for creating linked data ranges in Calc files, for pivot table analysis, or as the basis for charts.
This chapter presents an overview of these capabilities.įor those users who initially choose to manage their data in a Calc spreadsheet and subsequently decide that they need to use a more comprehensive database system, migrating Calc data to Base is straightforward. For such users, Calc has sufficient functionality to act as a simple yet capable database-like platform. As the data in a spreadsheet is laid out in a table view, plainly visible and easily edited or extended, some users may not need the comprehensive relational database facilities provided by the Base component of LibreOffice. In many everyday scenarios, Calc spreadsheets can be used to aggregate sets of data and to perform analyses on them. For a more detailed list, see the application Help and Appendix A (Keyboard Shortcuts) to this guide.Ĭontrol+click and/or right-click depending on computer setup 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 © 2021 by the LibreOffice Documentation Team.
0 kommentar(er)
