
By default the Kendo Spreadsheet selects cell A1 when the spreadsheet is loaded. I'd like to change this behavior so that there is no default selection. If a user clicks on the sheet then I want the selection functionality to behave normally.
I don't see any unselect or deselect options. Is this possible with the Spreadsheet object? If not, is there any sort of workaround to temporarily remove the selection box and column/row highlights?

Hi Telerik,
Can you advice on how to hide message showed when drag and drop to root? You may refer attached picture for your reference.
Thank you,
Afandi Sha'ari

Hi,
We have a big Gantt that has data until October. When in week view the pdf export chops off everything after September (both when expanded and collapsed). See:
https://dojo.telerik.com/@mattpil29/iFUlIFuP
Note month and year views are ok.
Is this an inbuilt limitation or is there something I can do. These big PDF will go to a plotter for a wall display!
Thanks, Matt

Hi,
Our Gantt displays the results of a fairly complex calculation which is stored in a db. Using the GanttDataSource and GanttDependencyDataSource we can load the results in a nice AJAX experience - the 2 separate api calls get the data from the DB. However I now need to allow our calculation to be previewed without saving to the DB. This makes having 2 api calls a pain. It would be much easier if the calculation just returned one joint JSON response for read only viewing in the Gantt.
I guess I could emit the data as a string embedded in the page source before its sent to the client. Is there another way?
Thanks, Matt
Hi,
The Bar Chart on the left has glowing effect, but the Right-Bar Chart is flat (not shining).
We would like to having blow Bar Chart having glowing effect.
How can we enforce the Bar Chart glowing (3D more sharp & smart), thank you?
Regards,
Davis
Hi,
Is it possible to make the Bar Chart Label Top Align, thank you ? (v2018.1.221)
Regards,
Davis
Hello,
I've got a grid with a client template set but everytime I click to expand the details row, the details collapse immediately. I don't know what is causing it. Here's my grid implemention.
@(Html.Kendo().Grid<AWP.UI.ViewModel.UIdto.Manufacturer>()
.Name("Manufacturers")
.Columns(columns =>
{
columns.Command(command =>
{
command.Edit();
});
columns.Bound(c => c.RecordState).Title("Active").ClientTemplate("<input type='checkbox' #= RecordState ? checked='checked' :'' # disabled />");
columns.Bound(c => c.DisplayValue).Title("Display Value");
columns.Bound(c => c.DisplayCode).Title("Display Code");
columns.Bound(c => c.DisplayOrder).Title("Display Order");
columns.Bound(c => c.InterfaceCode).Title("Interface Code");
columns.Template(c => null).ClientTemplate("#if(RecordState==0){#<button class='k-button k-button-icontext' onClick='Activate(\"#=ManufacturerId#\")'>Activate</button>#}else{#<button class='k-button k-button-icontext' onClick='Deactivate(\"#=ManufacturerId#\")'>Deactivate</button>#}#");
})
.ToolBar(toolbar =>
{
toolbar.Template(@<text>
<div class="toolbar">
<div class="row">
<div class="col-md-4">
<div class="input-group">
<input type="text" class="form-control k-textbox" id='FieldFilter' placeholder="Search for...">
</div>
</div>
</div>
</div>
</text>);
})
.ClientDetailTemplateId("mytemplate")
.AutoBind(true)
.Scrollable()
.Resizable(resizing => resizing.Columns(true))
.Sortable(sorting => sorting.Enabled(true))
.Reorderable(reorder => reorder.Columns(true))
.Editable(editable => editable.Mode(GridEditMode.InLine))
.Pageable(pageable => pageable
.Input(true)
.Numeric(false)
)
.DataSource(dataSource => dataSource
.Ajax()
.Model(model =>
{
model.Id(p => p.ManufacturerId);
model.Field(p => p.ManufacturerId).Editable(false);
model.Field(p => p.RecordState).Editable(false);
})
.PageSize(20)
.Read("Read", "Manufacturer")
.Update("Update", "Manufacturer")
)
.Events(events => events
.DetailInit("detailExpand")
)
)
My template is simple:
<script id="mytemplate" type="text/x-kendo-template">
<div>
This is my details view #: DisplayValue #
</div>
</script>
My detailExpand method only contains a debugger. I can catch the expansion only when debugging. Without debugging, the expansion is invisible. I've tried programmatically expanding the row but the row always collapses after i call expandRow().
var grid = $("#Manufacturers").data("kendoGrid");
expandedRowUid = e.masterRow.data('uid');
grid.expandRow($('tr[data-uid=' + expandedRowUid + ']'));
Why is this happening?
Hello,
I am using a TreeList to allow users to configure a Question and Answer tree. The user needs to be able to add a question row, then a list of potential answers (these are multiple choice questions) and then under each answer add a follow up question that should be asked in the event that that answer is selected.
Ideally, when a user creates a new question row, he would be presented with 3 or 4 editable rows - the top one intended to be the text of the question and then the additional rows to supply the answer choices for that question so that he can add questions AND answers with just one operation. So my first question is whether this is possible at all in TreeList (my attempts to call addRow() multiple times have not been successful).
If giving the user multiple editable rows all at once is not an option, then the second-best thing would be to automatically create some "default" answers in the database (I am using a remote datasource with this TreeList) and then upon the Create operation completing, show the new question they've added to the list as well as the two default answer rows below it. I have attempted this as well - when the transport Create operation is called, 3 new records are created in the database (the latter two records having a "parent" value of the ID of the first one), and I am returning JSON containing all 3 rows. The new question row then shows on the TreeList, but the new answers do not get added. I can collapse and re-expand the tree, but they still do not show up until I refresh the page and the TreeList loads from scratch again. So my second question is is it possible to have one transport create operation add multiple rows to the tree and have them be displayed immediately upon completion of the operation.
Thank you.
Hello,
I'm building a dynamic grid (Datasource Model,Columns are built as js objects),my issue is :
I've a column bound to a numeric field and displayed as a checkbox using as per the following code
fields["Fields[" + f + "].Value"] = { type: "number", editable: false, defaultValue: 0 };<br>Columns[i] = { field: "Fields[" + f + "].Value", title: gridModel.Fields[f].FieldName, template: "<input id='checkbox" + f + "' type='checkbox' #=(Fields[" + f + "].Value > 0 ) ? checked='checked' :'' # #=(Fields[" + f + "].ReadOnly > 0 ) ? disabled='disabled' :'' # class='chkbx' />", width: w, editable: false, attributes: { style: "text-align:center;" }, headerAttributes: { style: "text-align:center;", title: gridModel.Fields[f].Details }, footerAttributes: { style: "text-align:center;" }, aggregates: fAggregate, footerTemplate: footerTemplate, groupFooterTemplate: grpFooterTemplateFn };
It performs just fine, the problem takes place when i do datasource filtering, the field value is assumed to be a string and therefore an internal javascript exception occurs in the part below
(function anonymous(d, __f, __o) {return (((d.Fields[1].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[2].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[3].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[4].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[5].FieldText || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[7].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[8].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[9].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[10].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[11].FieldText || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[12].FieldText || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[13].FieldText || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[18].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[19].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[20].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[21].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[22].FieldText || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[23].FieldText || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[24].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[26].FieldText || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[27].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[28].FieldText || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[29].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[30].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[31].Value || '').toLowerCase().indexOf("mads") >= 0 || (d.Fields[32].Value || '').toLowerCase().indexOf("mads") >= 0))})
if i remove the template from the column definition (it displays 0 and 1) no exception happens, any suggestions
Regards,
MOTASH