Unplanned
Last Updated: 15 Jul 2021 11:02 by ADMIN
Created by: Martin
Comments: 8
Category: Spreadsheet
Type: Feature Request
36
Ability for spreadsheet row height to be auto set from the row contents. This is to support wrapped text.
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 

Completed
Last Updated: 05 Jul 2021 09:53 by ADMIN
Release 2021.R1.SP1
Enable Cut/Copy cell values and can Paste it in mutiple selected values
Unplanned
Last Updated: 02 Jul 2021 18:40 by ADMIN
Created by: Johannes
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

Hello,

the spreadsheet component triggers no change event if the width of a column changes. Is it possible to track a change of the width of a column?

Can be reproduced with your event demo of the spreadsheet component (https://demos.telerik.com/kendo-ui/spreadsheet/events)

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: 17 Jun 2021 10:44 by ADMIN
Created by: Ron
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

With Excel when you use a custom number format of #,##0.00 and you enter (10) into the cell it will be displayed as -10.  With the Spreadsheet control the same example yields (10).  How can we get the same behavior as Excel with the Spreadsheet control?

 

  dojo example: https://dojo.telerik.com/@843335b6-427b-4127-af09-fbe9957bfec6/uGaVAVat

 

Thanks,

Ron

Won't Fix
Last Updated: 09 Jun 2021 11:18 by ADMIN

Hi admin,

I have a problem when I do with the Spreadsheet.

Bug only appear on mobile deice that run iOS operation system. You need prepare a device as iPhone or iPad

** Prerequisite step.

1. Your device must install Japanese keyboard percussion. You can refer to this below link 

https://www.youtube.com/watch?v=2_ImIkZ5Kis&ab_channel=TaraNico

2. You visit to

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

** Step to reproduce this bug

Because having may steps to reproduce this bug, I records a video. Please check video attached.

** 

When you switch to Japanese keyboard percussion,  you select a cell and enter a formula excel on  'fx' input

Ex: =sum

** Phenomenon: 

You enter "="  and then continue entering 'u' character. But cells lose focus and can't enter any character.

You must click again on 'fx' input, it focus again. But only enter a character. And then continue losing focus

Please confirm and help me this problem

 

 

Duplicated
Last Updated: 08 Jun 2021 16:56 by David
We have clients with large spreadsheets that print out across multiple pages, which can mean losing track of which column refers to what on new pages after a page break, so they want to be able to assign a row of column headers to be printed on new pages above each column to keep track
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/

Completed
Last Updated: 27 May 2021 09:08 by ADMIN
Created by: Richard
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
The Excel file downloaded from Spreadsheet does not maintain leading spaces.  In other words, the internal sharedString.xml should use <t xml:space="preserve"> when necessary.
Completed
Last Updated: 27 May 2021 07:32 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
Allowing custom editors to be inline would be very helpful. In particular, inline editors using other Kendo controls (e.g. masked textbox, numeric textbox) should be possible.
Completed
Last Updated: 27 May 2021 07:10 by ADMIN
Created by: iTai
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
In the scpreadsheet you can use controls like  dropdowns & datepicker , but should be helpful if user could to customize the design and behavior. 

For example, the dropdown and any other control needs be opened since an icon at right that is displayed over the next column, As user i would like to choose how i want to be displayed the control: Open clicking on it, set expand direction, styles, etc.
Completed
Last Updated: 27 May 2021 07:09 by ADMIN
E.g. italian culture uses ";" as parameter separator in formulae.
Our client will adopt spreadsheet component on a global basis and users need to be able to e.g. copy/paste from excel to spreadsheet component using their culture
Unplanned
Last Updated: 27 May 2021 07:08 by ADMIN
Currently if I set column border width large, it has multiple problems:

1. it will overlay on columns next to it;
2. when copy the cell with thick border and paste somewhere else, the thick border get copied as well;
3. when select cell with thick border, the border will block part of editor;
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!!!.

Declined
Last Updated: 11 May 2021 11:40 by ADMIN
Presently in Spreadsheet tooltip is not working for filter applied range 
so tooltip should display for each cell in which the range of filter is applied
Unplanned
Last Updated: 10 May 2021 13:45 by ADMIN
Created by: Jaspreet
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

The spreadsheet currently relies on the <v> tag and doesn't accept cell type "inlineStr". Here is an article with more info regarding the inlineStr type:

https://c-rex.net/projects/samples/ooxml/e1/Part4/OOXML_P4_DOCX_c_topic_ID0E1XM4.html 

A cell of type "inlineStr" which is currently not accepted in SpredSheet

<c r="F2" s="4" t="inlineStr">
        <is>
          <t>1005131528</t>
        </is>
      </c>

 

while the format saved from excel is accepted:

 

<c r="F2" s="2" t="s">
        <v>12</v>
      </c>

Ticket ID: 1517963


1 2 3 4 5 6