Apache OpenOffice (AOO) Bugzilla – Issue 85813
Export to .dbf fails with large number
Last modified: 2013-01-29 21:52:32 UTC
I'm working with a .dbf file containing some geographical data. I can import the file into Calc without any problems, but if I try to save the file under a different name, it returns the error "Connection to the file cannot be established." However, it does in fact save a portion of the file to a new file, but fails at one particular row. If I sort the data differently, it again fails on the row with the same contents. That entry in the database contains a particularly large number 17537231.8133 in the final column of the entry. If I delete that one number from the database, the file saves correctly without any problems. I am unable to reproduce the problem by creating a new file in Calc that contains the same number and trying to save it in the .dbf format.
Created attachment 51322 [details] Geo data that caused problem -- line 33 offending row
Confirming with 2.4m4 on WinXP - as described.
Hello, I get the same error when I try to save a xls to dbf. This tabel has no big numbers but the first column changes from text to numeric after half of the table, so this may be the reason I will add the table Andreas
Created attachment 52161 [details] Tabel tha cannot be saved to dbf
This seems to work fine with dev m37. jyorgey, could you, please, install latest developer build (from http://download.openoffice.org/680/?intcmp=1461) and see if it saves your file?
possibly dupe to already fixed issue 96191
m71 errors out saving WaterPly.dbf - "error saving the document WaterPly: write error. the 'shape_area' column has been defined as 'decimal' type, the max length is 19 characters (with 11 decimal places). The specified value "17537231.81330000000 is longer than the number of digits allowed."