Telerik Forums
Kendo UI for jQuery Forum
1 answer
243 views

Hi,

  I want to be able to grammatically copy a range of cells down several rows and have the formula's update automatically.  

I can get to the cells i want to copy and their formulas with code like

 

                            var dataSheet = sheetKendo.sheetByName("sheet1");
                            var sourceRange= dataSheet.range("A1");
                            var val = rowCountRange.value();
                            var formula = rowCountRange.formula(); // =Len(B1) + 2

How could I copy A1 to A2 and have the resulting formula in A2 =Len(B2)+2 in code, eg the same way as you drag down the black cross when doing this manually in the ui. 

 I know I could do it manually by setting the formula of A2 manually but it would mean I would have to parse and change the formula from A1.

 

Thanks for any help 

 

 


Neil
Top achievements
Rank 1
 answered on 07 Mar 2016
1 answer
248 views

Hi

 

I need to create a very specific set of functionalities for a ComboBox, and from browsing the demos/apis/overview, I havn't been able to determine if it is possible. Therefore; this post, since I'm hoping someone with more experience using Kendo UI and the ComboBox widget, could answer the question.

The ComboBox has the following requirements:

  • UI-wise it will be two input field, where the user can write numbers in one, and letters in the other. Each of these input fields will be a separate ComboBox but they will share the Datasource.
  • When no inputs have been provided, the options in the ComboBox should be empty.
  • Whenever something is typed in one of the input fields, the Datasource should perform a fetch for new data, using the input as parameters (send via the url and used as filters on the server).
  • The Datasource should not fetch data if the input characters are less than 3.
  • Upon selecting an option in one of the ComboBox's the other should be updated with the selected value as well (One showing the options number, the other, the options name)

 

Is this possible? Basically I'm hoping to not download all of the options available on the server, and limit the fetching for when useful filtering values are available.

Any hints/examples would be helpful.

Would another widget be more suitable for this task?

 

(I'm guessing I have to setup a Datasource with Virtualization, but I havn't been able to get that going yet, so don't want to spend any more time on it, if it is the wrong direction I'm heading).

Alexander Valchev
Telerik team
 answered on 07 Mar 2016
3 answers
288 views
I am currently using the spreadsheet and a manual data entry form for users that currently have a lot of data stored in Excel spreadsheets.
I need to take data and format the data to a date format but only in certain columns (all cells below a certain column). It would be helpful to apply some sort of ID/name or something similar to give cells a unique identifier.
Alex Gyoshev
Telerik team
 answered on 07 Mar 2016
1 answer
900 views

I'm trying to add an onChange event to the Kendo DatePicker and noticed that there is not an easy way to go about doing this, I unfortunately. 

I was able to add an override by using jQuery but I can only get this to work if I know the name of the datepicker. I'm providing an example of this below for reference. 

<!-- [ begin ] invoke onChange event -->


<script type="text/javascript">
    $(document).ready(function () {
        function onChanger() {
            alert("Change :: " + kendo.toString(this.value(), 'd')); // show the value

            document.forms['submitForm'].submit(); // submit the form
        }

        $("#datepicker").kendoDatePicker({
            change: onChanger
        }
        );
    }); 
</script>

<input id="datepicker" name="datepickers" />

<!-- [ end ] invoke onChange event -->

My problem is I'm looping through items which dynamically are building these datepickers.

So my code looks like this:

<code>

  @(Html.Kendo()
                                                          .DatePicker()
                                                          .Name("AllTeachersObjectives_" + rec.CalendarGroupID)
                                                          .Value(rec.AllTeachersObjectives)
                                                          .Max(DateTime.Now.AddYears(10))
                                                          .Events(e => e.Change("startChange"))
                                                )

</code>

How can I dynamically invoke the onChange event from using a name of a datePicker that is dynamic?

Any help would be greatly appreciated!! 

TIA

- Dave

 

 

 

Helen
Telerik team
 answered on 07 Mar 2016
6 answers
661 views

Hi,

I have the following Site in a Cordova Application:

<div id="LQKXHXCUyI" style="width: 100%; height: auto;">
    <table class="db-layout tableview" style="width: 100%;">
        <tbody>
            <tr>
                <td style="padding: 0px 5px 5px 0px; width: 25% !important;">
                    <div id="vBulgojWFV" style="width: 100%; display: block;" k-data-source="gml.ui.vBulgojWFV.dataSource" kendo-drop-down-list="gml.ui.vBulgojWFV.control" ng-model="gml.ui.SDK_Kunde.filterColumn" k-data-text-field="'caption'" k-data-value-field="'id'"></div>
                </td>
                <td style="padding: 0px 5px 5px 0px; width: 75% !important;">
                    <input class="k-textbox" id="lUeESAqFyi" style="width: 100%; display: block;" type="text" data-role="maskedtextbox" ng-model="gml.ui.SDK_Kunde.filterValue" autocomplete="off">
                </td>
            </tr>
        </tbody>
    </table>
    <table class="db-layout tableview" style="width: 100%;">
        <tbody>
            <tr>
                <td style="padding: 0px 5px 5px 0px; width: 85.71% !important;"> </td>
                <td style="padding: 0px 5px 5px 0px; width: 14.28% !important;">
                    <kendo-button style="padding: 5px; float: right;" on-click="gml.ui.SDK_Kunde.search()">
                        <img style="margin: 0px; padding: 0px;" src="img/search.png">
                    </kendo-button>
                </td>
            </tr>
        </tbody>
    </table>
    <table class="db-layout tableview" style="width: 100%;">
        <tbody>
            <tr>
                <td style="padding: 0px 5px 5px 0px; width: 100% !important;">
                    <div id="JNrpXWRaGR"></div>
                </td>
            </tr>
        </tbody>
    </table>
</div>

If i open the DropDownList and select one Item the whole Application freeze. The DropDownList is not even closing.

I have found that in the Kendo.all.js is a function "propagateClassToWidgetWrapper" and inside this function is the folowing Code:

var mo = new MutationObserver(function(changes){
    suspend();    // make sure we don't trigger a loop
    if (!widget) {
        return;
    }
....

the param "changes" is growing every time times 2. (4, 8, 16, 32, 64, ....) It never stops. I'm not sure if this is the problem for the freezing but I thought it could help to locate the problem.

What is wrong with my Code?

With best regards

Johann

 
 
 
Kiril Nikolov
Telerik team
 answered on 07 Mar 2016
3 answers
478 views
I have a gantt chart that could have a large date range (years sometimes), and it always defaults to the earliest start date in my data set. This date could be well before the current date. I need the chart to center on the current date and allow the user to scroll back or forward. I believe I've read this isn't currently an out of the box option, but I was hoping someone could help me implement some code to achieve this.
Kiril Nikolov
Telerik team
 answered on 07 Mar 2016
3 answers
366 views
I know that DatePicker has a format attribute (http://docs.kendoui.com/api/web/datepicker#configuration-format).

But what if I had a grid with a date column. Can I set the format of the DatePicker that is used here in edit mode?

By the way, I am using fluid syntax.
Kiril Nikolov
Telerik team
 answered on 07 Mar 2016
3 answers
101 views

Ability to apply color scheming for different line types??

please help me how can i do?

Bozhidar
Telerik team
 answered on 07 Mar 2016
3 answers
264 views

Ability to split gantt lines / tasks into smaller tasks.

please help me.how can do?

Bozhidar
Telerik team
 answered on 07 Mar 2016
6 answers
771 views

We have a UI, where text and image components can be added and edited within a div, and the final layout should be saved on the server. 

I can drag an image using kendoDraggable and handle doubleclick on the image area to make image updates.

When a text component is added, its content is editable via inline kendo editor. But since editor captures clicks and mouse events, there seem to be no easy way to make inline editor draggable to move it around the parent div. Any suggestions are highly appreciated. 

Quotient
Top achievements
Rank 1
 answered on 05 Mar 2016
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
TimePicker
FloatingActionButton
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
StockChart
ContextMenu
DateTimePicker
RadialGauge
ArcGauge
AICodingAssistant
SmartPasteButton
PromptBox
SegmentedControl
+? more
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?