Telerik Forums
Kendo UI for jQuery Forum
1 answer
218 views
I'm looking at the spreadsheet validation here: https://demos.telerik.com/kendo-ui/spreadsheet/validation
It should that validation rules are set at each individual cell.   We are looking to build this grid dynamically (populating from a database) and that would require iterating through each cell to set validation.  Is there a way to set validation at the column level? 
Neli
Telerik team
 answered on 03 Jun 2022
0 answers
106 views

Hi,

I am using Kendo UI for jQuery in my ASP .Net 6 application. would like to check if it is possible to hide the red box area in the attached image, and the area to be shown only when user select a row in grid

 

Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
 asked on 02 Jun 2022
1 answer
128 views

Hello,

What should I write to get the value inside the cell? I run in angular, I want to assign the cell value I selected to the variable.


  @ViewChild('spreadsheet') spreadsheetEl!: ElementRef;

  constructor(private hostEl: ElementRef) {}

  ngAfterViewInit() {
    kendo.jQuery(this.spreadsheetEl.nativeElement).kendoSpreadsheet({
           columns: 3,
           //rows: 10,
           sheetsbar: false,
           toolbar: {
            home: [
              "open", "exportAs",

              {
                  type: "button",
                  text: "Material select",
                  showText: "both",
                  icon: "k-icon k-i-cog",
                  click: function(e: any) {



                    var sheet = this.spreadsheetEl.nativeElement.activeSheet();
                    var range = sheet.selection();
                  }
              }
          ],
            insert: false,
            data: false,
            },
...

thank you

regards

Neli
Telerik team
 answered on 01 Jun 2022
0 answers
153 views
hi, i need use "aspnetmvc-ajax" in DropDownTree.dataSource but i got Error: "Uncaught TypeError: data.Data is undefined"
$("#dropdowntree").kendoDropDownTree({ 
     dataSource: { 
          type: "aspnetmvc-ajax", 
          transport: { 
              read: { url: "xxxxxxxxxxxxxxxxxxxxxxxxxxx" , data: forgeryToken, dataType: "json" }
 }}

thank you

vahid
Top achievements
Rank 2
Iron
Iron
Iron
 updated question on 01 Jun 2022
1 answer
103 views
I want to show the data coming from web api by paginating in kendo grid?
Mihaela
Telerik team
 answered on 01 Jun 2022
1 answer
153 views
For example, you took 20 data and showed grid.
pressing the next button will pull the next 20 from the api again and it will be displayed
Aleksandar
Telerik team
 answered on 01 Jun 2022
0 answers
111 views

Hi,

      Method is https://docs.telerik.com/kendo-ui/knowledge-base/remote-validation?_ga=2.30044991.1233608935.1653012997-543877616.1650858150

      Demo is http://dojo.telerik.com/UgELisOy

      In above demo,  

      var remoteValidator = {
            valid: false,
            initiated: false,
            check: function(element, validator) {
            remoteValidator.initiated = true;
            //simulate Ajax
            setTimeout(function() {
                  //TODO: set to true if valid
                  remoteValidator.valid = true;

                  validator.validateInput(element);
                  remoteValidator.initiated = false;
            }, 1000);
          }
      };

      The form cannot be submitted normally.

       Thank you for your help!

                            
sun
Top achievements
Rank 2
Iron
Iron
Iron
 asked on 31 May 2022
3 answers
491 views

Hi,

     Is it possible to make date(month/day) is vertical and time(hour:minute) is horizontal in the "week" view of scheduler?

 

    Thank you for your help!

Dimitar
Telerik team
 answered on 31 May 2022
1 answer
349 views

Hello,

When locked columns and multi-column headers are configured in a grid and selectable: "multiple cell" is configured, we observed

  • Ctrl+ selection is working fine
  • Mouse drag and selection also working fine
  • Shift + selection is not working as expected (seems buggy behavior) 

Example : https://dojo.telerik.com/@shashi.kumar/IdeKUHam

What is the behavior of shift + selection on grid? Is there any documentation for the same?

Is there any way we can disable shift + selection for the grid? (ctrl selection & mouse selection should work)

 

Thanks

Nikolay
Telerik team
 answered on 31 May 2022
0 answers
81 views

Hello,

 

1. How to put validation in spreadsheet when  i'm getting data dynamically their are data coming key value pair.So how to validate every column based on requirement.Please help me to solve this problem. Thanks

brajesh
Top achievements
Rank 1
Iron
 asked on 30 May 2022
Narrow your results
Selected tags
Tags
Grid
General Discussions
Charts
Data Source
Scheduler
DropDownList
TreeView
MVVM
Editor
Window
Date/Time Pickers
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)
SPA
Filter
Drawer (Mobile)
Drawing API
Globalization
Gauges
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
OrgChart
TextBox
Effects
Accessibility
ScrollView
PivotGridV2
BulletChart
Licensing
QRCode
ResponsivePanel
Switch
Wizard
CheckBoxGroup
TextArea
Barcode
Collapsible
Localization
MultiViewCalendar
Touch
Breadcrumb
RadioButton
Stepper
Card
ExpansionPanel
Rating
RadioGroup
Badge
Captcha
Heatmap
AppBar
Loader
Security
Popover
DockManager
FloatingActionButton
TaskBoard
CircularGauge
ColorGradient
ColorPalette
DropDownButton
TimeDurationPicker
ToggleButton
BottomNavigation
Ripple
SkeletonContainer
Avatar
Circular ProgressBar
FlatColorPicker
SplitButton
Signature
Chip
ChipList
VS Code Extension
AIPrompt
PropertyGrid
Sankey
Chart Wizard
OTP Input
SpeechToTextButton
InlineAIPrompt
+? more
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?