Questions on Kendo UI for jQuery Forum

2 answers

169 views

I'm implementing the grid using Angular, and I'm a little hazy how to do a few things. I've posted several question on Stack Overflow but they are not getting responses.

Some things I"m trying to solve:

Row customization: I want to add a class to the row, based on a value of the row (eg. itemIsHealthy=false show color the row red). I know I can completely write the row template, but that seem overkill. Also, how do I then include all my coulmns, with their widths and custom templates, etc.?
I want to have a row-click action. (click on row to open nested detail, or click on row to go to edit page)

Select / Select All / Save: I want to POST a list of slected rows (by Id). Where is the array of my items? Best as I can figure, I have to call vm.myGrid.dataSource.options.data(). This gets me an array of init objects, which contains my actual item data. There's got to be a better way.

Grid

answered on 22 Aug 2016

1 answer

279 views

Grid Validation

When there is a required column, and the option of the update of the Grid is set to batch, the user gets stuck when he tries to edit a required cell. He needs to be able to cancel the edit without entering a value, and gets validated only on Save.

How can we do this?

Grid

answered on 22 Aug 2016

1 answer

1.1K+ views

keydown event

http://dojo.telerik.com/awIja/3

My keydown event does not work when navigatable is set to false.Can i get a solution for this.

Grid

answered on 22 Aug 2016

1 answer

1.0K+ views

Create unique name for grid in template

Hi,
I need to create unique grid name inside template, i try with javascript, but it doesn't work.

<script id="conditionGroupTemplate" type="text/x-kendo-template">

@(Html.Kendo().Grid<Rule.ConditionViewModel>()

.Name("entryGroupConditions" + //here i need to call getGUID()//)

.Columns(columns =>

{

columns.Bound(o => o.Text);

columns.Command(command =>

{

command.Destroy();

}).Width(110);

})

.ToolBar(toolbar =>

{

toolbar.Template("<div class='toolbar'><a class='k-button k-button-icontext pull-left' onClick='AddGroup(\"\\#entryGroupConditions\", \"Skupina podmínek\")'><span class='k-icon k-add'></span>Přidat skupinu</a><h3>AND</h3></div>");

})

.ClientDetailTemplateId("conditionTemplate")

.AutoBind(false)

.DataSource(ds => ds

.Ajax()

.Model(m => m.Id(o => o.Path))

.Destroy(del => del.Action("DeleteAttribute", "Rule"))

)

.Resizable(resize => resize.Columns(true))

.ToClientTemplate()

)

</script>

function getGUID(){

return (salt() + salt() + "-" + salt() + "-4" + salt().substr(0,3) + "-" + salt() + "-" + salt() + salt() + salt()).toLowerCase();

}

function salt(){

return (((1+Math.random())*0x10000)|0).toString(16).substring(1);

}

Any help?
thanks

Templates

answered on 22 Aug 2016

1 answer

157 views

Changing View on Safari changes date/month

I'm seeing some unexpected behaviour on the Scheduler running in Safari (on Mac OSX and iOS). If I have the initially selected view set to "month" and selectable: true, when I change the view the date/range displayed in the header is set to the beginning of the displayed month range. For example, with today being August 15, 2016, when I change the view to "day", the calendar displays July 31 instead of August 15. Similarly, if I switch from "month" to "week", the displayed week is "July 31 - August 6. If I don't have selectable set to true, I see the expected behaviour (i.e. display the current day/week). If I just select the Month option (i.e. no switch necessary) the displayed month changes to July.

I can reproduce this behaviour using the default demo (see, for example, http://dojo.telerik.com/@mrosvick/uBIKa/2). I don't see this behaviour on other browsers/platforms. Why is this occurring?

Scheduler

answered on 22 Aug 2016

1 answer

1.1K+ views

Disable / enable save button on add / update ?

I have a edit popup dialog in a grid which will save a project into a project table.

This operation can be lengthy, because some tables are copied in the same operation. Maybe 10 seconds..

The problem now is when i click the save button, nothing happens in the gui for 10 seconds. Then the dialog closes.

If the user clicks the button right after it has been clicked two events will trigger, resulting in a error.

So how can i disable the save button / display a spinner in the save button while the add / update operation is ongoing ?

And when the operation is done, enable the button and remove the spinner ?

If the execution fails then i want to enable the button and let the user try again..

Anyone ?

Grid

answered on 22 Aug 2016

3 answers

452 views

Include Current Item in Server Side Filter

I got a problem with the Kendo UI MVC DropDownList. I want to do server side filtering. When I click on the control, the list gets populated. This works fine if the current selected item is in the populated list.

But what if I have an address book and the current selected name is "Zorro". I have thousands of names before and when I click on the list, only the first 10 names starting with "A" are shown.

How do I include the currently selected item in the DataSource, so it remains selected if I click on the dropdownlist?

Here is my code:

Razor:

@(Html.Kendo().DropDownListFor(m => m.Id)

.DataValueField("Id")

.DataTextField("DisplayName")

.Filter("contains")

.DataSource(source =>

{

source.Read(read =>

{

read.Action("PopulateNames", "PhoneBook");

read.Type(HttpVerbs.Post);

})

.ServerFiltering(true);

})

)

Controller:

[HttpPost]

public ActionResult PopulateNames(string text)

{

var q = TblName.Query(n => n.ClientId.IsEqualTo(Manager.One.ClientId), n => n.DisplayName.Asc());

if (text != null && text.Length > 2) q.Filter(n => n.c.DisplayName.IsLike(text));

q.Top(10);

var rows = q.FetchList<NameLookupViewModel>();

rows.Insert(0, NameLookupViewModel.Default);

return Json(rows);

}

DropDownList

answered on 22 Aug 2016

1 answer

235 views

[Solved] Spreadsheet ToJSON breaks external references

All of our spreadsheets contain external references. That is, cells that retrieve values from other worksheets in the same workbook using formulae similar to =SomeOtherWorksheet!B13.

Our application workflow is pretty basic. We load a customer spreadsheet into the client-side kendoSpreadsheet control using the native "Load" button in the toolbar. We then save a representation of that workbook (from the toJSON() method) back to the server.

Later on, in server-side code, we Load() that json string into a Telerik.Web.Spreadsheet.Workbook and convert it to a Telerik.Windows.Documents.Spreadsheet.Model.Workbook. We then retrieve the value of certain cells with CellSelection.GetValue();

Unfortunately, when a cell formula refers to a cell on another worksheet, it fails. To be precise, cell.GetValue().Value.GetResultValueAsString(new CellValueFormat("")) comes back as "#REF!"

This only happens after the spreadsheet has been serialised/deserialised via JSON. If we load the exact same spreadsheet via
new XlsxFormatProvider().Import(myExcelFileStream)
then those external references work just fine.

Am I doing something wrong? I could not find anything in this forum or User Voice that relate to this bug. Is there a workaround?

Spreadsheet

answered on 22 Aug 2016

2 answers

123 views

Kendo Grid Keyboard Navigation for Frozen Columns

Hi,

I've a kendo grid with Navigatable option, and the grid navigation is working fine when I press Tab. But when I make some columns in grid as locked (frozen columns), the grid navigation is not working as expected. The navigation is working for only frozen columns and then for unfrozen columns.

Can you please provide me with sample solution if possible, because I'm a beginner with Kendo UI.

Thanks in Advance.

Grid

answered on 19 Aug 2016

6 answers

428 views

[Solved] Alter Uri sended from kendo grid to server for filtering (odata v4)

We have following model which are bind to kendo grid with web api 2.2 and Odata v4.0

public class Order

{

public int Id {get;set;}

public ICollection<User> ApprovedByUsers {get;set;}

}

public class User

{

public string Name {get;set;}

public string Company {get;set; }

}

For ApprovedByUsers property we use custom template to display data in grid column in format:

Name1 (company1)
Name 2 (Company2)

All columns have filterable row for filtering it.

When user input some text in filter column kendo grid generate folowing request:

GET /odata/documents?%24top=20&%24filter=contains(ApprovedByUsers%2C%27WMS%27)&%24count=true&myDocumentsOnly=true

which throws following errors:

The argument for an invocation of a function with name 'tolower' is not a single value. All arguments for this function must be single values.

We need to alter this request so that following request has to be send:

odata/documents?%24filter=AssignedUsers/any(d:d/CompanyNameExternalUser eq 'WMS')&%24count=true&myDocumentsOnly=false

We are using kendo controls version: 2014.3.1411

How we can do it?

Grid

answered on 19 Aug 2016