Telerik Forums
Kendo UI for jQuery Forum
1 answer
137 views

Hi folks,

 

I have a datasource bound spreasheet. When I enter a value in a cell, the change is reflected in the datasource. That's good.

A1     

 

Now, I enter a formula, =SUM(A1:B1), in cell C1, on the first time I input the formula in C1, the bound datasource gets the sum value correctly. Then I change value in cell A1 from 100

Anna
Top achievements
Rank 1
 answered on 03 Oct 2017
1 answer
203 views

Hi!

I am using kendo spreadsheet to batch-edit a list of values.

In the last version available, if I change a value, I lose the format (I append a currency to the number; currency that can be different in each cell). That's removed after I update the value

Here's a demo:

http://dojo.telerik.com/AyOXo/13

Try to change the value of the amount in the cell to something else.The currency (SEK/USD will dissapear from the format)

Thanks!

Ianko
Telerik team
 answered on 03 Oct 2017
1 answer
444 views

Hello,

Is it possible to localize the Column Title in the Grid component? 

For instance, in the following example, I would like to show Name or Nom depending on the user's locale.

$("#grid").kendoGrid({
       dataSource:remoteDataSource,
       height: 550,
       groupable: true,
       sortable: true,
       resizable: true,
       pageable: {
           refresh: true,
           pageSizes: true,
           buttonCount: 5
       },
       columns: [{
           field: "name",
           title: "Name",
           width: 400
       },

Cheers,

Paul

Georgi
Telerik team
 answered on 03 Oct 2017
3 answers
134 views

Dear support team,

   I'm using the built-in create child on the TreeList, which is referenced hear. I just added the "createChild" to the list of commands.  On the grid if I click the button the child is created. I can then update the cells, but once I click the update button, the actions are subsequently itemchange, sync, then remove.  Of course, the newly created item is removed from the grid. My contact information has been changed, but not with Telerik, so use the below contacts.

Respectfully,

James Rollins

Senior Developer

Digital Cloak LLC

james.rollins@digitalcloak.net

Stefan
Telerik team
 answered on 03 Oct 2017
2 answers
118 views

Suppose I have a data source with fields id and x that comes from a table foobar.

The view model is id, x, xorig.  For read operations the xorig value is also set to the x value

The peculiar rules for foobar is that when an x is to be updated it will try to honor the requested x, otherwise it will return a new x value

The data source is configured for batch mode.

The read gets a row id=1, x=10

The user edits x to be 20 and hits a save changes button.  The update transport sends json via parameterMap [ {id:1, x:20, xorig:10} ]

The update routine will send back [ {id:1, x:20, xorig:20} ] if the edit was honored, or perhaps [ {id:1,x:55,xorig:55} ] if the 20 could not be honored and the peculiar rules determined x should be 55 instead.

How and where can I capture the update response and tweak the data source elements to match the update response. For example:

for (var i=0; i<updateResponseData.length; i++) {
    var responseItem = updateResponseData[i];
    var datasorcItem = myDataSource.get(responseItem.id);
    datasorcItem.x = responseItem.x;
    datasorcItem.xorig =responseItem.xorig;
    datasorcItem.dirty = false;
}

 

Thanks,

Richard

Richard
Top achievements
Rank 1
 answered on 02 Oct 2017
3 answers
194 views

On the latest version of chrome 61.0.3163.100 column resize is broken if zoom is not set to 100%.  ie. if zoom is set to 110% then column resize no longer works.  This worked on version 60.0.3112.113.

Just try out the resize column sample on your demos page

http://demos.telerik.com/kendo-ui/grid/column-resizing

When on the page set zoom to 110%.  Column resize stops working.

Pavlina
Telerik team
 answered on 02 Oct 2017
2 answers
336 views

I have a grid with many records (over 1M records) in my DB. I want to only request the data that will be displayed on the current grid from my DB. What I do is pass my current page and pageSize to my java code in order to determine how many records I will skip in my DB.

Ex. If I navigate to page 5 with a pageSize of 20, I will skip the first 80 records and receive the next 20.

This is working so far, but my issue is that when I receive those 20 records of data and place it in my dataSource; page 5 will show up empty since the data will only be displayed on page 1.

A work-around I found is to fill my dataSource data with empty JSON objects {}. This works, but if I were to input 100,000 empty JSON objects, the program will crash.

What can I do to display my data on the specific page I'm on, and basically ignore all the other pages when I'm not visiting them?

Cassidy
Top achievements
Rank 1
 answered on 02 Oct 2017
4 answers
267 views

I am trying to configure a VerticalBoxPlot using the Kendo asp.net MVC in the following ways

 

1. Display just the outline for the box plot without any fill as shown in the image.

2. Display the median in a color other than white.

 

Are these 2 things customizable at all? I would really appreciate if anyone can point me in the right direction either using asp.net MVC or even using Javascript.

 

- Sumanth

Alex Hajigeorgieva
Telerik team
 answered on 02 Oct 2017
1 answer
424 views
Hi,
 I need to differentiate clearAll & single button clear in kendo multiselect. when i remove single item or clearAll items from multiselect.
Misho
Telerik team
 answered on 02 Oct 2017
5 answers
816 views

Hi there,

My bar chart is not picking up the sort order I am applying.  I am returning Json with 4 categories - High, Medium, Low and Very Low, each returning a sort order to force the graph to display in that correct order.  However, the graph renders in the wrong order.  Please can you assist.  I have attached a screenshot of what is rendered, code below.  Everything else in my chart is working fine.

 === JSON RETURNED ===

[{"Share":3,"VisibleInLegend":true,"Color":"#E8412D","category":"High","SortOrder":4,"PercentageField":"9%"},{"Share":9,"VisibleInLegend":true,"Color":"#ED8132","category":"Medium","SortOrder":3,"PercentageField":"29%"},{"Share":3,"VisibleInLegend":true,"Color":"#FFB400","category":"Low","SortOrder":2,"PercentageField":"9%"},{"Share":16,"VisibleInLegend":true,"Color":"#92CE7A","category":"Very Low","SortOrder":1,"PercentageField":"51%"}]​

=== VIEW ====

 @( Html.Kendo().Chart<Models.RiskItemsBarChartModel>()
                .Name("riskItems")
                .ChartArea(chartArea => chartArea.Background("#F5F5F5"))
                .Title(title => title
                    .Text("Risk Items")
                    .Position(ChartTitlePosition.Top))
                .DataSource(ds => ds
                    .Read(read => read.Action("RiskItemsBarChart", "Reporting"))
                    .Group(g => g.Add(d => d.category))
                    .Sort(g => g.Add(d => d.SortOrder))
                )
                .Series(series => series
                    .Bar(d => d.Share, d => d.Color).CategoryField("category")
                    .Name("#:group.value#")
                    .Stack(true)
                    .Labels(labels => labels
                        .Visible(true)
                        .Template("#= value # (#= dataItem.PercentageField #)")
                        .Position(ChartBarLabelsPosition.InsideBase)
                    )
                )
                .CategoryAxis(axis => axis
                    .Visible(false)
                )
                .Tooltip(tooltip => tooltip
                    .Visible(false)
                )
                .Legend(legend => legend
                    .Visible(true)
                    .Position(ChartLegendPosition.Bottom)
                )
                .Events(events => events
                    .SeriesClick("onSeriesClick_riskItems")
                    .DataBound("onDataBound_riskItems")
                )
            )

Thanks, Mark

Preslav
Telerik team
 answered on 02 Oct 2017
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
ContextMenu
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
DateTimePicker
RadialGauge
ArcGauge
AICodingAssistant
SegmentedControl
+? more
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?