Home > Ask the Enterprise Linux Experts > Questions & Answers > Comparing functions in Excel vs. Base
Ask The Enterprise Linux Expert: Questions & Answers
EMAIL THIS

Comparing functions in Excel vs. Base

Solveig Haugland EXPERT RESPONSE FROM: Solveig Haugland

Pose a Question
Other Enterprise Linux Categories
Meet all Enterprise Linux Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 05 July 2007
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?

>
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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Open source applications for Linux
EnterpriseDB says open source database saves big bucks
Red Hat releases Satellite 5.3 with Cobbler engine
Linux provisioning automation with Cobbler
Open source market benefits from recession
How to install and get started with OpenQRM
Microsoft makes Linux drivers for Hyper-V open source, but users not impressed
Microsoft submits Hyper-V drivers to Linux kernel
Open source for America launched
Red Hat debuts flexible JBoss platform additions
Recovering your Linux server with a Knoppix rescue disk

Linux enterprise desktop applications
What do you know about Linux administration tools?
Linux desktop adoption boosted by economy
Virtualization options for enterprise Linux
Open source predictions for 2009
Linux desktop interoperability: MS Office and OpenOffice
Linux distributions: Servers and desktops
Migrating a city government to OpenOffice
OpenOffice 2.0 use with ODBC
OpenOffice 2.0 market share
Preserving templates in Oxygen Office Professional 2.0.4 and OpenOffice 2.0

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Android  (SearchEnterpriseLinux.com)
Free and open source software (FOSS)  (SearchEnterpriseLinux.com)
gOS  (SearchEnterpriseLinux.com)
Subversion  (SearchEnterpriseLinux.com)
yacc  (SearchEnterpriseLinux.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Linux Migration Advice: Unix-to-Linux, Windows-to-Linux
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts