Ask the Expert

Comparing functions in Excel vs. Base

I use the spreadsheet for math functions inside of my quotation master document in Word. I also use the "insert merge field" function to bring in the customer information from an Excel file. Is this possible in OpenOffice 2.0?

    Requires Free Membership to View

Yes, you can set up a spreadsheet, among other things, as a database. Select File > New > Database, choose, to connect to an existing data source. Choose Spreadsheet as the type, and click Next. In the next window, specify the spreadsheet and continue through the wizard, being sure to register the database and name it something meaningful.

Then, you can choose Insert > Fields > Other, select the Database tab and open your database. You can also press F4 to view a list of all databases, expand the database you want and drag a field into your Writer document.

You might also try variables. Insert > Fields > Other, Variables, and create a user field.

This was first published in July 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: