https://bugs.freedesktop.org/show_bug.cgi?id=56875
Priority: medium
Bug ID: 56875
Assignee: [email protected]
Summary: LibreOffice Calc corrupts .dbf files
Severity: major
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Created attachment 69698
--> https://bugs.freedesktop.org/attachment.cgi?id=69698&action=edit
Zip folder of shape files with and without modified .dbf files to illustrate
corruption problem
Simple: when you open a .dbf file associated with a shapefile (.shp), it works
fine, you can edit and save and (sometimes successfully) re-open in Calc.
However, when you open the edited shapefile in a GIS program such as QGIS the
data has be garbled (only showing numeric data).
This bug has emerged recently: I used to use OO and LO for editing .dbf files
all the time and it worked fine for GIS applications. There are a number of
tutorials on the internet that recommend using this technique.
I've tested this behavior with the latest version of LibreOffice on a Windows 7
VM, on Ubuntu 12.04. Interestingly, I checked OpenOffice Calc and found that
the latest version of OO also corrupts .dbf files for use in QGIS.
Also note the .dbt file that is created every time a .dbf file is saved.
Suspect this is at the root of the problem.
Replicable example: extract this .zip file (below), open "points.dbf", edit it,
save it, and then load it in QGIS. The results should look like
"points-edited-open-office.dbf" when opened in QGIS: the attributes are
scrambled.
Replicable dataset to test this on and see what I mean is attached.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
