Hello Telerik Team,

Let's assume there is a xlsx file and I want to load this file to Spreadheet control.

Controller code:

var workbook = Workbook.Load(​path);  
var workbookJson = workbook.ToJson();
                                        
var model = new ExcelViewerViewModel()
{
Name = "Test",
Sheets = JsonConvert.DeserializeObject<IEnumerable<SpreadsheetSheet>>(workbookJson),   <--- the problem to deserialize sheets
};

return PartialView("~/Views/Shared/_ExcelViewer.cshtml", model);

The View code:

            @(Html.Kendo().Spreadsheet()
                .Name("excelViewer")                                
                .Toolbar(false)                       
                .BindTo(Model.Sheets))

So the question is how to get IEnumerable<SpreadsheetSheet>> type from workbook?

 Thank You

Hello,

I noticed today that the status of my trial application is only 'partially installed'.   I upgraded it to a newer version during my trail period.

 When I choose to repair the installation, the status remain. (please refer to attached a screenshot from my Telerik Control Panel).

Question - can I safely remove the product, then re-install without losing work ?

Thanks,

Mike James

I am trying to apply the filter for a column that has null values in the database. When I try to filter the column by some value, it throws following error. Please suggest the solution to handle columns those have null values in the database

An exception of type 'System.NullReferenceException' occurred in System.Core.dll but was not handled in user code

Additional information: Object reference not set to an instance of an object

Anyone know if offlineStorage would let users scroll through previous pages that were loaded via virtual scrolling? Can they come back to a page that was closed and see their cached data? Is there a feature that would allow this? 

I created a grid with detail rows. Detais rows may have unsaved data. In that case I need to stop the collapse event. My code is not working:

var detailGrid = $("#grid-details").kendoGrid({
            detailTemplate: getDetailTemplate,
            detailInit:InitFunc,
            detailCollapse: function (e) {
                if (.....here I check for changes ) {
                e.preventDefault();
                return false;

                }
            },​

......});

I got to e.preventDefault(), but the row is collapsed anyway

I was wondering how to hide/show columns based on  the values of aggregate values in footer. For example:

  @(Html.Kendo().Grid<Payroll.Models.PayrollAuthorizationByDepartmentModel>()
.Name("Grid")

.Columns(columns =>
{
columns.Bound(dataSource => dataSource.EmployeeId).Title("Emp. No");
columns.Bound(dataSource => dataSource.EmployeeNameForDisplay).Title("Emp. Name");
columns.Bound(e => e.RegHours).Title("Reg.")
.ClientFooterTemplate("<div style='text-align: right'> \\#= kendo.toString(sum, '0.00')\\# </div>")
.ClientTemplate("\\#= kendo.toString(RegHours, '0.00')\\#");
columns.Bound(e => e.OTHours).Title("OverTime 1.5")
.ClientFooterTemplate("<div style='text-align: right'> \\#= kendo.toString(sum, '0.00')\\# </div>")
.ClientTemplate("\\#= (OTHours==0)? '':kendo.toString(OTHours, '0.00')\\#");                        
                        })
.DataSource(dataSource => dataSource
.Ajax()
.Aggregates(aggregates =>
{
aggregates.Add(e => e.RegHours).Sum();
aggregates.Add(e => e.OTHours).Sum();                                                              
                                                          })
.Read(read => read.Action("AuthorizationByEmployee_Read", "Authorize", new { locationId = @ViewBag.LocationId, departmentId = "#=DepartmentId#", startDate = @ViewBag.StartDate, endDate = @ViewBag.EndDate }))
.ServerOperation(false)
.Sort(sort => sort.Add("EmployeeFirstName").Ascending())
)
.Sortable()
.Events(events => events.DataBound("onDataBoundOfChildGrid"))
.ToClientTemplate()
)

How to hide the column if the sum is 0?

Thanks!

I am having some trouble with a simple bar chart.

Here is my model

And here is my Chart.

Looking for the following result

Vertical Axis (value of the following)... model.Commitments, model.Distributions, model.DrawDown, Model.Fees (values are between 0 and 3 as a decimal with 1 precision.

Horizontal Axis (model.YearCategory)

Bars -- Commitment, Distribution, DrawDown and Fees.

Example of data

Any ideas of what i am missing?

Thanks

Corey

I want to open a kendo window when click in kendo grid cell. The code is

                columns.Bound(s => s.HasComments)
                    .HeaderHtmlAttributes(new { title = "Comments"})
                    .ClientTemplate("<div class='sprite sprite-note' onclick='openCommentWindow('ResourceSport', '<#= ResourceSportId #>', '<#= SportName #>', '" + Model.Editable + "', 'true');'></div>")
                    .Width(100);

openCommentWindow is jquery function. But onclick does not respond at all. I want to know what is the problem and how to do this. Thanks.