Approved
Last Updated: 23 Aug 2017 11:57 by ADMIN
ADMIN
Peter Milchev
Created on: 23 Aug 2017 11:56
Category: Spreadsheet
Type: Bug Report
1
The FIXED formula is not working as expected when second argument is 0
related to https://github.com/telerik/kendo-ui-core/issues/3519
workaround for rounding function is using Custom Functions http://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/custom-functions

kendo.spreadsheet.defineFunction("ROUND", function (x) {
    return Math.round(x);
}).args([
    ["x", "number"]
]);

Cell cell = new Cell() { Index = 0, Formula = "=ROUND(1.2)", Bold = true, Background = "#fef0cd", Format = "$0" };
0 comments