Thousands separator not working with format.locale

[wild-thomas]

Issue description

The format.locale on Dash table version 3.6.0 is not working correctly.

Steps to reproduce the issue

Using dash-table==3.6.0 and the example code from the documentation on https://dash.plot.ly/datatable as a basis I added 'format': {'locale': {'group': '.', 'decimal': ','}}

import dash
import dash_table
import pandas as pd
import locale

locale.setlocale( locale.LC_ALL, 'de_DE.UTF-8' )

df = pd.read_csv('https://raw.githubusercontent.com/plotly/datasets/master/solar.csv')

app = dash.Dash(__name__)

app.layout = dash_table.DataTable(
    id='table',
    columns=[{"name": i, "id": i, "type": "numeric", 'format': {'locale': {'group': '.', 'decimal': ','}}} for i in df.columns],
    data=df.to_dict("rows"),
    
)

if __name__ == '__main__':
    app.run_server(debug=True)

What's the expected result?

The numbers should have a thousands separator.

What's the actual result?

The thousands separator is not showing.

Additional informations

Also symbols seem not to work.

[Marc-Andre-Rivet]

@kolalait In the example above the locale configuration is defined but it is not used as no specifier is defined for formatting the data. Adding 'specifier': '.2f' to the column or some variation should fix the issue.

Side note, if you are using the same locale configuration for all or the majority of the columns, you can define it at the table's level with the locale_format prop.

Hope this helps.

[fses91]

Hi I am having the same issue here, the format doesn't work, I tried different things but nothing changes. I tried it with the solution mentioned by @Marc-Andre-Rivet but it also doesn't work.

EDIT
The normal formatting works now I didn't specified the type, but for the symbol attribute for specific prefix and suffix the output doesn't change. (

column = {"name": n, "id": i, "format": {"locale": {"group": ".", "decimal": ",", "symbol": ['-', '%']}, 
                      "specifier": ".2f"}, "type": "numeric"}

[thispejo]

hi, I have the same problem!

[ConnyCo]

Hi, after a LOT of try & error this ist working for me (col2):

from dash_table.Format import Format, Scheme, Sign, Symbol

columns=
[
{
'id': 'cola',
'name': 'Col A',
'type': 'text'
},
{
'id': 'col2',
'name': 'Col B',
'type': 'numeric',
'format': Format
(
precision=0,
group=',',
scheme=Scheme.fixed,
symbol='$'
),
}