Bug 47496

Summary:	Saving a DBF (dBase) after Editing values changes the column data format: adds trailing decimals (FILESAVE,FORMATTING)
Product:	LibreOffice	Reporter:	a.lo
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	critical
Priority:	high	CC:	alister.hood, a.lo, iplaw67, libreoffice, rayanAyar, swit, tonal.promsoft
Version:	3.4.3 release
Hardware:	All
OS:	Windows (All)
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=32672 https://bugs.freedesktop.org/show_bug.cgi?id=53027
Whiteboard:
i915 platform:		i915 features:
Attachments:	Original file, correct. Created using openoffice 3.3 same file, saved by libreoffice. Column data structure has been modified. (File is Iso-8859-15 or winlatin1)

Description a.lo 2012-03-19 03:23:21 UTC

Created attachment 58668 [details]
Original file, correct. Created using openoffice 3.3

first of all, this bug may be related to https://www.libreoffice.org/bugzilla/show_bug.cgi?id=32672, but it's a little different.

Saving a .dbf file changes the columns datatype. Trailing decimals are ALWAYS added.

There is no way to stop this. I tried saving in different charsets, changing the spreadshell cell format to whole numbers before saving, etc. Two trailing decimals are always added.

I.E. COLUMN,N,5,0 becomes COLUMN,N,7,2 and 1995 becomes 1995,00

This bug did not occur in Openoffice between March 2009 up to Version 3.3(including)


The reformatting seems to occure during filesave, not during opening the modified file.:
Opening a saved file and saving it again leads to a binary identical (modified) file.

Comment 1 a.lo 2012-03-19 03:25:45 UTC

Created attachment 58669 [details]
same file, saved by libreoffice. Column data structure has been modified. (File is Iso-8859-15 or winlatin1)

Comment 2 Florian Reisinger 2012-05-19 10:42:08 UTC

Please do not use https://www.libreoffice.org/bugzilla/*, use https://bugs.freedesktop.org/* URLs instead..
Thanks

Florian R.

Comment 3 Urmas 2012-08-14 17:18:20 UTC

*** Bug 33511 has been marked as a duplicate of this bug. ***

Comment 4 Tonal 2012-08-15 15:54:04 UTC

I do not open first attachment file from Calc - General InOut error.
Also do not save furst example from Bug 33511 - General InOut error.
Os: Kubuntu 12.04 with last LO from Kubuntu repositories: LibreOffice 3.5.4.2 350m1(Build:2)

Comment 5 alister.hood 2012-11-15 05:59:11 UTC

> I do not open first attachment file from Calc - General InOut error.
> Also do not save furst example from Bug 33511 - General InOut error.

It works OK for me (on Arch).
Maybe try again?

Comment 6 agiucar 2012-12-07 15:46:18 UTC

Ho lo stesso problema.
I campi numerici non conservano il formato originale.

agiucar

Comment 7 Alex Thurgood 2013-07-11 10:28:59 UTC

This looks like a DUP of bug 32672 to me, since the output header becomes the same as the one mentioned in that report.

Adding Kohei to CC.


Alex

Comment 8 Björn Michaelsen 2014-01-17 00:43:28 UTC

(This is an automated message.)

LibreOffice development currently prioritizes bugs with the so called MAB (most annoying bugs) -- as this bug has not run through that process (including writing a short rationale for this bug being a candidate and other who are watching the tracker bug silently approving that rationale etc.) its priority is set to high. Note this is effectively no change in the urgency assigned to this bug, as we are currently not making a difference between high and highest and severity is untouched.

You can find out more about MABs and how the process works by contacting libreoffice qa on irc:

 http://webchat.freenode.net/?channels=libreoffice-qa

The QA wiki page also gives you hints on how to get in contact with the team (if IRC fails you, your next best choice is the mailing list):

 https://wiki.documentfoundation.org/QA

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.