Telerik Forums
Kendo UI for jQuery Forum
18 answers
3.3K+ views

I have a situation where an administrative user creates an Excel file using her desktop copy of Excel and saves it to a location on our server. What I want to do is load that file from the server into a Spreadsheet control, have a user make changes in the Spreadsheet, and then click a button to save it back to a location on the server.

I see plenty of examples of importing files from the user's local system and exporting them to the user' local system. However, I don't see any examples of loading a file from the SERVER when the spreadsheet first loads. Similarly, I can't find an example of saving the spreadsheet contents as an Excel file on the SERVER.

Can somebody please provide an example of this?

Thank you!

greg
Top achievements
Rank 1
 answered on 20 Jan 2021
3 answers
540 views

Hi, 

I have an issue related to Gantt view changes. If I'm in week view, and I scroll it to some period, for example from Jun 25 to Jun 30 (see day.png), and then I change view to month, period is changed, and it goes to December (see month.png). Is there any way to fix this period after view change?

Thanks in advance. 

Stoyan
Telerik team
 answered on 20 Jan 2021
1 answer
319 views

Hi, 

I am trying to implement simpler version of tilelayout demo (small dashboard) in quite old angularjs application. 

Following examples in demo I wanted to replace simple hardcoded value of conversion-rate (9%) with data from my service. 

Html is correctly rendered but not updated when vm.myRisk changed..

Here are relevant pieces of code that I have:

Controller:

... controller declaration etc..
var vm = this;
vm.myRisk = 0;
getRiskData(); //Function calls server and retrieves simple int value and sets vm.myRisk to this value
var riskTemplateString = '<h3><label><span ng-bind="vm.myRisk"></span> % </label></h3> <div> ' + localeService.tr("risk") + '</div>';
var riskTemplate = kendo.template(riskTemplateString);
 
        $("#tilelayout").kendoTileLayout({
            containers: [{
                colSpan: 1,
                rowSpan: 1,
                header: {
                    text: "my risk"
                },
                bodyTemplate: kendo.template(riskTemplate)
            }],
            columns: 6,
            columnsWidth: 300,
            rowsHeight: 235,
            reorderable: true,
            resizable: true,
            resize: function (e) {
                var rowSpan = e.container.css("grid-column-end");
                var chart = e.container.find(".k-chart").data("kendoChart");
                // hide chart labels when the space is limited
                if (rowSpan === "span 1" && chart) {
                    chart.options.categoryAxis.labels.visible = false;
                    chart.redraw();
                }
                // show chart labels when the space is enough
                if (rowSpan !== "span 1" && chart) {
                    chart.options.categoryAxis.labels.visible = true;
                    chart.redraw();
                }
 
                // for widgets that do not auto resize
                kendo.resize(e.container, true);
            }
        });

 

my html is very simple and has only placeholder for the widget and controller declared using standard controller As syntax..

<body>
    <div ng-controller="myDashboardController as mdc" class="c-module">
        <div class="c-module-content">
            <div id="example">
                <div id="tilelayout"></div>
 
                <!-- container text templates -->
<!-- THIS IS CONTAINER I WAS REPLACING -->
                <!-- <script id="conversion-rate" type="text/x-kendo-template">
                    <h3>9%</h3>
        <div>Visitor to Customer</div>
    </script> -->
            </div>
            <style>
                .k-card-header {
                    flex: 0 0 auto;
                }
                .k-card-body {
                    overflow: hidden;
                }
            </style>
        </div>
    </div>
 
</body>

 

Thanks

Angel Petrov
Telerik team
 answered on 19 Jan 2021
3 answers
217 views

Hello, I'm using Kendo UI for JQuery Diagram in Angular and I have a problem with the size.

I want the diagram to fit to its container, and I have the container height and width set to 100%.

When first initialized, the height and width of the "k-layer" div is automatically set to always 600px which does not fit to its container.

And when I resize the window manually, this "k-layer" size changes to fit to the container size.

My question is, how can I make this diagram to fit its container when initially loaded?

I tried calling kendo.resize("wrapper") when initially loaded, but this does not work.

FYI, I initialize the diagram in ngAfterViewInit().

Please see the screenshot I attached.

This screenshot shows the initial size is 600px.

And the code below is the code I use to initialize the diagram.

init: function (diagramElement, designerPanelWrapperElement) {
  designerPanelWrapper = designerPanelWrapperElement;
  diagram = diagramElement.kendoDiagram({
    theme: "default",
    dataSource: {
      data: [{
        name: "0",
        items: [{
          name: "0"
        }]
      }],
      schema: {
        model: {
          children: "items"
        }
      }
    },
    shapeDefaults: {
      width: 120,
      height: 120,
      fill: "#8ebc00"
    },
    layout: {
      type: "tree",
      subtype: "right"
    },
    select: function (e) {
 
    }
  }).getKendoDiagram();
 
  diagramElement.kendoDropTarget({
    drop: function (e) {
      var item, pos, transformed;
      if (e.draggable.hint) {
        item = e.draggable.hint.data("shape");
        pos = e.draggable.hintOffset;
        pos = new Point(pos.left, pos.top);
        var transformed = diagram.documentToModel(pos);
        item.x = transformed.x;
        item.y = transformed.y;
 
        diagram.addShape(item);
      }
    }
  });
  kendo.resize(designerPanelWrapper);
}

 

Nikolay
Telerik team
 answered on 19 Jan 2021
1 answer
106 views

hello 

i try load view in kendowindow and it works on development but when deploy project on the server and then open kendowindow with view in content in production on iis, first open empty kendowindow and then as soon as possible whole browser became white and empty, even view content is just a div with short text.

 

this is my code

 

var window = $("#" + dialogName).kendoWindow({
                content: {
                    url: "Security/Users",
                    dataType: "html"
                },
                title: name,
                position: {
                    top: topOffset,
                    left:leftOffset
                },
                //width: 700,
                //height: 400,
                size: dialogSize,
                actions: ["Refresh", "Minimize", "Maximize", "Close"],
                animation: {
                    open: {
                        effects: "fade:in"
                    },
                    close: {
                        effects: "fade:out"
                    }
                },
                modal: false,
                close: function (e) {
                   
                },
                open: function (e) {
                    
                    e.preventDefault();
                    
                    closeDrawer();
                   
                }

            }).open().center();

 

first and second images are from development environment and everything is ok, third image is from production environment and has bug.

Aleksandar
Telerik team
 answered on 19 Jan 2021
6 answers
1.6K+ views

Hello,

I am new to KendoUI web and using basic Jquery widget for uploading/dropping PDF file. I want to convert uploaded PDF file into Base64 string and then pass that data on to Restfull API(C#) to be saved in database.

 I did not find a way to achieve this in this section of the forums. Can anyone please help on how to do this or point me into right direction please??

Sample code would be great help if anyone got it please !!

Thanks

Aleksandar
Telerik team
 answered on 19 Jan 2021
3 answers
624 views
Is there a way to style a kendo grid paging dropdown like a normal dropdown?
Nikolay
Telerik team
 answered on 19 Jan 2021
4 answers
2.4K+ views
I build and bind a DropDownList as listed below.

The "GetItemCategories" returns data I would like to sort before displayed in the DropDownList.

How do I do the sorting?​

 
@(Html.Kendo().DropDownListFor(m => m.Category)
    .Name("Category")
    .DataTextField("Name")
    .DataValueField("Value")
    .HtmlAttributes(new { style = "width: 280px;" })
    .DataSource(source =>
    {
        source.Read(read =>
        {
            read.Action("GetItemCategories", "Helper");
        });
    })
    .Value(Model.ActionTimeFrameId.ToString())
)

 

 

 

Aleksandar
Telerik team
 answered on 18 Jan 2021
1 answer
368 views

Good afternoon,

We have an issue where the tooltip widget would hide when it shouldn't.

Please see:

https://dojo.telerik.com/oCuMidOL/5

If you hover over your mouse and then scroll the window, then the tooltip will hide (even though we have set autoHide: false).

How can we make this stay always visible? It should hide only if the "x" button is clicked.

 

many thanks

Alex

Aleksandar
Telerik team
 answered on 18 Jan 2021
3 answers
404 views

Hi,

the "previous" navigation button does not work in week or workWeek view. It works for day, month and agenda.

the "next" navigation button is fine, whereby i can still view the next week's schedule, just that after i navigate to the next week, i can't go back to the previous week. I have followed this https://docs.telerik.com/kendo-ui/api/javascript/ui/scheduler/events/navigate 

There is no error message in my case. Kindly assist me.

 

this is my code :

001.$("#scheduler").kendoScheduler({
002.        editable:{
003.            destroy: can_delete,
004.            update : can_update,
005.            create : can_create,
006.            template : $("#schedulerTemplate").html(),
007.        },
008.        date : new Date(dtFrom),
009.        startDate: new Date(dtFrom),
010.        startTime: new Date(new Date(dtFrom).getFullYear(), new Date(dtFrom).getMonth(),new Date(dtFrom).getDate(),7, 0, 0, 0),
011.        selectable:true,
012.        height: "max-height",       
013.        views: [
014.            {type : "day",
015.                selected:day_selected, allDaySlot:all_day_slot},
016.            {type : "workWeek",
017.                selected: week_selected,
018.                allDaySlot:all_day_slot,
019.                workDays: days_to_print, title: "Week"},
020.            {type : "month",
021.                selected : month_selected,
022.                adaptiveSlotHeight:true,
023.                eventSpacing: 5,
024.                eventsHeight: 55, },
025.            {type : "agenda",
026.                selected : agenda_selected},
027.                      
028.        ],
029.        toolbar: ["pdf","search"],
030.        pdf:{
031.            landscape: true,
032.        },       
033.        dataSource : {
034.  
035.            transport: {
036.                read : {
037.                    url: "/load_events_ajax_new/",
038.                    data: {
039.                        dtFrom: dtFrom,
040.                        dtUntil: dtUntil,
041.                        tz : G_timezone_offset,
042.                        timezone: $('#searchTimezone option:selected').val(),
043.                    },
044.                    dataType: "json",
045.                },
046.                update: {
047.                    url: "/update_events_ajax_new/",
048.                    dataType: "json",
049.                    complete : function(){
050.                        reload_data();
051.                    },
052.                },
053.                destroy: {
054.                    url: "/delete_events_ajax_new/",
055.                    dataType: "json",
056.                    complete : function(){
057.                        reload_data();
058.                    },
059.                },
060.                create : {
061.                    url : "/create_event_db/",
062.                    dataType : 'json',
063.                    complete : function(){
064.                        reload_data();
065.                    },
066.                },
067.                batch: true,
068.            },
069.             
070.            schema: {
071.                data: "events",
072.                model: {
073.                    id: "id",
074.                    fields: {
075.                        id: { from: "id",type:"number"},
076.                        title: { from: "title", validation: { required: true } },
077.                        start: { type: "date", from: "start" },
078.                        end: { type: "date", from: "end" },
079.                        description: { from: "description"},
080.                        location: {from: "location"},
081.                        creator: {from: "creator"},
082.                        isAllDay : {type : "boolean", from : "isAllDay"},
083.                        recurrenceId: { from: "recurrenceID" },
084.                        recurrenceRule: { from: "recurrenceRule" },
085.                        recurrenceException: { from: "recurrenceException" },
086.                        startTimezone: { from: "StartTimezone" },
087.                        ownerId: {from: "ownerId"},
088.                         
089.                    }
090.                }
091.            },
092.            filter: {
093.                logic: "or",
094.                filters: [
095.                ]
096.            }
097.        },
098.        navigate : function(e){
099.            reload_data();               
100.        },
101.        resources: [
102.            {
103.                field: "category_id",
104.                dataSource: category_datasource,
105.                multiple: false,
106.                title: "Category"
107.            }
108.        ],
109.    });
Petar
Telerik team
 answered on 15 Jan 2021
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
Effects
Accessibility
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
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
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?