phpMyAdmin / Bugs / #2951 (ok 4.0) ODS: incorrect DECIMAL fields

Marc Delisle - 2010-01-03

I tried with a simple DECIMAL(4,2) field containing 44.33 and I saw nothing wrong when exported to OpenOffice 2.4.1. Please attach here a .sql export so that I can reproduce your problem.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-01-03

status: open --> pending
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jasper Knockaert - 2010-01-06

status: pending --> open
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jasper Knockaert - 2010-01-06

When exporting to OpenDocument format the resulting files should conform to the relevant standard, which they do not now.

How OpenOffice imports a file is a different matter entirely. It is my experience with OpenOffice that the result of importing incorrectly formatted field values depends on system locales (such as decimal separator).

Rather than testing incorrectly formatted exports for all values of system locales and application versions I think it deserves priority to conform to the standard.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-01-20

milestone: 3.2.3 --> 3.5.6
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Description has changed:

Diff:

--- old
+++ new
@@ -2,4 +2,4 @@
 fields are formatted incorrectly. The solution to this bug is simple: have them exported as if they
 were a DOUBLE field.

-The bug is related to https://sourceforge.net/tracker/index.php?func=detail&aid=2821833&group\_id=23067&atid=377408 which addressed similar bugs in exporting date and time fields. Also https://sourceforge.net/tracker/index.php?func=detail&aid=2856664&group\_id=23067&atid=377410 touches the issue.
+The bug is related to https://sourceforge.net/tracker/index.php?func=detail&aid=2821833&group_id=23067&atid=377408 which addressed similar bugs in exporting date and time fields. Also https://sourceforge.net/tracker/index.php?func=detail&aid=2856664&group_id=23067&atid=377410 touches the issue.

Michal Čihař - 2013-02-07

summary: ODS: incorrect DECIMAL fields --> (ok 4.0) ODS: incorrect DECIMAL fields

status: open --> open-fixed

assigned_to: Michal Čihař

priority: 5 --> 1
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michal Čihař - 2013-02-07

Fixed in git.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-05-03

Status: open-fixed --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michal Čihař - 2013-06-11

Status: closed-fixed --> fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

(ok 4.0) ODS: incorrect DECIMAL fields

A software tool to bring MySQL to the Web

Group

Searches

Help

#2951 (ok 4.0) ODS: incorrect DECIMAL fields

Discussion