Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#2951 (ok 4.0) ODS: incorrect DECIMAL fields

3.5.6
fixed
1
2013-06-11
2009-12-02
Jasper Knockaert
No

When exporting a table to Open Document Spreadsheet format, DECIMAL
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.

Discussion

  • Marc Delisle
    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.

     
  • Marc Delisle
    Marc Delisle
    2010-01-03

    • status: open --> pending
     
    • status: pending --> open
     
  • 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.

     
  • Marc Delisle
    Marc Delisle
    2013-01-20

    • milestone: 3.2.3 --> 3.5.6
     
  • Michal Čihař
    Michal Čihař
    2013-02-07

    • 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ř
    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
     
  • Michal Čihař
    Michal Čihař
    2013-02-07

    Fixed in git.

     
  • Marc Delisle
    Marc Delisle
    2013-05-03

    • Status: open-fixed --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> fixed