ToString() filling Decimal number with zeroes at the right

Question

This is a simple question for sure, but I can't find the solution. It's the opposite of this question. In my case, I have a decimal and a string properties on my ViewModel, like this:

public string FactorText 
{
    get
    {
        if (this.Factor != 0)
        {
            return this.Factor.ToString();
        }
    }

    set
    {
        this._factorText = value;
    }
}

public decimal Factor { get; set; }

When the .ToString() acts, it fills the number with zeroes at the right, e.g:

1.1 becomes 1.100000000000000
1.9999999999 becomes 1.999999999900000

... and so on. It fills the remaing of 15 decimal places with zeroes.

I don't really know why and if it have a way to make sure .ToString() stops making that.

If this information is relevant, that Factor is mapped with Fluent NHibernate as follows:

Map((x) => x.Factor).Column("FACTOR").Precision(30).Scale(15).Not.Nullable();

I don't know if this can be the cause of that behaviour.

Thank you in adv.

Update: I just can't change the scale and precision. They match the column on the database definition that is Decimal(30,15).

Well presumably NHibernate is providing a `decimal` value with all those trailing zeroes. — Jon Skeet, Nov 12 '13 at 18:05
@JonSkeet but when I stop in a break point here `return this.Factor.ToString();` the Factor value is `1,1`. — DontVoteMeDown, Nov 12 '13 at 18:06
Do you mean in the debugger? Don't assume the debugger is going to use the same representation as anything else, I'm afraid. — Jon Skeet, Nov 12 '13 at 18:06
@JonSkeet yes, in the debugger. Well, in this case I'm confused. — DontVoteMeDown, Nov 12 '13 at 18:07
Basically, don't trust the debugger, I'm afraid. You may be able to dig in to get more details, but I strongly suspect the value really *is* 1.100000000000000m. — Jon Skeet, Nov 12 '13 at 18:08

score 2 · Accepted Answer · edited May 23 '17 at 10:31

2

It's likely that this is due to how the database is representing the number. For example, if you insert 1.1 in a SQL Server 2008 decimal(30,15) field and select the result, you will get back 1.100000000000000.

See the comments below, the accepted solution was to use .ToString("G29") as found in How to format a decimal without trailing zeros

edited May 23 '17 at 10:31

Community

1
1

answered Nov 12 '13 at 18:14

Jamie Ide

48,427
16
81
117

I have suspected that. But I'm could not find out how to prevent that on the mapping or on the .ToString function. – DontVoteMeDown Nov 12 '13 at 18:16
This question offers a few options: http://stackoverflow.com/questions/17516460/how-to-format-a-decimal-without-trailing-zeros. Most applications use a format string on the page/form/viewmodel to display the desired decimal places. If you just want to remove the trailing zeros, you'll probably have to manipulate the string returned by the ToString call. – Jamie Ide Nov 12 '13 at 18:41
That was what I'm after, it worken with `.ToString("G29")`. Update your answer with this code, and I'll accept. – DontVoteMeDown Nov 12 '13 at 19:10
Really interesting solution. But/And the most interesting is, how it proves again the fact: calling `ToString` without params should be avoided – Radim Köhler Nov 13 '13 at 03:32

score 1 · Answer 2 · answered Nov 12 '13 at 18:05

1

1.1 becomes 1.100000000000000

              ^^^^^^^^^^^^^^^ 15 places

The .Scale(15) is what is causing this behavior. Reduce this to the number of decimal places you require.

answered Nov 12 '13 at 18:05

gleng

6,185
4
21
35

The problem is that I need that scale to be 15. I can't reduce it. It is equal to column definition in database: `Decimal(30,15)`. – DontVoteMeDown Nov 12 '13 at 18:12

score 0 · Answer 3 · answered Nov 12 '13 at 18:04

0

You can use string.format-Parameters like

string.format("{0:0.0000}",yourvalue");

answered Nov 12 '13 at 18:04

Ole Albers

8,715
10
73
166

kintaro · Answer 4 · 2013-11-12T18:17:03.107

0

Maybe this works for you:

if (this.Factor.Length < 15) for (int i = this.Factor.Length; i <= 15; i++) this.Factor += "0";

Regards.,

k

EDIT: Sorry, try this:

return Convert.ToDecimal(this.Factor, CultureInfo.InvariantCulture).ToString();

edited Nov 12 '13 at 18:17

answered Nov 12 '13 at 18:08

kintaro

2,393
2
16
16

I want to remove those zeroes, not adding more. – DontVoteMeDown Nov 12 '13 at 18:09

score 0 · Answer 5 · answered Nov 12 '13 at 18:13

0

Just remove Scale(15) to let the original value be loaded.

answered Nov 12 '13 at 18:13

mehmet mecek

2,615
2
21
25

ToString() filling Decimal number with zeroes at the right

5 Answers5