Wrong display in listview

[Iggby]

After upgrading from 5.0 to 5.2 I have encountered a problem with the display in the list view of the opportunities modules. The data displayed has the wrong decimal placement.

Ex.

In list view the fee field shows $14.00 where the corresponding field in detail view shows 14,958.00 and 1498 in the database.

This was displaying just fine prior to the upgrade to 5.2.

Any ideas why this would display this way?

I noticed also that the field displays correctly in a home page dashlet 14,958.00....could the currency formatting be messing it up? There is another number formatted in the listview to display as currency and it displays correctly.

[Iggby]

No ideas? Has anyone else had a similar problem when updating to 5.2?

[SugarDev.net]

Yes, showing the same w/ "," instead of "." symbols for decimal separator.

With the default settings it works perfectly.

[jasv]

Hi I'm having the same problem...

Anyone can help us to resolve this.... Thanks in advance...

[Iggby]

I don't think displaying the data incorrectly by putting commas where decimals go is the best answer, so I am assuming either I am misunderstanding something or my post is not being understood. I am going to attemp to attach before and after shots of what I am talking about.

The first picture is a before (version 5.0.0c) and the second is after upgrading to 5.2. No other changes were made to the program files.

[maggix]

Hello, I had a similar problem: using "." (dot) as separator for thousands and "," (comma) as decimal separator, all vaules were multiplied * 100 in the listview (and in the amount_usdollar field in the DB).

What I did is remove the unformat_field from the file SaveOverload.php in /modules/opportunities/

in this line:

 $focus->amount_usdollar = $currency->convertToDollar(unformat_number ($focus->amount)); 
  

change it to

 $focus->amount_usdollar = $currency->convertToDollar($focus->amount); 
  

This is because the field already gets unformatted in precedence, in the unformat_all_fields function


Is there a way to notify developers of this ?