Telerik Forums
Kendo UI for jQuery Forum
1 answer
170 views

When I tried to export excel, the data format changed.

For example, the data that is seen in the browser looks like this: 01:01:30 

However, checking the excel after export, the time shows like this: 3690, which is seconds.

How can I get the same format in the browser and in excel?

Thanks.

{
			field: "cn_busy_grp",
			title: "통화시간",
			columns :[{
				field: "ts_busy_times",
				title: "총통화시간",
				template: '#=convertSecondsToString(ts_busy_times, "hms")#',
				footerTemplate: '#=convertSecondsToString(sum, "hms")#',
				groupFooterTemplate: '#=convertSecondsToString(sum, "hms")#',
				width: "80px"
			},


Nikolay
Telerik team
 answered on 29 Sep 2022
0 answers
131 views

I am trying to select any step and when selecting it load information in a grid, but with the select event it only works in the step before or after the active one.

 var stepper = $("#stepper").kendoStepper({
                steps: Objson,
                select: function(e) {
                    console.log("i found");
                    e.preventDefault();}              }).getKendoStepper();
Oscar
Top achievements
Rank 1
 asked on 28 Sep 2022
1 answer
272 views

Hi,

I'm tryign to dynamically change the tagMode of a kendo.ui.DropDownTree as a user selects more or less items but the control does not refresh/rerender

 

Below is a sample of the code I have tried...

 var ddt = $(id).data('kendoDropDownTree');
        var maxSelectedItemsDisplayedInSingleTagMode = 3;
        let selectedValues = ddt.value();
        let currentTagMode = ddt.options.tagMode;
        let newTagMode = currentTagMode;

        newTagMode = selectedValues.length <= maxSelectedItemsDisplayedInSingleTagMode ? "multiple" : "single";
        if (newTagMode != currentTagMode) {
            ddt.value([])
            ddt.setOptions({
                tagMode: newTagMode
            });
            ddt.value(selectedValues);
        }

Something similar does work for the kendo.ui.MultiSelect but I cannot get it to play ball for kendo.ui.DropDownTree

 

Thanks

Neli
Telerik team
 answered on 28 Sep 2022
1 answer
623 views

I get content as HTML encoded and would like to render this content as HTML in a grid row column using a template.

template: window.kendo.template($("#title").html())

<script id="title" type="text/x-kendo-template">
  <strong>#:title#</strong>
  <div>#:content#</div>
</script>

Have tried many (all) combinations of #:content#, #=content#, encoded: false, kendo.htmlEncode...

Please see the screenshot.

What am I doing wrong?

/Morten

 

Nikolay
Telerik team
 updated answer on 27 Sep 2022
1 answer
258 views

Hello ,

I'm using below code for date validation

 sheetForNPD.range("O2:O100").validation({
        dataType: "date",
        showButton: true,
        comparerType: "between",
        from: "DATEVALUE(\"1/1/1900\")",
        to: "DATEVALUE(\"1/1/2050\")",
        allowNulls: true,
        type: "reject",
        titleTemplate: "Start Date validation error",
        messageTemplate: "Start Date should be between 1899 and 2050 year."
    }).format('MM-dd-yy');

 

But i need if user enter in these format then also acceptable 

    • Slashes

      • M/D/YY

      • M/D/YYYY

      • MM/DD/YY

      • MM/DD/YYYY

    • Dashes

      • M-D-YY

      • M-D-YYYY

      • MM-DD-YY

      • MM-DD-YYYY

    • Dots

      • M.D.YY

      • M.D.YYYY

      • MM.DD.YY

      • MM.DD.YYYY

    Is it possible in kendo spreadsheet can i validate these format for single column ?

Neli
Telerik team
 answered on 27 Sep 2022
1 answer
227 views

Hello,

 

I have applied range validation for numerical type data it's working until i'm entering single record but it's not working when i'm paste multiple record it's not validating please give me any solution.Thank you

 

 sheetForRootCause.range("G2:G300").validation({
        dataType: "number",
        from: "1899",
        to: "2050",
        comparerType: "between",
        allowNulls: true,
        type: "reject",
        titleTemplate: "Year validation error",
        messageTemplate: "Year should be between 1899 and 2050 year."
    });
Neli
Telerik team
 answered on 27 Sep 2022
1 answer
9.0K+ views
Hello,
I have the following problem, many warnings of "Added non-passive event listener to a scroll-blocking 'wheel' event" are generated, to avoid these warnings I have found the following library (https://unpkg.com/default-passive- events@2.0.0/dist/index.umd.js), with this library loaded, it does not throw the warnings, but I was wondering if it is a suitable solution to put a grid in a production environment.

error:



solution: https://unpkg.com/default-passive-events@2.0.0/dist/index.umd.js
Nikolay
Telerik team
 answered on 27 Sep 2022
1 answer
410 views

I use kendoEditor(jQuery) to let user create html content. Then, saving this content as html and using this html content to export to a pdf document by xmlParser. 

I also restricted the width of kendoEditor by A4 page width in order to create a PDF document without fitting problem.

But the problem is the users are not able to know page end so their contents might be split. For example, they create a table and table header in kendoEditor but this table and its header can be split in two pages when exporting to pdf document.

So, is there a way to show page layout or a page end marker or line in kendoEditor?

Neli
Telerik team
 answered on 27 Sep 2022
1 answer
177 views
I've been trying to solve this with functions and the like, but don't seem to be able to find an answer.

Is there anyway I can pass the type field value in the datasource for the foreign key column?
This will allow me to populate the tenantId list based on the type of Row.


toolbar: ["create"], columns: [ { field: "id", title: "Id", hidden: true }, { field: "type", title: "type", hidden: true }, { field: "tenantId", filterable: { multi: true, search: true} ,width: "200px", dataTextField: "name", dataValueField: "id", dataSource: { type: "json", transport: { read: { url: '@Url.Action("GetSyncingTennantsJsn", "dB")', data: { type: ##I want to pass 'type' value for this row## } } } } }, { field: "folder", title: "Folder" },


Many thanks!

Rob

Rob
Top achievements
Rank 2
Iron
Veteran
Iron
 updated answer on 26 Sep 2022
0 answers
384 views
How can I set the stroke width of the circular gauge component? It looks like the width  of the stroke is calulcated relative to the size of the gauge. I would like to increase the stroke width.
Inception
Top achievements
Rank 1
Veteran
 asked on 24 Sep 2022
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
Chat
MultiColumnComboBox
Dialog
DateRangePicker
Checkbox
Timeline
Drawer
DateInput
ProgressBar
MediaPlayer
ImageEditor
TextBox
OrgChart
Accessibility
Effects
PivotGridV2
ScrollView
Switch
TextArea
BulletChart
Licensing
QRCode
ResponsivePanel
Wizard
CheckBoxGroup
Localization
Barcode
Breadcrumb
Collapsible
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
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
AICodingAssistant
+? more
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?