Unplanned
Last Updated: 30 Aug 2019 04:59 by ADMIN

Bug report

Reproduction of the problem

Reproducible in the demos.

  1. Use the HYPERLINK function in a cell:

=HYPERLINK("https://google.com")

Current behavior

The link does not work. It does if you specify a "friendly name":
=HYPERLINK("https://google.com", "google")

Expected/desired behavior

The link works with and without a "friendly name" specified, as in Excel.

Environment

  • Kendo UI version: 2019.2.619
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 25 Dec 2019 06:16 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
7

Bug report

Office 365 Comment are shown with a warning:
"[Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Reproduction of the problem

go to demo - https://demos.telerik.com/kendo-ui/spreadsheet/index

Current behavior

import a file from ticket - 1447268

A warning is displayed

Expected/desired behavior

No warning is displayed

Environment

  • **Kendo UI version: 2019.3.1023
Unplanned
Last Updated: 27 Aug 2024 20:21 by Shivam
Created by: Shivam
Comments: 0
Category: Spreadsheet
Type: Bug Report
3

Bug report

When trying to import an Excel document into the Kendo UI Spreadsheet with a missing/corrupt image reference, the file will not show.

Reproduction of the problem

  1. Import an XLSX file with a corrupted image into the Kendo UI Spreadsheet demo. (See ticket 1661911 for an example document)

Current behavior

The Kendo UI Spreadsheet fails to load the document.

Expected/desired behavior

The Kendo UI Spreadsheet should handle the error and load the Spreadsheet data without the image.

Environment

Unplanned
Last Updated: 09 Jan 2025 07:31 by Faraz

Describe the bug
When a custom editor is defined and next to it there is a frozen column, the custom editor cannot be opened.

To reproduce
Steps to reproduce the behavior:

  1. Go to 'Dojo'
  2. Click in cell B1
  3. Try to open the calendar

Expected behavior
The calendar should be opened

Workaround

.k-spreadsheet .k-selection-wrapper .k-spreadsheet-editor-button.k-spreadsheet-last-column {
        transform: translateX(-100%);
}

The issue is a regression starting with themes version 6.3.0

Affected package (please remove the unneeded items)

  • theme-default
  • theme-bootstrap
  • theme-material
  • theme-tasks

Affected suites (please remove the unneeded items)

  • Kendo UI for jQuery

Affected browsers (please remove the unneeded items)

  • All
Unplanned
Last Updated: 17 Jan 2020 13:39 by ADMIN

Bug report

Reproduction of the problem

Dojo example.

Current behavior

The first row is duplicated.

Expected/desired behavior

The first row is not duplicated

Environment

  • Kendo UI version: 2019.3.1023
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 10 Mar 2020 09:51 by Naveen

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.

MicrosoftTeams-image

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]
Unplanned
Last Updated: 14 Jul 2020 07:25 by Naveen

Bug report

The AND formula, when used as part of an array formula, does not evaluate the whole array.

{=AND(A1:D1="")} would return TRUE if a value is entered in the range B1:D1 and FALSE only if value is entered in A1
=IF(AND(A1="",B1="",C1="",D1=""),TRUE,FALSE) would return FALSE if value is entered in any cell in range A1:D1

Reproduction of the problem

  1. Run this dojo
  2. Select cell E1, press F2 to edit formula and press Ctrl+Shift+Enter to enter as an array formula

Current behavior

  1. Enter a value in cell B1 - Array formula evaluates as TRUE, Non-array formula as FALSE
  2. Only if a value is entered in A1 the Array formula will evaluate as FALSE

Expected/desired behavior

Array formula should be evaluated correctly and return FALSE when a value is entered in any cell in range A1:D1.

Environment

  • Kendo UI version: 2020.2.617
  • Browser: [all]
Unplanned
Last Updated: 11 Nov 2020 15:49 by ADMIN

Bug report

Reproduction of the problem

Dojo example.

  1. Click column "B"'s header to select the column.
  2. Use the "Wrap text" tool from the toolbar. The text in B2 is wrapped.
  3. While the column is still selected, use the "Wrap text" tool again.

Current behavior

The text in B2 is not unwrapped.

The merged cell prevents the unwrap. If there is no merged cell, or if the tool is used over the cell itself, wrapping/unwrapping works as expected.

Expected/desired behavior

The text in B2 is unwrapped.

Environment

  • Kendo UI version: 2020.3.1021
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 18 Jul 2023 09:15 by Naveen

Bug report

YEAR, MONTH and DATE functions do not return the same value on a black cell as in MS Excel

Reproduction of the problem

Apply the Year, Month or Date functions on any blank cell, it returns #VALUE!, where as Excel returns the respective value. 

Environment
Kendo UI version: [all]
Browser: [all]

Unplanned
Last Updated: 13 Feb 2019 15:07 by ADMIN

Hello there,

I am developing a Web application using  Kendo UI Spreadsheet control, but I noticed that when I copy some numbers from a Excel sheet to the spreadsheet and then copy back to Excel, the decimal values are quite different, I mean, the decimal precision has been affected.

For example:

I have the following numbers on a Excel sheet:

10.50.3333333330.250.20.1666670.1428570.1250.1111110.10.0909090.0833330.0769230.0714290.0666670.06250.0588240.0555560.052632

Then, I copy them to the Kendo spreadsheet and I got the following:

100.00%50.00%33.33%25.00%20.00%16.67%14.29%12.50%11.11%10.00%9.09%8.33%7.69%7.14%6.67%6.25%5.88%5.56%5.26%

But when I copy them back to Excel I got this:

10.50.33330.250.20.16670.14290.1250.11110.10.09090.08330.07690.07140.06670.06250.05880.05560.0526

Losing many decimals affecting the results of my computation and calculation.

Can you tell me why is this happening?

Thank you some much.

 

 

 

Unplanned
Last Updated: 27 May 2021 09:10 by ADMIN
Created by: Sandeep
Comments: 8
Category: Spreadsheet
Type: Bug Report
1

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/

Unplanned
Last Updated: 20 Nov 2019 07:50 by ADMIN

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]
Unplanned
Last Updated: 26 Feb 2020 15:07 by ADMIN
Created by: Sandeep
Comments: 3
Category: Spreadsheet
Type: Bug Report
1

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.

Unplanned
Last Updated: 22 Jan 2020 11:53 by ADMIN

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.

Unplanned
Last Updated: 24 Jan 2020 13:28 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
1
Dear Concerned,

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

2. Move horizontal scroller to column P

3. Now select Row 1 header, then row 2 header and keep doing it

4. Please observe horizontal scroller is also moving towards left

I assume it is a bug and need a fix. Meanwhile if you can provide a workaround for the same if possible.

Note: Similar behavior can be noted for vertical scroller on column header selection
Unplanned
Last Updated: 22 Jun 2020 18:18 by Vamsi
Created by: Vamsi
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

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]
Unplanned
Last Updated: 06 Aug 2020 08:18 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

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]
Unplanned
Last Updated: 12 Apr 2021 09:53 by ADMIN
Created by: Sandeep
Comments: 1
Category: Spreadsheet
Type: Bug Report
1

Hi Team,

 

When I add comments to enabled columns(product)it is allowing me to add and after reopening the comments it is retained. But when I add comments to disabled columns(ID) it is not adding to it and no messages are added like it is disabled and comments are not allowed.

demo: https://dojo.telerik.com/ISIvATiN

thanks.

Unplanned
Last Updated: 12 Apr 2021 13:24 by Sandeep

Describe the bug

To reproduce
Steps to reproduce the behavior:

  1. Go to https://dojo.telerik.com/avuXEJUV/2
  2. Scroll the Spreadsheet horizontally to the "J" column.
  3. Click the header of the "J" column to select it.
  4. Activate the "Freeze Panes" tool from the toolbar.
  5. The Spreadsheet re-renders. The scroll bar does not scroll the columns past "G". A browser scrollbar appears. Use it to scroll horizontally beyond the right border of the Spreadsheet. Some of the columns are displayed outside the Spreadsheet. Once they are visible, scroll horizontally to the far right using the Spreadsheet scrollbar. Column A is duplicated after column AX.

Expected behavior
The panes are frozen without breaking the layout of the Spreadsheet and without cells/column duplication.

Affected package (please remove the unneeded items)

  • theme-default
  • theme-bootstrap
  • theme-material

Affected suites (please remove the unneeded items)

  • Kendo UI for jQuery

Affected browsers (please remove the unneeded items)

  • All

Build system information (please remove the unneeded items)

  • Not Applicable

Additional context
Add any other context about the bug.

Unplanned
Last Updated: 17 May 2021 06:25 by serge

Bug report

When the Sheetsbar is hidden the horizontal scrollbar is not adjusted to the bottom of the widget

Reproduction of the problem

  1. Run this dojo
  2. Note the space below the horizontal scrollbar:
    image

Expected/desired behavior

The horizontal scrollbar should be adjusted to the bottom of the widget.

As a possible workaround, when hiding the Sheetsbar add the following styling:

<style>
    .k-spreadsheet-sheets-bar {
      padding: 0;
      border-style: none;
    }
</style>

Environment

  • Kendo UI version: 2021.2.511
  • Browser: [all]
1 2 3