.NET OData error with decimals: Type mismatch
<p>I'm currently trying to get rid of OData error which looks like a problem with decimal parsing/deserializing.</p>

<p>I have working OData API (using System.Web.Http.OData library) in my ASP.NET MVC application and user can download OData Feed file *.odc pointing to said OData API. When there is a decimal in OData API response, such as</p>

<pre><code>&lt;d:Value m:type="Edm.Decimal"&gt;50.50&lt;/d:Value&gt;
</code></pre>

<p>and user wants to open OData Feed file in Excel (tested on Excel 2016) to fetch data he gets an error:</p>

<pre><code>We couldn't get data from the Data Model. Here's the error message we got:
The following system error occurred: Type mismatch.
</code></pre>

<p>What is intersting is that there is no error when the decimal value has no decimal part, like this:</p>

<pre><code>&lt;d:Value m:type="Edm.Decimal"&gt;50.00&lt;/d:Value&gt;
</code></pre>

<p>Here's complete API response (with urls cut out):</p>

<pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
&lt;feed xml:base="xxxxxxxxx" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml"&gt;
  &lt;id&gt;http://schemas.datacontract.org/2004/07/&lt;/id&gt;
  &lt;title /&gt;
  &lt;updated&gt;2016-06-22T11:01:10Z&lt;/updated&gt;
  &lt;link rel="self" href="xxxxxxxxxxxxx" /&gt;
  &lt;entry&gt;
    &lt;id&gt;xxxxx&lt;/id&gt;
    &lt;category term="Itm.Erp.Domain.Finance.CashRegistryListView" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /&gt;
    &lt;link rel="edit" href="xxxx" /&gt;
    &lt;link rel="self" href="xxxx" /&gt;
    &lt;title /&gt;
    &lt;updated&gt;2016-06-22T11:01:10Z&lt;/updated&gt;
    &lt;author&gt;
      &lt;name /&gt;
    &lt;/author&gt;
    &lt;content type="application/xml"&gt;
      &lt;m:properties&gt;
        &lt;d:Number&gt;001&lt;/d:Number&gt;
        &lt;d:Location m:null="true" /&gt;
        &lt;d:Direction&gt;In&lt;/d:Direction&gt;
        &lt;d:Person&gt;Sam&lt;/d:Person&gt;
        &lt;d:Company&gt;Company&lt;/d:Company&gt;
        &lt;d:Date m:type="Edm.DateTime"&gt;2016-06-06T00:00:00&lt;/d:Date&gt;
        &lt;d:IsProcessed m:type="Edm.Boolean"&gt;true&lt;/d:IsProcessed&gt;
        &lt;d:ExpenseType m:null="true" /&gt;
        &lt;d:Value m:type="Edm.Decimal"&gt;50.50&lt;/d:Value&gt;
        &lt;d:EffectiveValue m:type="Edm.Decimal"&gt;50.50&lt;/d:EffectiveValue&gt;
        &lt;d:Seller m:null="true" /&gt;
        &lt;d:DocumentNumber m:null="true" /&gt;
      &lt;/m:properties&gt;
    &lt;/content&gt;
  &lt;/entry&gt;
&lt;/feed&gt;
</code></pre>

<p>What is the problem with decimals in API response and is there a way to fix it? Does anyone had a similar problem and managed to solve it?</p>