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?