Questions on Kendo UI for jQuery Forum

0 answers

92 views

Kendo spreadsheet keyboard navigation not working for last column

Kendo spreadsheet keyboard navigation using arrow keys not working properly for the last column. please refer below .

Accessibility

Spreadsheet

updated question on 18 Sep 2023

0 answers

167 views

PivotGrid Custom measures for subtotal

Hi

I need create one measure for total sales amount Proportion by product category. For Example:

column measure

Productcate , Productname salesamount amount%

A, A1 100, 58%

A, A2 50 29%

A, A3 20 11%

A subtotal 170 73%

B, B1 50 83%

B, B2 10 17%

b subtotal 60 27%

Total 230 100%

How to design this code function?

Thanks.

James

PivotGrid

asked on 14 Sep 2023

0 answers

87 views

Filter suggestions / questions

3 - have ability to make filter simpler(UI, remove group option)

the scenario - I want to have the filter be above the grid & be able to apply the filtering on the server to limit the result set, but at the same time, when the result set is limited give the user the ability to filter the grid on the client using grid row filter

Filter

Grid

updated question on 14 Sep 2023

0 answers

79 views

Filter -> cant load state when datasource was not set

https://dojo.telerik.com/oKoXUJOy

Filter

asked on 14 Sep 2023

1 answer

134 views

Kendo Grid dynamic columns Endless scrolling implementation ASP.NET

I am trying to bind it with dynamic columns SQL table paging. The issue is on the second scroll/page it failed the method.

Razor Page

@model System.Data.DataTable
@(Html.Kendo().Grid<dynamic>()
    .Name("Grid")
    .Sortable()
    .Scrollable(sc => sc.Endless(true))
    .Filterable()
    .Groupable()
        .DataSource(dataSource => dataSource
            .Ajax()
            .PageSize(100)
            .Model(model =>
            {
                var id = "Id";
                model.Id(id);
            })
            .Read(read => read.Action("Data_Read", "DynamicColumn"))
        )
)

Controller DynamicColumn

 public IActionResult Data_Read([DataSourceRequest] DataSourceRequest request)
 {
     var dt = GetViewsData(request.PageSize, request.Page);
     var data = dt.ToDataSourceResult(request);
     var viewData = new DataSourceResult()
     {
         Data = data.Data, //this return NULL on the second page/scroll request
         Total = 181480 //total rows of table, just make it static
     };
     return Json(viewData);
 }

public DataTable GetViewsData(int pageSize, int page)
    {

        try
        {
            int offSet = (page - 1) * 100;
            string connString = "Server=.; Database=TheVault_VMC; Trusted_Connection=true; MultipleActiveResultSets=True; Encrypt=False;";
            SqlConnection con = new SqlConnection(connString);
            con.Open();
            SqlCommand cmd = new SqlCommand("sp_GetData", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@OFFSetRows", offSet);
            cmd.Parameters.AddWithValue("@PageSize", pageSize);
            SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
            var dataTable = new DataTable();

            dataAdapter.Fill(dataTable);
            dataAdapter.FillSchema(dataTable, SchemaType.Mapped);
            con.Close();
            return dataTable;

        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

}

SQL Server Procedure

CREATE PROCEDURE [dbo].[sp_GetData] 
   @OFFSetRows INT,
   @PageSize INT
As
BEGIN    
SELECT Id, [Column1], [Column2], [Column3],[Column4],[Column5],[Column6]
FROM
[StagingDetail]
ORDER BY Id
OFFSET @OFFSetRows ROWS
FETCH NEXT @PageSize ROWS ONLY
END

The issue is the function ToDataSourceResult() returns NULL Data on the second request

Data Source

Grid

answered on 13 Sep 2023

1 answer

348 views

DatePicker - set default month for popup

Hello,

How do I set default month to popup calendar when user opens popup and no date is selected? Now calendar is opened to current month.

Thanks.
Mikko

Date/Time Pickers

answered on 11 Sep 2023

1 answer

107 views

For initDetails: Is there a way to increase the indentation of the child table.

Was wondering if there was a way to increase the indentation of the child grid when using the initDetails option?

I have this:

Want something like:

Is there any way of accieving this?

Thanks!

George

Grid

answered on 08 Sep 2023

0 answers

135 views

Kendo ui jQuery custom download question

Hi team,

I often use the kendo custom download facility, works good usualy.

Now I have a problem with grid column grouping that seems broken due to the missing of chiplist component. (R2023.1.425).

But when you select all grid options in custom download, it does not select automatically the ChipList component. Please advise...

Another question please: what is the "DateInputCommon" entry. Should it be selected when taking any other date thing like "DatePicker" ?

Best regards,

Laurent.

Date/Time Pickers

General Discussions

Grid

asked on 08 Sep 2023

0 answers

123 views

Scheduler Restriction Problem

Hi

I have tested the demo Scheduler Restriction and find its not giving accurate result when we manipulate date and time. I have added event with daily repeat occurrence (PFA the same 1.png) and open another event window with different date and time and change it manually with different date but same time whose already added (PFA the same 2.png) , hit save then its added successfully. (PFA the same 3.png) which is wrong according to this behaviour. its works fine when we open popup window on same date but only change time manually, problem is with changing date and time both to different ones. Hope you understand this. please resolve this asap.

Regards

Pankaj

Scheduler

updated question on 07 Sep 2023

1 answer

307 views

MVC Grid helper omits HtmlAttributes classes or k-table-td

I am using the MVC helpers from telerik.ui.for.aspnetmvc.2023.2.829.commercial. When I do

            @(Html.Kendo().Grid(Model.ServerColumnValues)
                .Name("NoKTableTd")
                .Selectable(select => select.Enabled(true).Type(GridSelectionType.Cell))
                .DataSource(dataSource => dataSource
                  .Server()
                  .Model(model => model.Id(p => p.Value1))
                )
                .Columns(columns =>
                {
                    columns.Bound(c => c.Value1).Width("200px").HtmlAttributes(new { Class = "ct" });
                    columns.Bound(c => c.Text).Width("200px").HtmlAttributes(new { Class = "rt" });
                })
                .Scrollable(scrolling => scrolling.Virtual(false).Enabled(true))
                .Sortable()
                .Pageable(paging => paging.Enabled(true)
                    .PageSizes(false)
                    .Input(false)
                    .Info(true)
                    .Numeric(false)
                    .PreviousNext(false)
                    .Messages(m => m.Display("Total Records: {2}")))
                .Groupable(grouping => grouping.Enabled(false))
                .Resizable(resize => resize.Columns(false))
            )

the grid cells are rendered without a k-table-td class:

<tr class="k-table-row k-alt k-table-alt-row k-master-row" role="row">
    <td class="ct" role="gridcell">1</td>
    <td class="rt" role="gridcell">These grid cells do not have a k-table-td class</td>
</tr>

When I do

            @(Html.Kendo().Grid(Model.AjaxColumnValues)
                .Name("NoHtmlAttributesClass")
                .Selectable(select => select.Enabled(true).Type(GridSelectionType.Cell))
                .DataSource(dataSource => dataSource
                  .Ajax()
                  .PageSize(250)
                  .ServerOperation(false)
                  .Read(read => read.Action("_IndexData", "Home", null))
                )
                .Columns(columns =>
                {
                    columns.Bound(c => c.Value1).Width("200px").HtmlAttributes(new { Class = "ct" });
                    columns.Bound(c => c.Text).Width("200px").HtmlAttributes(new { Class = "rt" });
                })
                .Scrollable(scrolling => scrolling.Virtual(false).Enabled(true))
                .Sortable()
                .Pageable(paging => paging.Enabled(true)
                    .PageSizes(false)
                    .Input(false)
                    .Info(true)
                    .Numeric(false)
                    .PreviousNext(false)
                    .Messages(m => m.Display("Total Records: {2}")))
                .Groupable(grouping => grouping.Enabled(false))
                .Resizable(resize => resize.Columns(false))
            )

the grid cells are rendered without the classes specified in their HtmlAttributes:

<tr class="k-table-row k-master-row" data-uid="fe1fd9d6-7894-4421-b257-80c6732bd2f0" role="row">
    <td class="k-table-td" role="gridcell">0</td>
    <td class="k-table-td" role="gridcell">These grid cells do not have their HtmlAttributes class</td>
</tr>

This case seems related to

        function decorateCellWithClass(html) {
            var element = html;
            var classes = element.match(/class=["][^"]+/g);
            if (classes) {
                var cssClasses = classes[0].split('\"').pop();
                element = element.replace(cssClasses, cssClasses + " k-table-td");
            } else {
                element = element.replace("<td","<td class='k-table-td'");
            }

            return element;
        }

where the incoming html is

"<td Class=\"ct\">"

and so the regex doesn't match. I've attached an example program which demonstrates both issues. I can certainly open this up as a support ticket if that is desired.

Grid

answered on 04 Sep 2023