Problem displaying formatted Values
ODBO provider for connections to XMLA data sources
Status: Beta
Brought to you by:
alexa77
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?