Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Please get "Base Handbook 4.0 (database)" from http://www.libreoffice.org/get-help/documentation/

Some ways to link Calc and Base:

  • Hold the data in a Calc file and edit it there. Generate the .odb file from 'Connect to an existing database' type Spreadsheet. You need the .odb file for example for mail merge and queries.
  • Create a new database with the embedded HSQLDB. Define the table in Base, drag-drop it to Calc or insert them from data source browser(F4). You get a linked data range "Import". Edit the data in Base and refresh the linked range in Calc.
  • Create a new database with the embedded HSQLDB. Define the tables in Base. Create a spreadsheet as external form for the embedded database to show and update the database. You can do calculations on this form and add charts, the linking is done via form control elements.
  • Create your data in Calc and save it as dBASE file. Generate the .odb file from "Connect to an existing database' type dBASE. You can edit the data in Base and in Calc as well. Calculations and charts have to be done in a separate file, which can get its data via link.