ColumnConfig Numbercolumn Localized

Hi ,I’m running my app locally but st.column_config.NumberColumn(format = 'localized") does not seem to be working as I expected. I expect the result of this minimal example:

# Set the locale for the number format NL
locale.setlocale(locale.LC_ALL, 'nl_NL.utf8')

# Create a title for your app
st.title('Minimal Work Example')


st.data_editor(
    data=pd.DataFrame({"A": [123994, 23445, 345446]}),
    key='data_editor',
    column_config={
        "A": st.column_config.NumberColumn(format="localized")
    }
)

To show a thousand seperator as a . and the comma as a , but instead it does not do that while when I print a number using this locale setting it does.
Streamlit version 1.43.2

Thanks for all the help in advance! I really need to tackle this issue before being able to make a streamlit app in production in the Netherlands since it can get very confusing for big numbers.

1 Like

I have the same issue. It would help so much if you could change the decimal separator to a ‘,’

1 Like

I was indeed missing something. The localization depends on the user browser language settings.

Language Example
Nederlans
Français
English US

I think they just called localized to formatting the number with a period as a decimal separator and a comma for the thousands, I do not think the app is actually aware of the users’ locale.

Though I might be missing something, this exact issue was raised here and it was closed with the 1.43 release.

1 Like

If the other options aren’t working, try replacing ‘localized’ with the following string below:

“%'d\n”

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.