Three issues with formulae support

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

    Posted 03 Feb Link to this post

    Hi again,
    after some initial testing, we have found some formulae related issues.

    1) first is about "shared" formulae formulae" (ie the ones obtained by dragging one formula over adjacent cells).
    I'll attach you two simple xlsx file, both work exactly the same in MS Excel, but one doesn't work fine in Spreadsheet component.

    Compare the first section of the two files: the row tagged as "Cumulative" doesn't work in Spreadsheet in the second version, since the "shared" sum formula doesn't work. 

    NOTE: the first version is produced with MS Excel, the other with a famous third party commercial XLS library.

    2) empty cells are not considered as "0", and give an error when used as parameters in formulae (see second section of any of the attached file, compared to first section) the yellow empty cell gives an error

     

    3) SUMPRODUCT doesn't work. It's sufficient to test it on one of your online examples to verify. It throws an error

    thanks and regards,
    Sebastian

  2. T. Tsonev
    Admin
    T. Tsonev avatar
    2772 posts

    Posted 05 Feb Link to this post

    Hello,

    Thanks for reporting these issues.

    We'll investigate and get back to you with our assessment and a timeline for potential fixes.

    Regards,
    T. Tsonev
    Telerik
    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. Mihai
    Admin
    Mihai avatar
    153 posts

    Posted 08 Feb Link to this post

    Hi Sebastian,

    We fixed these issues, and the fixes will make it into the next internal build (mid February).  Thanks again for your report.

    Regards,
    Mihai
    Telerik
    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