LibreOffice Calc 7.0 Guide
This book is adapted and updated from the LibreOffice 6.4 Calc Guide. Each spreadsheet can have up to 10000 sheets and each sheet can have a maximum of.
LibreOffice 7.2 Calc Guide
This book introduces the features and functions of LibreOffice Calc. It is not a tutorial on using This user guide has been updated from Calc Guide 7.1.
LibreOffice 7.1 Calc Guide
This book introduces the features and functions of LibreOffice Calc. Each spreadsheet can have up to 10000 sheets and each sheet can have a maximum of.
LibreOffice 7.0 Getting Started Guide
the relevant chapters in this guide about Writer Calc
LibreOffice 7.3 Getting Started Guide
the relevant chapters in this guide about Writer Calc
LibreOffice 4.1 Calc Guide - The Document Foundation Wiki
Dec 9 2013 What's in this book? This book introduces the features and functions of LibreOffice Calc. It is not a tutorial on using spreadsheets.
LibreOffice 7.2 Base Guide
Relationships between spreadsheets cannot be set up in Base as Calc is not suitable for use as a relational database. Accessing external databases
LibreOffice 7.2 Getting Started Guide
the relevant chapters in this guide about Writer Calc
LibreOffice 7.2 Math Guide
In LibreOffice formulas can be inserted as objects into Writer
LibreOffice 7.3 Writer Guide
For more about charts see the Calc Guide. Creating and editing images. You might create images using a graphics program
[PDF] LibreOffice Calc 70 Guide
This book is adapted and updated from the LibreOffice 6 4 Calc Guide also export spreadsheets to PDF and XHTML file formats; see Chapter 6 Printing
Calc Guides - LibreOffice Documentation
Purchase or download the latest LibreOffice Calc Guide written by community experts LibreOffice the best free and open source office suite
[PDF] LibreOffice 70 Getting Started Guide
May I distribute the PDF of this book or print and sell copies? Calc has all of the advanced analysis charting and decision making features expected
English documentation - LibreOffice User Guides - LibreOffice
Download Impress Guide 7 4 Buy a printed copy · Download PDF · Download Source Files · Read in your browser · Download Calc Guide 7 4 Buy a printed copy
[PDF] LibreOffice 73 Getting Started Guide
May I distribute the PDF of this book or print and sell copies? Calc has all of the advanced analysis charting and decision making features expected
The LibreOffice Calc Guide 71 is Here!
21 mai 2021 · The book is available in PDF format and contains 545 pages covering all basic and advanced features of the spreadsheet module of LibreOffice
[PDF] Parcours guidé du tableur Calc - Pack Logiciels Libres
Formule un éditeur de formules mathématiques comme l'éditeur d'équations de Microsoft LibreOffice est un produit libre téléchargeable sur le site officiel
[PDF] Advanced spreadsheet; LibreOffice Calc - handbook - ITdeskinfo
ITdesk info – project of computer e-education with open access – Manual for computer literacy Subtitle: Advanced spreadsheets – LibreOffice Calc manual
[PDF] Lesson 4: Introduction to the Calc Spreadsheet
4 1 Typical spreadsheet (Grade book) for a 4th Grade class As illustrated in Fig Open the LibreOffice program then open a new Calc spreadsheet
LibreOffice
This guide explains the file formats supported by the LibreOffice Calc spreadsheet This tutorial explains simple steps to modify PDF documents using the
Copyright
This document is Copyright © 2021 by the LibreOffice Documentation Team. Contributors are listed below. You may distribute it and/or modify it under the terms of either the GNU General Public License (https://www.gnu.org/licenses/gpl.html), version 3 or later, or the Creative Commons Attribution License (https://creativecommons.org/licenses/by/4.0/), version 4.0 or later. All trademarks within this guide belong to their legitimate owners.Contributors
To this edition
Pulkit KrishnaDan LewisJenna Sargent
Drew JensenJean-Pierre LedureJean Hollis Weber
Steve Fanning
To previous editions
Pulkit KrishnaJean Hollis WeberDan Lewis
Peter SchofieldJochen SchiffersRobert Großkopf
Jost LangeMartin FoxHazel Russman
Steve SchwettmanAlain RomedenneAndrew Pitonyak
Jean-Pierre LedureDrew JensenRandolph Gamo
Feedback
Please direct any comments or suggestions about this document to the Documentation Team's mailing list: documentation@global.libreoffice.org. Note Everything 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.Publication date and software version
Published December 2021. Based on LibreOffice 7.2 Community. Other versions of LibreOffice may differ in appearance and functionality. Documentation for LibreOffice is available at https://documentation.libreoffice.org/en/Contents
Who is this book for?.................................................................................................................7
What's in this book?..................................................................................................................7
Sample databases....................................................................................................................7
Where to get more help.............................................................................................................7
What you see may be different................................................................................................10
Using LibreOffice on macOS...................................................................................................10
What are all these things called?.............................................................................................11
Frequently asked questions....................................................................................................12
What's new in LibreOffice Base 7.2 Community?....................................................................13
Chapter 1 Introduction to Base......................................................................................14
Base - a container for database content.................................................................................15
A simple database - test example in detail.............................................................................23
Extensions to the sample database........................................................................................51
Chapter 2 Creating a Database......................................................................................52
Creating a new database using the internal HSQL engine......................................................53
Accessing external databases.................................................................................................55
Subsequent editing of connection properties..........................................................................82
Chapter 3 Tables..............................................................................................................85
General information on tables.................................................................................................86
Relationships between tables..................................................................................................86
Creating tables........................................................................................................................92
Linking tables........................................................................................................................109
Entering data into tables........................................................................................................112
Chapter 4 Forms............................................................................................................127
Forms make data entry easier...............................................................................................128
Creating forms......................................................................................................................128
Form properties.....................................................................................................................132
Main forms and subforms......................................................................................................175
One view - many forms........................................................................................................187
Error messages during input to forms...................................................................................193
Searching and filtering in forms using the navigation bar......................................................193
Record input and navigation..................................................................................................199
Printing from forms................................................................................................................200
Chapter 5 Queries..........................................................................................................202
General information on queries.............................................................................................203
Entering queries....................................................................................................................203
Using an alias in a query.......................................................................................................227
Queries for the creation of list box fields...............................................................................228
LibreOffice 7.2 Base Guide | 3
Queries as a basis for additional information in forms...........................................................230
Data entry possibilities within queries....................................................................................231
Use of parameters in queries................................................................................................235
Correlated subqueries...........................................................................................................237
Queries as source tables for queries.....................................................................................237
Summarizing data with queries.............................................................................................240
More rapid access to queries using table views....................................................................241
Calculation errors in queries..................................................................................................242
Chapter 6 Reports.........................................................................................................245
Creating reports using the Report Builder.............................................................................246
The user interface of the Report Builder................................................................................246
Functions in the Report Builder.............................................................................................261
Examples of reports created with the Report Builder............................................................269
Sources of errors in reports...................................................................................................283
Chapter 7 Linking to Databases...................................................................................284
General notes on database linkage.......................................................................................285
Registration of databases......................................................................................................285
Data source browser.............................................................................................................285
Mail merge............................................................................................................................291
Creating mail merge documents...........................................................................................292
Label printing........................................................................................................................297
Direct creation of mail merge and label documents...............................................................299
External forms.......................................................................................................................301
Database use in Calc............................................................................................................302
Converting data from one database to another.....................................................................305
Importing records into a table using the clipboard.................................................................306
Importing PDF records..........................................................................................................306
Chapter 8 Database Tasks............................................................................................313
General remarks on database tasks......................................................................................314
Data filtering..........................................................................................................................314
Searching for data.................................................................................................................316
Handling images and documents in Base.............................................................................321
Reading and displaying images and documents...................................................................329
Code snippets.......................................................................................................................330
Chapter 9 Macros..........................................................................................................341
General remarks on macros..................................................................................................342
Macros in Base.....................................................................................................................343
Improving usability................................................................................................................366
Database tasks expanded using macros...............................................................................399
Accessing a MySQL database with macros..........................................................................415
Writing macros with Access2Base.........................................................................................431
4 | LibreOffice 7.2 Base Guide
Chapter 10 Database Maintenance..............................................................................435
General remarks on maintaining databases..........................................................................436
Compacting a database........................................................................................................436
Resetting autovalues.............................................................................................................436
Querying database properties...............................................................................................436
Exporting data.......................................................................................................................437
Testing tables for unnecessary entries..................................................................................438
Database search speed........................................................................................................440
Appendix A Common Database Tasks........................................................................442
Data types for the table editor...............................................................................................443
Data types in StarBasic.........................................................................................................445
Built-in functions and stored procedures...............................................................................445
Control characters for use in queries.....................................................................................452
Some uno commands for use with a button..........................................................................452
Information tables for HSQLDB.............................................................................................452
Database repair for *.odb files...............................................................................................454
Managing the internal Firebird database...............................................................................462
Appendix B Comparison of HSQLDB and Firebird....................................................463Data types and functions in HSQLDB and Firebird...............................................................464
Built-in functions and stored procedures...............................................................................464
Data types for the table editor...............................................................................................480
LibreOffice 7.2 Base Guide | 5
Base Guide 7.2
Preface
Who is this book for?
Anyone who wants to get up to speed quickly with LibreOffice Base will find this book valuable. Whether you have never worked with databases before, or have worked with them in a DBMS (Database Management System), or you are used to another database system from an office suite or a stand-alone database system such as MySQL, this book is for you. You may wish to first read Chapter 8, Getting Started with Base, in the Getting Started Guide.What's in this book?
This book introduces Base, the database component of LibreOffice. Base uses the HSQLDB (HyperSQL DataBase) database engine to create database documents. It can access databases created by many database programs, including Microsoft Access, MySQL, Oracle, Firebird, and PostgreSQL. Base includes additional functionality that allows you to create full data-driven applications. Note In addition to the HSQLDB engine, an experimental facility is available to create database documents using an embedded Firebird database engine. Advanced users can enable experimental facilities by selecting the Enable experimental facilities checkbox on the Tools > Options > LibreOffice > Advanced dialog. This book introduces the features and functions of Base, using a set of sample databases. •Creating a database •Accessing external databases •Creating and using tables in relational databases •Creating and using forms for data entry •Using queries to bring together data from different tables, calculate results where necessary, and quickly filter a specific record from a mass of data •Creating reports using the Report Builder •Linking databases to other documents and external forms, including use in mail merge •Filtering and searching data •Using macros to prevent input errors, simplify tasks, and improve usability of forms •Maintaining databasesSample databases
A set of sample databases has been created to accompany this book. You can find them here:Where to get more help
This book, the other LibreOffice user guides, the built-in Help system, and user support systems assume that you are familiar with your computer and basic functions such as starting a program, opening and saving files.Where to get more help | 7
Help system
LibreOffice comes with an extensive Help system. This is the first line of support for using LibreOffice. Windows and Linux users can choose to download and install the offline Help for use when not connected to the Internet; the offline Help is installed with the program on macOS. To display the Help system, press F1 or select Help > LibreOffice Help on the Menu bar. If you do not have the offline help installed on your computer and you are connected to the Internet, your default browser will open the online Help pages on the LibreOffice website. The Help menu (Figure 1) includes links to other LibreOffice information and support facilities.Figure 1: The Help menu
Note The options indicated by a ‡ symbol in the list below are only accessible if your computer is connected to the Internet. •What's This? - For quick tips when a toolbar is visible, place the mouse pointer over any of the icons to see a small box ("tooltip") with a brief explanation of the icon's function. For a more detailed explanation, select Help > What's This? and hold the pointer over the icon. In addition, you can choose whether to activate extended tips using Tools >Options > LibreOffice > General > Extended tips.
•User Guides‡ - Opens your default browser at the English Documentation page of the LibreOffice website https://documentation.libreoffice.org/en/english-documentation/. There you will find copies of user guides and other useful information. •Show Tip of the Day - Opens a dialog showing a useful bit of information to help expand your knowledge of LibreOffice. •Get Help Online‡ - Opens your default browser at the Ask LibreOffice forum of questions and answers from the LibreOffice community https://ask.libreoffice.org/en/questions/. •Send Feedback‡ - Opens your default browser at the Feedback page of the LibreOffice website https://www.libreoffice.org/get-help/feedback/. From there you can report bugs, suggest new features, and communicate with others in the LibreOffice community.8 | Preface
•Restart in Safe Mode - Opens a dialog where you can restart LibreOffice and reset the software to its default settings. •Get Involved‡ - Opens your default browser at the Get Involved page of the LibreOffice website https://www.libreoffice.org/community/get-involved/. There you can choose a topic of interest to help improve the program. •Donate to LibreOffice‡ - Opens your default browser at the Donation page of the LibreOffice website https://donate.libreoffice.org/. •License Information - Outlines the licenses under which LibreOffice is made available. •Check for Updates‡ - Opens a dialog and checks the LibreOffice website for updates to your version of the software. •About LibreOffice - Opens a dialog, which displays information about the version of LibreOffice and the operating system you are using. This information will often be requested if you ask the community for help or assistance with the software. A button is provided to enable you to copy this information to the clipboard so that you can subsequently paste it into a forum post, an email, or a bug report. (On macOS, this item is under LibreOffice on the Menu bar.)Other free online support
The LibreOffice community not only develops software, but provides free, volunteer-based support. In addition to the Help menu links above, other online community support options are available, see Table 1.Table 1: Free LibreOffice support
FAQsAnswers to frequently asked questions
https://wiki.documentfoundation.org/Faq Mailing listsFree community support is provided by a network of experienced usersQuestions &
Answers and
Knowledge BaseFree community assistance is provided in a question and answer formatted web service. Search similar topics or open a new one in The service is available in several other languages; just replace /en/ with de, es, fr, ja, ko, nl, pt, tr, and many others in the web address above.Native language
supportThe LibreOffice website in various languagesMailing lists for native languages
Information about social networking
Accessibility
optionsInformation about available accessibility optionsPaid support and training
You can also pay for support through service contracts from a vendor or consulting firm specializing in LibreOffice. For information about certified professional support, see The Document Foundation's website: https://www.documentfoundation.org/gethelp/support/. For schools, educational and research institutions, and large organizations, seeWhere to get more help | 9
What you see may be different
Illustrations
LibreOffice runs on Windows, Linux, and macOS operating systems, each of which has several versions and can be customized by users (fonts, colors, themes, window managers). The illustrations in this guide were taken from a variety of computers and operating systems. Therefore, some illustrations will not look exactly like what you see on your computer display. Also, some of the dialogs may be different because of the settings selected in LibreOffice. You can either use dialogs from your computer's operating system or from LibreOffice. The differences affect mainly Open, Save, and Print dialogs. To change which dialogs are used, go to Tools > Options > LibreOffice > General and select or deselect the option Use LibreOffice dialogs. Icons The LibreOffice community has created icons for several icon sets: Colibre, Breeze, Breeze Dark, Elementary, Karasa Jaga, Sifr, Sifr Dark, and Sukapura. Each user can select a preferred set. The icons in this guide have been taken from a variety of LibreOffice installations that use different sets of icons. The icons for some of the many tools available in LibreOffice may then differ from the ones used in this guide. To change the icon set used, go to Tools > Options > LibreOffice > View. Choose from the drop-down list under Icon Style. Note The Galaxy, Oxygen, and Tango icon sets are no longer included as part of the standard installation package. They can be added back by downloading and installing the following extensions: Some of the previously included gallery backgrounds are now only available as an extension from:Using LibreOffice on macOS
Some keystrokes and menu items are different on macOS from those used in Windows or Linux. Table 2 gives some common substitutions for the instructions in this document. For a more detailed list, see the application Help. Table 2: Example keystrokes for different environmentsWindows or LinuxmacOS equivalentEffect
Tools > Options
menu selectionLibreOffice > PreferencesAccess setup optionsRight-clickControl+click and/or right-click
depending on computer setupOpen a context menu Ctrl (Control)⌘ (Command)Used with other keysF11+T⌘Open the Styles deck in the
Sidebar
10 | Preface
What are all these things called?
The terms used in LibreOffice for most parts of the user interface (the parts of the program you see and use, in contrast to the behind-the-scenes code that actually makes it work) are the same as for most other programs. A dialog is a special type of window. Its purpose is to inform you of something, or request input from you, or both. It provides controls to use to specify how to carry out an action. Some commoncontrols are highlighted by callouts in Figure 2, with a brief technical description given in the key
that follows the figure. In most cases the technical terms are not used in this book, but it is useful
to know them because the Help and other sources of information often use them. In most cases, you can interact only with the dialog (not the document itself) as long as the dialog remains open. When you close the dialog after use (usually, clicking OK or another button saves your changes and closes the dialog), then you can again work with the document. Some dialogs can be left open as you work, so you can switch back and forth between the dialog and your document.Figure 2: Dialog showing common controls
1)Tabbed page (not strictly speaking a control).
What are all these things called? | 11
2)Radio buttons (only one can be selected at a time).
3)Checkbox (more than one can be selected at a time).
4)Spin box (click the up and down arrows to change the number shown in the text box next
to it, or type in the text box).5)Thumbnail or preview.
6)Drop-down list from which to select an item.
7)Push buttons.
Frequently asked questions
How is LibreOffice licensed?
LibreOffice is distributed under the Open Source Initiative (OSI) approved Mozilla Public License (MPL). See https://www.libreoffice.org/about-us/licenses/. It is based on code from Apache OpenOffice made available under the Apache License 2.0 but also includes software that differs from version to version under a variety of other Open Source licenses. New code is available under GNU Lesser General Public License (LGPL)3.0 and MPL 2.0.
May I distribute LibreOffice to anyone? May I sell it? May I use it in my business? Yes.How many computers may I install it on?
As many as you like.
Is LibreOffice available in my language?
LibreOffice has been translated (localized) into over 100 languages, so your language is probably supported. Additionally, there are over 100 spelling, hyphenation, and thesaurus dictionaries available for languages, and dialects that do not have a localized program interface. The dictionaries are available by selecting the Dictionary tag filter from the LibreOffice Extension Center https://extensions.libreoffice.org/.How can you make it for free?
LibreOffice is developed and maintained by volunteers and has the backing of several organizations. I am writing a software application. May I use programming code from LibreOffice in my program? You may, within the parameters set out in the licenses: https://www.mozilla.org/MPL/2.0/ Why do I need Java to run LibreOffice? Is it written in Java? LibreOffice is not written in Java; it is mostly written in the C++ language. Java is one of several languages that can be used to extend the software. The Java JRE (Java Runtime Environment) is only required for some features. The most notable one is the HSQLDB relational database engine used by the Base component of LibreOffice. Java is available at no cost. More information and download links to the appropriate edition for your operating system can be found at: https://java.com/en/download/manual.jsp. Note If you want to use LibreOffice features that require Java it is important that the correct 32 bit or 64 bit edition matches the installed version of LibreOffice.How can I contribute to LibreOffice?
12 | Preface
You can help with the development and user support of LibreOffice in many ways, and you do not need to be a programmer. To start, check out this webpage: May I distribute the PDF of this book, or print and sell copies? Yes, as long as you meet the requirements of one of the licenses in the copyright statement at the beginning of this book. You do not have to request special permission. We request that you share with the project some of the profits you make from sales of books, in consideration of all the work we have put into producing them. Donate to LibreOffice: https://www.libreoffice.org/donate/.What's new in LibreOffice Base 7.2 Community?
LibreOffice 7.2 Community includes many changes not visible in the user interface. These changes include improved interoperability with Microsoft's proprietary file formats and performance improvements in handling large files, opening certain .docx and .xlsx files, managing font caching, and opening presentations and drawings that contain large images.More information is in the announcement:
Release Notes are here: https://wiki.documentfoundation.org/ReleaseNotes/7.2. This user guide is based on Base Guide 6.4. The information in the chapters and appendixes that follow this Preface is unchanged from Base Guide 6.4 - the main work carried out on Base since6.4 has been concerned with on-going development of the experimental facility to create
database documents with Firebird. What's new in LibreOffice Base 7.2 Community? | 13Base Guide 7.2
Chapter 1
Introduction to Base
Introduction
In everyday office operation, spreadsheets are regularly used to aggregate sets of data and to perform some kind of analyses on them. As the data in a spreadsheet is laid out in a table view, plainly visible and able to be edited or added to, many users ask why they should use a database instead of a spreadsheet. This book explains the differences between the two. Note In technical language, "database document file" is used for a database from a single interface and "database system" encompasses the database management system (DBMS) and the actual database. Base offers access to various database systems through a graphical user interface. Base works by default with the embedded database engine HSQLDB. This chapter introduces two sample databases and this entire book is built around them: Media_without_macros.odb and Media_with_macros.odb, extended with the inclusion of macros. Both databases are for operating a library: media capture, user uptake, media rental, and everything connected with it, such as the recall for readers. A more detailed example is given later in this chapter (starting on page 23). It uses thequotesdbs_dbs41.pdfusesText_41[PDF] libreoffice calcul automatique
[PDF] ln(a)/ln(b)
[PDF] a t on besoin d admirer des individus extraordinaires
[PDF] bts culture générale 2017 corrigé
[PDF] notre societe a t elle besoin de heros
[PDF] ln(a+b) = ln(a) + ln(b)
[PDF] ln(a)*ln(b)
[PDF] corrige culture générale bts 2017
[PDF] curriculum et programme scolaire
[PDF] curriculum scolaire définition
[PDF] curriculum scolaire pdf
[PDF] qu'est-ce qu'un programme d'enseignement
[PDF] définition d'un programme scolaire pdf
[PDF] qu'est ce qu'un programme scolaire