Issue 85813

Summary: Export to .dbf fails with large number
Product: Calc Reporter: jyorgey <jyorgey>
Component: save-exportAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kpalagin, ocke.janssen
Version: OOo 2.3   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Geo data that caused problem -- line 33 offending row
none
Tabel tha cannot be saved to dbf none

Description jyorgey 2008-02-02 04:27:47 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.
Comment 1 jyorgey 2008-02-02 04:31:16 UTC 
Created attachment 51322 [details]
Geo data that caused problem -- line 33 offending row
Comment 2 kpalagin 2008-02-02 21:57:58 UTC 
Confirming with 2.4m4 on WinXP - as described.
Comment 3 amoroder2 2008-03-17 15:42:13 UTC 
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
Comment 4 amoroder2 2008-03-17 15:45:24 UTC 
Created attachment 52161 [details]
Tabel tha cannot be saved to dbf
Comment 5 kpalagin 2008-12-22 07:42:44 UTC 
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?
Comment 6 pmike 2010-02-22 10:14:54 UTC 
possibly dupe to already fixed issue 96191
Comment 7 kpalagin 2010-02-23 05:02:46 UTC 
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."