Menu

#26 Problem displaying formatted Values

1.0
open
nobody
None
2016-06-07
2016-06-07
No

with Mondrian 4.3.0.1 and localized format for measures:

the cell-values are all displayed in scietific-notation, not changeable within Excel. No chance to apply a money-format on the cells.
Looks like only one part from the XMLA-DataSet-answer from the Mondrian-server is used in the plugin. A snippet from the SOAP-Answert which looks like

   <Cell CellOrdinal="1">
      <Value xsi:type="xsd:string">3.1718235230515957E7</Value>
      <FmtValue>31.718.235,23</FmtValue>
      <FormatString>#,###.00</FormatString>
    </Cell>

results in Excel to "3.1718235230515957E7" without any option to see "31.718.235,23".
Does somebody know what is happening?

Discussion


Log in to post a comment.