Decimal separator problems

4 posts, 0 answers
  1. Adrian
    Adrian avatar
    4 posts
    Member since:
    Jan 2016

    Posted 06 Oct Link to this post

    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?

  2. Peter Milchev
    Admin
    Peter Milchev avatar
    144 posts

    Posted 11 Oct Link to this post

    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
  3. UI for ASP.NET MVC is VS 2017 Ready
  4. Adrian
    Adrian avatar
    4 posts
    Member since:
    Jan 2016

    Posted 11 Oct in reply to Peter Milchev Link to this post

    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).

     

  5. Peter Milchev
    Admin
    Peter Milchev avatar
    144 posts

    Posted 13 Oct Link to this post

    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
Back to Top
UI for ASP.NET MVC is VS 2017 Ready