Using JabRef bibliographies in OpenOffice.org
JabRef can export your database in both the OpenOffice.org 1.1
.sxc spreadsheet format, and the OpenDocument
.ods spreadsheet format used by OpenOffice.org 2.0.
In both cases the exported spreadsheet will contain one data
sheet, listing entries in rows and the various fields in
columns. The order and names of the columns is set to be
compatible with OpenOffice.org's bibliography functions (OOo
1.1 in the case of the .sxc export, and OOo 2.0 in the
case of the .ods format).
Depending on your version of OpenOffice.org, here are the method to use JabRef bibliographic databases:
Using the exported file as bibliography database in
OpenOffice.org 2.3 and 2.4
Use the following steps to set up a spreadsheet exported from
JabRef as bibliography database in OpenOffice.org:
- From JabRef, export your database using the .ods format
- Start OpenOffice.org Writer
- Choose Edit -> Change database. Click on Select, and select your database exported to the .ods format.
- Unfold the + located in front of the name of the imported database, then click on the displayed filename, and, finally, on the button Define.
- Choose Tools -> Options -> OpenOffice.org Base -> Database. In this window, the database you just imported should be displayed. The default OOo bibliographic database should also be displayed (Bibliography).
- Edit the Bibliography database, and alter its name, such as Bibliography-old (in fact, OpenOffice.org Writer does not allow selecting several bibliographic databases).
- Select your bibliographic database, edit it, and rename it Bibliography (pay a special attention to the capital letter at the beginning of the name).
After these steps, your bibliographic database should be ready for use with OpenOffice.org. To check about it, choose Insert -> Index -> Bibliographic entry...: the list of the BibTeX keys should be displayed.
Using the exported file as bibliography database in
OpenOffice.org 2.0, 2.1 and 2.2
Use the following steps to set up a spreadsheet exported from
JabRef as bibliography database in OpenOffice.org:
- Export your database using the .ods format
- Start OpenOffice.org
- Choose Tools -> Options -> OpenOffice.org Base
-> Databases
- Edit the Bibliography database, and change the
name to something else, e.g. Bibliography-old
(indeed, OpenOffice.orgWriter does not allow for several
bibliographies)
- Close the Options window, and choose File
-> New -> Database
- Choose Connect to an existing database, select
Spreadsheet as the database type, and choose the
.ods file you exported
- Click Finish, then choose the name
Bibliography when prompted
After finishing these steps, choose Tools ->
Bibliography Database. Your database should now be
displayed.
Using the exported file as bibliography database in
OpenOffice.org 1.1.x
- Export your database using the .sxc format
- Start OpenOffice.org
- Choose Tools -> Data sources
- Select the Bibliography database, and change its
name to something else, e.g. Bibliography-old. Click
Apply.
- Click New Data Source. A new entry will appear.
Change its name to Bibliography.
- Change Database type to Spreadsheet.
Click the ... button in the Data source URL
line. Choose the .sxc file you exported.
- Click OK to close the Data Sources
window.
After finishing these steps, choose Tools ->
Bibliography Database. Your database should now be
displayed.