Unplanned
Last Updated: 18 Mar 2024 07:50 by Gaurav

Bug report
SpreadSheet does not apply borderBottom correctly for last row

Reproduction of the problem

Dojo - https://dojo.telerik.com/UGABAnoR

Current behavior
Border is applied at the first row for the next column

Expected/desired behavior

The border shall be applied at the bottom at A2000


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

Unplanned
Last Updated: 18 Mar 2024 07:45 by Peili
Created by: Peili
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

When values are pasted in the Spreadsheet if the cell is not empty the previous format is taken into account

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/@NeliK/IniJunuZ
  2. Paste content that contains different formats such as dates and numbers (sample file attached)
    test_format.xlsx
  3. Paste the content two times as the second time the number column should be pasted over the column that has dates

Current behavior

The number column is formatted as date - screencast(https://somup.com/cZeoodChyH)

Expected/desired behavior

The current format should be applied to the pasted data.

Environment

  • Kendo UI version: 2024.1.130
  • Browser: [all ]
Unplanned
Last Updated: 07 Mar 2024 12:30 by Steven

Bug report

The computed range when pasting data into the spreadsheet is incorrect.



Reproduction of the problem

Dojo: https://dojo.telerik.com/eToXOQOL/9

1. Open a Notepad, and create the following structure:

a
b[tab]c[tab]d
e[tab]f[tab]g

Between each element on rows 2 and 3, there is a [tab] character. This will make sure that the data pasted into Spreadsheet will land on different columns.

 2. Copy the entire content of the Notepad document and paste it in cell A1. After the paste operation, you will notice under the Spreadsheet component an output with the range that was passed to the change event.

Problem:
The computed range is A1:A3 while the expected value is A1:C3

Expected behaviour

The expected value is A1:C3

Environment
Kendo UI version: 2021.1.224 or newer
Browser: [all]

Unplanned
Last Updated: 06 Mar 2024 10:12 by Mohd
Created by: Mohd
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

Round Function from empty cell shows #VALUE! but in Excel, this shows 0

Reproduction of the problem

Open Dojo: https://dojo.telerik.com/aBOMoCOF

Paste in cell B1 the following formula: =ROUND(A1, 2)

The shown result is #VALUE!

In Excel the same formula returns 0

Expected/desired behavior

The shown value must be 0

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

Unplanned
Last Updated: 08 Jan 2024 09:09 by Anant

Bug report

In a Spreadsheet with date cell editor, the fr-CA culture does not work.

Reproduction of the problem

  1. Open this Dojo example - https://dojo.telerik.com/ogEvuTEf/6
  2. Open the editor for the date cell

Current behavior

The Calendar is empty

Expected/desired behavior

The Calendar should display the dates defined in the validation

Environment

  • Kendo UI version: 2023.3.1114
  • Browser: [all]
Unplanned
Last Updated: 24 Nov 2023 06:18 by Mohd

Bug report

When an Excel File that contains VLOOKUP and calculated columns is imported in Excel, this results to CIRCULAR value for the cells, although ther are no circular formulas in the file.

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/@NeliKondova/ApAGUkET
  2. Import the file - Demo.xlsx

Current behavior

The values in the Spreadsheet are imported as '#CIRCULAR' although there are no circular formulas.

When the VLOOKUP in cell L2 is deleted the values are imported as '#VALUE'

Expected/desired behavior

The values in the Excel file should be imported correctly.

Environment

  • Kendo UI version: 2023.3.1114
  • jQuery version: x.y
  • Browser: [all ]
Unplanned
Last Updated: 03 Oct 2023 04:55 by Indika Samarasekara (Manager - IT Infrastructure)
Created by: Indika Samarasekara (Manager - IT Infrastructure)
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

When the scale and layout setting of the machine is different than 100% the keyboard navigation does not work properly. The issue occurs with different scales on each machine. For example, on some machines, it could work with all scales, but on others, it may not work with a scale of 125% or 175%, even if this is the recommended value.

Reproduction of the problem

  1. Open the demos - https://demos.telerik.com/kendo-ui/spreadsheet/keyboard-navigation
  2. Set a scale different than 100% to the computer
    image

Note, that you may need to test with different scales to manage to replicate the issue.

  1. Using the arrow keys navigate to the last column of the Spreadsheet (AX)
  2. Go to the previous column (AW)
  3. Try to move up/down/left/right

Current behavior

The navigation does not work. The cell selection does not work or goes to a wrong cell.

https://somup.com/c06nQJBFmV

Expected/desired behavior

The Spreadsheet navigation should work with all screen scales.

Environment

  • Kendo UI version: 2023.2.829
  • Browser: [all ]
Unplanned
Last Updated: 27 Sep 2023 12:30 by Pravin

Bug report

Dropdownlist editor remains visible on scroll of the Scheduler

Reproduction of the problem

Dojo: https://dojo.telerik.com/iLusiHAm

Open the DropsDownList editor in B2 cell 

Scroll down the sceduler

Expected/desired behavior
DropsDownList editor shall close

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

Unplanned
Last Updated: 21 Sep 2023 12:34 by Pravin

Bug report

When exporting a Spreadsheet with a set background to a PDF file, some of its borders are not displayed.

Reproduction of the problem

  1. Open the following Dojo example - https://dojo.telerik.com/IZUhIDeV
  2. Export the Spreadsheet to PDF

Current behavior

Some borders of the Spreadsheet are missing in the exported PDF file.

Expected/desired behavior

All borders of the Spreadsheet should be displayed in the PDF file.

Environment

  • Kendo UI version: 2023.2.829
  • Browser: [all]
Unplanned
Last Updated: 05 Sep 2023 12:38 by ADMIN
Cell Highlight is getting Overlapped to the top and left cell of the current editing cell when "Freeze Panes" has been enabled. Working and Overlapping versions have been provided as Screenshots replicated in the Kendo UI Demo Page.
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: 15 Dec 2023 14:14 by ADMIN
Created by: John
Comments: 2
Category: Spreadsheet
Type: Bug Report
3

[Edited]

Bug report

After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.

Reproduction of the problem

  1. Open the Kendo UI Spreadsheet Overview
  2. Copy Data C7:D8 from Kendo Spreadsheet
  3. Paste data to MS Excel (used: Microsoft 365 MSO version 2309)
  4. Edit values in MS Excel.
  5. Copy from MS Excel
  6. Paste new values to a Kendo UI Spreadsheet.

Expected/desired behavior

The new values are not pasted back to the Kendo UI Spreadsheet.

Environment

  • Kendo UI version: 2023.3.1114
  • jQuery version: All Supported Versions
  • Browser: all
Unplanned
Last Updated: 27 Apr 2023 09:33 by EK

Bug report

In the Spreadsheet, if you freeze too many columns and then try to export to Excel, the file is corrupted.

If you reduce the number of columns in the example below, the issue does not occur.

Reproduction of the problem

  1. Open this example
  2. Click the frozen rows button
  3. Click the Export to Excel button

Current behavior

The exported file is corrupted and cannot be opened

Expected/desired behavior

The file should not be corrupted

Environment

  • Kendo UI version: 2023.1.314
  • Browser: [all]
Unplanned
Last Updated: 07 Apr 2023 13:25 by George
Created by: George
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

In Firefox with Windows 11, the Spreadsheet cannot be scrolled using the scrollbars.

Reproduction of the problem

  1. Open the Overview demo in Firefox on a machine that uses Windows 11
  2. Try to scroll vertically or horizontally.

Current behavior

The Spreadsheet cannot be scrolled through the scrollbars

Expected/desired behavior

The Spreadsheet should be scrolled through the scrollbars

Environment

  • Kendo UI version: 2023.1.314
  • Browser: [Firefox + Windows 11]
Unplanned
Last Updated: 02 Mar 2023 14:49 by Peili

Bug report

Spreadsheet: Improper copy paste to Excel when merged cells are present and one column in the merged cells range is hidden. If the column containing the first merged cell is hidden all the rows on that row will be shifted to the left.

Reproduction of the problem

  • Run the following Dojo;
  • Select Range A1:D3 (note that column B is hidden)
  • Press Ctrl + C;
  • In Excel workbook press Ctrl + P;

Current behaviour

After pasting, the merged cell consists of 4 cells, as expected, but the cell data is shifted to the left and the hidden column contains the cell data of the next column

Expected/desired behavior

The cells after the merged cell should not be shifted.

Environment

  • Kendo UI version: 2023.1.117
  • Browser: [all ]
Unplanned
Last Updated: 08 Mar 2023 08:16 by ADMIN
Created by: Sooty
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

To whom it may concern,

I am having a problem with the AGGREGATE function in the spreadsheet control. Cell H7 does not give me a value.

I have attached a dojo saved file, the tutorial documentation I was following (please see pages 4 & 5), a screenshot of the function in dojo and an excel file with the aggregate function working.

Thank you advance.

Unplanned
Last Updated: 09 Nov 2022 08:31 by ADMIN

Bug report

When the select() method is used in the Spreadsheet changing event wrong cell is selected.

Reproduction of the problem

  1. Open the dojo example
  2. Select a different cell, change its value, and press Enter

Current behavior

Changing event is fired, but the 'B3' cell is selected instead of the 'B2'

Expected/desired behavior

The correct cell should be selected when using the select method inside the Spreadsheet event handlers.

Environment

  • Kendo UI version: 2022.3.913
  • Browser: [all ]
Unplanned
Last Updated: 07 Jun 2022 13:26 by Jose

Bug report

When a border is applied and there are frozen rows/columns the border appears splitted with a white lin in the middle.

Reproduction of the problem

  1. Open the Dojo example.

Current behavior

The bottom border and the right border are split with a white line in the middle.

Expected/desired behavior

The border should appear entirely filled with the selected color.

Environment

  • Kendo UI version: 2022.2.510
  • Browser: [all ]
Unplanned
Last Updated: 19 May 2022 10:05 by George

Bug report

Hyperlinks in a Spreadsheet cell do not work mobile devices.

Reproduction of the problem

  1. Open this example on a mobile device - https://dojo.telerik.com/ahixOKep
  2. Try to click on the links in the Product column.

Current behavior

The link in the cell does not work.

Expected/desired behavior

The link should work

Environment

  • Kendo UI version: 2022.2.510
  • Browser: [all]
Unplanned
Last Updated: 29 Sep 2022 07:43 by ADMIN

Bug report

Spreadsheet doеs not allow selecting of multiple cells when opened on Microsoft Surface. It is also not possible to resize columns.

Reproduction of the problem

Issue 1

  1. Open the Spreadsheet Index demo on a Microsoft Surface device.
  2. Click in a cell and try to drag the selection to select multiple cells

Issue 2
In the Spreadsheet Index demo select a column. Try to place the mouse in between columns for the icon to be changed and to will be able to resize the column.

Current behavior

Currently, the selection in the Spreadsheet could not be expanded to multiple cells and the columns could not be resized when the Spreadsheet is used on a Microsoft Surface device.

Expected/desired behavior

The Spreadsheet should allow selecting multiple cells and resizing columns when opened on a Microsoft Surface device.

Environment

  • Kendo UI version: 2022.2.510
  • jQuery version: x.y
  • Browser: [all ]
1 2 3