List view in new List experience: ratings does not display when decimal separator is comma

[jikleveland]

Target SharePoint environment

SharePoint Online

What SharePoint development model, framework, SDK or API is this about?

not applicable

Developer environment

None

What browser(s) / client(s) have you tested

• 💥 Internet Explorer
• 💥 Microsoft Edge
• 💥 Google Chrome
• 💥 FireFox
• 💥 Safari
• mobile (iOS/iPadOS)
• mobile (Android)
• not applicable
• other (enter in the "Additional environment details" area below)

Additional environment details

Describe the bug / error

When using rating with stars and regional locale settings is a locale that has a comma separator for digits the ratings displays 0.0 and not the correct rating.
When selecting a locale with period separator the ratings displays correctly.

Steps to reproduce

1.Set site locale to a locale that use comma as digit separator
2.Add ratings with stars to a list
3.Rate one or more list items with 2 or more ratings that will result in an average rating with decimals
4.Rating average displays as 0.0

Expected behavior

Average rating displays as the correct decimal number

[Ashlesha-MSFT]

Hello @jikleveland,
Thank you for bringing this issue to our attention. We will look into it and get back to you shortly.

[Ashlesha-MSFT]

@jikleveland,
According to this site https://sharepointmaven.com/add-average-rating-column-to-a-sharepoint-list/
When multiple users rate the same item (row), the average of the multiple ratings is taken.
By this you will get expected output.

After rating given by 2 users

thanks!

[jikleveland]

Sure.
But if you chage language to Norwegian the delimitter get changed, and the calculation failes.

[Ashlesha-MSFT]

@jikleveland,
I have already tested with french, now as per your suggestion I changed it to Norwegian

still getting correct rating average.

Thanks!

[jikleveland]

Did You change browser language, too?

I have my profile language set to Norwegian and site language set to Norwegian.
This is how it looks:

And with english settings:

[Ashlesha-MSFT]

@jikleveland,
I have changed browser language and also language in site setting too.

Getting expected behavior.

[jikleveland]

Something strange - I tested in another tenant.

Site regional settings = Norwegian. Also when I added ratings to the list.
Opened in a browser with norwegian settings and the ratings average shows what it should.
Then I changed regional settings in the site to Enlish (UK) and then the list view in both browsers/users with Norwegian and Enlish shows like this:

[Ashlesha-MSFT]

@jikleveland,
Then This might be the case that
if we select the same language in both the browser and site settings, it will work correctly

[jikleveland]

I'm testing with two different users, one with Norwegian config and one with English(UK) settings. I get the same problem for both.

[Ashlesha-MSFT]

@jikleveland,
Sorry for misunderstanding
Do you mean that for one user both Site regional settings = Norwegian and his browser language is also Norwegian.
And for another user both Site regional settings = English(UK) and his browser language is also English(UK)?

[jikleveland]

The site regional settings is Norwegian:

I have one accout with Enlish settings in the Edge account settings and English settings in the User account settings. this is the list view from that user:

I have another user with Norwegian settings in the Edge account and MyAccount. This is the list view for that user:

I change the site regional settings to English:

This is the list view for the user with English settings:

And for the user with Norwegian settings:

I get the same result when I do the same in another tenant, and also if I create the a new list with norwegian settings with the user with norwegian settings.

[Ashlesha-MSFT]

@jikleveland,
Thanks For detailed explanation,

We were able to reproduce the issue, and we are investigating it. We will log this as a bug, and our engineering team will look into it.

Thank you for your patience!