Telerik Forums
Kendo UI for jQuery Forum
1 answer
129 views

Are locked cells in a imported excel file supported? They don't appear to be.

Also are hidden sheets able to be supported as well?

 

Nikolay
Telerik team
 answered on 28 Feb 2023
1 answer
150 views

The following code works when I have one detail grid expanded. If I have multiple grids expanded, it only executes against the first detail grid. I am having trouble figuring out how to determine which grid is selected and execute the below code against that particular detail grid:


if (count === 0) {
	_.each($('.tst-k-grid').data("kendoGrid")._data, function (e) {
		if (e.Status !== 'E') {
			e.Status = 'W';
		}
	});
} else if (count > 1) {
	_.each($('.tst-k-grid').data("kendoGrid")._data, function (e) {
		if (e.Status !== 'E') {
			e.Status = 'X';
		}
	});
}

Nikolay
Telerik team
 answered on 27 Feb 2023
1 answer
110 views
Dear Kendo team,

I'm having an issue with Rich Text Format, I have a blank page at the beginning and end of the report,
also, the grid of content is not showing in a proper way,

I have tried almost everything in report style but came up with no result, any idea of what can cause this and how I can solve it? 
Todor
Telerik team
 answered on 27 Feb 2023
10 answers
2.0K+ views
In the screenshot you'll see that the Category Axis is at the 0 line and the columns go above and below it. How do I put the Category Azix at the bottom of the chart always?

Html.Kendo().Chart<AccountPerformance>(Model.Results)
    .Name("chartPCT")
    .Title("% Return")
    .Legend(legend => legend.Visible(false))
    .Series(series =>
            series.Column(model => model.Metrics.Return)
                  .Name(Model.ColumnTitle)
                  .Labels(false)
    )
    .ValueAxis(axis => axis.Numeric()
                           .Labels(labels => labels.Format("{0}%")))
    .CategoryAxis(axis => axis
                              .Categories(model => model.Observation)
                              .Labels(labels =>
                                  {
                                      labels.Format("MMM");
                                  }))
    .Render();
Christian
Top achievements
Rank 1
Iron
 updated answer on 24 Feb 2023
0 answers
159 views

I'm trying to filter a spreadsheet, and while it works, it is EXTREMELY slow

And this kind of makes sense - we have ~35k unique values in this SKU column - but clicking to add a filter and then clicking the down arrow takes 20+ seconds before the filter popup appears, during which time the whole screen is frozen

Is there a way to allow a filter by value without including this multi-select, as with the data we have, in its current form, its completely unusable.

Thanks

Kevin
Top achievements
Rank 1
 asked on 24 Feb 2023
1 answer
199 views

Hi,

There are question as below, I could not provide a code snippet because for editing require an API which are not available as development is in progress

  • can I know is there a way to get the response code / response message after the API is call. For example code below, after the create API call I would like to get the response code example 200 or 500 so that we can manipulate error message that require to show for user. Example if kendo taskboard it have "requestEnd" event
transport: {
	read: {
		url: crudServiceBaseUrl ,
		dataType: "json"
	},
	create: {
		url: crudServiceBaseUrl + "/add",
		dataType: "json"
	},
	update: {
		url: crudServiceBaseUrl + "/update",
		dataType: "json"
	},
	destroy: {
		url: crudServiceBaseUrl + "/delete",
		dataType: "json"
	},
	parameterMap: function (options, operation) {
		if (operation !== "read" && options.models) {
			return { models: kendo.stringify(options.models) };
		}
	}
},
  • when I perform  transport "destroy", I realize that it will first remove the node before calling API. I wonder what happen if I fail to remove from our own logic (hit issues when remove from database) then how can we revert the node? 
  • Is it in treelist we can get parent value and assign to a hidden field? Treelist only support number for id and parentid (hierarchy), howeer in our case we use GUID. Therefore, I generate number just for hierarchy display (and drag and drop) purpose. However the models only recognize the parentid but not guid that is from other field.
  • on my page I reliaze that sometimes the jquery are calling the API and sometimes not? Is it related to the placement file of my kendo script versus jquery file?
  • When I add new item, from backend we success to trigger and I return response 200 and model data as per below
{"Project":"e81af126-13cd-40c4-951b-9611fa85f39c","ID":"fc980fda-40c5-4fda-b97d-dfc0aced6a10","Description":"123123","WBSType":1,"SequenceNumber":0,"Parent":null,"BudgetSalesAmountDC":0.0,"BudgetCostsAmountDC":0.0,"Quantity":10.0,"WBSIcon":"","ReportsTo":null,"WBSRunningNumber":0,"hasChildren":false}

however from front-end it will never append. I follow exact implementation from the snippet / tutorial, accept the response type 
Neli
Telerik team
 answered on 23 Feb 2023
1 answer
897 views

Hi ,

I am testing trail version of v2023.1.117 Kendo UI for jquery.  I have upgraded jquery version to the latest . 

I am trying to implement CSP header in the web pages using meta tag.

 <meta http-equiv="Content-Security-Policy" content="default-src 'self' 'sha256-lzhPGNqxpwmBda/ftMrdga7dSTDWPq2rpjz66R6TVFw=' http://localhost:9000/xxxx/js/lib; script-src 'self' 'sha256-lzhPGNqxpwmBda/ftMrdga7dSTDWPq2rpjz66R6TVFw=' http://localhost:9000/xxxx/js/lib;  style-src 'self' 'sha256-lzhPGNqxpwmBda/ftMrdga7dSTDWPq2rpjz66R6TVFw=' http://localhost:9000/xxxx/js/lib;">

I am getting an error , i can't use unsafe tag in the CSP.  Any thought what am i missing.

Refused to apply inline style because it violates the following Content Security Policy directive: "style-src 'self' 'sha256-lzhPGNqxpwmBda/ftMrdga7dSTDWPq2rpjz66R6TVFw=' http://localhost:9000/recon/js/lib". Either the 'unsafe-inline' keyword, a hash ('sha256-g6wc7vdud1aSmTLcpHjWXR0Wfvqff5mhy00lnnvIu5c='), or a nonce ('nonce-...') is required to enable inline execution. Note that hashes do not apply to event handlers, style attributes and javascript: navigations unless the 'unsafe-hashes' keyword is present.

Xt @ kendo.all.js:313050
t.attachTo @ kendo.all.js:313050
t.load @ kendo.all.js:313050
i.draw @ kendo.all.js:313050
draw @ kendo.all.js:313050
_redraw @ kendo.all.js:313050
(anonymous) @ kendo.all.js:313050
Re.loadFonts @ kendo.all.js:313050
Re.preloadFonts @ kendo.all.js:313050
init @ kendo.all.js:313050
_createChart @ kendo.all.js:313050
_initChart @ kendo.all.js:313050
_initDataSource @ kendo.all.js:313050
init @ kendo.all.js:313050
(anonymous) @ kendo.all.js:313050
each @ jquery-3.6.3.min.js:2
each @ jquery-3.6.3.min.js:2
t.fn.<computed> @ kendo.all.js:313050
e @ jquery-3.6.3.min.js:2
t @ jquery-3.6.3.min.js:2

 

Thanks in advance

Nikolay
Telerik team
 answered on 22 Feb 2023
1 answer
129 views

Hi,

in the hierarchical grid, if parent and child both grids have a custom command with same text, and if we click on the custom command on the child it executes the script twice.

 

https://dojo.telerik.com/eTAJIkuw

 

it works if we change the text of one of the custom command, but it wont be always so simple and easy to change the text, so can you suggest me a fix for this?

Nikolay
Telerik team
 answered on 22 Feb 2023
1 answer
155 views

Dear Support

Is it possible to rotate text by 90 degree in spreadsheet ranges. I would like to rotate the text only in some specific ranges. I searched for this solution a lot without success. Any of kendo spreadsheet version does support it? Or is there any other jQuery solution for it?

Thank you!

Best Regards,

Norbert

Martin
Telerik team
 answered on 22 Feb 2023
4 answers
1.4K+ views
Hi,
Please help me out from this issue.
my kendo grid is not showing data over 285 records. i dont know why it is doing that. but i can tell you my code.
i m using kendo grid with asmx web services. JSON is the data type.
i checked my service that it is calculating fine and sending data is also fine. but after send, kendo grid not showing it. if I limit the data to 100 or 200 rows then it shows but over this limit it is showing a blank screen.
I want to show over 10,000 rows and not to use virtual and paging.

CODE SAMPLE :
$("#SearchGrid").kendoGrid({
        height: 820,
        selectable: true,
        groupable: true,
        filterable: true,
        sortable: true,
        columns: [
                    { field: "PartNo", title: "Part", width: "40px" },
                    { field: "NewNo", title: "New No", width: "40px" },
                    { field: "PartDesc", title: "Desc", width: "50px" },
                    { field: "WH_31", title: "31", width: "20px" },
                    { field: "WH_32", title: "32", width: "20px" },
                    { field: "WH_34", title: "34", width: "20px" },
                    { field: "WH_35", title: "35", width: "20px" },
                    { field: "WH_36", title: "36", width: "20px" },
                    {field: "MinRate", title: "Rate", width: "20px" },
                    { field: "Grade", title: "ABC", width: "20px" },
                    { field: "LocationCode", title: "BIN", width: "20px" }
                ],
        dataSource: {
            schema: {
                model: {
                    id: "PartID"
                },
                data: "d"
            },
            transport: {
                read: {
                    url: "abc.asmx/Status",
                    contentType: "application/json; charset=utf-8",
                    type: "POST",
                    dataType: "json"
                },
                parameterMap: function (data, operation) {
                    return JSON.stringify({ PartNo: part, Group: GROUP, Code: info })
                }
            }
        }
    });
}

Please help me out
Ramprasad
Top achievements
Rank 1
Iron
 answered on 22 Feb 2023
Narrow your results
Selected tags
Tags
Grid
General Discussions
Charts
Data Source
Scheduler
DropDownList
TreeView
MVVM
Editor
Window
DatePicker
Spreadsheet
Upload
ListView (Mobile)
ComboBox
TabStrip
MultiSelect
AutoComplete
ListView
Menu
Templates
Gantt
Validation
TreeList
Diagram
NumericTextBox
Splitter
PanelBar
Application
Map
Drag and Drop
ToolTip
Calendar
PivotGrid
ScrollView (Mobile)
Toolbar
TabStrip (Mobile)
Slider
Button (Mobile)
Filter
SPA
Drawing API
Drawer (Mobile)
Globalization
LinearGauge
Sortable
ModalView
Hierarchical Data Source
Button
FileManager
MaskedTextBox
View
Form
NavBar
Notification
Switch (Mobile)
SplitView
ListBox
DropDownTree
PDFViewer
Sparkline
ActionSheet
TileLayout
PopOver (Mobile)
TreeMap
ButtonGroup
ColorPicker
Pager
Styling
MultiColumnComboBox
Chat
DateRangePicker
Dialog
Checkbox
Timeline
Drawer
DateInput
ProgressBar
MediaPlayer
ImageEditor
TextBox
OrgChart
Accessibility
Effects
PivotGridV2
ScrollView
BulletChart
Licensing
QRCode
ResponsivePanel
Switch
Wizard
CheckBoxGroup
TextArea
Barcode
Breadcrumb
Collapsible
Localization
MultiViewCalendar
Touch
RadioButton
Stepper
Card
ExpansionPanel
Rating
RadioGroup
Badge
Captcha
Heatmap
AppBar
Loader
Security
TaskBoard
Popover
DockManager
FloatingActionButton
CircularGauge
ColorGradient
ColorPalette
DropDownButton
TimeDurationPicker
ToggleButton
TimePicker
AICodingAssistant
BottomNavigation
Ripple
SkeletonContainer
Avatar
Circular ProgressBar
FlatColorPicker
SplitButton
Signature
Chip
ChipList
VS Code Extension
AIPrompt
PropertyGrid
Sankey
Chart Wizard
OTP Input
SpeechToTextButton
InlineAIPrompt
StockChart
ContextMenu
DateTimePicker
RadialGauge
ArcGauge
+? more
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?