Issue 4991 - Foxpro 2.6 .dbf file will not open in CALC
Summary: Foxpro 2.6 .dbf file will not open in CALC
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
Depends on:
Reported: 2002-05-17 17:39 UTC by Unknown
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Foxpro 2.6 format .dbf file that won't open in CALC (40.92 KB, application/octet-stream)
2002-05-17 17:42 UTC, Unknown
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-05-17 17:39:18 UTC
I work with a database that produces .dbf files in Foxpro 2.6 format.  When I 
try to open them in CALC, the file opens instead as a text file in WRITER.  The 
same file will open flawlessly in Excel or 1-2-3.  If I open it in Excel and 
resave it from Excel in .dbf format, it will open correctlly in CALC.

If I could see where or how to attach a file, I would attach a sample Foxpro 
2.6 format .dbf file for your use.
Comment 1 Unknown 2002-05-17 17:42:00 UTC
Created attachment 1683 [details]
Foxpro 2.6 format .dbf file that won't open in CALC
Comment 2 peter.junge 2002-06-10 11:08:07 UTC
I'll have a look, Peter
Comment 3 peter.junge 2002-09-24 13:52:24 UTC
there's something strange about this file. vi freezes. Gnumeric
crashes opening it. Kspread wouldn't even find it. Starting it from a
terminal using 'kspread .../Supplies.dbf' crashes kspread too. OOo
opens it always in writer no matter which filter I select. Only Excel
hasn't any sign of problems.
@ Eike: Some strange characters at the beginning of the file. Is this
a valid dbf file at all?
Comment 4 Unknown 2002-09-24 17:45:10 UTC
The file was produced using Alpha Five version 4.5 for
Windows, a relational end-user database.  

The folks at Alpha Five have built their program using
the CodeBase xBase engine from Sequiter Software, a product
utilized by a variety of programmers looking to add
database functionality to their software.  It is
presumably Foxbase 2.6 compatible, but I don't know
enough about file formats to verify that.

The Sequiter folks may be able to provide more
information.  Their web site is

Thank you for your interest and assistance.

Comment 5 ooo 2002-09-26 18:24:48 UTC
@Peter: Don't know which rotten vi you're using, but vim had no
problem, of course ;-)

@all: The format of this file doesn't follow the dBase specifications
exactly and differs in one aspect: at file offset 8 (zero based) there
is a 16-bit little-endian value telling the overall length of the
header, here 162. The last byte of the header (in this case at offset
161) has to be a 0x0d, which isn't the case here. The 0x0d is at
offset 160 instead, and another 0-byte follows to pad the header. If
the two values are exchanged (0-byte at offset 160, 0x0d at offset
161), then the file can be loaded. Excel seems to ignore all sanity
checks (as usual), but Calc checks for the presence of the 0x0d at the
end of the header.

@Paul: If you want your files to get loaded I suggest you contact the
folks who are responsible for the product you're using to write proper
file formats. Otherwise you'd had to use a utility that checks for the
header format described above and corrects it if necessary.
Comment 6 ooo 2002-09-26 18:25:15 UTC
Comment 7 ooo 2002-09-26 18:25:57 UTC
closing I said ...