Issue 101045 - Decimal Numbers in DBF file does not get saved
Summary: Decimal Numbers in DBF file does not get saved
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: DEV300m46
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-04-13 16:18 UTC by kyoshida
Modified: 2013-03-11 15:01 UTC (History)
1 user (show)

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

proposed patch (4.64 KB, patch)
2009-04-13 16:41 UTC, kyoshida
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description kyoshida 2009-04-13 16:18:12 UTC
When saving a Calc document as DBF file, the document loses precision.  For
instance, when opening a DBF file, changing the precision of a column that
contains floating point numbers, and re-saving it as DBF will not save the
precision information of that column.
Comment 1 kyoshida 2009-04-13 16:41:33 UTC
Created attachment 61529 [details]
proposed patch
Comment 2 niklas.nebel 2009-06-30 11:18:20 UTC
This would mean we have two conflicting sources of column type information - the
headers and the number formats. I don't think that's a good idea.
Comment 3 kyoshida 2009-06-30 14:11:08 UTC
@nn: then what would be a better idea ?
Comment 4 niklas.nebel 2009-06-30 15:50:32 UTC
Either define a new interface for the field settings, replacing the headers, or
keep them as-is.

Modifying a dbf file's table structure might well make it unusable for the
application it belongs to, so we should change it only if we're sure that's what
the user wanted.
Comment 5 Rob Weir 2013-03-11 15:01:29 UTC
I'm adding this comment to all open issues with Issue Type == PATCH.  We have 220 such issues, many of them quite old.  I apologize for that.  

We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0.

If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know.

On the other hand, if the patch is no longer relevant, please let us know that as well.

If you have any general questions or want to discuss this further, please send a note to our dev mailing list: