Hi Team,

I have getting warning message when open down loaded excel file . This warning is coming if we apply conditional formatting in kendo spreadsheet .Please 

check the URL

https://dojo.telerik.com/

Bug report

The wrap text tool hides some of the cell's text if it is too long.

Reproduction of the problem

Go to this Dojo. Select cell A1 and toggle the wrap text tool. The beginning of the text is not displayed.

Current behavior

Part of the cell's content is hidden.

Expected/desired behavior

All the text should be visible.

Environment

• Kendo UI version: 2019.3.1023
• Browser: [all]

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.

Hi,

I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).

When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.

Editing an empty row above this new row will modify one of the records created in this process.

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.

Can you add feature or set option to allow text to run into adjacent cells to right? 

(example in ticket 1500102)

Hello,

I have some problems with setting up correct Cell Validation for my use-case. I want to create a list validation which is going to have a numeric options instead of typical string values.

So in order to achieve that I created a following cell validation:

{
    dataType: "list",
    showButton: true,
    comparerType: "list",
    from: '{1,2,3,4,5}',
    allowNulls: true,
    type: "reject"
}

Everything works fine in the widget, but the problems starts when I want to Export the following spreadsheet to Excel format. I'm getting the following message when trying to open such file:

In the past I had a similar problem with the list validation (but for string values) (https://www.telerik.com/account/support-tickets/view-ticket/1381434)

There you suggested to create a validation using different format for "from" property. So I decided to change it from:

from: '{1,2,3,4,5}',

to

from: '"1,2,3,4,5"',

After that I can freely export the spreadsheet without any problems, but then my list is inserting string values instead of numeric ones, therefore this solution is not suitable for my use-case.


And my question is: Is there a possibility to create a Cell validation where I can put numeric values as a possible options without breaking the export process? 

Here's a example spreadsheet, which I used to reproduce this behavior: https://dojo.telerik.com/IfuMIbic

Best regards,

can add float object container ? eg:charts

Bug report

Reproduction of the problem

Reproducible in the demos. The attached video demonstrates the issue.
Recording49.zip

1. Reduce to minimum the width of several adjacent columns
2. Increase the width of one of them

Current behavior

As shown in the video, the F column completely disappears. The column letter remains visible within the next column (G). F column's resize handle remains hidden, and it cannot be made visible.

Expected/desired behavior

There should be a minimum column width that should be respected on resizing. Its value should always allow the column to be resized. No column overlapping should occur.

Environment

• Kendo UI version: 2020.3.1118
• jQuery version: x.y
• Browser: [Chrome 87 ]

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

Dear Concerned,

1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Select column B and drag mouse towards C, both columns will be selected which is correct behavior

3. Now just scroll down 2-3 rows using vertical scroll bar

4. Repeat step 2, this time it does not select B &  C, instead it selects B,C,D,E.

5. Seems a bug, not an expected behavior.

Observation that might help you in fixing it:

1. if you move scroll bar in such a way so that no merged cell is visible it works well, e.g. scroll down till 20th row becomes first visible row on screen and now repeat step 2, it will work

2. if scroll position is on top then behavior is correct as well

3. Same issue exists in case of multiple row selection with merged column and scroll position.

This is observed also in online demos:

• https://demos.telerik.com/kendo-ui/spreadsheet/index

Steps:

1. Open demo
2. Edit a cell and enter text
3. Press Alt+Enter and enter more text
4. Press Alt+Enter
   
   Result: the last letter of the row is transferred to the new row

Bug report

Memory usage is increased if the DevTools is open. Navigation between sheets is also slower.

Reproduction of the problem

1. Open our Spreadsheet demo in Chrome.
2. Import the attached Spreadsheet.
3. Open the Task Manager to check Chrome memory usage, and switch sheets to see the navigation speed.
4. Open DevTools and check memory usage again. Note that switching sheets is also significantly slower.

Current behavior

Memory usage increased and slower sheet change.

Expected/desired behavior

Memory usage should not be increased and sheet navigation should not be slow.

Environment

• Kendo UI version: 2020.2.619
• Browser: [all]

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.

Bug report

When using a custom cell editor in the Spreadsheet along with keyboard navigation value selection is not limited to the cell with the custom cell editor

Reproduction of the problem

1. Run the Custom Editors Demo
2. Click on cell B2 and open the list popup with available values for selection
3. Press the right arrow key on the keyboard
4. Select a value from the list
5. The selected value will be applied to cell C2

Current behavior

The selected value is applied to cell other then the one using the custom cell editor

Expected/desired behavior

The selected value should be applied only to the cell with the custom cell editor

Environment

• Kendo UI version: 2020.2.617
• Browser: [all]

Bug report

Reproduction of the problem

Reproducible in this demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource

1. Scroll down to row 78
2. Focus A78 and drag to E78. Copy the data
3. Paste over the empty 79 row's first cell
4. Press Ctrl + Z to undo the changes.
5. Open the browser's dev tools network tab and press the "Save" button above the Spreadsheet.

Current behavior

The data cleared by the "undo" shortcut is saved and sent to the server

A different behavior is exhibited if the data is pasted over the row header instead of the row's first cell. Follow the same steps, but on step 3. instead of pasting over the first cell, paste the data over the row 79 header. After undo and then clicking "Save", the fields have null values.

Expected/desired behavior

No data is sent with the request

Environment

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

Bug report

Related To: #5500

When there are merged cells and the SUM formula is used for the merged cells the result is wrong (it depends on the count of the merged cells)

Reproduction of the problem

1. Open the Dojo
2. Enter for example 5 in the merged cells (A1:B2)

Current behavior

The result in the D1 cell is 20. ( value of cell * count of cells in merged range)

Expected/desired behavior

The result should be 5. In the same scenario, the result in Excel will be 5.

Environment

• Kendo UI version: 2020.3.1118
• Browser: [all ]

In Excel it is possible to select several rows and increase/decrease all selected rows height. In the Spreadsheet this works only for the last selected row. The following steps demonstrate the behavior:

1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Click on the header of row 6, hold and drag until rows 6, 7, 8, 9 , 10 are selected.

3. Click the handle below row 10's header and drag to increase the height of the rows. The Spreadsheet increases only the last row's height.