Decimal places in Django template

Question

Good morning, everyone,

I’m having a basic problem but apparently boring to solve:

{% load l10n %}
{% localize off %}
    var dados_grafico = [
        [
            'Entradas',
            {{relatorio.grafico.entradas|floatformat:2}},
            {{relatorio.grafico.saidas|floatformat:2}},
        ]
    ]
{% endlocalize %}

From Django’s documentation, assuming I have 10 for inputs and 7 for outputs, this should return 10.00 and 7.00 respectively, with dots separating the decimal places, which is what I desire.

The problem is it’s returning 10.00 and 7.00 (commas separating the decimal places).

I also noticed that by removing the floatformat:2 of the values, Django returns, for example, 10,000 and 7,000 (works but does not limit the number of decimals).

Question: Someone’s been through it and can give me a light?

Answer 1

You can change this in your file settings.py, but note that for our system the "correct", is to separate decimal places with commas and not with point, the topic Format localization in the documentation says that formatting is disabled by default, so you should probably have the following command in your settings.py:

USE_L10N = True

Although local formatting is disabled by default, when Voce creates a project with django-admin startproject, by convenience, USE_L10N = True is included in your settings. Try to remove this line or switch to:

USE_L10N = False

Note that this will affect other details of local formatting (Brazil).

intcoma (Django.contrib.humanize):

One option is to use [django.contrib.humanize][2] "A set of template filters that adds a 'human touch' to the data"

intcomma Convert a int or float (or a string representation) for a string containing commas every 3 digits:

Examples:

4500 se torna 4,500
4500.2 se torna 4,500.2

I don’t know if this option would specifically suit your case, to use it, add on INSTALLED_APPS and the template you will use {% load humanize %}

Answer 2

The obvious is often the last thing that comes to mind:

    var dados_grafico = [
        [
            'Entradas',
            parseFloat('{{relatorio.grafico.entradas|floatformat:2}}'.replace(',', '.')),
            parseFloat('{{relatorio.grafico.saidas|floatformat:2}}'.replace(',', '.')),
        ]
    ]

This way, Django will return the value with the comma but it is modified via Javascript by the dot. :-)