Unplanned
Last Updated: 19 Jan 2022 20:23 by Jagan
Created by: Massimo
Comments: 2
Category: Spreadsheet
Type: Feature Request
9

Needs:

Load big excel files stored on the server

Possible implementation:

Load on demand data:

First load the file structure (sheets name, column names and number of rows)

Then load data when sheet is selected or scrolled

Unplanned
Last Updated: 05 Jan 2022 01:17 by ADMIN
Scheduled for 2022.1

Describe the bug
When the Spreadsheet has locked columns and columnWidth is set, but the width of the locked exceed the width of the Spreadsheet, the widget is not rendered correctly.

To reproduce
Steps to reproduce the behavior:

  1. Run the Dojo - https://dojo.telerik.com/@NeliKondova/aXUvAKeB

The columns of the Spreadsheet are visible even outside of the component.

Expected behavior
The columns should be limited to the Spreadsheet width

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
Unplanned
Last Updated: 20 Dec 2021 19:09 by ADMIN
Created by: δΈ‰
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Hi Team,

I'd like to request the functionality to be able to filter null and whitespace items more easily with the built-in API for the Kendo UI Spreadsheet. 

Thank you!

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 ]
Unplanned
Last Updated: 17 Nov 2021 13:36 by ADMIN
Created by: EK
Comments: 0
Category: Spreadsheet
Type: Feature Request
0

Currently, the Spreadsheet does not appear and does not function properly when the 'k-rtl' class is applied.

Dojo

Please provide Right-To-Left support for the Spreadsheet widget. 

Unplanned
Last Updated: 12 Nov 2021 14:11 by ADMIN
Created by: Alina
Comments: 0
Category: Spreadsheet
Type: Feature Request
2

Hi Team,

I would like to request the Kendo UI Grid to improve performance when evaluating multiple formulas.  At this point, if I use a formula on multiple rows(over 1500 rows), the page slows and eventually crashes.  This happens when I use the fromFile method too.  

Thank you for the consideration!

 
Duplicated
Last Updated: 22 Oct 2021 12:25 by ADMIN
Created by: Jin Teik
Comments: 0
Category: Spreadsheet
Type: Feature Request
0
Add image saving capabilities to the Workbook. Currently, you load (through the Workbook's Load method) an Excel file that contains images, and when you save it, it is saved without the images.
Duplicated
Last Updated: 22 Oct 2021 12:23 by ADMIN

The FromJson method of Telerik.Web.Spreadsheet.Workbook doesn't add images when a JSON containing an image blob is passed to it. 

It would be nice if the FromJson method supports images.

Unplanned
Last Updated: 18 Oct 2021 07:02 by ADMIN

Hi,

There are multiple formats for date and time in kendo and in different cultures the count increases. Is there a function in which i pass spreadsheet cell value and format and it returns that it is a date format or number format. I just want to know the type of format so i can parse the dates on my own from json on server side.

 

Regards,
Faraz

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: 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]
Unplanned
Last Updated: 19 Aug 2021 07:52 by ADMIN

When an Excel file with 'Set precision as displayed' option enabled is imported in the Spreadsheet the calculations are not the same as in the Excel file.

Reproduction:

1. Open the Spreadsheet demo

2. Import the excel file from the zip. in the Excel file the following option is enabled - File->Options->Advanced->When Calculating this workbook-> Set precision as displayed

The value in Excel in C1 column is 399.96, while the value displayed in the Spreadsheet is 400.00

I would like to have support in Spreadsheet for Excel files with 'Set precision as displayed' option enabled.

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: 10 Aug 2021 15:59 by Siva
Created by: Siva
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Please allow copy of multiple randomly selected cells in Spreadsheet.
Unplanned
Last Updated: 05 Aug 2021 07:35 by ADMIN
Currently, when a column in the Spreadsheet is filtered and you paste a value in the cells of another column, the pasted value will apply for all rows between the filtered rows as well. That is similar to the Transpose paste option in Excel. Kindly change the default behavior so that the pasted values will apply for the filtered rows only, as in Excel. Additionally, implement an Transpose option that could be enabled/disabled.
Unplanned
Last Updated: 04 Aug 2021 11:56 by ADMIN
Created by: Brian
Comments: 3
Category: Spreadsheet
Type: Feature Request
9

It would be nice to have custom attributes for rows and cells so that I can track things behind the scenes such as row identifiers that could be used to update a corresponding rows in a the data base. This id would not be editable by the user. There are many more uses I would like this for and that is just one example.

I would rather not have to create a column in the spreadsheet just for this and then hide it. I find that very clunky.

 

Thanks.

Unplanned
Last Updated: 29 Jul 2021 06:52 by ADMIN

Currently, in Kendo Spreadsheet multiple rows/columns can not be selected by using Shift + click. For example, in Excel, if the user clicks on the first column header, then press 'Shift' key and click on the fifth column header all five columns will be selected. The same is valid for row selection.

I would like to have the possibility for multiple rows/columns selection by using the Shift key +click In Kendo UI for jQuery Spreadsheet.

 

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