Using Data Sources with Calc
Productivity Sauce
Say you use a simple OpenOffice.org Base database to keep track of your invoices and you want to analyze the invoicing data. One way to do this is to create reports and SQL queries, but this requires skill and a lot of time. Another approach is to pull database records into a Calc spreadsheet and then use Calc's tools to analyze the data. To do this, you have to register the invoice database as a data source in OpenOffice.org. Choose Tools -> Options, select OpenOffice.org Base -> Databases and press the New button. Select then the database and give the new connection a name. Press OK -> OK to save the settings and close the window.
Create a new Calc spreadsheet and press F4 to show the Data Sources pane. Select the table or query you want from the registered data source, and drag it onto the spreadsheet. This imports records from the table or query as rows into the spreadsheet, and you can then use Calc's tools to analyze and manipulate the imported data range. When using this technique, OpenOffice.org creates a live link between the database table or query and the data in the spreadsheet. This means that if you make changes in the database (i.e., add a new record or modify an existing one), you can update data in the spreadsheet by refreshing it. To do this, click on any cell in the imported data range and choose -> Data Refresh Range. Keep in mind, though, that the created link works only one way -- from database to spreadsheet -- so any changes you made to the data in the spreadsheet will not be saved back in the database.
Instead of linking to a table or query, you might want to import data into the spreadsheet. To do this, click on the table or query you want in the Data Sources pane, select then all records by clicking on the top-left empty gray box in the Record Browser pane. Drag then the selected records set onto the spreadsheet.
comments powered by DisqusSubscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Fedora KDE Approved as an Official Spin
If you prefer the Plasma desktop environment and the Fedora distribution, you're in luck because there's now an official spin that is listed on the same level as the Fedora Workstation edition.
-
New Steam Client Ups the Ante for Linux
The latest release from Steam has some pretty cool tricks up its sleeve.
-
Gnome OS Transitioning Toward a General-Purpose Distro
If you're looking for the perfectly vanilla take on the Gnome desktop, Gnome OS might be for you.
-
Fedora 41 Released with New Features
If you're a Fedora fan or just looking for a Linux distribution to help you migrate from Windows, Fedora 41 might be just the ticket.
-
AlmaLinux OS Kitten 10 Gives Power Users a Sneak Preview
If you're looking to kick the tires of AlmaLinux's upstream version, the developers have a purrfect solution.
-
Gnome 47.1 Released with a Few Fixes
The latest release of the Gnome desktop is all about fixing a few nagging issues and not about bringing new features into the mix.
-
System76 Unveils an Ampere-Powered Thelio Desktop
If you're looking for a new desktop system for developing autonomous driving and software-defined vehicle solutions. System76 has you covered.
-
VirtualBox 7.1.4 Includes Initial Support for Linux kernel 6.12
The latest version of VirtualBox has arrived and it not only adds initial support for kernel 6.12 but another feature that will make using the virtual machine tool much easier.
-
New Slimbook EVO with Raw AMD Ryzen Power
If you're looking for serious power in a 14" ultrabook that is powered by Linux, Slimbook has just the thing for you.
-
The Gnome Foundation Struggling to Stay Afloat
The foundation behind the Gnome desktop environment is having to go through some serious belt-tightening due to continued financial problems.