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

Decimal separator problems

3 Answers 244 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Adrian
Top achievements
Rank 1
Adrian asked on 06 Oct 2016, 07:22 PM

In my spreadsheet decimal separator in number cells is dot instead of comma (with the latter being proper to my culture). I set kendo.culture before loading spreadsheet widget and while debugging the current culture setting values seems OK, but they are not applied to spreadsheet.

I have set  "#,##0.00" format to my number cells to display numbers properly and it works fine with a few exceptions:

- when writing a formula numbers must have dot separator

- loading data from external spreadsheet file in widget shows numbers with dot separator

 

Are there ways to get this done that I'm not aware of or this is just not supported, and if so are there plans to improve it in next versions?

3 Answers, 1 is accepted

Sort by
0
Peter Milchev
Telerik team
answered on 11 Oct 2016, 07:11 AM
Hello Adrian,

I am afraid that we could not completely understand the issue and reproduce it. Would you please modify the Dojo example we used to test your scenario? We would also appreciate it if you provide more detailed steps for reproducing the issues along with some examples and screenshots, if possible. 

We are looking forward to your reply.

Regards,
Peter Milchev
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Adrian
Top achievements
Rank 1
answered on 11 Oct 2016, 05:46 PM

OK, so the first problem is when user enters formula in cell (e.g. =1,41*3,14) it does not calculate properly and it must be with entered with dot separator (=1.41*3.14) which is not consistent with culture. Example in dojo: http://dojo.telerik.com/eTosU/2

 

Second thing is when load data from .xls file (with comma separator) in kendo spreadsheet there are dot separators (example in screenshots).

 

0
Peter Milchev
Telerik team
answered on 13 Oct 2016, 11:47 AM
Hello Adrian,

Thank you for the clarifications.

Regarding the number's format in the formula, unfortunately we support only numbers with dot "." as a decimal separator, no commas, regardless of the culture. 

As for the excel import, what happens there is that the cells have no format at all. If you format them in Excel "#,##.00" and save the file, it should be fine on import. When there's no format defined, currently the Spreadsheet doesn't take culture into account - the browser itself just stringifies the number to 3.14.

If you consider that this should be built-in functionality of the Spreadsheet, I would suggest you to create feature requests in the Kendo UI UserVoice portal.

Regards,
Peter Milchev
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Spreadsheet
Asked by
Adrian
Top achievements
Rank 1
Answers by
Peter Milchev
Telerik team
Adrian
Top achievements
Rank 1
Share this question
or