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

Close

Excel Export Number Format problem

2008-05-16
2013-04-29
  • daneel-olivaw
    daneel-olivaw
    2008-05-16

    Hello to everybody,

    We use Mondrian version 2.4.2.9831 through which we navigate an OLAP schema (via JPivot); the problem arises when we try to export the current cube view to Excel.

    Numbers result uncorrectly formatted; for example, we have these two main problems:

    1. The number 234 results in the number "234,", the Excel column format is "Custom" and the format string is "###0,###"

    2. (Even more odd!!) The string "134E1" results in the number 123E+01 (in scientific notation - see http://en.wikipedia.org/wiki/Scientific_notation#E_notation\)

    The measure referred in problem n. 1 has these two attributes in the Mondrian XML:

       datatype="Numeric" formatString="#,##0 m3"

    What's more, the error n. 1 also occurs with:

    - The JPivot-1.8.war run with the example schema (particularly with the first example link, "Slice and Dice with two hierarchies") --> we then export the view in Excel and the numbers are wronly formatted like said above,

    - Mondrian 3.0.3

    Any help will be appreciated. Thanks,
    Daneel