Hi again,
after some initial testing, we have found some formulae related issues.

1) first is about "shared" formulae formulae" (ie the ones obtained by dragging one formula over adjacent cells).
I'll attach you two simple xlsx file, both work exactly the same in MS Excel, but one doesn't work fine in Spreadsheet component.

Compare the first section of the two files: the row tagged as "Cumulative" doesn't work in Spreadsheet in the second version, since the "shared" sum formula doesn't work. 

NOTE: the first version is produced with MS Excel, the other with a famous third party commercial XLS library.

2) empty cells are not considered as "0", and give an error when used as parameters in formulae (see second section of any of the attached file, compared to first section) the yellow empty cell gives an error

3) SUMPRODUCT doesn't work. It's sufficient to test it on one of your online examples to verify. It throws an error

thanks and regards,
Sebastian

Hi there,

I believe I have found a bug with the PDF export on the grid in Q2 2015 and onwards. I have reproduced this bug using the VS2015 PDF Export demo  supplied with the Kendo install.

In order to replicate this bug, please enable bundling optimizations in the BundleConfig class:

Grid export to PDF will no longer work - it will fail with an error about the font:

"Cannot load font from http://localhost/Content/kendo/fonts/DejaVu/DejaVuSans-Bold.ttf?v=1.1"

It would seem that the path is working from the kendo folder and excluding the version number? The actual path to the font file should be:

"http://localhost/Content/kendo/2015.2.624/fonts/DejaVu/DejaVuSans-Bold.ttf"

The export works without issue when optimizations are disabled.

Regards,

Paul McKay

Hi,

I am trying to access the grid column in detail template and it's gives me invalid template.

The code look's like

@(Html.Kendo().Grid<MessageViewModel>()
              .Name("messageGrid")
              .Columns(columns =>
              {
                  columns.Bound(e => e.MessageName);
                  columns.Bound(e => e.MessageSentTime);
                  columns.Bound(e => e.Message).Visible(false);
              })
              .Sortable()
              .Pageable()
              .Scrollable()
              .Groupable()
              .ClientDetailTemplateId("template")
              .HtmlAttributes(new {style = "height:550px;"})
              .DataSource(dataSource => dataSource
                  .Ajax()
                  .PageSize(25)
                  .Read(read => read.Action("GetMessageGridData", "Home").Data("getGridData"))
              ))
        <script id="template" type="text/kendo-tmpl">
            @(Html.Kendo().PanelBar()
                          .Name("Panel_#:Id#") // this id is from parent grid.
                          .Items(panelbar =>
                          {
                              panelbar.Add().Text("#:MessageName#")
                                  .Expanded(false)
                                  .Content("<pre>" + @Html.Raw(Html.Encode("#:Message#")) + "</pre>");
                          }).ToClientTemplate()
                  )

        </script>

Please help me.

Hi,

I need to call scheduler's navigate function when I click Search button. How can I do that?

I wrote the following code for refreshing the scheduler but it sometimes works and sometimes not.

 Thanks.

I'm trying to figure out how to have one of my fields data validated through my controller on a popup edit via the grid by GridEditMode.Popup.

Here's how my grid is set up:

And here's my template where users can add/edit records that's used by the grid's editable template name:

Ideally, I'd like to be able to validate the SupervisorPic field (basically someone's user ID at my work) by calling a method in my controller to validate the entry against our security system.  Is this possible?

Hello,

Is it possible to combine virtualization and MVVM in a ComboBox?

Because I'm trying to do it and it doesn't work.

If yes can you send me the link to an example, because I've been searching and I didn't find any.

Thank you,

Olido.

Hi, I have been receiving the error  "0x800a138f - JavaScript runtime error: Unable to get property 'show' of undefined or null reference". I've looked over my code and examined my javascript function, but I have been unable to find any errors. Why would the .show error out on me?


My Code looks as follows:

@(Html.Kendo().Notification()
    .Name("#popupNotification")
    .Width("100%")
    .Position(p => p.Pinned(true).Top(30).Right(30))
    .Stacking(NotificationStackingSettings.Down)
    .AutoHideAfter(7000)
    .Templates(t =>
            {
               t.Add().Type("info").ClientTemplateID("popupTemplate");
            })
)

<button id="showNotification" class="k-button">Notification</button><br />

<script id="popupTemplate" type="text/x-kendo-template">
    <div class="">
        <h3>#= title #</h3>
        <p>#= message #</p>
    </div>
</script>

<script>
    $(document).ready(function() {
        var popupNotification = $("#popupNotification").data("kendoNotification");

        $("#showNotification").click(function() {
            popupNotification.show ({
                title: "New Notification",
                message: "Test"
            }, "info");
        });
    });
</script>

I have a Grid with a detail template to show another records related to the main data set. I'm trying to export everyting to excel but when i export it excel says "Excel found unreadable content" if i make the function to return an empty list to the export function the excel file has no problem it shows nothing about details but columns names. but if i return the dataset that i need the message of unreadable content is shown.

i've followed the example http://docs.telerik.com/kendo-ui/aspnet-mvc/helpers/grid/how-to/excel/detail-grid-export  and http://docs.telerik.com/kendo-ui/controls/data-management/grid/how-to/excel/detail-grid-export so the functions are practically the same

var detailExportPromises = [];

        var dataSource = new kendo.data.DataSource({
            type: "aspnetmvc-ajax",
            transport: {
                read: "@Url.Action("Fracciones_Read", "Home")",
                type: "POST"
            },
            schema: {
                data: "Data",
                total: "Total",
                error: "Errors"
            }
        });

        dataSource.read();

        function dataBound() {
            detailExportPromises = [];
            this.expandRow(this.tbody.find("tr.k-master-row").first());
        }
        function parameters() {
            return {
                fechaIni: $("#fechaIni").data("kendoDatePicker").value(),
                fechaFin: $("#fechaFin").data("kendoDatePicker").value(),
                operacion: "Imp"
            }
        }

        function fracciones_excelExport(e) {
            e.preventDefault();
        }

        function excelExport(e) {
            e.preventDefault();

            var workbook = e.workbook;

            detailExportPromises = [];

            var masterData = e.data;

            for (var rowIndex = 0; rowIndex < masterData.length; rowIndex++) {
                exportChildData(masterData[rowIndex].NumeroPedimento, rowIndex);
            }

            // wait for all detail grids to finish exporting
            $.when.apply(null, detailExportPromises)
            .then(function () {
                // get the export results
                var detailExports = $.makeArray(arguments);

                // sort by masterRowIndex
                detailExports.sort(function (a, b) {
                    return a.masterRowIndex - b.masterRowIndex;
                });

                // add an empty column
                workbook.sheets[0].columns.unshift({ width: 30 });

                // prepend an empty cell to each row
                for (var i = 0; i < workbook.sheets[0].rows.length; i++) {
                    workbook.sheets[0].rows[i].cells.unshift({});
                }

                // merge the detail export sheet rows with the master sheet rows
                // loop backwards so the masterRowIndex doesn't need to be updated
                for (var i = detailExports.length - 1; i >= 0; i--) {
                    var masterRowIndex = detailExports[i].masterRowIndex + 1;

                    var sheet = detailExports[i].sheet;

                    // prepend an empty cell to each row
                    for (var ci = 0; ci < sheet.rows.length; ci++) {
                        if (sheet.rows[ci].cells[0].value) {
                            sheet.rows[ci].cells.unshift({});
                        }
                    }

                    // insert the detail sheet rows after the master row
                    [].splice.apply(workbook.sheets[0].rows, [masterRowIndex + 1, 0].concat(sheet.rows));
                }

                // save the workbook
                kendo.saveAs({
                    dataURI: new kendo.ooxml.Workbook(workbook).toDataURL(),
                    fileName: "Importaciones.xlsx"
                });
            });
        }

        function exportChildData(NumeroPedimento, rowIndex) {
            var deferred = $.Deferred();

            detailExportPromises.push(deferred);

            var rows = [{
                cells: [
                    { value: "DescripcionFactura" },
                    { value: "DescripcionPedimento" },
                    { value: "Arancel" }
                ]
            }];

            dataSource.filter({ field: "NumeroPedimento", operator: "eq", value: NumeroPedimento });

            var exporter = new kendo.ExcelExporter({
                columns: [
                    { field: "DescripcionFactura" },
                    { field: "DescripcionPedimento" },
                    { field: "Arancel" }
                ],
                dataSource: dataSource
            });

            exporter.workbook().then(function (book, data) {
                deferred.resolve({
                    masterRowIndex: rowIndex,
                    sheet: book.sheets[0]
                });
            });
        }
    </script>