Hi folks,
I have a datasource bound spreasheet. When I enter a value in a cell, the change is reflected in the datasource. That's good.
A1
Now, I enter a formula, =SUM(A1:B1), in cell C1, on the first time I input the formula in C1, the bound datasource gets the sum value correctly. Then I change value in cell A1 from 100
Hi!
I am using kendo spreadsheet to batch-edit a list of values.
In the last version available, if I change a value, I lose the format (I append a currency to the number; currency that can be different in each cell). That's removed after I update the value
Here's a demo:
http://dojo.telerik.com/AyOXo/13
Try to change the value of the amount in the cell to something else.The currency (SEK/USD will dissapear from the format)
Thanks!

Hello,
Is it possible to localize the Column Title in the Grid component?
For instance, in the following example, I would like to show Name or Nom depending on the user's locale.
$("#grid").kendoGrid({ dataSource:remoteDataSource, height: 550, groupable: true, sortable: true, resizable: true, pageable: { refresh: true, pageSizes: true, buttonCount: 5 }, columns: [{ field: "name", title: "Name", width: 400 },Cheers,
Paul

Dear support team,
I'm using the built-in create child on the TreeList, which is referenced hear. I just added the "createChild" to the list of commands. On the grid if I click the button the child is created. I can then update the cells, but once I click the update button, the actions are subsequently itemchange, sync, then remove. Of course, the newly created item is removed from the grid. My contact information has been changed, but not with Telerik, so use the below contacts.
Respectfully,
James Rollins
Senior Developer
Digital Cloak LLC
james.rollins@digitalcloak.net

Suppose I have a data source with fields id and x that comes from a table foobar.
The view model is id, x, xorig. For read operations the xorig value is also set to the x value
The peculiar rules for foobar is that when an x is to be updated it will try to honor the requested x, otherwise it will return a new x value
The data source is configured for batch mode.
The read gets a row id=1, x=10
The user edits x to be 20 and hits a save changes button. The update transport sends json via parameterMap [ {id:1, x:20, xorig:10} ]
The update routine will send back [ {id:1, x:20, xorig:20} ] if the edit was honored, or perhaps [ {id:1,x:55,xorig:55} ] if the 20 could not be honored and the peculiar rules determined x should be 55 instead.
How and where can I capture the update response and tweak the data source elements to match the update response. For example:
for (var i=0; i<updateResponseData.length; i++) { var responseItem = updateResponseData[i]; var datasorcItem = myDataSource.get(responseItem.id); datasorcItem.x = responseItem.x; datasorcItem.xorig =responseItem.xorig; datasorcItem.dirty = false;}
Thanks,
Richard
On the latest version of chrome 61.0.3163.100 column resize is broken if zoom is not set to 100%. ie. if zoom is set to 110% then column resize no longer works. This worked on version 60.0.3112.113.
Just try out the resize column sample on your demos page
http://demos.telerik.com/kendo-ui/grid/column-resizing
When on the page set zoom to 110%. Column resize stops working.
I have a grid with many records (over 1M records) in my DB. I want to only request the data that will be displayed on the current grid from my DB. What I do is pass my current page and pageSize to my java code in order to determine how many records I will skip in my DB.
Ex. If I navigate to page 5 with a pageSize of 20, I will skip the first 80 records and receive the next 20.
This is working so far, but my issue is that when I receive those 20 records of data and place it in my dataSource; page 5 will show up empty since the data will only be displayed on page 1.
A work-around I found is to fill my dataSource data with empty JSON objects {}. This works, but if I were to input 100,000 empty JSON objects, the program will crash.
What can I do to display my data on the specific page I'm on, and basically ignore all the other pages when I'm not visiting them?
I am trying to configure a VerticalBoxPlot using the Kendo asp.net MVC in the following ways
1. Display just the outline for the box plot without any fill as shown in the image.
2. Display the median in a color other than white.
Are these 2 things customizable at all? I would really appreciate if anyone can point me in the right direction either using asp.net MVC or even using Javascript.
- Sumanth
Hi there,
My bar chart is not picking up the sort order I am applying. I am returning Json with 4 categories - High, Medium, Low and Very Low, each returning a sort order to force the graph to display in that correct order. However, the graph renders in the wrong order. Please can you assist. I have attached a screenshot of what is rendered, code below. Everything else in my chart is working fine.
=== JSON RETURNED ===
[{"Share":3,"VisibleInLegend":true,"Color":"#E8412D","category":"High","SortOrder":4,"PercentageField":"9%"},{"Share":9,"VisibleInLegend":true,"Color":"#ED8132","category":"Medium","SortOrder":3,"PercentageField":"29%"},{"Share":3,"VisibleInLegend":true,"Color":"#FFB400","category":"Low","SortOrder":2,"PercentageField":"9%"},{"Share":16,"VisibleInLegend":true,"Color":"#92CE7A","category":"Very Low","SortOrder":1,"PercentageField":"51%"}]​
=== VIEW ====
@( Html.Kendo().Chart<Models.RiskItemsBarChartModel>()
.Name("riskItems")
.ChartArea(chartArea => chartArea.Background("#F5F5F5"))
.Title(title => title
.Text("Risk Items")
.Position(ChartTitlePosition.Top))
.DataSource(ds => ds
.Read(read => read.Action("RiskItemsBarChart", "Reporting"))
.Group(g => g.Add(d => d.category))
.Sort(g => g.Add(d => d.SortOrder))
)
.Series(series => series
.Bar(d => d.Share, d => d.Color).CategoryField("category")
.Name("#:group.value#")
.Stack(true)
.Labels(labels => labels
.Visible(true)
.Template("#= value # (#= dataItem.PercentageField #)")
.Position(ChartBarLabelsPosition.InsideBase)
)
)
.CategoryAxis(axis => axis
.Visible(false)
)
.Tooltip(tooltip => tooltip
.Visible(false)
)
.Legend(legend => legend
.Visible(true)
.Position(ChartLegendPosition.Bottom)
)
.Events(events => events
.SeriesClick("onSeriesClick_riskItems")
.DataBound("onDataBound_riskItems")
)
)
Thanks, Mark