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
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
0
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.
Our thoughts here at Progress are with those affected by the outbreak.