Django administration Model list always shows Decimal with decimal places

[jason@…]

Only in the list_display does the admin interface show DecimalField with precision of .00. In the view of an object in the Model, 0.00, for example, would be shown as 0, without the precision. I'd say the same rendering should be for both, and that displaying without the .00 is preferred.

[Alex Gaynor]

Not a critical bug, thus not in line for 1.1.

[Aymeric Augustin]

Change UI/UX from NULL to False.

[Aymeric Augustin]

Change Easy pickings from NULL to False.

[Tomek Paczkowski]

The problem here is two folds:

1. By default, admin will not localize input values. Not localized input is rendered as str(value), which is Decimal.__str__. List display uses display_for_field, which localizes value if USE_L10N is true.
2. When forced to localize (by settings ModelForm._opts.localized_fields = '__all__'), decimal input still does not honour DecimalField.decimal_places and is displayed differently from list.

Fix for 2. is easy, overriding _format_value in NumberInput to correctly use number_format with decimal_places.
Fix for 1. is not easy, if not impossible, tickets #13032 and #13546 mention problems with localizing inputs by default. At least we can better document current admin behaviour and include instructions to change it. Better yet, would be to include another ModelAdmin option to control localized_fields in generated ModelForm classes.

[gaweng]

Issue doesn't exist anymore, cause its handled already in DB Connectors:

SQLite:

# operations.py Line 316-328
def get_decimalfield_converter(self, expression):
    if isinstance(expression, Col):
        quantize_value = decimal.Decimal(1).scaleb(
            -expression.output_field.decimal_places
        )
        def converter(value, expression, connection):
            if value is not None:
                return self._create_decimal(value).quantize(
                    quantize_value, context=expression.output_field.context
                )

PostgreSQL:

# base.py Line 93-96
def _get_decimal_column(data):
    if data["max_digits"] is None and data["decimal_places"] is None:
        return "numeric"
    return "numeric(%(max_digits)s, %(decimal_places)s)" % data

MariabDB:

# operations.py Line 28
"DecimalField": "decimal(%(max_digits)s, %(decimal_places)s)",