Trouble saving .dbf file from OO 2.4

Asked by RFW

This is clearly closely related to, or identical with, the problem reported at

https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/27604

Using Hardy (8.04) and OO 2.4, I can open an existing .dbf file Into a spreadsheet and edit it, but when I try to save it as .dbf I get the same error message as in #27604: [error saving document XYZ: connection to the file could not be established]

I can open, edit, and save .dbf files by going into OO Base and connecting to an existing database, but the editing window in Base, though it looks like a spreadsheet, isn't. You can't, for example, highlight a range and copy/paste it, not even into an OO Spreadsheet. Also, in an OO Spreadsheet, when you set up a "simple filter", it shows you the various field values to choose from, but in OO Base, you have to know what they are!

Even something as basic as Undo works differently. If opened as a spreadsheet, it's the usual ctrl-Z, but in Base there is no such shortcut - you must click Edit > Undo.

All very unsatisfactory.

The question is, then, does anyone know how to open a .dbf file, edit it with spreadsheet functionality (not as a Base table), and save it?

I probably need to add that one of my .dbf files has something on the order of 40,000 records in it.

Also, #138686 implies that being able to directly open and save .dbf in OO Spreadsheet is a functionality that has come and gone with the release of various versions. This implies that switching from OO 2.4 to a later version may not solve the problem.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Tony Pursell (ajpursell) said :
#1

Hi

This is a difficult one to answer for me, mainly because you have old versions of OOo and Ubuntu. Mine is OOo 3.2 and Ubuntu 10.10 (Maverick). On my versions I can create a dBase file using Calc then Save it, and then open it, modify it and re-Save it as dbf.

Don't expect Base to work the same as Calc. Base is a relational database and Calc is a spreadsheet. These are very different applications.

If you want to copy data from Base to Calc you may be able to do this:

1. Open the dBase database in Base (I assume from your remarks that you can do this)

2. Select Tables in the Database pane.

3. Select the table, that you want to copy from, in the Tables pane.

4 Right click on the table name and select Copy.

5 Switch to a blank Calc spreadsheet and Paste.

You may find that you have to re-format the data a bit. I had the do Format > Cells and change Strikethrough and Underline to (Without) on the Font Effects tab.

Of course I did all this on my versions of OOo and Ubuntu.

Hope that helps.

Tony

Revision history for this message
marcobra (Marco Braida) (marcobra) said :
#2

There was a bug... https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/204795
Please upgrade your Ubuntu from 8.04 to 10.04 from update manager...
Ubuntu 8.04 is not more supported...

Revision history for this message
JakeRogers (montyphilips) said :
#3

It must be .dbf file corruption.

In that case it's suitable to try programming way of resolving issue.

Try to use next one http://www.dbf.fixtoolbox.com

Can you help with this problem?

Provide an answer of your own, or ask RFW for more information if necessary.

To post a message you must log in.