Hi how can i close second level  nodes please.

https://s10.postimg.org/8ouy6zo95/Capturar.jpg

Hello,

I used spreadsheet to open an xlsx file like in this demo (http://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export), but I found a problem with the filters in the excel file. In the "filter by value" zone, it appears only "all" , the other values doesn't appear , also for the "filter by Condition" zone when I try to find some value the filter doesn't work, it only changes the color of the arrow icon but all the values still exists.

As for the excel file I created a simple excel file with some filters. I noticed that the filters works only if I used an excel file that I have already used its filters in Microsoft excel.

I used 

below the code that I used 

HomeController.cs:

        public string GetJsonExcel(string fileName1)
        {
            var fileName = fileName1.Replace("***", "'");
            string pathF = ConfigurationManager.AppSettings["PathDocs"].ToString();
            var physicalPath = Path.Combine(pathF, fileName);
            var workbook = Workbook.Load(physicalPath);
            return workbook.ToJson();
        }

Index.cshtml:

<div id="spreadsheet" style="width: 100%; height: 99%"></div>
<script>

    $("#spreadsheet").kendoSpreadsheet();
    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    $.getJSON(generateUrlWithParam("Home", "GetJsonExcel", "fileName1", "spreadsheet with file after using filters in microsoft excel.xlsx"))
        .done(function (sheets) {
            spreadsheet.fromJSON(sheets);
          });
         
        });
</script>

Best regards, 

I am checking out KendoUI for Angular.  

The DataQuery component mentions mvc integration (http://www.telerik.com/kendo-angular-ui/components/dataquery/mvc-integration/).

I went to (http://docs.telerik.com/aspnet-core/getting-started/getting-started#configuration-Add) on how to add the UI for ASP.NET Core.

The only thing I can find at the source is KendoUIProfessional.Trial.

What gives?  I am trying to get the mvc service extenstions like ToDataSourceResult.  

I would like to localize the "No data found" message in the grid when the column filter is not overriden. In my grid I have filterable mode="row" so by setting the column values to collection the filter will work as expected. Is there a way to easily override this label without customizing the filter? 

I found the <kendo:grid-filterable-messages> tag which has options to translate a few properties, so I expected that this would be there too.

Thanks in advance.

Daniel

Hi 

I get some problem when I try to delete a record in Grid. They method will call the create and update method which is I don't want.

Please refer to pic1, my grid is batch update, I have one record in , then click Add new record button to add two new records but not save into database yet. At this moment, there are three records in grid, then I click the delete button on the third row, it will trigger the create method to transfer the two new records to the backend, this is I don't want, because I have not typed any value, it will get error in my backend.

So my question is there any way to ignore the create, update method when I click the delete button?

Below is the method of my custom Delete button.

function onDeleteConfirm_VendorSalesRepsGrid(e, obj) {
    e.preventDefault();
    var dataItem = obj.dataItem($(e.target).closest("tr"));
    CustomConfirmDialog("Are you sure you want to delete this Vendor Sales Reps?", function test2(result) {
        if (result === true) {
            var dataSource = $("#VendorSalesRepsGrid").data("kendoGrid").dataSource;
            dataSource.remove(dataItem);
            //If the id equal to 0, it means that this record does not existed in database. so no need to run the sync().
            if (dataItem.id != 0) {
                dataSource.sync();
            }            
        }
    });
}

Hi,

Facing issue with TreeView with  angular1. PSB code.

Problem: When i try to model my JSON for Checkbox Tree doesn't bind my attribute named "children" may be because the property name same!

Expected: As we change kendo default "text" property to custom "dataTextField", How can i replace "items" to "children"

HTML:

<div kendo-tree-view="tree"  k-data-source="dataSource"   k-options="options"   k-on-change="selecteditem=dataItem"> </div>

Angular:

 var schemaTree = {
        model: {
          //children: "items"
            children: "children"
          }
        };

        $scope.options = {
         dataTextField: "name",
          
          checkboxes: {
            checkChildren: true,
            template: "<input id='checkbox_#:item.uid#' ng-model='dataItem.isChecked' type='checkbox' class='k-checkbox'/><label for='checkbox_#:item.uid#' class='k-checkbox-label'></label>"
          },
          
          template: "#: item.name #"
        };

        $scope.treeData = [
          {
            "name": "Alex's family tree",
            "isChecked":true,
            "id": 44,
            "items": [
              {
                "id": 1,
                "name": "Reef",
                "isChecked": true
              },
              {
                "id": 2,
                "name": "Coraline",
                "isChecked": true
              }
            ],
            "children": [
              {
                "id": 1,
                "name": "Reef",
                "isChecked": true
              },
              {
                "id": 2,
                "name": "Coraline",
                "isChecked": true
              }
            ]
          }
        ];
        
        $scope.dataSource = new kendo.data.HierarchicalDataSource({
        data : $scope.treeData,
          schema: schemaTree
        });

Please let me know if you need more info on the same. Any help will be appreciated.

Regards,

Harish

Hi, is there any way to filter rows in the spreadsheet by cell colour? Excel has this functionality - its called "Filter by Color or Filter Cell by color"

Thanks

Marc

Hi,

I'm trying to figure out how to display the category name for each data series on a column chart (I'm trying to get to something like the attached picture).

For now I'm just hard coding up an example in an html template. and so far I have the following:

Looking at the docs (SeriesLabel) I think I can add more to the labels json object I'm configuring on line 4. But I'm struggling to get the syntax correct.

Does anyone have any suggestions?

Can you look this example http://dojo.telerik.com/ebAkU/5.

When i use "editRow" method first time - all work good. But the second call "editRow" kendo grid do nothing. 

Did i do something wrong? Or it is a grid bug?

I have a method which takes some data from the datasource and via a RESTful webservice, changes it. I then need to update the datasource items.

I am using AngularJS so I have tried updating the $scope variable which is used inside the read method of my datasource ie (in the below example I changed $scope.myLocalResults

read: function (options) {
    options.success($scope.myLocalResults);
}

And then called datasource.read() - however this turned out to be quite slow.

I have then tried just updating the changed records - ie my webservice returns an array of records (order guaranteed so I find the originally index of the record from $scope.myLocalResults, and then do:

var dataItem = dataSource.at(index);
dataSource.remove(dataItem);
dataSource.insert(index, myNewRecord);

However this is also quite slow - around 1 second per record, and I have around 2000 records.

Is there a quicker way to achieve what I want to do? I cannot simply using the .set method of the dataItem, as we have around 200 columns which could change.

Also - does .remove and .insert on the dataItem cause any datasource method to be fired, ie read or sync or something like that? I'm trying to work out why this is so slow, in comparison to other operations I am doing to the JS objects.

Thanks

Marc