Hello,

I was wondering if the newer releases of Kendo UI (or RadGrid) support pasting data from Excel to the grid?

I found some older code in these forums (from 2011) that "hand implements" the paste, but I was wondering if there are any native capabilities that have been added to support pasting data to a Kendo grid (as opposed to from a kendo grid to excel). I looked through the new demos, and didn't see anything along those lines. Just wondering if this is a feature or if it's on the roadmap, as it's a highly desirable feature for an editable grid.

I cannot figure out how to hide the splitbar - even if I delete the HTML element, it still shows because of other widths and offsets.

I have googled this for ages and found a few old suggestions (even by kendo people) that don't work anymore.

Could you point out the CSS required to simply hide the splitbar - either by transparency or even setting it to my own color - no matter much I played with the CSS, I could not work this out.

I just started working with the MultiColumnComboBox component, and I immediately noticed that the headers are increasing misaligned with their columns as you move from left to right across the grid.

The demos show a small buffering header over the vertical scrollbar, but that's not present in my implementation.

Is there something I'm missing to have that little buffering header over the scrollbar?

I've included a screenshot of the MultiColumnComboBox grid rendering where you can clearly see the misalignment. The screenshot includes the configuration code, as well.

I have a grid with inline editing, linked to a datasource with a update url like listed below.

How do I catch an error returned by the transport.update ?

Thanks in advance

Regards

Morten

$("#grid").kendoGrid({

dataSource: gridDs,

editable: "inline",

...

var gridDs = new kendo.data.DataSource({

transport: {

    read: { ... }

    update: { 

                    type: "POST",
                    url: '@Url.Action("Update", "Customers")',
                    dataType: "json",
                    contentType: "application/json; charset=utf-8"

      }

Hi

Will Kendo UI Scheduler work within Salesforce LockerService?

LockerService Isolation

LockerService is the primary and preferred isolation mechanism for the Lightning Component Framework. LockerService wraps standard objects like window, document, and element inside a secure version of these objects (SecureWindow, SecureDocument and SecureElement) as a way to control access to APIs and regions of the DOM. When components are loaded, they are provided with the secure wrappers (secureWindow and secureDocument) in lieu of the standard objects (window and document). When a component invokes a method on the document or window object, the secure wrapper can apply appropriate security restrictions. For example, access to the DOM of another component will be:

• Granted if the other component is in the same namespace
• Denied if the other component is in a different namespace

In addition to providing a sophisticated namespace-based access control mechanism, LockerService enforces a series of rules to further avoid security exploits:

• JavaScript ES5 strict mode is automatically enabled. Libraries that do not support strict mode will not work with LockerService.
• Content Security Policy (CSP). unsafe-eval and unsafe-inline are disallowed. Libraries using eval() or inline JavaScript code execution will not work with LockerService.

The rules enforced by LockerService are recognized as industry best practices. However some libraries may not yet work with these restrictions enabled. In that case, we recommend you ask the library author to support strict mode and CSP. In the meantime, you can use the alternative Lightning Container Component isolation described below.

LockerService Advantages

• No iframe. Components live in the same DOM (better performance)
• Straightforward, natural communication between components
• Cohesive UI
• Eliminates DOM scraping vulnerabilities
• Mitigates the impact of developer mistakes such as the lack of proper escaping
• Cross-site scripting (XSS) and template injection are no longer possible
• Eliminate server-side action invocation/spoofing

LockerService Limitations

•  Non-compliant libraries will not work with LockerService

https://developer.salesforce.com/blogs/developer-relations/2017/02/lockerservice-lightning-container-third-party-libraries-lightning-components.html

     Hi, I have a problem with kendo UI grid, the export as PDF works very well, but the export as Excel doesn't work. My code is the following :

@(Html.Kendo().Grid<PRR405Data.Models.MPremiumTransaction>
(Model.Transactions)
.Name("TransactionsDossierPrime")
//.ToolBar(tools => tools.Pdf())
.ToolBar(tools => tools.Template("<a class='k-button k-button-icontext' onclick='exportToPDF()'>" + PRR405.Resources.ConsultationHistorique.ConsultationHistorique.TelechargerPDF + "</a><a class='k-button k-button-icontext' onclick='exportToCSV()'>" + PRR405.Resources.ConsultationHistorique.ConsultationHistorique.TelechargerCSV + "</a>"))
.Pdf(pdf => pdf
.AllPages()
.AvoidLinks()
//.PaperSize("A4")
.Scale(0.8)
//.Margin("2cm", "1cm", "1cm", "1cm")
//.Landscape()
//.RepeatHeaders()
//.TemplateId("page-template")
//.FileName("Kendo UI Grid Export.pdf")
//.ProxyURL(Url.Action("Pdf_Export_Save", "Grid"))
)
.Columns(columns =>
{
columns.Bound(p => p.ENTR_NUM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.NoInscriptionHeader).Width(240).ClientGroupFooterTemplate(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.TotalTransactionsAcceptees);
columns.Bound(p => p.BR_CD).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.SuccursaleHeader).Width(90);
columns.Bound(p => p.AGNCY_CD).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.CodeAgenceHeader).Width(80);
columns.Bound(p => p.OCCSN_DR).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.ConducteurLabel).Width(80);
columns.Bound(p => p.TXN_CD).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.CodeTransactionHeader).Width(100);
columns.Bound(p => p.PLCY_TYPE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.IndicateurDeDureeHeader).Width(80);
columns.Bound(p => p.INSUR_NAME).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.NomHeader).Width(250);
columns.Bound(p => p.NIV).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.NIVHeader).Width(180);
columns.Bound(p => p.XFER_DATE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.DebutTransactionHeader).Width(100);
columns.Bound(p => p.EXPIR_DATE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.FinTransactionHeader).Width(100);
columns.Bound(p => p.BUS_TYPE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.GenreAffaireHeader).Width(70);
columns.Bound(p => p.USE_TYPE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.GenreDUtilisationHeader).Width(90);
columns.Bound(p => p.TERR).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.ZoneStatistiqueHeader).Width(90);
columns.Bound(p => p.DRIV_AGE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.AgeHeader).Width(60);
columns.Bound(p => p.DRIVING_RC).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.DossierCondRCHeader).Width(80);
columns.Bound(p => p.DRIVING_CL).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.DossierCondCLTRHeader).Width(80);
columns.Bound(p => p.RCLIMI_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.RCLimiteHeader).Width(80);
columns.Bound(p => p.RCPREM_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.RCPrimeHeader).Width(70).ClientGroupFooterTemplate("#=sum#");
columns.Bound(p => p.RCCANCL_C).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.RCAnnulHeader).Width(60);
columns.Bound(p => p.TRLIMI_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.TRFranchHeader).Width(80);
columns.Bound(p => p.TRPREM_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.TRPrimeHeader).Width(70).ClientGroupFooterTemplate("#=sum#");
columns.Bound(p => p.TRCANCL_C).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.TRAnnulHeader).Width(60);
columns.Bound(p => p.CLLIMI_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.CLFranchHeader).Width(80);
columns.Bound(p => p.CLPREM_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.CLPrimeHeader).Width(70).ClientGroupFooterTemplate("#=sum#");
columns.Bound(p => p.CLCANCL_C).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.CLAnnulHeader).Width(60);
columns.Bound(p => p.ADLIMI_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.ADFranchHeader).Width(80);
columns.Bound(p => p.ADPREM_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.ADPrimeHeader).Width(70).ClientGroupFooterTemplate("#=sum#");
columns.Bound(p => p.ADCANCL_C).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.ADAnnulHeader).Width(60);
columns.Bound(p => p.RSLIMI_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.RSFranchHeader).Width(80);
columns.Bound(p => p.RSPREM_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.RSPrimeHeader).Width(70).ClientGroupFooterTemplate("#=sum#");
columns.Bound(p => p.RSCANCL_C).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.RSAnnulHeader).Width(60);
columns.Bound(p => p.FMLIMI_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.FMLimiteHeader).Width(80);
columns.Bound(p => p.FMPREM_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.FMPrimeHeader).Width(70).ClientGroupFooterTemplate("#=sum#");
columns.Bound(p => p.FMCANCL_C).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.FMAnnulHeader).Width(60);
columns.Bound(p => p.ITLIMI_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.ITLimiteHeader).Width(60);
columns.Bound(p => p.ITPREM_AM).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.ITPrimeHeader).Width(70).ClientGroupFooterTemplate("#=sum#");
columns.Bound(p => p.ITCANCL_C).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.ITAnnulHeader).Width(60);
columns.Bound(p => p.TOT_PRE_A).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.PrimeTotaleHeader).Width(60).ClientGroupFooterTemplate("#=sum#");
columns.Bound(p => p.TARIF_STD).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.TarifStandardHeader).Width(80);
columns.Bound(p => p.BTCH_CD).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.CodeLotHeader).Width(80);
columns.Bound(p => p.BATCH_TYPE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.TypeLotHeader).Width(80);
columns.Bound(p => p.POST_DATE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.DateTransmissionHeader).Format("{0: yyyy-MM-dd}").Width(100);
columns.Bound(p => p.CYCLE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.ReleveHeader).Width(70);
columns.Bound(p => p.CYCLE_DATE).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.DateReleveHeader).Format("{0: yyyy-MM-dd}").Width(100);
columns.Bound(p => p.REJECT).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.CodeRejetHeader).Width(140);
columns.Bound(p => p.WARNINGS).Title(PRR405.Resources.ConsultationHistorique.ConsultationHistorique.AvertissementHeader).Width(300);

})
.Scrollable(s => s.Height("300px"))
.HtmlAttributes(new { style = "margin-bottom:20px;" })
.Sortable()
.Scrollable()
.Events(e => e.DataBound("rejectColor"))
//.Filterable()
.Resizable(resize => resize.Columns(true))
.DataSource(dataSource => dataSource
.Ajax()
.Aggregates(aggregates =>
{
aggregates.Add(p => p.RCPREM_AM).Sum();
aggregates.Add(p => p.TRPREM_AM).Sum();
aggregates.Add(p => p.CLPREM_AM).Sum();
aggregates.Add(p => p.ADPREM_AM).Sum();
aggregates.Add(p => p.RSPREM_AM).Sum();
aggregates.Add(p => p.FMPREM_AM).Sum();
aggregates.Add(p => p.ITPREM_AM).Sum();
aggregates.Add(p => p.TOT_PRE_A).Sum();
})
.Group(groups => groups.Add(p => p.NIV))
.Group(groups => groups.Add(p => p.OCCSN_DR))
.Read(read => read.Action("Aggregates_Read", "Grid"))
//.Sort(s => s.Add("NuméroSéquence").Descending())
//.Read(read => read.Action("LotsOuvert_Read", "Grid"))
//.Events(e => e.Error("onError"))
))

When the user clicks on the PDF/Excel button, these methods are fired :

// For PDF

function exportToPDF() {
$("#TransactionsDossierPrime").data("kendoGrid").saveAsPDF();
}

// For excel

function exportToCSV() {
        $("#TransactionsDossierPrime").data("kendoGrid").saveAsExcel();
}

The method exportToCSV generated an 404 error : "Failed to load resource : the server responded with a status of 404 (Not found)

It seems that te grid doesn't detect that the data are being rendered localy

Thank you for your help

Hi

I'm using a donut chart with legend in the bottom that can have multiple and variable amount of values. More values make my chart smaller and does not look good at all. Is there any way I can add a scroll in the legend? Or if you have any other option that I can use to be able to see the chart in a fix size and the legend in a fix container will be great

Here is a pic of how it looks now.

Thank you in advance

     Hi,

I have a situation where I am setting the dataSource of a dropdowntree after defining it (using the setDropDown method). Howerver, I can't seem to be able to clear values from the dropdowntree in this scenario.

I tried to replicate the problem best I could in this dojo: https://dojo.telerik.com/iKoBOVIk/3

Upon selecting item 1 and item 2, if I click the button I want the selected values to be cleared. How can I achieve this?

Thanks.

Hi Telerik,

Tooltip not showing if we put chart inside HTML5 fullscreen.

You may refer here for your reference.