Completed
Last Updated: 02 Dec 2021 13:38 by ADMIN
Release 2021.R3.SP.next

In Excel I can create a merged cell. For this example, I will merge A1:B1 and name the range MyCell.  Next I name the single cell D5, and call it MyAnswer.  I can enter the following formula into MyAnswer, =MyCell and Excel will return the result.

Using Telerik if I create the same layout I get a #Value or #Spill error because Telerik requires MyAnswer to be the same merge configuration as MyCell which creates a significant disadvantage in usability.

Can you please advise when this issue will be fixed in Telerik.

I have attached a screen recording of this not working in your Dojo named "Telerik merge cell reference not working when not same col.mov".

Thank you so much.

Completed
Last Updated: 02 Dec 2021 12:31 by ADMIN
Release 2021.R1.SP1
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 ]
Planned
Last Updated: 01 Nov 2021 14:07 by ADMIN
Created by: Chris
Comments: 2
Category: Spreadsheet
Type: Bug Report
0

Hi

We have noticed that spreadsheet filter box (click on filter down arrow) didnt appear when clicked on certain environment (win10, surface pro 7), but works on others.

What happens is you click the down arrow, a scroll bar appears on rhs, which i think is suggesting the popup has positioned soemwhere off visible area.

This happens in each browser - edge (94.0.992.50 ), chrome (95.0.4638.54 ) and firefox (93.0). Plug ins disabled.   Windows 10.0.19043

 

Wondered if about high res screens or display settings?

 

Recreated with kendo demo 

https://dojo.telerik.com/aruPOzEx

 

then tried each kendo version going back in time, and basically version 2020 R2 SP1 it worked (see attached working.. shot), and anything since it fails. 

In the shots i am clicking on company filter arrow.   the failversion-before is before i click, failversion-after is after click - where you can see extra vertical scrollbar

 

Regards

Chris

Unplanned
Last Updated: 27 Oct 2021 10:46 by ADMIN

Hello,

When spreadsheet cells are merged and have comment, it's shown only when hovering over first cell and not shown when hovering over other cells of the merged group of cells

Example to reproduce on dojo - https://dojo.telerik.com/@Andrii/uHINuvIh

On the cell A1 there is a comment, merged cells are A1:G1, comment is shown only when hover over cell A1.

Pending Review
Last Updated: 15 Oct 2021 14:00 by Florian

### Bug report

When the property "useCultureDecimals" is enabled in a culture where the decimal separator is the comma, the function Text() does not format numbers correctly.

### Reproduction of the problem

1. Set a culture where the decimal separator is the comma (i.e. "da-DK");

2. Create a Spreadsheet and enable the property "useCultureDecimals";

3. Enter a number with a decimal separator comma (i.e. "0,1141");

4. Format the cell by using the Text() function ( =TEXT(A1; "##0,00%") );

5. The number is not formatted properly - "011%"

A Dojo sample for reproduction: https://dojo.telerik.com/AsiLiKil/12


### Expected/desired behavior
"0,1141" should be formatted as "11,41%" as in Excel.

### Environment

* **Kendo UI version: 2021.3.914
* **jQuery version: 1.12.4
* **Browser: [all]

Completed
Last Updated: 08 Oct 2021 06:58 by ADMIN
Release R3.2021.SP.next
Created by: Darin
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

In my application I am using the following. 

kendo.ns="kendo-";

Dojo example: https://dojo.telerik.com/@iankodj/aKIyEwUv 

The spreadsheet component works well with the namespace, however any dialogs that the component opens do not function correctly.

For example, I am using Edge browser. If I copy a cell and they try and past the value via the context menu, a dialog appears telling me to use the keyboard.

The "ok" button of the dialog does not work. Looking at the html source that is added to the DOM, it appears that the button is trying to bind to the click event via a "data-bind" attribute rather than a "data-kendo-bind" attribute as specified via the namespace.

The attached file show the behavior with the Basic demo example having the kendo namespace set.

Thanks,

Darin

Unplanned
Last Updated: 06 Oct 2021 13:34 by Jeffrey

Bug report

When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.

Reproduction of the problem

  1. Go to the Basic Usage example - https://demos.telerik.com/kendo-ui/spreadsheet/index
  2. Enter "SS0012" as value in a random cell.
  3. Grab the handle at the bottom right of the cell and drag down.

Current behavior

The value entered for the cells below is SS13, SS14 etc.

Expected/desired behavior

The value entered for the cells should be SS0012, SS0013 etc.

Environment

  • Kendo UI version: 2021.3.914
  • Browser: [all]
Unplanned
Last Updated: 02 Sep 2021 18:34 by Darin

Bug report

In Spreadsheet, the cell format is lost when you change its value.

Reproduction of the problem

  1. Open this Dojo example - https://dojo.telerik.com/@martin.tabakov@progress.com/EWUdUDUp/2
  2. Change the value of cell C3 to 5.5678

Current behavior

The new value is not rounded as per the preset format.

Expected/desired behavior

The new value should respect the format set for the cell.

Environment

  • Kendo UI version: 2021.2.616
  • Browser: [all]
Completed
Last Updated: 17 Aug 2021 06:37 by ADMIN

Bug report

Excel file is corrupted when it is created with the kendo.ooxml.Workbook toDataURL method, using stringified sheet data:

let dataURL = new kendo.ooxml.Workbook(JSON.stringify(data)).toDataURL();

If the data is passed to the Workbook without stringifying it, this causes a circular reference error (check the console).

let dataURL = new kendo.ooxml.Workbook(data).toDataURL();

Reproduction of the problem

Dojo example.

  1. Click the "To Json" button above the Spreadsheet.
  2. Try to open the generated file in Excel.

Current behavior

The generated Excel file is corrupted

Expected/desired behavior

The generated Excel file is not corrupted

Environment

  • Kendo UI version: 2020.2.617
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 09 Aug 2021 11:01 by ADMIN
Created by: Stephen
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

Hi, I'm using the spreadsheet control and i'm having an issue with date columns.

When I enter a valid date, it works fine.

but when I enter an empty date (clicking delete on date column, or emptying out the contents)

the date gets stored as "new Date(0,0,-1)" ["Sat Dec 30 1899 00:00:00 GMT+1130 (New Zealand Daylight Time)" in my local time]

obviously, this is incorrect, and it should store the value as NULL.

it happens regardless of whether the schema/model has nullable=true.

If I manually modify the dataItem via JS, it stores it correctly as null. 

I have a dojo demo set up which replicates the issue.

https://dojo.telerik.com/oFowivUN

 

Steps:

  1. select the ItemDate column of the first row in the spreadsheet
  2. type in a valid date (e.g. 1/1/2020)
  3. Click View ItemDate button (It should show the correct date)
  4. Select the ItemDate column and empty it out (e.g. click delete)
  5. Click View ItemDate button. (it should now show the incorrect date!)

Doing some investigation into the kendo code, it seems to be caused by the serialToDate method of the spreadsheet.

Thanks

Unplanned
Last Updated: 13 Jul 2021 09:50 by ADMIN

When values in the sheet are updated using the batch method the DataSource does not update according to changes.

Dojo: https://dojo.telerik.com/@iankodj/IRUdufOx

1. Run the example

2. Check the console showing "no data" and an empty array.

 

Expected: https://dojo.telerik.com/@iankodj/EKoziCic 

Unplanned
Last Updated: 01 Jul 2021 05:18 by ADMIN

When there is formatting and decimals are rounded negative numbers that round to zero show a negative sign. In Excel those are shown without the negative sign. 

Dojo example: https://dojo.telerik.com/@iankodj/azEMIRUv/21

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]
1 2 3 4 5