Telerik Forums
Kendo UI for jQuery Forum
1 answer
211 views

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

Georgi Krustev
Telerik team
 answered on 25 May 2016
1 answer
164 views

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();
};

Georgi Krustev
Telerik team
 answered on 25 May 2016
2 answers
110 views

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

 

Georgi Krustev
Telerik team
 answered on 25 May 2016
3 answers
728 views

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?

Lance
Top achievements
Rank 1
 answered on 24 May 2016
2 answers
157 views

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.  

Dimiter Madjarov
Telerik team
 answered on 24 May 2016
1 answer
722 views

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.

 

 

Dimiter Topalov
Telerik team
 answered on 24 May 2016
5 answers
393 views
Hello,

I have problem with grid aggregates.

When data changes, on Save event everything is fine – aggregates recalculated and label updated correctly. But when row is deleted, aggregates refresh only after event Remove. As result the label shows wrong, not updated number. Is any way to work it around?

http://jsfiddle.net/oucyngdf/

Thank you in advance.
Ruben
Top achievements
Rank 1
 answered on 24 May 2016
1 answer
419 views

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

Dimiter Madjarov
Telerik team
 answered on 24 May 2016
2 answers
992 views

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!

 

 

IT
Top achievements
Rank 1
 answered on 24 May 2016
4 answers
944 views

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

Georgi Krustev
Telerik team
 answered on 24 May 2016
Narrow your results
Selected tags
Tags
Grid
General Discussions
Charts
Data Source
Scheduler
DropDownList
TreeView
MVVM
Editor
Window
DatePicker
Spreadsheet
Upload
ListView (Mobile)
ComboBox
TabStrip
MultiSelect
AutoComplete
ListView
Menu
Templates
Gantt
Validation
TreeList
Diagram
NumericTextBox
Splitter
PanelBar
Application
Map
Drag and Drop
ToolTip
Calendar
PivotGrid
ScrollView (Mobile)
Toolbar
TabStrip (Mobile)
Slider
Button (Mobile)
Filter
SPA
Drawing API
Drawer (Mobile)
Globalization
LinearGauge
Sortable
ModalView
Hierarchical Data Source
Button
FileManager
MaskedTextBox
View
Form
NavBar
Notification
Switch (Mobile)
SplitView
ListBox
DropDownTree
PDFViewer
Sparkline
ActionSheet
TileLayout
PopOver (Mobile)
TreeMap
ButtonGroup
ColorPicker
Pager
Styling
Chat
MultiColumnComboBox
Dialog
DateRangePicker
Checkbox
Timeline
Drawer
DateInput
ProgressBar
MediaPlayer
ImageEditor
TextBox
OrgChart
Accessibility
Effects
PivotGridV2
Licensing
ScrollView
Switch
TextArea
BulletChart
QRCode
ResponsivePanel
Wizard
CheckBoxGroup
Localization
Barcode
Breadcrumb
Collapsible
MultiViewCalendar
Touch
RadioButton
Stepper
Card
ExpansionPanel
Rating
RadioGroup
Badge
Captcha
Heatmap
AppBar
Loader
Security
TaskBoard
Popover
DockManager
TimePicker
FloatingActionButton
CircularGauge
ColorGradient
ColorPalette
DropDownButton
TimeDurationPicker
ToggleButton
BottomNavigation
Ripple
SkeletonContainer
Avatar
Circular ProgressBar
FlatColorPicker
SplitButton
Signature
Chip
ChipList
VS Code Extension
AIPrompt
PropertyGrid
Sankey
Chart Wizard
OTP Input
SpeechToTextButton
InlineAIPrompt
StockChart
ContextMenu
DateTimePicker
RadialGauge
ArcGauge
AICodingAssistant
SmartPasteButton
PromptBox
SegmentedControl
+? more
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?