Hi,
I tried using the filtering and sorting functionality on clientside when using pivotgrid by setting the $scope.options - but neither of these work.
Is this a bug or some additional configuration that needs to be done?
$scope.options = { columnWidth : 20, height : 580, dataSource: $scope.dataSource, filterable: true, sortable: true};Note: I am getting all of my data from remote service in form of json (via transport) and using schema/model/cube technique to specify rows/column/measures
Thanks,
Labhesh
Hi ,
I am using pivotgrid's angular version.
When I download using excel (saveAsExcel()) functionality, all NaNs in my pivotgrid download as 0s in the excel. I'd like them to be kept as NaNs...
How can I do this?
Thanks,
Labhesh
$scope.exportToExcel = function() { var pivotGrid = $("#pivotgrid").data("kendoPivotGrid"); pivotGrid.saveAsExcel();};Hi,
I would like to filter measures (shown in total column) of the pivotgrid?
If this is not supported, is there a way to modify the query object as described in http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/how-to/access-mdx-query documentation?
Specifically, I would like to exclude rows where the absolute(total_column) < 0.01 %
Thanks,
Labhesh
We need to run some user confirmations for certain changes that occur with our incell-edited table. Our standard confirmation dialog is an async dialog, not Window.confirm(), which seems to cause some problems.
If we were just using the synchronous confirm(), then we could easily preventDefault() upon rejection, but the async confirm comes too late for that.
Additionally, there are times that we want to modify the value that the user enters as part of the save() call, but I haven't figured out how to get that to work.
In this fiddle (http://jsfiddle.net/LMFinney/3qkpLjvt/2/), I've simulated the async confirm dialog by wrapping confirm() in a Promise.resolve(). And I've simulated changing the value of the user-entered data by doubling odd entries. In this case, preventDefault() doesn't work because it's too late, and setting the modified value actually clears the value instead.
Is there another approach for these two issues?
I have a simple grid with filter (row mode), and it seems the grid fails to add new items when the filter is applied. Clicking the "Add new record" does nothing, not even triggering the grid `edit` event.
I have found this question on StackOverflow: http://stackoverflow.com/questions/17840312/cant-add-new-object-to-kendoui-grid-if-filter-is-applied-to-any-column but this seems an overly-complicated solution to a simple problem. Is there a more direct way of allowing the creation of new items while filter is on? I don't mind if I'll have to clear all filter fields, as long as the user doesn't have to do so manually.
I have a Kendo UI grid control that has three columns: Price Code, Description, and Quantity. The Price Code uses a DropDownList as a custom editor that changes the value of the Description field once selected. The problem that I'm having is that although the Description field changes when the DropDownList is changed, the Quantity field is reset to 0 when any of the fields in the row are changed. Here is my code:
<div id="workorderdetails" style="padding-top: 2em;"> <div id="grid"></div> <script> $(document).ready(function () { $("#client").kendoAutoComplete({ template: "<span class='client-id'>#= AccountNumber #</span> <span class='branch-id'>#= (Branch == null) ? ' ' : Branch #</span> <span class='department-id'>#= (Department == null) ? ' ' : Department #</span> #= Name #", dataTextField: "Name", height: 520, dataSource: { type: "json", transport: { read: "http://localhost:53786/api/client" }, schema: { model: { fields: { AccountNumber: { type: "number" }, Branch: { type: "string" }, Department: { type: "string" }, Name: { type: "string" } } } }, pageSize: 80, serverPaging: true, serverFiltering: false } }); // create DatePicker from input HTML element $("#datepicker").kendoDatePicker({ format: "dddd, MMMM d, yyyy" }); $("#grid").kendoGrid({ dataSource: { transport: { read: { url: "http://localhost:53786/api/workorder/1/workorderdetails", dataType: "json" } }, schema: { model: { fields: { WorkOrderID: { type: "number" }, ShortCode: { defaultValue: { PriceCodeID: 1436, ShortCode: "REF3" } }, Description: { type: "string" }, Quantity: { type: "number" } } } } }, pageable: true, height: 550, toolbar: ["create"], columns: [ { field: "ShortCode", title: "Price Code", editor: shortcodeDropDownEditor, template: "#=ShortCode.ShortCode#" }, { field: "Description", title: "Description", editable: "false" }, { field: "Quantity", title: "Quantity" }, { command: ["edit", "destroy"], width: "150px" }], editable: true, save: function (e) { if (e.values.ShortCode !== "") { var test = e.model.set("Description", e.values.ShortCode.Description); } } }); $("#warehouse").kendoDropDownList({ dataTextField: "Name", dataValueField: "WarehouseID", dataSource: { valueTemplate: "#= Name#", template: '#= Name# <h3>#= Address1#, #= City #, #= Province#, #= Country#</h3>', transport: { read: { url: "http://localhost:53786/api/warehouse", dataType: "json" } }, schema: { model: { fields: { WarehouseID: { type: "number" }, Name: { type: "string" }, Address1: { type: "string" }, City: { type: "string" }, Province: { type: "string" }, Country: { type: "string" } } } } } }); }); function shortcodeDropDownEditor(container, options) { $('<input required data-text-field="ShortCode" data-value-field="PriceCodeID" data-bind="value:' + options.field + '"/>') .appendTo(container) .kendoDropDownList({ valuePrimitive: false, dataTextField: "ShortCode", dataSource: { transport: { read: { url: "http://localhost:53786/api/pricecodes/unique", dataType: "json" } } } }); } </script>In addition, I'd like to make it such that the user cannot edit the Description field manually; it can only be altered by changing the Price Code.
Hi,
I have created a kendoWindow with this code
function CustomerPopupEditor() {
$("#showCustomerEdit").append("<div id='window'></div>");
var myWindow = $("#window").kendoWindow({
width: "80%",
height: "47%",
title: "Customer",
content: "/Customer/CustomerEditor",
modal: true,
actions: [
"Close"
],
close: function (e) {
$("#window").empty();
}
}).data("kendoWindow");
myWindow.center().open();
}
and I am closing the window using this code
function CloseTheWindow() {
$("#window").data("kendoWindow").close();
}
this is called on a button click event, when I get this window open, it works fine, I click my Save button it closes it. However if I open it again and try to close it, the window won't close.
I am not sure if this is enough information or if I need to add more information.
Thanks
Hi Guys,
I'm trying to locate the unminified kendo culture JS files to modify for a custom culture in my application but for some reason i cant seem to locate them anymore in latest Kendo installation 2016.2.504 UI for ASP.NET MVC Q2 2016.
Can you point me out to a location where to find the culture file source?
Cheers!
Hello
Can we customize the measure based on some other column values? eg: If I have measures like below,
measures: {
"ChainShare": { field: "ChainShare", aggregate: "sum" },
"DemandIndex":{field:"DemandIndex",aggregate: "sum"},
"GroupShare":{field:"GroupShare",aggregate: "sum"}
}
Then can we define DemanIndex field as ChainShare/GroupShare .
Thanks and Regards
Satabdi