Completed
Last Updated: 17 Oct 2019 11:54 by ADMIN
Created by: Andrew
Comments: 4
Category: Spreadsheet
Type: Bug Report
0

I am using kendo spreadsheet binding to a datasource... very similar to the demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource

Is there a way to add a two row header while binding to a data source?  For example, my first row would be a merged cell spanning all columns and would contain some text.  I can see how to do two row headers and to merge cells.. but it doesn't work when the spreadsheet is bound to a datasource as it starts the data in row 2.... where I want row 2 to be my actual field name headers.  I don't see any options to fix that.

If there is no way to do that... is there a way to alter my header style?  For example, I want a column header to be

MY FIELD NAME HERE
additional text (smaller font and color)

I know in kendo grid there is headerTemplate... but this doesn't seem to be available in kendo spreadsheet.

Thank you.

 

In Development
Last Updated: 17 Oct 2019 10:57 by ADMIN
Scheduled for 2019.R3.SP.next

Dear Concerned,

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

2. Copy from F3:F15

3. Paste as value (ctrl+shift+v) in H3

4. See it pasted only non-empty cells

Empty cells values should be pasted as well as Excel does.

 

Pending Review
Last Updated: 10 Oct 2019 07:35 by ADMIN
Created by: Anna
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

The spreadsheet widget has no Polish localization.

Feel free to use those: https://github.com/telerik/kendo-ui-core/pull/5310

Completed
Last Updated: 10 Oct 2019 07:24 by ADMIN
Release 2019.R3.SP.next
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

Dear Concerned,

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

2. Click Background or Text Color icon , select custom color

3. See the popup UI , there is boarder and margin issues, boarder is visible on top,left & bottom side but not on right side

Pending Review
Last Updated: 08 Oct 2019 09:43 by Rubén
### Bug report
The Ctrl + Shift + Arrow key keyboard shortcut should select a range in the row/column starting with the active cell and ending with the first cell in the row/column that has a value: [list of shortcuts](https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/end-user/list-of-shortcuts) used by the Spreadsheet. It works similarly in Excel. 


### Current behavior
The selection does not end at the first cell that has a value, it ends with the last cell of the row/column.  

### Expected/desired behavior
The expected behavior should be as described in the documentation: "Extends the selection of cells to the last nonblank cell in the same row or column as the active cell."

### Environment

* **Kendo UI version:** 2018.2.620
* **Browser:** [all ] 

Approved
Last Updated: 08 Oct 2019 06:53 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
Dear Concerned,

1. Open https://dojo.telerik.com/IjasAbeC/11

2. Check split button is not prefixed with a separator, where as all other buttons comes with prefixed separator

It seems a bug, please provide a fix.
Approved
Last Updated: 07 Oct 2019 11:33 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
1
1. Open https://dojo.telerik.com/IjasAbeC/3

2. Background color and text color buttons are initialized as a group. These buttons are not working if we put them in a group

3. If we keep them separate, outside group, the buttons work as expected.
Approved
Last Updated: 27 Sep 2019 17:56 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
1

Bug report

Reproducible with the Default and Bootstrap SASS themes.

Reproduction of the problem

Reproducible in the demos.

  1. Resize the browser window making it more narrow (screencast)

Current behavior

Icons are misaligned.

Expected/desired behavior

Icons are properly aligned.

Environment

  • Kendo UI version: 2019.3.917
  • jQuery version: x.y
  • Browser: [all]
Approved
Last Updated: 06 Sep 2019 07:33 by ADMIN

When using IE 11 and using Ctrl+X to cut, this only works the first time. All subsequent attempts to use cut produce the following dialog:

Completed
Last Updated: 02 Sep 2019 09:38 by ADMIN
Release 2019.R3

Bug report

When a cell/row is selected, its first cell is focused and the sheet is scrolled to show it. If a long sheet is scrolled down/right to edit cells, this scroll top/left is very annoying and user unfriendly.
In these scenarios Excel focuses the topmost/leftmost currently visible cell, avoiding sheet scrolling.

Reproduction of the problem

  1. Go to https://demos.telerik.com/kendo-ui/spreadsheet/index
  2. Scroll to the bottom row of Spreadsheet's sheet.
  3. Click in cell B200 to select it.
  4. Click on the header of column C to select the whole column.

NOTE: for rows reproduction select cell AX2, then click on the header of row 2 - sheet is scrolled to the left and cell A2 is focused.

Current behavior

Column C is selected, cell C1 is focused and the sheet is scrolled to top.
The used has to scroll down to the bottom row again to edit data at the bottom of the sheet.

Expected/desired behavior

Column C is selected. The currently visible topmost cell of column C is focused, without scrolling the sheet. Excel works that way

Environment

  • Kendo UI version: 2019.2.619
  • Browser: all
Approved
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]
Approved
Last Updated: 25 Jul 2019 13:04 by ADMIN

Bug report

The current client-side export functionality does not preserve the number of columns.

Reproduction of the problem

  • Load the following file in the Spreadsheet which contains columns up to "BA".

  • Export the file

  • Load the file again in the Spreadsheet and notice that the columns are displayed up to "AX" instead of "BA".

Current behavior

Client-side export does not preserve the number of columns greater than "AX".

Expected/desired behavior

Client-side export does not preserve the exact number of columns.

Environment

  • Kendo UI version: 2019.2.619
  • Browser: [all]
Completed
Last Updated: 01 Jul 2019 10:47 by ADMIN

Bug report

Client-side exported Excel workbooks are exported "uncompressed" (as readable text) and their size is much greater than the original document.

Regression since R2 2019 - 2019.2.514

Reproduction of the problem

  1. Go to https://demos.telerik.com/kendo-ui/spreadsheet/index
  2. Open the following file in Spreadsheet -
    Workbook Original.xlsx - 26 KB
  3. Export the file to Excel

Current behavior

The exported file is 1015 KB in size. The content of the file may be read as plain text
image

Expected/desired behavior

The exported file is 26 KB or similar size. The content of the file is unreadable binary data
image

Environment

  • Kendo UI version: 2019.2.619
  • Browser: all
Approved
Last Updated: 18 Jun 2019 09:30 by Steven

Bug report

When a string, used as old_text for SUBSTITUTE(text, old_text, new_text, [instance_num]) function, is repeated more than once and the new_text is an empty string, one occurrence of the old_text remains not substituted.

Reproduction of the problem

  1. Go to Spreadsheet Basic usage demo
  2. Add a new sheet
  3. Type ab113abababab11ab in A1
  4. Enter the following formula in B1 =SUBSTITUTE(A1, "ab", "")

NOTE: substituting ab with another string, e.g. cd, replaces all instances of ab as expected.

Current behavior

113ab11 - when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string

Expected/desired behavior

11311

Environment

  • Kendo UI version: 2019.2.514
  • Browser: all
Completed
Last Updated: 10 Jun 2019 07:15 by ADMIN
Release 2019.R2.SP.Next

Bug report

The performance in the latest official version is significantly worse compared to older versions (2017.1.117 and 2018.1.118 tested).

Reproduction of the problem

Dojo example.

  1. Click a cell
  2. Press Ctrl + A
  3. Select a font size from the dropdown in the Spreadsheet's toolbar

Current behavior

The UI freezes and remains unresponsive for minutes.

Expected/desired behavior

The new font size is applied without significant delay.

Environment

  • Kendo UI version: 2019.2.514
  • jQuery version: x.y
  • Browser: [all]
Pending Review
Last Updated: 04 Jun 2019 15:32 by ADMIN
Created by: CCAC
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

Spreadsheet saveAsExcel split is not a function error (kendo.all.js:3436) after upgrade to Kendo 2019.2.514.

Approved
Last Updated: 31 May 2019 12:35 by Paul

Bug report

When destroying a SpreadSheet and removing its corresponding DOM element, there are some DOM nodes added on SpreadSheet's initialization which are not removed after the execution of .destroy() and .remove().

Reproduction of the problem

  1. Open this Dojo and run it.
  2. Open browser's console and see the output in it. The initial number of the children nodes in the body is 2 and the children nodes after adding and removing a SpreadSheet are 5.
    Nodes_count
  3. Right-click the blank page in right and inspect it. Navigate to the body in the iframe and see the additional nodes in it
    Nodes_count_body

Current behavior

Not all DOM elements added on SpreadSheet initialization are being removed when destroying it and removing its corresponding DOM element.

Expected/desired behavior

After destroying a SpreadSheet and removing its corresponding DOM element, no DOM nodes added on component's initialization should be presented in the DOM tree.

Environment

  • Kendo UI version: 2019.2.514
  • jQuery version: x.y
  • Browser: [all]
Completed
Last Updated: 21 May 2019 12:23 by ADMIN
Release 2019.R2.SP.Next
Created by: Ricardo
Comments: 1
Category: Spreadsheet
Type: Bug Report
0
Hello!

We find a formatting problem, when we have a relatively small result, for example (0.05%) the referring component on the screen gives a strange value (-,05%) as shown in the image below.

We want to know if you can help us with this.

Thank you.
Completed
Last Updated: 21 May 2019 09:09 by ADMIN
Release 2019.R2.SP.Next

Bug report

When pasting data from Excel, the data is being pasted as an image instead of values

Reproduction of the problem

  1. Open https://dojo.telerik.com/UKAFAkEn
  2. Open new Excel file on your system in MS Excel application
  3. Enter data 1, 2, 3, 4, 5 in A1 to A5 in sheet1
  4. Copy data from A1 to A5 from the local file
  5. Paste data in C3 of Spreadsheet opened in step 1
  6. The pasted result is an image instead of values

Current behavior

Pasting from Excel results in an image
spreadsheet_paste

Expected/desired behavior

Pasting from Excel should result in correctly filled data cells
spreadsheet_paste1

Environment

  • Kendo UI version: 2019.2.514
  • jQuery version: x.y
  • Browser: [Chrome 74.0.3729.131 | Firefox 66.0.5 | Edge 42.17134.1.0 ]
Approved
Last Updated: 16 May 2019 08:04 by n/a
Created by: n/a
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

File:
3f0465a2-412c-4876-ba47-4b12ae46f92e_adam.zip

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

Reproduction of the problem

  1. Import the file

Current behavior

Errors are encountered. Even if resolving the errors bold styles are not applied as they are part of the font definition and not of the inlineStyles.

Expected/desired behavior

The excel is imported as expected.

Environment

  • Kendo UI version: 2019.2.514
  • Browser: all
1 2