This is a migrated thread and some comments may be shown as answers.

Decimal separator of regional settings vs specific settings

1 Answer 225 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Nazario
Top achievements
Rank 1
Nazario asked on 05 Jun 2020, 02:42 PM
Hi,
we got stuck in what might be an issue with your RadSpreadsheet.
We use the control to show a read-only imported file on our WPF client, full of numbers and formulas.
The problem arises when window (the operating system) regional settings (ex. USA, Italy, or any country) and advanced settings are incoherent such that the country has x as decimal separator culture and y as group separator culture and, in advanced settings, inverted values are provided (y as decimal separator and x as group separator). For example, this happens if we set Usa and "," as decimal separator and "." as group separator, or Italy and "." as decimal separator and "," as group separator.
What happens is that, although the values stored in any cell are correct if retrieved via code, the final rendering shows wrong decimal numbers and it seems that the decimal separator is considered as a group separator. For example, if the value would be 0.00, with the incoherent configuration above the value shown by the control would be 000.
Thanks

1 Answer, 1 is accepted

Sort by
0
Nikolay Demirev
Telerik team
answered on 10 Jun 2020, 02:33 PM

Hello Nazario,

Thank you for the provided information, I was able to reproduce the issue and I was able to fix it. If it passes our QA process it will be released with our next release. I have logged a public item in our Feedback portal which you could follow in order to receive updates about the progress on the matter: https://feedback.telerik.com/wpf/1471248.

I have updated your Telerik points as a token of our appreciation for reporting the bug.

Please let me know if there is anything else I can help you with.

Regards,
Nikolay Demirev
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Tags
Spreadsheet
Asked by
Nazario
Top achievements
Rank 1
Answers by
Nikolay Demirev
Telerik team
Share this question
or