On Tue, 2012-01-31 at 18:02 -0800, Jeffrey Needle wrote:
> Using OpenOffice 3.2 on a Linux system.
>
> This may sound a bit like a whine; it's actually a plea for help.
>
> OpenOffice's database has some fine features, but, amazingly, you can't
> do simple calculations -- especially date calculations -- in the
> database module. I'm a book review editor. I assign books to
> reviewers, and I need to calculate the date the review is due based on
> the date the book is received by the reviewer. I need to calculate how
> long the book has been out to the reviewer. Etc., etc.
>
> Now, all of this is done simply in the spreadsheet, but the interface
> lacks the kind of visual clarity that the database gives me. Scrolling
> across the screen to get data is distracting and annoying.
>
> So, my question. I think I can create a database and link it to a
> spreadsheet. If I enter data in the database, will it obey the commands
> I have set up in the spreadsheet? Will it display the calculations in
> real time?
>
> I don't know if it's possible. Any help will be appreciated. Thanks.
>
When you use Base to connect to a spreadsheet, the tables are read
only. You can not add nor modify data in the spreadsheet using Base.
What you can do is create the spreadsheet in Calc (which I think
you may have already done). Use Calc to update the spreadsheet. Also use
Base to connect to the spreadsheet which creates a .odb database
document file. Using this file you can create forms, queries, and or
reports of the spreadsheet.
One slight problem that I have noticed. When Base opens the
database file, it gathers information from the spreadsheet at that time.
But any updating of the spreadsheet is not reflected in tables of
the .odb file. After updating the spreadsheet, Base must be closed and
then opened to show the updated data.
--Dan
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
