Issue 85813 - Export to .dbf fails with large number
Summary: Export to .dbf fails with large number
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.3
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-02-02 04:27 UTC by jyorgey
Modified: 2013-01-29 21:52 UTC (History)
3 users (show)

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


Attachments
Geo data that caused problem -- line 33 offending row (89.69 KB, application/dbase)
2008-02-02 04:31 UTC, jyorgey
no flags Details
Tabel tha cannot be saved to dbf (800.50 KB, application/vnd.ms-excel)
2008-03-17 15:45 UTC, amoroder2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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."