Unplanned
Last Updated: 17 Jun 2021 15:15 by ADMIN

Hi there,

 

When a spreadsheet is linked to a datasource, if you leave a gap between previously entered rows and your new data, each cell edit creates a new item in the datasource with only the cell modified.

 

Here is the record after adding one cell.

 

and after adding another cell:

 

This is the state of the spreadsheet:

 

I managed to replicate this in dojo here: https://dojo.telerik.com/eRiHocar

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: 26 May 2021 09:33 by Naveen

Bug report

When you copy a formatted cell with value "0", pasting the content in the Spreadsheet results in an incorrect value in the formula input.

Reproduction of the problem

  1. Open the attached file in the Spreadsheet.
    CopyPaste-CellFormatIssue.xlsx
  2. Open the attached file in Excel.
  3. Copy the content from C3 to C5 and paste it in the Spreadsheet.

Current behavior

The value of the cells containing "-" are incorrectly changed to "-" in the formula bar.

Expected/desired behavior

The value of the cells containing "-" should remain "0" in the formula bar.

Environment

  • Kendo UI version: 2021.2.511
  • Browser: [all]
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]
Unplanned
Last Updated: 12 May 2021 13:54 by ADMIN


To reproduce
Steps to reproduce the behavior:

step1: Make a cell become wrap text and text something

 

step2: Export to pdf file:

 

Expected behavior
Text display same as on safari

Please fix this problem asap!!!.

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: 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: 07 Apr 2021 06:54 by Kenny

Bug report

Spreadsheet throws error when opening a xlsx file containing diagonal borders.

Reproduction of the problem

  1. Try to open a xlsx file, containing a cell with diagonal borders:
    image
    Sample File:
    DiagonalBorderTest.xlsx

Current behavior

Spreadsheet crashes and throws an error Uncaught TypeError: Cannot set property 'color' of undefined

Expected/desired behavior

The file should open.

Environment

  • Kendo UI version: 2021.1.330
  • Browser: [all]
Completed
Last Updated: 01 Mar 2021 07:04 by ADMIN
Release 2021.R1.SP.next

Bug report

Reproduction of the problem

Dojo example.

  1. Hide the second row.
  2. Slowly scroll the Spreadsheet horizontally (left and right).

Current behavior

Column lines disappear and row lines appear (columns G, M, N, O). In Chrome values disappear as well, observe the value in column F. The configuration options required for reproducing the behavior are mergedCells and frozenRows.

Expected/desired behavior

No changes to the column/row lines and no disappearing values on scrolling.

Environment

  • Kendo UI version: 2021.1.119
  • jQuery version: x.y
  • Browser: [all ]
Completed
Last Updated: 03 Feb 2021 14:44 by ADMIN
Release 2021.R1.SP.next
Created by: Kocsis
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

Custom validation error can not be handled in spreadsheet

Reproduction of the problem

https://dojo.telerik.com/@zdravkov/uJuruCod
go to Data->Data Validation->Custom Formula (Ignore blank, Reject input),
open the console,
than if you enter an invalid formula (<4, >A3 or something like this) and press Apply, in the console you can see an exception

Current behavior

The exception can't be handled

Expected/desired behavior

One should be able to handle the exception

workaround - https://dojo.telerik.com/@zdravkov/adEWOlOk

Environment

  • **Kendo UI version: 2021.1.119
Completed
Last Updated: 28 Jan 2021 15:05 by ADMIN
Release 2021.R1.SP.next

Bug report

Reproduction of the problem

Use the Events demo to reproduce, since the events are logged in the console: https://demos.telerik.com/kendo-ui/spreadsheet/events

  1. Add a new sheet
  2. Drag left the newly added sheet, to make it first
  3. Click "Invoice", hold down the mouse button and drag the Invoice sheet back to first place

Current behavior

The Invoice sheet is selected but the selectSheet event does not fire.

Expected/desired behavior

The selectSheet event fires

Environment

  • Kendo UI version: 2020.2.617
  • jQuery version: x.y
  • Browser: [all]
Completed
Last Updated: 25 Jan 2021 09:52 by ADMIN
Release 2021.R1.SP.next
Created by: Ramesh
Comments: 0
Category: Spreadsheet
Type: Bug Report
2

Bug report

Reproduction of the problem

Dojo example.

  1. Change a value in the second column, for example change 8 to 7.
  2. Open the column filter menu. The filter menu properly shows the current values (5 and 7).
  3. Close the filter menu and change the cell value again.
  4. Open the column filter menu.

Current behavior

After the initial value change the filter menu no longer shows the current value of the modified cell.

Expected/desired behavior

The filter menu should always show the current values of the cells.

Environment

  • Kendo UI version: 2020.3.1118
  • jQuery version: x.y
  • Browser: [all]
Completed
Last Updated: 18 Jan 2021 09:09 by ADMIN
Release 2021.R1
Created by: Softwarehouse
Comments: 0
Category: Spreadsheet
Type: Bug Report
3

Bug report

Values that are copied from Spreadsheet are duplicated when pasted in Excel if before that the copied cells have been cut and pasted inside the Spreadsheet.

Reproduction of the problem

  1. Open this Dojo project
  2. Cut B3:C3
  3. Paste the copied content to A1:B1
  4. Copy A1:B2
  5. Paste to Excel

Current behavior

In Excel, the first row is duplicated and the pasted content contains 3 rows, while 2 rows are copied

Expected/desired behavior

The pasted in Excel content should contain 2 rows instead of 3

Environment

  • Kendo UI version: 2020.3.1021
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 11 Jan 2021 16:10 by pradeep

Bug report

The Spreadsheet SLOPE and INTERCEPT functions do not calculate if arrays passed as parameters contain blank or string cells

Reproduction of the problem

  1. Run this dojo

Current behavior

  1. Note that cell B3, B4, and B5 return errors as a result of the calculation
  2. Same data passed to the SLOPE and INTERCEPT functions in Excel returns a valid result

Expected/desired behavior

Calculation of the SLOPE and INTERCEPT functions should be consistent with Excel

Environment

  • Kendo UI version: 2020.3.118
  • Browser: [all]
Completed
Last Updated: 07 Jan 2021 09:30 by ADMIN

Bug report

cell connection in Spreadsheet is not working when the sheet contains 1.0 in the name

Reproduction of the problem

download the file from ticket - 1500102
open our demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
open the file from the ticket in the Kendo Spreadsheet

Current behavior

cell F17 is not connected with cell B12 from the second sheet

Expected/desired behavior

cell F17 is connected with cell B12 from the second sheet

note: if the name of the sheet is changed to something different than 1.00 for example 'A' the cells are connected

Environment

  • **Kendo UI version:2020.3.1118
Unplanned
Last Updated: 05 Jan 2021 07:40 by ADMIN

Bug report

when the color of the borderBottom is commented

  "borderBottom": {
                            //"color": "black",

js error when color is not applied a cell of the Spreadsheet

kendo.all.js:61278 Uncaught TypeError: e.transform is not a function

Reproduction of the problem

https://dojo.telerik.com/@zdravkov/iVoJuxAZ
export to pdf

Current behavior

js error

Expected/desired behavior

the data is exported correctly

Environment

  • **Kendo UI version: 2020.3.1118
Unplanned
Last Updated: 17 Dec 2020 16:40 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

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 ]
Unplanned
Last Updated: 27 Nov 2020 09:11 by ANDREY
Created by: ANDREY
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

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 ]
Unplanned
Last Updated: 23 Nov 2020 14:13 by n/a

Bug report

When importing from Excel in Spreadsheet if a date is entered, but the date format is not set explicitly, the imported date always has the following format: "mm-dd-yy". The issue is observed even if a culture is set.

Reproduction of the problem

  1. Open the Dojo example
  2. Import the following file
    DateFormat.xlsx

Current behavior

The value in Excel is "15.6.2020" , but the imported date in the Spreadsheet is "05-15-20" screencast

Expected/desired behavior

The format of the dates should be the same as in the imported file.

Environment

  • Kendo UI version: 2020.3.1118
  • 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]
1 2 3 4