Questions on Kendo UI for jQuery Forum

1 answer

373 views

Set cell value - slow - Manual calculation

Setting a cell value seems to be very slow when the sheet contains several formulars.

I this the optimal code to set a cell value :

var rr = range._sheet.range(row, column);
rr.value(value);

Is there any setting that disable automatic calculation "manual calculation" ? Could offer a better performance by

1. disable automatic calculation

2. set all cell values

3. activate automatic calculation.

Spreadsheet

answered on 11 May 2017

5 answers

289 views

Invalid Leap Year Day Value Being Changed On Focus Loss

Hi Guys,

I have just tripped over an issue whereby an invalid leap year day value is being automatically changed when the control losses focus.

To illustrate the problem I have created the following

http://dojo.telerik.com/ePIQE

If you run this dojo and enter 29/02/2001 then tab to second control the value is changed to 29/02/2020.

The same effect is not seen when entering 30/02/2001 and then tabbing away so it would appear to be related to the 29 Feb.

I have looked through the documentation and the forums for any information relating to this issue but have so far drawn a blank.

Therefore I would be most grateful if someone could take a look and advise.

Thanks
Alan

Date/Time Pickers

answered on 11 May 2017

4 answers

309 views

Window Content Overflow

In the new release of kendo ui professional, content inside a window is overflowing ever so slightly. The printscreens attached show the exact same code I've written, with R1 2017 Kendo UI and with R2 2017 Kendo UI and you can see that the content is overflowed, even though the div.k-window-content height property is set to 100%. If I manually remove the padding .58em property this is fixed.

Thanks

Marc

General Discussions

answered on 11 May 2017

3 answers

632 views

Set template in kendo upload without upload click/select

Hello,

I created a small module with a upload kendo input.

This input has a template.

When I uploading a file by clicking on the kendo load button, the file is loaded and the kendo upload shows everything in my template.

But how can I initialize the model without clicking on the kendo loading button?

I get a src in byte64 from my database and set it in the template variable, but the template is not show. With the function "FillViewModelFromResponse".
When i set this byte64 from the function "onSelect" of my model view, the template is show

HTML:

01.<input name="logo" id="a-gst-logo" type="file"

02.accept=".jpg,.png"

03.data-role="upload"

04.data-async="false"

05.data-multiple="false"

06.data-template="template"

07.data-bind="events: {select: onSelect}" />

08.

09.<script id="template" type="text/x-kendo-template">

10. <div id="divTemplate" class='file-wrapper'>

11. <button type='button' class='k-upload-action'></button>

12. <img id="imageLogo" data-bind="attr: {src: logoSrc}"/>

13. <h4 class='file-heading file-name-heading' data-bind="text: logoNome"></h4>

14. </div>

15.</script>

JS:

01.$(document).ready(function () {

02. vm = kendo.observable({

03. logo: null,

04. logoNome: null,

05. logoSrc: null,

06. onSelect: function(e){

07. if(!Utils.isNullOrUndefined(e.files)){

08. for (var i = 0; i < e.files.length; i++) {

09. var file = e.files[i].rawFile;

10. var name = e.files[i].name;

11. vm.set("nomeImmagine", name);

12. if (file) {

13. var reader = new FileReader();

14. reader.onloadend = function() {

15. vm.set("logo", this.result.substring(this.result.search("base64,")+7));

16. vm.set("logoSrc", this.result);

17. vm.set("logoNome", vm.nomeImmagine);

18. A_Gst.KendoBind("divTemplateLogo");

19. };

20. reader.readAsDataURL(file);

21. }

22. }

23. }

24. },

25. FillViewModelFromResponse: function(data){

26. vm.set("logo", data.gst.logoBase64);

27. vm.set("logoNome", data.gst.logoNome);

28.

29. }

30. });

31.

32. KendoUtils.bind(idForm, vm);

33.});

Ps. I cleaned the code, but some wrong code maybe remaining

Templates

answered on 10 May 2017

1 answer

1.1K+ views

HtmlAttributes for new rows

I have applied a class HTML attribute to the final column in a Grid a

@(Html.Kendo().Grid<myModel>()
.Columns(columns =>
{
columns.Bound(entity => entity.SurrogateKey).Hidden();
columns.Bound(entity => entity.column1);
columns.Bound(entity => entity.column2);
columns.Command(command => command.Destroy())
.HtmlAttributes(new { @class = "finalColumn" })
;
})

When a new row is added using addRow(), the new row's column doesn't have the "finalColumn" class attached to it (it just has the dirty cell class). Is this expected behavior? If so, do you have any suggestions on how I should handle this so the new row's final column has the "finalColumn" class?

Thanks,

Richard

Grid

answered on 10 May 2017

2 answers

68 views

Gird for Angular 2- exported excel looses aggreagtes

I slightly modified following example: http://www.telerik.com/kendo-angular-ui/components/grid/excel-export/#toc-exporting-specific-data

I just added "sum" aggregate to "ProductID" field. It works fine in the grid. But when I try to save the grid as an excel file, I loose that aggregate. Though the excel file contains grouped data.

Here is a plunker to reproduce: http://plnkr.co/edit/ej4yEj2wZO0RoHXlzqGF?p=preview

Could someone help me to fix that plunker, please?

Grid

answered on 10 May 2017

4 answers

630 views

Uncaught RangeError: Maximum call stack size exceeded if en-US culture is used

Hi. there is a bug in last release 2017.2.504, where was fixed weekNumber for DatePeacker.

If en-US culture/messages are included (maybe not only en-US, didn't check all of them)- error happens and modal doesn't appear https://www.screencast.com/t/whv1Kup3itFO

example: http://dojo.telerik.com/Ovequ

Date/Time Pickers

answered on 10 May 2017

1 answer

963 views

Send file loaded to spring in multipart

Hello i have a little problem with the kendo upload.

I want send one file to my spring controller but i can't with the kendo ui.

I have a simple form:

<form>

<ul>

<li>

<input data-role="maskedtextbox" data-bind="value: testoHome" id="testohome" name="testo home" />

<input id="upload" name="upload" type="file" />

</li>

<li>

<button id="next" class="k-button k-primary" onclick="Form.sendData()">Next</button>

</li>

</ul>

</form>

with a simple js:

var Form = {

vm: null,

sendData: function(){

data = new FormData();

data.append("file", $('#a-can-uploadrl')[0].files[0]);

data.append("testo", Form.vm.get("testoHome"));

$.ajax({

url: myURL,

data: data,

contentType: false,

processData: false,

enctype: 'multipart/form-data',

type: 'POST',

success:

function(data){

alert(data);

}

});

},

InitKendoBind: function(){

this.vm = kendo.observable({

testoHome: null

});

kendo.bind($("#formId")[0], vm);

},

Init: function() {

$("#formId").submit(function(event) {

event.preventDefault();

});

$("upload").kendoUpload();

this.InitKendoBind();

},

}

$(document).ready(function() {

Form.Init();

});

but if i use the kendo upload with

$("upload").kendoUpload()

the

$('#a-can-uploadrl')[0].files[0]

is undefined.

If i not use the kendo upload i take the file with this code

$('#a-can-uploadrl')[0].files[0]

and i can pass the file to my controller.

How i can take the file for pass all the data (file with name, size, etc. + others input strings from my form) using the kendo upload?

(without the async uploading)

this is my java controller:

@RequestMapping(value="myURL", method=RequestMethod.POST)

public static Long myURL(HttpServletRequest request,

@RequestParam("file") MultipartFile file

@RequestParam("testo") String cantiereString

) throws FileUploadException, IOException {

/* some code */

return 1;

}

Upload

answered on 10 May 2017

1 answer

190 views

Batch data entry

I've been tasked with having a browser-based ability to quickly enter large amounts of data into a table. One requirement is that the user should be able to do everything using only the keyboard after the first column/row has focus. The typical use case for a 3 column table would be:

Enter value, TAB, enter value, TAB, enter value, TAB (new row is created)

...

I have been working on this for a few days with my initial expectation being that it wouldn't be a challenge. I'm finding that it's more difficult than expected and would like to take a step back to ensure I'm not missing any obvious alternative solutions.

My current belief is that this kind of quick batch editing mode (keyboard only) isn't directly supported in the Kendo Grid widget and is expected to require some JQuery customization/event handling. Does that sound correct?

You may notice I've posted 3 other threads recently. They are all related to this basic problem. If you have any high-level pointers that may not have been obvious because the threads were so specific, I would be all ears :).

Thanks,

Richard

Grid

answered on 10 May 2017

5 answers

208 views

Frozen Column : Row alignment issues - Part II

Hi Guys,

Following on from my original posting relating to scrolling issues

   http://www.telerik.com/forums/frozen-column-row-alignment-issue

I have now tripped over another scenario whereby the frozen column scrolls independently of the other rows.

To illustrate the problem I have created the following

   http://dojo.telerik.com/eyeku

If you run this dojo and select the first checkbox then using the keyboard tab through the other checkboxes.

As you traverse down the checkboxes the rows in the frozen column will start to scroll but the other rows remain static causing major synchronization issues between the two tables.

Regards
Alan

Grid

answered on 10 May 2017