Bug report

The select method of the range in the Spreadsheet component throws an error when we have a selected cell in the visible area of the component and try to select a range that is outside of this visible area.
The bug is replicable both when the range is passed as exact cells or row-column pair:

• sheet.range(3,2,3,3).select();
• sheet.range("C4:E6").select();

** This is a regression from the R3 2019 release

Reproduction of the problem

1. Open this Dojo
2. Scroll to row 70+ and select a random cell
3. Press the "Select range" button

Current behavior

The following error appears in the browser's console

If you scroll to the top rows of the Spreadsheet there is a visual selection of the cells that are passed in the range

Expected/desired behavior

On "Select range" click the "C4:E6" cell range should be selected and the Spreadsheet should be automatically scrolled to this selection.

Here is a working demo: https://dojo.telerik.com/uRERUxOm

Environment

• Kendo UI version: 2020.1.219
• jQuery version: x.y
• Browser: [all]

Bug report

The Spreadsheet doesn't' load correctly Excel files which definition of the tag is a single cell, instead of a cell range.

Test files: test-2.zip

Reproduction of the problem

1. Download the test-2.zip file and load the "test.xlsx" file in the Spreadsheet here.
2. The file has data in the “AZ” and “BA” columns and once it is imported in the Spreadsheet the data from the “BA” column is imported in the “AX” column and the values in the AZ column are missing.

• If the above file is saved in Excel it is correctly loading in the Spreadsheet. In the attached archive there is the “test-copy.xlsx” file which is the saved and correctly working one. Below is the structure of the two files. The one in red is from the "test.xlsx" file and the code in green is from the "test-copy.xlsx" file.

Current behavior

The The "test.xlsx" file is not loading correctly in the Spreadsheet and loses data

Expected/desired behavior

The "test.xlsx" file should load correctly in the Spreadsheet without losing data

Environment

• Kendo UI version: 2020.1.219
• jQuery version: x.y
• Browser: [all]

Right now, a List based validation is strict on case, it'd be nice to have a toggle for when it is appropriate.

Add menu item that allows end users to style background and text color based on rules (if cell value > 0 then green)

Add a watermark in each worksheet.

I know it seems like a small thing, but I work with complex spreadsheets, and supporting coloured sheet tabs would really help 
Love this control.

Hi Progress - just some quick feedback: 1. Telerik Control Panel updates - it feels like a lot of the time, when the TCP needs updating the user has to manually uninstall the old version and the install the new one using the .exe installer. If the TCP could automatically handle this process, that would be appreciated. 2. The various Telerik Spread Processing libraries (and other document processing libraries) can only be installed as an included component of the Telerik "UI for X" library installations. It would be great if there was an option in the TCP to do a standalone installation of just the Spread Processing libraries. Thanks and kind regards, - Lawrence

Integration of the pivot control with the spreadsheet

Bug in js\spreadsheet\numformat.js makeDateFormat

You appear to be using the wrong indices inside a nested loop.

if (/^(?:date|time|ampm)$/.test(section.body[i].type)) {

Should be (switch i to j)

if (/^(?:date|time|ampm)$/.test(section.body[j].type)) {

Getting error

Uncaught TypeError: Cannot read property 'type' of undefined
     at Object.<anonymous> (numformat.js:630)

Note: Version is actually 2018.3.1114 from npm

Hi,

We are using Kendo spreadsheet one of our applications. We wanted to get applied filters and set back to the Kendo spreadsheet. Not able to find a documentation for that. Can you please anyone help to sort this issue out?

Thanks

Hello

We are trying to use the Kendo Jquery spreadsheet but are running across some issues in terms of setting up for printing and/or exporting to PDF.

Currently, we let the user modify the spreadsheet to suit their needs.  The problem is there is no way to see page breaks at this time...that we know of.  The users stretch columns and row to suit their needs but the only way to see if they 'broke' across a page is to export to pdf to see...

We would like one or two options...

1. We know what our page size is - 8 1/2 x 11.  Is there a way to fix the max size of the spreadsheet so it's 1 page wide?  If the user inserts columns then the other columns just get smaller and smaller - proportionally - but ultimately the sheet is as only as wide as 1 page...

2. The ability to see where the page breaks are so they can set up the sheet correctly.

Please let me know if one of these options is feasible or are we stuck?

Thank you

Jeffrey Suffet

Hi team,

In kendo spreadsheet if you disable any row by adding enable property to false and apply sort from data tab, then the disable row is changing based on the sort. instead of applying to particular row  it is applying to perticular range and while sorting the row items are changing. The cell properties are not applying there while sorting.

link for example: https://dojo.telerik.com/IkoJeMIz

please let me know if I am doing anything wrong here.

thanks.

Hello,

Is is possible to trigger validation in cells in spreadsheet control? I want to make all validation controls with a button click outside the spreadsheet control.

Set Fixed Cols/Rows etc. or setOptions( {filter: { ref: "A3:G49", columns:[]}});

We are using the Kendo UI spreadsheet in a real-world website. We have a design team who are providing a visual design which fits in with our company's corporate standards.

HTML5 aims at separating styling from the layout design, which enables different teams to build the syle, with very little development experience, but more artistic experience.

For some reason, the Spreadsheet control can only be styled via the API (javascript code)! This means our design team needs to write their style in javascript, which is completely unrealistic.

It should be a fairly simple change to allow a range object to have a CSS class associated, and let HTML work like it should.

It would be useful if copy and paste the data have the option of fill the series or copy the value for the date format. 
Furthermore, copy from multiple column value and allow to paste multiple copied value from the spreadsheet will be added advantage. 

Thanks. 

I am working on a project where i am using KendoUI components. I have to show a financial sheet. All formulas are working fine like SUM,INDIRECT etc. but IRR not working as expected.

Tested IRR formula outside my project and the same happened.

I need the way to get a user the opportunity to set the columns headers. Moreover, the columns headers should be saved separately from the main spreadsheet data.

Of course, the possible variant is to have two spreadsheets: the one – for the data, the second (with one row) – for the headers.

But the better way is to get a user the opportunity to set the spreadsheet columns headers.
It would be ideally if a user could change “A”, “B”, “C” for “ID”, “Product”, “Quantity” …
Not to have a first row for headers, but change the spreadsheet columns headers!
Moreover, we have the context menu on the columns headers and it is possible to add one more item “Edit” in it.